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-03 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (5, 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 : (5, 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 : 03 mtr_id : dashboard_places : SCCU_cam8 date : 2025-03 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-03%') and created_at like '%2025-03%'))); nb_day : (5, 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) = 03 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) = 03 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 '%032025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-03-01 : dt_date_just_month_year : 2025-03-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-03-01" AND ded.date <= "2025-03-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 (1641156,1641378,1643793,1646911,1650541,1653394,1656908,1660068,1661844,1664137,1668388,1671936,1674577,1678156,1679832,1679975) 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.021987073670841795, 'nb_photo': 10143, 'list_port_cont': '20944113,20944151,20945232,20945728,20946247,20946799,20947255,20947433,20947754,20948306,20949088,20949204,20949326,20949520,20949780,20950067,20950454,20950832,20951605,20952115,20952478,20952867,20953430,20953605,20954171,20954224,20954536,20954849,20955067,20955164,20955312,20955459,20955574,20955709,20955813,20955998,20956093,20956170,20956279,20956499,20956560,20956719,20956903,20957048,20957095,20957257,20957437,20961443,20963416,20965489,20966910,20969085,20970690,20974286,20975848,20977541,20979569,20985836,20988137,20992307,20993280,20993573,20993794,20993898,20994000,20994127,20994323,20995055,20995256,20995660,21026233,21027857,21028552,21028937,21029279,21029928,21031693,21032180,21032856,21034008,21034631,21035063,21036150,21036616,21041750,21042604,21043629,21045339,21045816,21047179,21047803,21048625,21050948,21084649,21084927,21085404,21085444,21086158,21086465,21087694,21088391,21088969,21089103,21090083,21090640,21091113,21091847,21092241,21092894,21094034,21094453,21095840,21096616,2109821', 'assoc_port': '20943977:20944151,20943978:20944113,20944758:20945232,20945563:20945728,20946203:20946247,20946649:20946799,20947068:20947255,20947412:20947433,20947732:20947754,20948284:20948306,20948674:20949326,20949000:20949088,20949182:20949204,20949476:20949520,20949744:20949780,20950040:20950067,20950383:20950454,20950736:20950832,20951081:20953430,20951513:20951605,20952015:20952115,20952421:20952478,20952779:20952867,20953467:20953605,20954162:20954224,20954163:20954171,20954515:20954536,20954799:20954849,20954932:20955067,20955121:20955164,20955265:20955312,20955412:20955459,20955518:20955574,20955658:20955709,20955763:20955813,20955904:20955998,20956041:20956093,20956149:20956170,20956256:20956279,20956405:20956499,20956553:20956560,20956666:20956719,20956812:20956903,20956953:20957048,20957085:20957095,20957252:20957257,20957383:20957437,20961267:20961443,20963097:20963416,20965279:20965489,20966465:20966910,20967891:20969085,20970439:20970690,20972824:20974286,20975675:20975848,20977301:20977541,20979382:2097956', 'assoc_mat': '20943977:autre:4230:20944151,20943978:autre:4230:20944113,20944758:autre:4230:20945232,20945563:autre:4230:20945728,20946203:autre:4230:20946247,20946649:autre:4230:20946799,20947068:autre:4230:20947255,20947412:autre:4230:20947433,20947732:autre:4230:20947754,20948284:autre:4230:20948306,20948674:autre:4230:20949326,20949000:autre:4230:20949088,20949182:autre:4230:20949204,20949476:autre:4230:20949520,20949744:autre:4230:20949780,20950040:autre:4230:20950067,20950383:autre:4230:20950454,20950736:autre:4230:20950832,20951081:autre:4230:20953430,20951513:autre:4230:20951605,20952015:autre:4230:20952115,20952421:autre:4230:20952478,20952779:autre:4230:20952867,20953467:autre:4230:20953605,20954162:autre:4230:20954224,20954163:autre:4230:20954171,20954515:autre:4230:20954536,20954799:autre:4230:20954849,20954932:autre:4230:20955067,20955121:autre:4230:20955164,20955265:autre:4230:20955312,20955412:autre:4230:20955459,20955518:autre:4230:20955574,20955658:autre:4230:20955709,20955763:autre:4230:20955813,20955904:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07344461681416486, 'nb_photo': 46413, 'list_port_cont': '20944116,20944158,20945240,20945727,20946245,20946802,20947250,20947425,20947746,20948305,20949099,20949205,20949332,20949532,20949779,20950071,20950459,20950831,20951610,20952108,20952470,20952866,20953435,20953610,20954183,20954225,20954526,20954859,20955071,20955178,20955321,20955469,20955576,20955711,20955815,20956001,20956096,20956171,20956281,20956497,20956574,20956718,20956895,20957042,20957107,20957267,20957435,20961444,20963423,20965493,20966918,20969088,20970704,20974295,20975841,20977532,20979575,20985843,20988135,20992314,20993278,20993574,20993786,20993909,20993997,20994138,20994331,20995066,20995261,20995655,21026232,21027862,21028565,21028943,21029277,21029933,21031705,21032186,21032849,21034019,21034635,21035059,21036143,21036618,21041763,21042609,21043625,21045342,21045828,21047193,21047798,21048640,21050947,21084650,21084914,21085405,21085436,21086157,21086468,21087705,21088396,21088975,21089113,21090087,21090647,21091115,21091850,21092230,21092899,21094044,21094456,21095837,21096623,2109821', 'assoc_port': '20943977:20944158,20943978:20944116,20944758:20945240,20945563:20945727,20946203:20946245,20946649:20946802,20947068:20947250,20947412:20947425,20947732:20947746,20948284:20948305,20948674:20949332,20949000:20949099,20949182:20949205,20949476:20949532,20949744:20949779,20950040:20950071,20950383:20950459,20950736:20950831,20951081:20953435,20951513:20951610,20952015:20952108,20952421:20952470,20952779:20952866,20953467:20953610,20954162:20954225,20954163:20954183,20954515:20954526,20954799:20954859,20954932:20955071,20955121:20955178,20955265:20955321,20955412:20955469,20955518:20955576,20955658:20955711,20955763:20955815,20955904:20956001,20956041:20956096,20956149:20956171,20956256:20956281,20956405:20956497,20956553:20956574,20956666:20956718,20956812:20956895,20956953:20957042,20957085:20957107,20957252:20957267,20957383:20957435,20961267:20961444,20963097:20963423,20965279:20965493,20966465:20966918,20967891:20969088,20970439:20970704,20972824:20974295,20975675:20975841,20977301:20977532,20979382:2097957', 'assoc_mat': '20943977:carton:4230:20944158,20943978:carton:4230:20944116,20944758:carton:4230:20945240,20945563:carton:4230:20945727,20946203:carton:4230:20946245,20946649:carton:4230:20946802,20947068:carton:4230:20947250,20947412:carton:4230:20947425,20947732:carton:4230:20947746,20948284:carton:4230:20948305,20948674:carton:4230:20949332,20949000:carton:4230:20949099,20949182:carton:4230:20949205,20949476:carton:4230:20949532,20949744:carton:4230:20949779,20950040:carton:4230:20950071,20950383:carton:4230:20950459,20950736:carton:4230:20950831,20951081:carton:4230:20953435,20951513:carton:4230:20951610,20952015:carton:4230:20952108,20952421:carton:4230:20952470,20952779:carton:4230:20952866,20953467:carton:4230:20953610,20954162:carton:4230:20954225,20954163:carton:4230:20954183,20954515:carton:4230:20954526,20954799:carton:4230:20954859,20954932:carton:4230:20955071,20955121:carton:4230:20955178,20955265:carton:4230:20955321,20955412:carton:4230:20955469,20955518:carton:4230:20955576,20955658:carton:4230:20955711,2095'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012424443317844253, 'nb_photo': 638, 'list_port_cont': '20944118,20944145,20945244,20945719,20946244,20946790,20947251,20947428,20947750,20948308,20949094,20949202,20949335,20949526,20949783,20950079,20950460,20950818,20952102,20952871,20953440,20953599,20954174,20954208,20954528,20954857,20955079,20955177,20955314,20955460,20955566,20955714,20955818,20955993,20956085,20956164,20956265,20956489,20956567,20956723,20956890,20957043,20957096,20957272,20957439,20963418,20965477,20966917,20969089,20970689,20975850,20977535,20993568,20993792,20993902,20993994,20994141,20994324,21027865,21032851,21034640,21036142,21042605,21043616,21045830,21047802,21050935,21084644,21084910,21085394,21085440,21086159,21086456,21088381,21089104,21090657,21091103,21092905,21094458,21130412,21131120,21161166,21161245,21161319,21161419,21161662,21161772,21162193,21162688,21162778,21162895,21162943,21163014,21163064,21163107,21163147,21163207,21163456,21163497,21163541,21167224,21168170,21169396,21170404,21172245,21174344,21175144,21177236,21179004,21180318,21182886,21184160,21186186,2118804', 'assoc_port': '20943977:20944145,20943978:20944118,20944758:20945244,20945563:20945719,20946203:20946244,20946649:20946790,20947068:20947251,20947412:20947428,20947732:20947750,20948284:20948308,20948674:20949335,20949000:20949094,20949182:20949202,20949476:20949526,20949744:20949783,20950040:20950079,20950383:20950460,20950736:20950818,20951081:20953440,20952015:20952102,20952779:20952871,20953467:20953599,20954162:20954208,20954163:20954174,20954515:20954528,20954799:20954857,20954932:20955079,20955121:20955177,20955265:20955314,20955412:20955460,20955518:20955566,20955658:20955714,20955763:20955818,20955904:20955993,20956041:20956085,20956149:20956164,20956256:20956265,20956405:20956489,20956553:20956567,20956666:20956723,20956812:20956890,20956953:20957043,20957085:20957096,20957252:20957272,20957383:20957439,20963097:20963418,20965279:20965477,20966465:20966917,20967891:20969089,20970439:20970689,20975675:20975850,20977301:20977535,20993556:20994141,20993557:20993994,20993558:20993792,20993559:20993902,20993560:2099356', 'assoc_mat': '20943977:metal:4230:20944145,20943978:metal:4230:20944118,20944758:metal:4230:20945244,20945563:metal:4230:20945719,20946203:metal:4230:20946244,20946649:metal:4230:20946790,20947068:metal:4230:20947251,20947412:metal:4230:20947428,20947732:metal:4230:20947750,20948284:metal:4230:20948308,20948674:metal:4230:20949335,20949000:metal:4230:20949094,20949182:metal:4230:20949202,20949476:metal:4230:20949526,20949744:metal:4230:20949783,20950040:metal:4230:20950079,20950383:metal:4230:20950460,20950736:metal:4230:20950818,20951081:metal:4230:20953440,20952015:metal:4230:20952102,20952779:metal:4230:20952871,20953467:metal:4230:20953599,20954162:metal:4230:20954208,20954163:metal:4230:20954174,20954515:metal:4230:20954528,20954799:metal:4230:20954857,20954932:metal:4230:20955079,20955121:metal:4230:20955177,20955265:metal:4230:20955314,20955412:metal:4230:20955460,20955518:metal:4230:20955566,20955658:metal:4230:20955714,20955763:metal:4230:20955818,20955904:metal:4230:20955993,20956041:metal:4230:20956085,20956149:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.29225101234456863, 'nb_photo': 167801, 'list_port_cont': '20944124,20944161,20945245,20945730,20946239,20946803,20947253,20947434,20947755,20948304,20949091,20949196,20949333,20949529,20949778,20950075,20950450,20950825,20951601,20952112,20952469,20952876,20953444,20953597,20954186,20954214,20954529,20954848,20955080,20955180,20955320,20955456,20955575,20955703,20955821,20956002,20956097,20956165,20956277,20956502,20956571,20956726,20956901,20957039,20957097,20957271,20957427,20961439,20963415,20965486,20966919,20969087,20970697,20974297,20975847,20977537,20979567,20985844,20988127,20992316,20993285,20993569,20993782,20993907,20994008,20994142,20994326,20995059,20995260,20995652,21026222,21027866,21028562,21028940,21029282,21029929,21031700,21032175,21032853,21034025,21034633,21035073,21036148,21036625,21041757,21042616,21043627,21045347,21045821,21047195,21047797,21048638,21050951,21084648,21084920,21085401,21085438,21086160,21086464,21087693,21088390,21088980,21089105,21090090,21090654,21091114,21091842,21092244,21092907,21094041,21094449,21095833,21096615,2109822', 'assoc_port': '20943977:20944161,20943978:20944124,20944758:20945245,20945563:20945730,20946203:20946239,20946649:20946803,20947068:20947253,20947412:20947434,20947732:20947755,20948284:20948304,20948674:20949333,20949000:20949091,20949182:20949196,20949476:20949529,20949744:20949778,20950040:20950075,20950383:20950450,20950736:20950825,20951081:20953444,20951513:20951601,20952015:20952112,20952421:20952469,20952779:20952876,20953467:20953597,20954162:20954214,20954163:20954186,20954515:20954529,20954799:20954848,20954932:20955080,20955121:20955180,20955265:20955320,20955412:20955456,20955518:20955575,20955658:20955703,20955763:20955821,20955904:20956002,20956041:20956097,20956149:20956165,20956256:20956277,20956405:20956502,20956553:20956571,20956666:20956726,20956812:20956901,20956953:20957039,20957085:20957097,20957252:20957271,20957383:20957427,20961267:20961439,20963097:20963415,20965279:20965486,20966465:20966919,20967891:20969087,20970439:20970697,20972824:20974297,20975675:20975847,20977301:20977537,20979382:2097956', 'assoc_mat': '20943977:papier:4230:20944161,20943978:papier:4230:20944124,20944758:papier:4230:20945245,20945563:papier:4230:20945730,20946203:papier:4230:20946239,20946649:papier:4230:20946803,20947068:papier:4230:20947253,20947412:papier:4230:20947434,20947732:papier:4230:20947755,20948284:papier:4230:20948304,20948674:papier:4230:20949333,20949000:papier:4230:20949091,20949182:papier:4230:20949196,20949476:papier:4230:20949529,20949744:papier:4230:20949778,20950040:papier:4230:20950075,20950383:papier:4230:20950450,20950736:papier:4230:20950825,20951081:papier:4230:20953444,20951513:papier:4230:20951601,20952015:papier:4230:20952112,20952421:papier:4230:20952469,20952779:papier:4230:20952876,20953467:papier:4230:20953597,20954162:papier:4230:20954214,20954163:papier:4230:20954186,20954515:papier:4230:20954529,20954799:papier:4230:20954848,20954932:papier:4230:20955080,20955121:papier:4230:20955180,20955265:papier:4230:20955320,20955412:papier:4230:20955456,20955518:papier:4230:20955575,20955658:papier:4230:20955703,2095'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005652675129537525, 'nb_photo': 1625, 'list_port_cont': '20944117,20944159,20945234,20945726,20946804,20947254,20947432,20947741,20948299,20949097,20949206,20949334,20949525,20949782,20950080,20950457,20950827,20951604,20952106,20952479,20952868,20953441,20953607,20954182,20954215,20954537,20954860,20955076,20955175,20955322,20955463,20955573,20955712,20955823,20956003,20956086,20956172,20956267,20956500,20956565,20957052,20963421,20969075,20992319,20993283,20993796,20994139,20994321,21027863,21035071,21036155,21043623,21084654,21084916,21085443,21086153,21086459,21088976,21089109,21090085,21090655,21091117,21091840,21092243,21092900,21094039,21094444,21095839,21099349,21130420,21131131,21161164,21161252,21161313,21161420,21161660,21161763,21161937,21162192,21162311,21162699,21162782,21162897,21162947,21163026,21163053,21163108,21163134,21163179,21163215,21163450,21163507,21163548,21163980,21167045,21167233,21168171,21169397,21170418,21172253,21174348,21174418,21175135,21177244,21178990,21180308,21181569,21182881,21184165,21186193,21188039,21188183,21189357,2119048', 'assoc_port': '20943977:20944159,20943978:20944117,20944758:20945234,20945563:20945726,20946649:20946804,20947068:20947254,20947412:20947432,20947732:20947741,20948284:20948299,20948674:20949334,20949000:20949097,20949182:20949206,20949476:20949525,20949744:20949782,20950040:20950080,20950383:20950457,20950736:20950827,20951081:20953441,20951513:20951604,20952015:20952106,20952421:20952479,20952779:20952868,20953467:20953607,20954162:20954215,20954163:20954182,20954515:20954537,20954799:20954860,20954932:20955076,20955121:20955175,20955265:20955322,20955412:20955463,20955518:20955573,20955658:20955712,20955763:20955823,20955904:20956003,20956041:20956086,20956149:20956172,20956256:20956267,20956405:20956500,20956553:20956565,20956953:20957052,20963097:20963421,20967891:20969075,20989996:20993283,20992202:20992319,20993556:20994139,20993558:20993796,20994210:20994321,21027670:21043623,21027672:21036155,21027675:21035071,21027681:21027863,21084512:21099349,21084518:21095839,21084520:21092900,21084522:21094039,21084524:2109444', 'assoc_mat': '20943977:pehd:4230:20944159,20943978:pehd:4230:20944117,20944758:pehd:4230:20945234,20945563:pehd:4230:20945726,20946649:pehd:4230:20946804,20947068:pehd:4230:20947254,20947412:pehd:4230:20947432,20947732:pehd:4230:20947741,20948284:pehd:4230:20948299,20948674:pehd:4230:20949334,20949000:pehd:4230:20949097,20949182:pehd:4230:20949206,20949476:pehd:4230:20949525,20949744:pehd:4230:20949782,20950040:pehd:4230:20950080,20950383:pehd:4230:20950457,20950736:pehd:4230:20950827,20951081:pehd:4230:20953441,20951513:pehd:4230:20951604,20952015:pehd:4230:20952106,20952421:pehd:4230:20952479,20952779:pehd:4230:20952868,20953467:pehd:4230:20953607,20954162:pehd:4230:20954215,20954163:pehd:4230:20954182,20954515:pehd:4230:20954537,20954799:pehd:4230:20954860,20954932:pehd:4230:20955076,20955121:pehd:4230:20955175,20955265:pehd:4230:20955322,20955412:pehd:4230:20955463,20955518:pehd:4230:20955573,20955658:pehd:4230:20955712,20955763:pehd:4230:20955823,20955904:pehd:4230:20956003,20956041:pehd:4230:20956086,20956149:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.016936004938457424, 'nb_photo': 12829, 'list_port_cont': '20944119,20944153,20945242,20945729,20946232,20946796,20947249,20947430,20947752,20948309,20949093,20949207,20949323,20949527,20949785,20950077,20950449,20950835,20951609,20952113,20952474,20952873,20953446,20953603,20954178,20954216,20954535,20954854,20955069,20955167,20955324,20955468,20955572,20955717,20955822,20955997,20956099,20956160,20956275,20956495,20956568,20956725,20956900,20957051,20957103,20957265,20957440,20961440,20963417,20965492,20966913,20969079,20970705,20974298,20975844,20977536,20979576,20985838,20988138,20992318,20993286,20993575,20993790,20993903,20994011,20994132,20994330,20995062,20995253,20995654,21026229,21027859,21028566,21028938,21029290,21029927,21031691,21032189,21032847,21034018,21034641,21035069,21036149,21036632,21041761,21042611,21043630,21045353,21045826,21047191,21047804,21048637,21050946,21084647,21084926,21085407,21085435,21086152,21086462,21087700,21088398,21088973,21089112,21090084,21090650,21091118,21091849,21092233,21092910,21094040,21094446,21095835,21096621,2109821', 'assoc_port': '20943977:20944153,20943978:20944119,20944758:20945242,20945563:20945729,20946203:20946232,20946649:20946796,20947068:20947249,20947412:20947430,20947732:20947752,20948284:20948309,20948674:20949323,20949000:20949093,20949182:20949207,20949476:20949527,20949744:20949785,20950040:20950077,20950383:20950449,20950736:20950835,20951081:20953446,20951513:20951609,20952015:20952113,20952421:20952474,20952779:20952873,20953467:20953603,20954162:20954216,20954163:20954178,20954515:20954535,20954799:20954854,20954932:20955069,20955121:20955167,20955265:20955324,20955412:20955468,20955518:20955572,20955658:20955717,20955763:20955822,20955904:20955997,20956041:20956099,20956149:20956160,20956256:20956275,20956405:20956495,20956553:20956568,20956666:20956725,20956812:20956900,20956953:20957051,20957085:20957103,20957252:20957265,20957383:20957440,20961267:20961440,20963097:20963417,20965279:20965492,20966465:20966913,20967891:20969079,20970439:20970705,20972824:20974298,20975675:20975844,20977301:20977536,20979382:2097957', 'assoc_mat': '20943977:pet_clair:4230:20944153,20943978:pet_clair:4230:20944119,20944758:pet_clair:4230:20945242,20945563:pet_clair:4230:20945729,20946203:pet_clair:4230:20946232,20946649:pet_clair:4230:20946796,20947068:pet_clair:4230:20947249,20947412:pet_clair:4230:20947430,20947732:pet_clair:4230:20947752,20948284:pet_clair:4230:20948309,20948674:pet_clair:4230:20949323,20949000:pet_clair:4230:20949093,20949182:pet_clair:4230:20949207,20949476:pet_clair:4230:20949527,20949744:pet_clair:4230:20949785,20950040:pet_clair:4230:20950077,20950383:pet_clair:4230:20950449,20950736:pet_clair:4230:20950835,20951081:pet_clair:4230:20953446,20951513:pet_clair:4230:20951609,20952015:pet_clair:4230:20952113,20952421:pet_clair:4230:20952474,20952779:pet_clair:4230:20952873,20953467:pet_clair:4230:20953603,20954162:pet_clair:4230:20954216,20954163:pet_clair:4230:20954178,20954515:pet_clair:4230:20954535,20954799:pet_clair:4230:20954854,20954932:pet_clair:4230:20955069,20955121:pet_clair:4230:20955167,20955265:pet_clair:4230:20955324,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007042890742360934, 'nb_photo': 856, 'list_port_cont': '20944120,20944160,20945237,20945717,20946246,20946805,20947245,20948307,20949096,20949195,20949531,20949784,20950076,20950453,20950834,20951596,20952107,20952476,20952874,20953604,20954221,20955323,20955577,20955713,20955991,20956095,20956167,20956272,20956493,20956566,20956715,20956904,20957049,20957101,20957270,20957441,20963413,20965483,20966916,20974294,20985840,20988131,20992320,20993279,20993793,20994007,20994319,20995262,20995650,21026219,21028559,21028941,21029285,21029935,21031695,21032177,21032855,21034016,21036631,21045351,21047183,21047795,21084646,21084921,21085437,21086161,21086469,21088387,21088978,21090092,21090652,21091116,21091841,21092242,21092901,21094037,21094457,21095836,21096614,21098213,21099357,21130423,21131125,21161247,21161414,21161663,21162196,21162696,21162781,21162894,21162944,21163058,21163100,21163142,21163182,21163222,21163512,21163536,21174428,21177230,21179005,21181570,21182883,21184170,21188186,21194192,21194543,21195107,21195227,21195279,21195404,21195666,21196599,2119685', 'assoc_port': '20943977:20944160,20943978:20944120,20944758:20945237,20945563:20945717,20946203:20946246,20946649:20946805,20947068:20947245,20948284:20948307,20949000:20949096,20949182:20949195,20949476:20949531,20949744:20949784,20950040:20950076,20950383:20950453,20950736:20950834,20951513:20951596,20952015:20952107,20952421:20952476,20952779:20952874,20953467:20953604,20954162:20954221,20955265:20955323,20955518:20955577,20955658:20955713,20955904:20955991,20956041:20956095,20956149:20956167,20956256:20956272,20956405:20956493,20956553:20956566,20956666:20956715,20956812:20956904,20956953:20957049,20957085:20957101,20957252:20957270,20957383:20957441,20963097:20963413,20965279:20965483,20966465:20966916,20972824:20974294,20981624:20995262,20983933:20995650,20985803:20985840,20987762:20988131,20989996:20993279,20992202:20992320,20993557:20994007,20993558:20993793,20994210:20994319,21009642:21026219,21027618:21047183,21027619:21047795,21027668:21045351,21027673:21036631,21027677:21032855,21027678:21029285,21027679:2102993', 'assoc_mat': '20943977:pet_fonce:4230:20944160,20943978:pet_fonce:4230:20944120,20944758:pet_fonce:4230:20945237,20945563:pet_fonce:4230:20945717,20946203:pet_fonce:4230:20946246,20946649:pet_fonce:4230:20946805,20947068:pet_fonce:4230:20947245,20948284:pet_fonce:4230:20948307,20949000:pet_fonce:4230:20949096,20949182:pet_fonce:4230:20949195,20949476:pet_fonce:4230:20949531,20949744:pet_fonce:4230:20949784,20950040:pet_fonce:4230:20950076,20950383:pet_fonce:4230:20950453,20950736:pet_fonce:4230:20950834,20951513:pet_fonce:4230:20951596,20952015:pet_fonce:4230:20952107,20952421:pet_fonce:4230:20952476,20952779:pet_fonce:4230:20952874,20953467:pet_fonce:4230:20953604,20954162:pet_fonce:4230:20954221,20955265:pet_fonce:4230:20955323,20955518:pet_fonce:4230:20955577,20955658:pet_fonce:4230:20955713,20955904:pet_fonce:4230:20955991,20956041:pet_fonce:4230:20956095,20956149:pet_fonce:4230:20956167,20956256:pet_fonce:4230:20956272,20956405:pet_fonce:4230:20956493,20956553:pet_fonce:4230:20956566,20956666:pet_fonce:4230:20956715,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(1641156,1641378,1643793,1646911,1650541,1653394,1656908,1660068,1661844,1664137,1668388,1671936,1674577,1678156,1679832,1679975)); 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-03-01' and date <= '2025-03-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((911,),), 'unwanted_material_monthly_percentage': ((0.6199313122644925,),), 'material_repartition': (('incineration', 903),), 'material_dict': {'incineration': 903}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 3, 1), 0.6358994174376137, 80), (datetime.date(2025, 3, 2), 0.7521264767587421, 72), (datetime.date(2025, 3, 3), 0.8100557016201598, 52), (datetime.date(2025, 3, 4), 0.7978308717830422, 52), (datetime.date(2025, 3, 5), 0.6696704341882375, 56), (datetime.date(2025, 3, 6), 0.5800594918531125, 32), (datetime.date(2025, 3, 7), 0.48880879991907783, 61), (datetime.date(2025, 3, 8), 0.5504159018471309, 54), (datetime.date(2025, 3, 9), 0.5507854104275727, 56), (datetime.date(2025, 3, 10), 0.5362634840598333, 51), (datetime.date(2025, 3, 11), 0.5467848566875516, 61), (datetime.date(2025, 3, 12), 0.5881385319321567, 62), (datetime.date(2025, 3, 13), 0.6299044338679574, 59), (datetime.date(2025, 3, 14), 0.5651606270997768, 64), (datetime.date(2025, 3, 15), 0.5688215093234584, 58), (datetime.date(2025, 3, 16), 0.6255747739623047, 33)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 3, 1), 0.6358994174376137, 80), (datetime.date(2025, 3, 2), 0.7521264767587421, 72), (datetime.date(2025, 3, 3), 0.8100557016201598, 52), (datetime.date(2025, 3, 4), 0.7978308717830422, 52), (datetime.date(2025, 3, 5), 0.6696704341882375, 56), (datetime.date(2025, 3, 6), 0.5800594918531125, 32), (datetime.date(2025, 3, 7), 0.48880879991907783, 61), (datetime.date(2025, 3, 8), 0.5504159018471309, 54), (datetime.date(2025, 3, 9), 0.5507854104275727, 56), (datetime.date(2025, 3, 10), 0.5362634840598333, 51), (datetime.date(2025, 3, 11), 0.5467848566875516, 61), (datetime.date(2025, 3, 12), 0.5881385319321567, 62), (datetime.date(2025, 3, 13), 0.6299044338679574, 59), (datetime.date(2025, 3, 14), 0.5651606270997768, 64), (datetime.date(2025, 3, 15), 0.5688215093234584, 58), (datetime.date(2025, 3, 16), 0.6255747739623047, 33))}, 'quality_array': [['-7.737746003865416', '01032025'], ['-8.007447067084804', '02032025'], ['-6.781928358221221', '03032025'], ['-6.358807428625658', '04032025'], ['-6.53666001684734', '05032025'], ['-8.164510155964125', '06032025'], ['-8.285971937996399', '07032025'], ['-8.015586571175508', '08032025'], ['-7.914260186928855', '09032025'], ['-7.588521601804382', '10032025'], ['-7.364008243098092', '11032025'], ['-7.2837816295824', '12032025'], ['-8.209444693629239', '13032025'], ['-8.212708316791604', '14032025'], ['-8.19786906936703', '15032025'], ['-8.063113804630417', '16032025']], 'number_of_batch': ((345,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.021987073670841795, 'nb_photo': 10143, 'list_port_cont': '20944113,20944151,20945232,20945728,20946247,20946799,20947255,20947433,20947754,20948306,20949088,20949204,20949326,20949520,20949780,20950067,20950454,20950832,20951605,20952115,20952478,20952867,20953430,20953605,20954171,20954224,20954536,20954849,20955067,20955164,20955312,20955459,20955574,20955709,20955813,20955998,20956093,20956170,20956279,20956499,20956560,20956719,20956903,20957048,20957095,20957257,20957437,20961443,20963416,20965489,20966910,20969085,20970690,20974286,20975848,20977541,20979569,20985836,20988137,20992307,20993280,20993573,20993794,20993898,20994000,20994127,20994323,20995055,20995256,20995660,21026233,21027857,21028552,21028937,21029279,21029928,21031693,21032180,21032856,21034008,21034631,21035063,21036150,21036616,21041750,21042604,21043629,21045339,21045816,21047179,21047803,21048625,21050948,21084649,21084927,21085404,21085444,21086158,21086465,21087694,21088391,21088969,21089103,21090083,21090640,21091113,21091847,21092241,21092894,21094034,21094453,21095840,21096616,2109821', 'assoc_port': '20943977:20944151,20943978:20944113,20944758:20945232,20945563:20945728,20946203:20946247,20946649:20946799,20947068:20947255,20947412:20947433,20947732:20947754,20948284:20948306,20948674:20949326,20949000:20949088,20949182:20949204,20949476:20949520,20949744:20949780,20950040:20950067,20950383:20950454,20950736:20950832,20951081:20953430,20951513:20951605,20952015:20952115,20952421:20952478,20952779:20952867,20953467:20953605,20954162:20954224,20954163:20954171,20954515:20954536,20954799:20954849,20954932:20955067,20955121:20955164,20955265:20955312,20955412:20955459,20955518:20955574,20955658:20955709,20955763:20955813,20955904:20955998,20956041:20956093,20956149:20956170,20956256:20956279,20956405:20956499,20956553:20956560,20956666:20956719,20956812:20956903,20956953:20957048,20957085:20957095,20957252:20957257,20957383:20957437,20961267:20961443,20963097:20963416,20965279:20965489,20966465:20966910,20967891:20969085,20970439:20970690,20972824:20974286,20975675:20975848,20977301:20977541,20979382:2097956', 'assoc_mat': '20943977:autre:4230:20944151,20943978:autre:4230:20944113,20944758:autre:4230:20945232,20945563:autre:4230:20945728,20946203:autre:4230:20946247,20946649:autre:4230:20946799,20947068:autre:4230:20947255,20947412:autre:4230:20947433,20947732:autre:4230:20947754,20948284:autre:4230:20948306,20948674:autre:4230:20949326,20949000:autre:4230:20949088,20949182:autre:4230:20949204,20949476:autre:4230:20949520,20949744:autre:4230:20949780,20950040:autre:4230:20950067,20950383:autre:4230:20950454,20950736:autre:4230:20950832,20951081:autre:4230:20953430,20951513:autre:4230:20951605,20952015:autre:4230:20952115,20952421:autre:4230:20952478,20952779:autre:4230:20952867,20953467:autre:4230:20953605,20954162:autre:4230:20954224,20954163:autre:4230:20954171,20954515:autre:4230:20954536,20954799:autre:4230:20954849,20954932:autre:4230:20955067,20955121:autre:4230:20955164,20955265:autre:4230:20955312,20955412:autre:4230:20955459,20955518:autre:4230:20955574,20955658:autre:4230:20955709,20955763:autre:4230:20955813,20955904:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07344461681416486, 'nb_photo': 46413, 'list_port_cont': '20944116,20944158,20945240,20945727,20946245,20946802,20947250,20947425,20947746,20948305,20949099,20949205,20949332,20949532,20949779,20950071,20950459,20950831,20951610,20952108,20952470,20952866,20953435,20953610,20954183,20954225,20954526,20954859,20955071,20955178,20955321,20955469,20955576,20955711,20955815,20956001,20956096,20956171,20956281,20956497,20956574,20956718,20956895,20957042,20957107,20957267,20957435,20961444,20963423,20965493,20966918,20969088,20970704,20974295,20975841,20977532,20979575,20985843,20988135,20992314,20993278,20993574,20993786,20993909,20993997,20994138,20994331,20995066,20995261,20995655,21026232,21027862,21028565,21028943,21029277,21029933,21031705,21032186,21032849,21034019,21034635,21035059,21036143,21036618,21041763,21042609,21043625,21045342,21045828,21047193,21047798,21048640,21050947,21084650,21084914,21085405,21085436,21086157,21086468,21087705,21088396,21088975,21089113,21090087,21090647,21091115,21091850,21092230,21092899,21094044,21094456,21095837,21096623,2109821', 'assoc_port': '20943977:20944158,20943978:20944116,20944758:20945240,20945563:20945727,20946203:20946245,20946649:20946802,20947068:20947250,20947412:20947425,20947732:20947746,20948284:20948305,20948674:20949332,20949000:20949099,20949182:20949205,20949476:20949532,20949744:20949779,20950040:20950071,20950383:20950459,20950736:20950831,20951081:20953435,20951513:20951610,20952015:20952108,20952421:20952470,20952779:20952866,20953467:20953610,20954162:20954225,20954163:20954183,20954515:20954526,20954799:20954859,20954932:20955071,20955121:20955178,20955265:20955321,20955412:20955469,20955518:20955576,20955658:20955711,20955763:20955815,20955904:20956001,20956041:20956096,20956149:20956171,20956256:20956281,20956405:20956497,20956553:20956574,20956666:20956718,20956812:20956895,20956953:20957042,20957085:20957107,20957252:20957267,20957383:20957435,20961267:20961444,20963097:20963423,20965279:20965493,20966465:20966918,20967891:20969088,20970439:20970704,20972824:20974295,20975675:20975841,20977301:20977532,20979382:2097957', 'assoc_mat': '20943977:carton:4230:20944158,20943978:carton:4230:20944116,20944758:carton:4230:20945240,20945563:carton:4230:20945727,20946203:carton:4230:20946245,20946649:carton:4230:20946802,20947068:carton:4230:20947250,20947412:carton:4230:20947425,20947732:carton:4230:20947746,20948284:carton:4230:20948305,20948674:carton:4230:20949332,20949000:carton:4230:20949099,20949182:carton:4230:20949205,20949476:carton:4230:20949532,20949744:carton:4230:20949779,20950040:carton:4230:20950071,20950383:carton:4230:20950459,20950736:carton:4230:20950831,20951081:carton:4230:20953435,20951513:carton:4230:20951610,20952015:carton:4230:20952108,20952421:carton:4230:20952470,20952779:carton:4230:20952866,20953467:carton:4230:20953610,20954162:carton:4230:20954225,20954163:carton:4230:20954183,20954515:carton:4230:20954526,20954799:carton:4230:20954859,20954932:carton:4230:20955071,20955121:carton:4230:20955178,20955265:carton:4230:20955321,20955412:carton:4230:20955469,20955518:carton:4230:20955576,20955658:carton:4230:20955711,2095'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012424443317844253, 'nb_photo': 638, 'list_port_cont': '20944118,20944145,20945244,20945719,20946244,20946790,20947251,20947428,20947750,20948308,20949094,20949202,20949335,20949526,20949783,20950079,20950460,20950818,20952102,20952871,20953440,20953599,20954174,20954208,20954528,20954857,20955079,20955177,20955314,20955460,20955566,20955714,20955818,20955993,20956085,20956164,20956265,20956489,20956567,20956723,20956890,20957043,20957096,20957272,20957439,20963418,20965477,20966917,20969089,20970689,20975850,20977535,20993568,20993792,20993902,20993994,20994141,20994324,21027865,21032851,21034640,21036142,21042605,21043616,21045830,21047802,21050935,21084644,21084910,21085394,21085440,21086159,21086456,21088381,21089104,21090657,21091103,21092905,21094458,21130412,21131120,21161166,21161245,21161319,21161419,21161662,21161772,21162193,21162688,21162778,21162895,21162943,21163014,21163064,21163107,21163147,21163207,21163456,21163497,21163541,21167224,21168170,21169396,21170404,21172245,21174344,21175144,21177236,21179004,21180318,21182886,21184160,21186186,2118804', 'assoc_port': '20943977:20944145,20943978:20944118,20944758:20945244,20945563:20945719,20946203:20946244,20946649:20946790,20947068:20947251,20947412:20947428,20947732:20947750,20948284:20948308,20948674:20949335,20949000:20949094,20949182:20949202,20949476:20949526,20949744:20949783,20950040:20950079,20950383:20950460,20950736:20950818,20951081:20953440,20952015:20952102,20952779:20952871,20953467:20953599,20954162:20954208,20954163:20954174,20954515:20954528,20954799:20954857,20954932:20955079,20955121:20955177,20955265:20955314,20955412:20955460,20955518:20955566,20955658:20955714,20955763:20955818,20955904:20955993,20956041:20956085,20956149:20956164,20956256:20956265,20956405:20956489,20956553:20956567,20956666:20956723,20956812:20956890,20956953:20957043,20957085:20957096,20957252:20957272,20957383:20957439,20963097:20963418,20965279:20965477,20966465:20966917,20967891:20969089,20970439:20970689,20975675:20975850,20977301:20977535,20993556:20994141,20993557:20993994,20993558:20993792,20993559:20993902,20993560:2099356', 'assoc_mat': '20943977:metal:4230:20944145,20943978:metal:4230:20944118,20944758:metal:4230:20945244,20945563:metal:4230:20945719,20946203:metal:4230:20946244,20946649:metal:4230:20946790,20947068:metal:4230:20947251,20947412:metal:4230:20947428,20947732:metal:4230:20947750,20948284:metal:4230:20948308,20948674:metal:4230:20949335,20949000:metal:4230:20949094,20949182:metal:4230:20949202,20949476:metal:4230:20949526,20949744:metal:4230:20949783,20950040:metal:4230:20950079,20950383:metal:4230:20950460,20950736:metal:4230:20950818,20951081:metal:4230:20953440,20952015:metal:4230:20952102,20952779:metal:4230:20952871,20953467:metal:4230:20953599,20954162:metal:4230:20954208,20954163:metal:4230:20954174,20954515:metal:4230:20954528,20954799:metal:4230:20954857,20954932:metal:4230:20955079,20955121:metal:4230:20955177,20955265:metal:4230:20955314,20955412:metal:4230:20955460,20955518:metal:4230:20955566,20955658:metal:4230:20955714,20955763:metal:4230:20955818,20955904:metal:4230:20955993,20956041:metal:4230:20956085,20956149:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.29225101234456863, 'nb_photo': 167801, 'list_port_cont': '20944124,20944161,20945245,20945730,20946239,20946803,20947253,20947434,20947755,20948304,20949091,20949196,20949333,20949529,20949778,20950075,20950450,20950825,20951601,20952112,20952469,20952876,20953444,20953597,20954186,20954214,20954529,20954848,20955080,20955180,20955320,20955456,20955575,20955703,20955821,20956002,20956097,20956165,20956277,20956502,20956571,20956726,20956901,20957039,20957097,20957271,20957427,20961439,20963415,20965486,20966919,20969087,20970697,20974297,20975847,20977537,20979567,20985844,20988127,20992316,20993285,20993569,20993782,20993907,20994008,20994142,20994326,20995059,20995260,20995652,21026222,21027866,21028562,21028940,21029282,21029929,21031700,21032175,21032853,21034025,21034633,21035073,21036148,21036625,21041757,21042616,21043627,21045347,21045821,21047195,21047797,21048638,21050951,21084648,21084920,21085401,21085438,21086160,21086464,21087693,21088390,21088980,21089105,21090090,21090654,21091114,21091842,21092244,21092907,21094041,21094449,21095833,21096615,2109822', 'assoc_port': '20943977:20944161,20943978:20944124,20944758:20945245,20945563:20945730,20946203:20946239,20946649:20946803,20947068:20947253,20947412:20947434,20947732:20947755,20948284:20948304,20948674:20949333,20949000:20949091,20949182:20949196,20949476:20949529,20949744:20949778,20950040:20950075,20950383:20950450,20950736:20950825,20951081:20953444,20951513:20951601,20952015:20952112,20952421:20952469,20952779:20952876,20953467:20953597,20954162:20954214,20954163:20954186,20954515:20954529,20954799:20954848,20954932:20955080,20955121:20955180,20955265:20955320,20955412:20955456,20955518:20955575,20955658:20955703,20955763:20955821,20955904:20956002,20956041:20956097,20956149:20956165,20956256:20956277,20956405:20956502,20956553:20956571,20956666:20956726,20956812:20956901,20956953:20957039,20957085:20957097,20957252:20957271,20957383:20957427,20961267:20961439,20963097:20963415,20965279:20965486,20966465:20966919,20967891:20969087,20970439:20970697,20972824:20974297,20975675:20975847,20977301:20977537,20979382:2097956', 'assoc_mat': '20943977:papier:4230:20944161,20943978:papier:4230:20944124,20944758:papier:4230:20945245,20945563:papier:4230:20945730,20946203:papier:4230:20946239,20946649:papier:4230:20946803,20947068:papier:4230:20947253,20947412:papier:4230:20947434,20947732:papier:4230:20947755,20948284:papier:4230:20948304,20948674:papier:4230:20949333,20949000:papier:4230:20949091,20949182:papier:4230:20949196,20949476:papier:4230:20949529,20949744:papier:4230:20949778,20950040:papier:4230:20950075,20950383:papier:4230:20950450,20950736:papier:4230:20950825,20951081:papier:4230:20953444,20951513:papier:4230:20951601,20952015:papier:4230:20952112,20952421:papier:4230:20952469,20952779:papier:4230:20952876,20953467:papier:4230:20953597,20954162:papier:4230:20954214,20954163:papier:4230:20954186,20954515:papier:4230:20954529,20954799:papier:4230:20954848,20954932:papier:4230:20955080,20955121:papier:4230:20955180,20955265:papier:4230:20955320,20955412:papier:4230:20955456,20955518:papier:4230:20955575,20955658:papier:4230:20955703,2095'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005652675129537525, 'nb_photo': 1625, 'list_port_cont': '20944117,20944159,20945234,20945726,20946804,20947254,20947432,20947741,20948299,20949097,20949206,20949334,20949525,20949782,20950080,20950457,20950827,20951604,20952106,20952479,20952868,20953441,20953607,20954182,20954215,20954537,20954860,20955076,20955175,20955322,20955463,20955573,20955712,20955823,20956003,20956086,20956172,20956267,20956500,20956565,20957052,20963421,20969075,20992319,20993283,20993796,20994139,20994321,21027863,21035071,21036155,21043623,21084654,21084916,21085443,21086153,21086459,21088976,21089109,21090085,21090655,21091117,21091840,21092243,21092900,21094039,21094444,21095839,21099349,21130420,21131131,21161164,21161252,21161313,21161420,21161660,21161763,21161937,21162192,21162311,21162699,21162782,21162897,21162947,21163026,21163053,21163108,21163134,21163179,21163215,21163450,21163507,21163548,21163980,21167045,21167233,21168171,21169397,21170418,21172253,21174348,21174418,21175135,21177244,21178990,21180308,21181569,21182881,21184165,21186193,21188039,21188183,21189357,2119048', 'assoc_port': '20943977:20944159,20943978:20944117,20944758:20945234,20945563:20945726,20946649:20946804,20947068:20947254,20947412:20947432,20947732:20947741,20948284:20948299,20948674:20949334,20949000:20949097,20949182:20949206,20949476:20949525,20949744:20949782,20950040:20950080,20950383:20950457,20950736:20950827,20951081:20953441,20951513:20951604,20952015:20952106,20952421:20952479,20952779:20952868,20953467:20953607,20954162:20954215,20954163:20954182,20954515:20954537,20954799:20954860,20954932:20955076,20955121:20955175,20955265:20955322,20955412:20955463,20955518:20955573,20955658:20955712,20955763:20955823,20955904:20956003,20956041:20956086,20956149:20956172,20956256:20956267,20956405:20956500,20956553:20956565,20956953:20957052,20963097:20963421,20967891:20969075,20989996:20993283,20992202:20992319,20993556:20994139,20993558:20993796,20994210:20994321,21027670:21043623,21027672:21036155,21027675:21035071,21027681:21027863,21084512:21099349,21084518:21095839,21084520:21092900,21084522:21094039,21084524:2109444', 'assoc_mat': '20943977:pehd:4230:20944159,20943978:pehd:4230:20944117,20944758:pehd:4230:20945234,20945563:pehd:4230:20945726,20946649:pehd:4230:20946804,20947068:pehd:4230:20947254,20947412:pehd:4230:20947432,20947732:pehd:4230:20947741,20948284:pehd:4230:20948299,20948674:pehd:4230:20949334,20949000:pehd:4230:20949097,20949182:pehd:4230:20949206,20949476:pehd:4230:20949525,20949744:pehd:4230:20949782,20950040:pehd:4230:20950080,20950383:pehd:4230:20950457,20950736:pehd:4230:20950827,20951081:pehd:4230:20953441,20951513:pehd:4230:20951604,20952015:pehd:4230:20952106,20952421:pehd:4230:20952479,20952779:pehd:4230:20952868,20953467:pehd:4230:20953607,20954162:pehd:4230:20954215,20954163:pehd:4230:20954182,20954515:pehd:4230:20954537,20954799:pehd:4230:20954860,20954932:pehd:4230:20955076,20955121:pehd:4230:20955175,20955265:pehd:4230:20955322,20955412:pehd:4230:20955463,20955518:pehd:4230:20955573,20955658:pehd:4230:20955712,20955763:pehd:4230:20955823,20955904:pehd:4230:20956003,20956041:pehd:4230:20956086,20956149:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.016936004938457424, 'nb_photo': 12829, 'list_port_cont': '20944119,20944153,20945242,20945729,20946232,20946796,20947249,20947430,20947752,20948309,20949093,20949207,20949323,20949527,20949785,20950077,20950449,20950835,20951609,20952113,20952474,20952873,20953446,20953603,20954178,20954216,20954535,20954854,20955069,20955167,20955324,20955468,20955572,20955717,20955822,20955997,20956099,20956160,20956275,20956495,20956568,20956725,20956900,20957051,20957103,20957265,20957440,20961440,20963417,20965492,20966913,20969079,20970705,20974298,20975844,20977536,20979576,20985838,20988138,20992318,20993286,20993575,20993790,20993903,20994011,20994132,20994330,20995062,20995253,20995654,21026229,21027859,21028566,21028938,21029290,21029927,21031691,21032189,21032847,21034018,21034641,21035069,21036149,21036632,21041761,21042611,21043630,21045353,21045826,21047191,21047804,21048637,21050946,21084647,21084926,21085407,21085435,21086152,21086462,21087700,21088398,21088973,21089112,21090084,21090650,21091118,21091849,21092233,21092910,21094040,21094446,21095835,21096621,2109821', 'assoc_port': '20943977:20944153,20943978:20944119,20944758:20945242,20945563:20945729,20946203:20946232,20946649:20946796,20947068:20947249,20947412:20947430,20947732:20947752,20948284:20948309,20948674:20949323,20949000:20949093,20949182:20949207,20949476:20949527,20949744:20949785,20950040:20950077,20950383:20950449,20950736:20950835,20951081:20953446,20951513:20951609,20952015:20952113,20952421:20952474,20952779:20952873,20953467:20953603,20954162:20954216,20954163:20954178,20954515:20954535,20954799:20954854,20954932:20955069,20955121:20955167,20955265:20955324,20955412:20955468,20955518:20955572,20955658:20955717,20955763:20955822,20955904:20955997,20956041:20956099,20956149:20956160,20956256:20956275,20956405:20956495,20956553:20956568,20956666:20956725,20956812:20956900,20956953:20957051,20957085:20957103,20957252:20957265,20957383:20957440,20961267:20961440,20963097:20963417,20965279:20965492,20966465:20966913,20967891:20969079,20970439:20970705,20972824:20974298,20975675:20975844,20977301:20977536,20979382:2097957', 'assoc_mat': '20943977:pet_clair:4230:20944153,20943978:pet_clair:4230:20944119,20944758:pet_clair:4230:20945242,20945563:pet_clair:4230:20945729,20946203:pet_clair:4230:20946232,20946649:pet_clair:4230:20946796,20947068:pet_clair:4230:20947249,20947412:pet_clair:4230:20947430,20947732:pet_clair:4230:20947752,20948284:pet_clair:4230:20948309,20948674:pet_clair:4230:20949323,20949000:pet_clair:4230:20949093,20949182:pet_clair:4230:20949207,20949476:pet_clair:4230:20949527,20949744:pet_clair:4230:20949785,20950040:pet_clair:4230:20950077,20950383:pet_clair:4230:20950449,20950736:pet_clair:4230:20950835,20951081:pet_clair:4230:20953446,20951513:pet_clair:4230:20951609,20952015:pet_clair:4230:20952113,20952421:pet_clair:4230:20952474,20952779:pet_clair:4230:20952873,20953467:pet_clair:4230:20953603,20954162:pet_clair:4230:20954216,20954163:pet_clair:4230:20954178,20954515:pet_clair:4230:20954535,20954799:pet_clair:4230:20954854,20954932:pet_clair:4230:20955069,20955121:pet_clair:4230:20955167,20955265:pet_clair:4230:20955324,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007042890742360934, 'nb_photo': 856, 'list_port_cont': '20944120,20944160,20945237,20945717,20946246,20946805,20947245,20948307,20949096,20949195,20949531,20949784,20950076,20950453,20950834,20951596,20952107,20952476,20952874,20953604,20954221,20955323,20955577,20955713,20955991,20956095,20956167,20956272,20956493,20956566,20956715,20956904,20957049,20957101,20957270,20957441,20963413,20965483,20966916,20974294,20985840,20988131,20992320,20993279,20993793,20994007,20994319,20995262,20995650,21026219,21028559,21028941,21029285,21029935,21031695,21032177,21032855,21034016,21036631,21045351,21047183,21047795,21084646,21084921,21085437,21086161,21086469,21088387,21088978,21090092,21090652,21091116,21091841,21092242,21092901,21094037,21094457,21095836,21096614,21098213,21099357,21130423,21131125,21161247,21161414,21161663,21162196,21162696,21162781,21162894,21162944,21163058,21163100,21163142,21163182,21163222,21163512,21163536,21174428,21177230,21179005,21181570,21182883,21184170,21188186,21194192,21194543,21195107,21195227,21195279,21195404,21195666,21196599,2119685', 'assoc_port': '20943977:20944160,20943978:20944120,20944758:20945237,20945563:20945717,20946203:20946246,20946649:20946805,20947068:20947245,20948284:20948307,20949000:20949096,20949182:20949195,20949476:20949531,20949744:20949784,20950040:20950076,20950383:20950453,20950736:20950834,20951513:20951596,20952015:20952107,20952421:20952476,20952779:20952874,20953467:20953604,20954162:20954221,20955265:20955323,20955518:20955577,20955658:20955713,20955904:20955991,20956041:20956095,20956149:20956167,20956256:20956272,20956405:20956493,20956553:20956566,20956666:20956715,20956812:20956904,20956953:20957049,20957085:20957101,20957252:20957270,20957383:20957441,20963097:20963413,20965279:20965483,20966465:20966916,20972824:20974294,20981624:20995262,20983933:20995650,20985803:20985840,20987762:20988131,20989996:20993279,20992202:20992320,20993557:20994007,20993558:20993793,20994210:20994319,21009642:21026219,21027618:21047183,21027619:21047795,21027668:21045351,21027673:21036631,21027677:21032855,21027678:21029285,21027679:2102993', 'assoc_mat': '20943977:pet_fonce:4230:20944160,20943978:pet_fonce:4230:20944120,20944758:pet_fonce:4230:20945237,20945563:pet_fonce:4230:20945717,20946203:pet_fonce:4230:20946246,20946649:pet_fonce:4230:20946805,20947068:pet_fonce:4230:20947245,20948284:pet_fonce:4230:20948307,20949000:pet_fonce:4230:20949096,20949182:pet_fonce:4230:20949195,20949476:pet_fonce:4230:20949531,20949744:pet_fonce:4230:20949784,20950040:pet_fonce:4230:20950076,20950383:pet_fonce:4230:20950453,20950736:pet_fonce:4230:20950834,20951513:pet_fonce:4230:20951596,20952015:pet_fonce:4230:20952107,20952421:pet_fonce:4230:20952476,20952779:pet_fonce:4230:20952874,20953467:pet_fonce:4230:20953604,20954162:pet_fonce:4230:20954221,20955265:pet_fonce:4230:20955323,20955518:pet_fonce:4230:20955577,20955658:pet_fonce:4230:20955713,20955904:pet_fonce:4230:20955991,20956041:pet_fonce:4230:20956095,20956149:pet_fonce:4230:20956167,20956256:pet_fonce:4230:20956272,20956405:pet_fonce:4230:20956493,20956553:pet_fonce:4230:20956566,20956666:pet_fonce:4230:20956715,2'}), 'main_stat': {'nb_photos': 911}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-03', 0.6199313122644925),)]} 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': ((911,),), 'unwanted_material_monthly_percentage': ((0.6199313122644925,),), 'material_repartition': (('incineration', 903),), 'material_dict': {'incineration': 903}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 3, 1), 0.6358994174376137, 80), (datetime.date(2025, 3, 2), 0.7521264767587421, 72), (datetime.date(2025, 3, 3), 0.8100557016201598, 52), (datetime.date(2025, 3, 4), 0.7978308717830422, 52), (datetime.date(2025, 3, 5), 0.6696704341882375, 56), (datetime.date(2025, 3, 6), 0.5800594918531125, 32), (datetime.date(2025, 3, 7), 0.48880879991907783, 61), (datetime.date(2025, 3, 8), 0.5504159018471309, 54), (datetime.date(2025, 3, 9), 0.5507854104275727, 56), (datetime.date(2025, 3, 10), 0.5362634840598333, 51), (datetime.date(2025, 3, 11), 0.5467848566875516, 61), (datetime.date(2025, 3, 12), 0.5881385319321567, 62), (datetime.date(2025, 3, 13), 0.6299044338679574, 59), (datetime.date(2025, 3, 14), 0.5651606270997768, 64), (datetime.date(2025, 3, 15), 0.5688215093234584, 58), (datetime.date(2025, 3, 16), 0.6255747739623047, 33)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 3, 1), 0.6358994174376137, 80), (datetime.date(2025, 3, 2), 0.7521264767587421, 72), (datetime.date(2025, 3, 3), 0.8100557016201598, 52), (datetime.date(2025, 3, 4), 0.7978308717830422, 52), (datetime.date(2025, 3, 5), 0.6696704341882375, 56), (datetime.date(2025, 3, 6), 0.5800594918531125, 32), (datetime.date(2025, 3, 7), 0.48880879991907783, 61), (datetime.date(2025, 3, 8), 0.5504159018471309, 54), (datetime.date(2025, 3, 9), 0.5507854104275727, 56), (datetime.date(2025, 3, 10), 0.5362634840598333, 51), (datetime.date(2025, 3, 11), 0.5467848566875516, 61), (datetime.date(2025, 3, 12), 0.5881385319321567, 62), (datetime.date(2025, 3, 13), 0.6299044338679574, 59), (datetime.date(2025, 3, 14), 0.5651606270997768, 64), (datetime.date(2025, 3, 15), 0.5688215093234584, 58), (datetime.date(2025, 3, 16), 0.6255747739623047, 33))}, 'quality_array': [['-7.737746003865416', '01032025'], ['-8.007447067084804', '02032025'], ['-6.781928358221221', '03032025'], ['-6.358807428625658', '04032025'], ['-6.53666001684734', '05032025'], ['-8.164510155964125', '06032025'], ['-8.285971937996399', '07032025'], ['-8.015586571175508', '08032025'], ['-7.914260186928855', '09032025'], ['-7.588521601804382', '10032025'], ['-7.364008243098092', '11032025'], ['-7.2837816295824', '12032025'], ['-8.209444693629239', '13032025'], ['-8.212708316791604', '14032025'], ['-8.19786906936703', '15032025'], ['-8.063113804630417', '16032025']], 'number_of_batch': ((345,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.021987073670841795, 'nb_photo': 10143, 'list_port_cont': '20944113,20944151,20945232,20945728,20946247,20946799,20947255,20947433,20947754,20948306,20949088,20949204,20949326,20949520,20949780,20950067,20950454,20950832,20951605,20952115,20952478,20952867,20953430,20953605,20954171,20954224,20954536,20954849,20955067,20955164,20955312,20955459,20955574,20955709,20955813,20955998,20956093,20956170,20956279,20956499,20956560,20956719,20956903,20957048,20957095,20957257,20957437,20961443,20963416,20965489,20966910,20969085,20970690,20974286,20975848,20977541,20979569,20985836,20988137,20992307,20993280,20993573,20993794,20993898,20994000,20994127,20994323,20995055,20995256,20995660,21026233,21027857,21028552,21028937,21029279,21029928,21031693,21032180,21032856,21034008,21034631,21035063,21036150,21036616,21041750,21042604,21043629,21045339,21045816,21047179,21047803,21048625,21050948,21084649,21084927,21085404,21085444,21086158,21086465,21087694,21088391,21088969,21089103,21090083,21090640,21091113,21091847,21092241,21092894,21094034,21094453,21095840,21096616,2109821', 'assoc_port': '20943977:20944151,20943978:20944113,20944758:20945232,20945563:20945728,20946203:20946247,20946649:20946799,20947068:20947255,20947412:20947433,20947732:20947754,20948284:20948306,20948674:20949326,20949000:20949088,20949182:20949204,20949476:20949520,20949744:20949780,20950040:20950067,20950383:20950454,20950736:20950832,20951081:20953430,20951513:20951605,20952015:20952115,20952421:20952478,20952779:20952867,20953467:20953605,20954162:20954224,20954163:20954171,20954515:20954536,20954799:20954849,20954932:20955067,20955121:20955164,20955265:20955312,20955412:20955459,20955518:20955574,20955658:20955709,20955763:20955813,20955904:20955998,20956041:20956093,20956149:20956170,20956256:20956279,20956405:20956499,20956553:20956560,20956666:20956719,20956812:20956903,20956953:20957048,20957085:20957095,20957252:20957257,20957383:20957437,20961267:20961443,20963097:20963416,20965279:20965489,20966465:20966910,20967891:20969085,20970439:20970690,20972824:20974286,20975675:20975848,20977301:20977541,20979382:2097956', 'assoc_mat': '20943977:autre:4230:20944151,20943978:autre:4230:20944113,20944758:autre:4230:20945232,20945563:autre:4230:20945728,20946203:autre:4230:20946247,20946649:autre:4230:20946799,20947068:autre:4230:20947255,20947412:autre:4230:20947433,20947732:autre:4230:20947754,20948284:autre:4230:20948306,20948674:autre:4230:20949326,20949000:autre:4230:20949088,20949182:autre:4230:20949204,20949476:autre:4230:20949520,20949744:autre:4230:20949780,20950040:autre:4230:20950067,20950383:autre:4230:20950454,20950736:autre:4230:20950832,20951081:autre:4230:20953430,20951513:autre:4230:20951605,20952015:autre:4230:20952115,20952421:autre:4230:20952478,20952779:autre:4230:20952867,20953467:autre:4230:20953605,20954162:autre:4230:20954224,20954163:autre:4230:20954171,20954515:autre:4230:20954536,20954799:autre:4230:20954849,20954932:autre:4230:20955067,20955121:autre:4230:20955164,20955265:autre:4230:20955312,20955412:autre:4230:20955459,20955518:autre:4230:20955574,20955658:autre:4230:20955709,20955763:autre:4230:20955813,20955904:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07344461681416486, 'nb_photo': 46413, 'list_port_cont': '20944116,20944158,20945240,20945727,20946245,20946802,20947250,20947425,20947746,20948305,20949099,20949205,20949332,20949532,20949779,20950071,20950459,20950831,20951610,20952108,20952470,20952866,20953435,20953610,20954183,20954225,20954526,20954859,20955071,20955178,20955321,20955469,20955576,20955711,20955815,20956001,20956096,20956171,20956281,20956497,20956574,20956718,20956895,20957042,20957107,20957267,20957435,20961444,20963423,20965493,20966918,20969088,20970704,20974295,20975841,20977532,20979575,20985843,20988135,20992314,20993278,20993574,20993786,20993909,20993997,20994138,20994331,20995066,20995261,20995655,21026232,21027862,21028565,21028943,21029277,21029933,21031705,21032186,21032849,21034019,21034635,21035059,21036143,21036618,21041763,21042609,21043625,21045342,21045828,21047193,21047798,21048640,21050947,21084650,21084914,21085405,21085436,21086157,21086468,21087705,21088396,21088975,21089113,21090087,21090647,21091115,21091850,21092230,21092899,21094044,21094456,21095837,21096623,2109821', 'assoc_port': '20943977:20944158,20943978:20944116,20944758:20945240,20945563:20945727,20946203:20946245,20946649:20946802,20947068:20947250,20947412:20947425,20947732:20947746,20948284:20948305,20948674:20949332,20949000:20949099,20949182:20949205,20949476:20949532,20949744:20949779,20950040:20950071,20950383:20950459,20950736:20950831,20951081:20953435,20951513:20951610,20952015:20952108,20952421:20952470,20952779:20952866,20953467:20953610,20954162:20954225,20954163:20954183,20954515:20954526,20954799:20954859,20954932:20955071,20955121:20955178,20955265:20955321,20955412:20955469,20955518:20955576,20955658:20955711,20955763:20955815,20955904:20956001,20956041:20956096,20956149:20956171,20956256:20956281,20956405:20956497,20956553:20956574,20956666:20956718,20956812:20956895,20956953:20957042,20957085:20957107,20957252:20957267,20957383:20957435,20961267:20961444,20963097:20963423,20965279:20965493,20966465:20966918,20967891:20969088,20970439:20970704,20972824:20974295,20975675:20975841,20977301:20977532,20979382:2097957', 'assoc_mat': '20943977:carton:4230:20944158,20943978:carton:4230:20944116,20944758:carton:4230:20945240,20945563:carton:4230:20945727,20946203:carton:4230:20946245,20946649:carton:4230:20946802,20947068:carton:4230:20947250,20947412:carton:4230:20947425,20947732:carton:4230:20947746,20948284:carton:4230:20948305,20948674:carton:4230:20949332,20949000:carton:4230:20949099,20949182:carton:4230:20949205,20949476:carton:4230:20949532,20949744:carton:4230:20949779,20950040:carton:4230:20950071,20950383:carton:4230:20950459,20950736:carton:4230:20950831,20951081:carton:4230:20953435,20951513:carton:4230:20951610,20952015:carton:4230:20952108,20952421:carton:4230:20952470,20952779:carton:4230:20952866,20953467:carton:4230:20953610,20954162:carton:4230:20954225,20954163:carton:4230:20954183,20954515:carton:4230:20954526,20954799:carton:4230:20954859,20954932:carton:4230:20955071,20955121:carton:4230:20955178,20955265:carton:4230:20955321,20955412:carton:4230:20955469,20955518:carton:4230:20955576,20955658:carton:4230:20955711,2095'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012424443317844253, 'nb_photo': 638, 'list_port_cont': '20944118,20944145,20945244,20945719,20946244,20946790,20947251,20947428,20947750,20948308,20949094,20949202,20949335,20949526,20949783,20950079,20950460,20950818,20952102,20952871,20953440,20953599,20954174,20954208,20954528,20954857,20955079,20955177,20955314,20955460,20955566,20955714,20955818,20955993,20956085,20956164,20956265,20956489,20956567,20956723,20956890,20957043,20957096,20957272,20957439,20963418,20965477,20966917,20969089,20970689,20975850,20977535,20993568,20993792,20993902,20993994,20994141,20994324,21027865,21032851,21034640,21036142,21042605,21043616,21045830,21047802,21050935,21084644,21084910,21085394,21085440,21086159,21086456,21088381,21089104,21090657,21091103,21092905,21094458,21130412,21131120,21161166,21161245,21161319,21161419,21161662,21161772,21162193,21162688,21162778,21162895,21162943,21163014,21163064,21163107,21163147,21163207,21163456,21163497,21163541,21167224,21168170,21169396,21170404,21172245,21174344,21175144,21177236,21179004,21180318,21182886,21184160,21186186,2118804', 'assoc_port': '20943977:20944145,20943978:20944118,20944758:20945244,20945563:20945719,20946203:20946244,20946649:20946790,20947068:20947251,20947412:20947428,20947732:20947750,20948284:20948308,20948674:20949335,20949000:20949094,20949182:20949202,20949476:20949526,20949744:20949783,20950040:20950079,20950383:20950460,20950736:20950818,20951081:20953440,20952015:20952102,20952779:20952871,20953467:20953599,20954162:20954208,20954163:20954174,20954515:20954528,20954799:20954857,20954932:20955079,20955121:20955177,20955265:20955314,20955412:20955460,20955518:20955566,20955658:20955714,20955763:20955818,20955904:20955993,20956041:20956085,20956149:20956164,20956256:20956265,20956405:20956489,20956553:20956567,20956666:20956723,20956812:20956890,20956953:20957043,20957085:20957096,20957252:20957272,20957383:20957439,20963097:20963418,20965279:20965477,20966465:20966917,20967891:20969089,20970439:20970689,20975675:20975850,20977301:20977535,20993556:20994141,20993557:20993994,20993558:20993792,20993559:20993902,20993560:2099356', 'assoc_mat': '20943977:metal:4230:20944145,20943978:metal:4230:20944118,20944758:metal:4230:20945244,20945563:metal:4230:20945719,20946203:metal:4230:20946244,20946649:metal:4230:20946790,20947068:metal:4230:20947251,20947412:metal:4230:20947428,20947732:metal:4230:20947750,20948284:metal:4230:20948308,20948674:metal:4230:20949335,20949000:metal:4230:20949094,20949182:metal:4230:20949202,20949476:metal:4230:20949526,20949744:metal:4230:20949783,20950040:metal:4230:20950079,20950383:metal:4230:20950460,20950736:metal:4230:20950818,20951081:metal:4230:20953440,20952015:metal:4230:20952102,20952779:metal:4230:20952871,20953467:metal:4230:20953599,20954162:metal:4230:20954208,20954163:metal:4230:20954174,20954515:metal:4230:20954528,20954799:metal:4230:20954857,20954932:metal:4230:20955079,20955121:metal:4230:20955177,20955265:metal:4230:20955314,20955412:metal:4230:20955460,20955518:metal:4230:20955566,20955658:metal:4230:20955714,20955763:metal:4230:20955818,20955904:metal:4230:20955993,20956041:metal:4230:20956085,20956149:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.29225101234456863, 'nb_photo': 167801, 'list_port_cont': '20944124,20944161,20945245,20945730,20946239,20946803,20947253,20947434,20947755,20948304,20949091,20949196,20949333,20949529,20949778,20950075,20950450,20950825,20951601,20952112,20952469,20952876,20953444,20953597,20954186,20954214,20954529,20954848,20955080,20955180,20955320,20955456,20955575,20955703,20955821,20956002,20956097,20956165,20956277,20956502,20956571,20956726,20956901,20957039,20957097,20957271,20957427,20961439,20963415,20965486,20966919,20969087,20970697,20974297,20975847,20977537,20979567,20985844,20988127,20992316,20993285,20993569,20993782,20993907,20994008,20994142,20994326,20995059,20995260,20995652,21026222,21027866,21028562,21028940,21029282,21029929,21031700,21032175,21032853,21034025,21034633,21035073,21036148,21036625,21041757,21042616,21043627,21045347,21045821,21047195,21047797,21048638,21050951,21084648,21084920,21085401,21085438,21086160,21086464,21087693,21088390,21088980,21089105,21090090,21090654,21091114,21091842,21092244,21092907,21094041,21094449,21095833,21096615,2109822', 'assoc_port': '20943977:20944161,20943978:20944124,20944758:20945245,20945563:20945730,20946203:20946239,20946649:20946803,20947068:20947253,20947412:20947434,20947732:20947755,20948284:20948304,20948674:20949333,20949000:20949091,20949182:20949196,20949476:20949529,20949744:20949778,20950040:20950075,20950383:20950450,20950736:20950825,20951081:20953444,20951513:20951601,20952015:20952112,20952421:20952469,20952779:20952876,20953467:20953597,20954162:20954214,20954163:20954186,20954515:20954529,20954799:20954848,20954932:20955080,20955121:20955180,20955265:20955320,20955412:20955456,20955518:20955575,20955658:20955703,20955763:20955821,20955904:20956002,20956041:20956097,20956149:20956165,20956256:20956277,20956405:20956502,20956553:20956571,20956666:20956726,20956812:20956901,20956953:20957039,20957085:20957097,20957252:20957271,20957383:20957427,20961267:20961439,20963097:20963415,20965279:20965486,20966465:20966919,20967891:20969087,20970439:20970697,20972824:20974297,20975675:20975847,20977301:20977537,20979382:2097956', 'assoc_mat': '20943977:papier:4230:20944161,20943978:papier:4230:20944124,20944758:papier:4230:20945245,20945563:papier:4230:20945730,20946203:papier:4230:20946239,20946649:papier:4230:20946803,20947068:papier:4230:20947253,20947412:papier:4230:20947434,20947732:papier:4230:20947755,20948284:papier:4230:20948304,20948674:papier:4230:20949333,20949000:papier:4230:20949091,20949182:papier:4230:20949196,20949476:papier:4230:20949529,20949744:papier:4230:20949778,20950040:papier:4230:20950075,20950383:papier:4230:20950450,20950736:papier:4230:20950825,20951081:papier:4230:20953444,20951513:papier:4230:20951601,20952015:papier:4230:20952112,20952421:papier:4230:20952469,20952779:papier:4230:20952876,20953467:papier:4230:20953597,20954162:papier:4230:20954214,20954163:papier:4230:20954186,20954515:papier:4230:20954529,20954799:papier:4230:20954848,20954932:papier:4230:20955080,20955121:papier:4230:20955180,20955265:papier:4230:20955320,20955412:papier:4230:20955456,20955518:papier:4230:20955575,20955658:papier:4230:20955703,2095'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005652675129537525, 'nb_photo': 1625, 'list_port_cont': '20944117,20944159,20945234,20945726,20946804,20947254,20947432,20947741,20948299,20949097,20949206,20949334,20949525,20949782,20950080,20950457,20950827,20951604,20952106,20952479,20952868,20953441,20953607,20954182,20954215,20954537,20954860,20955076,20955175,20955322,20955463,20955573,20955712,20955823,20956003,20956086,20956172,20956267,20956500,20956565,20957052,20963421,20969075,20992319,20993283,20993796,20994139,20994321,21027863,21035071,21036155,21043623,21084654,21084916,21085443,21086153,21086459,21088976,21089109,21090085,21090655,21091117,21091840,21092243,21092900,21094039,21094444,21095839,21099349,21130420,21131131,21161164,21161252,21161313,21161420,21161660,21161763,21161937,21162192,21162311,21162699,21162782,21162897,21162947,21163026,21163053,21163108,21163134,21163179,21163215,21163450,21163507,21163548,21163980,21167045,21167233,21168171,21169397,21170418,21172253,21174348,21174418,21175135,21177244,21178990,21180308,21181569,21182881,21184165,21186193,21188039,21188183,21189357,2119048', 'assoc_port': '20943977:20944159,20943978:20944117,20944758:20945234,20945563:20945726,20946649:20946804,20947068:20947254,20947412:20947432,20947732:20947741,20948284:20948299,20948674:20949334,20949000:20949097,20949182:20949206,20949476:20949525,20949744:20949782,20950040:20950080,20950383:20950457,20950736:20950827,20951081:20953441,20951513:20951604,20952015:20952106,20952421:20952479,20952779:20952868,20953467:20953607,20954162:20954215,20954163:20954182,20954515:20954537,20954799:20954860,20954932:20955076,20955121:20955175,20955265:20955322,20955412:20955463,20955518:20955573,20955658:20955712,20955763:20955823,20955904:20956003,20956041:20956086,20956149:20956172,20956256:20956267,20956405:20956500,20956553:20956565,20956953:20957052,20963097:20963421,20967891:20969075,20989996:20993283,20992202:20992319,20993556:20994139,20993558:20993796,20994210:20994321,21027670:21043623,21027672:21036155,21027675:21035071,21027681:21027863,21084512:21099349,21084518:21095839,21084520:21092900,21084522:21094039,21084524:2109444', 'assoc_mat': '20943977:pehd:4230:20944159,20943978:pehd:4230:20944117,20944758:pehd:4230:20945234,20945563:pehd:4230:20945726,20946649:pehd:4230:20946804,20947068:pehd:4230:20947254,20947412:pehd:4230:20947432,20947732:pehd:4230:20947741,20948284:pehd:4230:20948299,20948674:pehd:4230:20949334,20949000:pehd:4230:20949097,20949182:pehd:4230:20949206,20949476:pehd:4230:20949525,20949744:pehd:4230:20949782,20950040:pehd:4230:20950080,20950383:pehd:4230:20950457,20950736:pehd:4230:20950827,20951081:pehd:4230:20953441,20951513:pehd:4230:20951604,20952015:pehd:4230:20952106,20952421:pehd:4230:20952479,20952779:pehd:4230:20952868,20953467:pehd:4230:20953607,20954162:pehd:4230:20954215,20954163:pehd:4230:20954182,20954515:pehd:4230:20954537,20954799:pehd:4230:20954860,20954932:pehd:4230:20955076,20955121:pehd:4230:20955175,20955265:pehd:4230:20955322,20955412:pehd:4230:20955463,20955518:pehd:4230:20955573,20955658:pehd:4230:20955712,20955763:pehd:4230:20955823,20955904:pehd:4230:20956003,20956041:pehd:4230:20956086,20956149:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.016936004938457424, 'nb_photo': 12829, 'list_port_cont': '20944119,20944153,20945242,20945729,20946232,20946796,20947249,20947430,20947752,20948309,20949093,20949207,20949323,20949527,20949785,20950077,20950449,20950835,20951609,20952113,20952474,20952873,20953446,20953603,20954178,20954216,20954535,20954854,20955069,20955167,20955324,20955468,20955572,20955717,20955822,20955997,20956099,20956160,20956275,20956495,20956568,20956725,20956900,20957051,20957103,20957265,20957440,20961440,20963417,20965492,20966913,20969079,20970705,20974298,20975844,20977536,20979576,20985838,20988138,20992318,20993286,20993575,20993790,20993903,20994011,20994132,20994330,20995062,20995253,20995654,21026229,21027859,21028566,21028938,21029290,21029927,21031691,21032189,21032847,21034018,21034641,21035069,21036149,21036632,21041761,21042611,21043630,21045353,21045826,21047191,21047804,21048637,21050946,21084647,21084926,21085407,21085435,21086152,21086462,21087700,21088398,21088973,21089112,21090084,21090650,21091118,21091849,21092233,21092910,21094040,21094446,21095835,21096621,2109821', 'assoc_port': '20943977:20944153,20943978:20944119,20944758:20945242,20945563:20945729,20946203:20946232,20946649:20946796,20947068:20947249,20947412:20947430,20947732:20947752,20948284:20948309,20948674:20949323,20949000:20949093,20949182:20949207,20949476:20949527,20949744:20949785,20950040:20950077,20950383:20950449,20950736:20950835,20951081:20953446,20951513:20951609,20952015:20952113,20952421:20952474,20952779:20952873,20953467:20953603,20954162:20954216,20954163:20954178,20954515:20954535,20954799:20954854,20954932:20955069,20955121:20955167,20955265:20955324,20955412:20955468,20955518:20955572,20955658:20955717,20955763:20955822,20955904:20955997,20956041:20956099,20956149:20956160,20956256:20956275,20956405:20956495,20956553:20956568,20956666:20956725,20956812:20956900,20956953:20957051,20957085:20957103,20957252:20957265,20957383:20957440,20961267:20961440,20963097:20963417,20965279:20965492,20966465:20966913,20967891:20969079,20970439:20970705,20972824:20974298,20975675:20975844,20977301:20977536,20979382:2097957', 'assoc_mat': '20943977:pet_clair:4230:20944153,20943978:pet_clair:4230:20944119,20944758:pet_clair:4230:20945242,20945563:pet_clair:4230:20945729,20946203:pet_clair:4230:20946232,20946649:pet_clair:4230:20946796,20947068:pet_clair:4230:20947249,20947412:pet_clair:4230:20947430,20947732:pet_clair:4230:20947752,20948284:pet_clair:4230:20948309,20948674:pet_clair:4230:20949323,20949000:pet_clair:4230:20949093,20949182:pet_clair:4230:20949207,20949476:pet_clair:4230:20949527,20949744:pet_clair:4230:20949785,20950040:pet_clair:4230:20950077,20950383:pet_clair:4230:20950449,20950736:pet_clair:4230:20950835,20951081:pet_clair:4230:20953446,20951513:pet_clair:4230:20951609,20952015:pet_clair:4230:20952113,20952421:pet_clair:4230:20952474,20952779:pet_clair:4230:20952873,20953467:pet_clair:4230:20953603,20954162:pet_clair:4230:20954216,20954163:pet_clair:4230:20954178,20954515:pet_clair:4230:20954535,20954799:pet_clair:4230:20954854,20954932:pet_clair:4230:20955069,20955121:pet_clair:4230:20955167,20955265:pet_clair:4230:20955324,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007042890742360934, 'nb_photo': 856, 'list_port_cont': '20944120,20944160,20945237,20945717,20946246,20946805,20947245,20948307,20949096,20949195,20949531,20949784,20950076,20950453,20950834,20951596,20952107,20952476,20952874,20953604,20954221,20955323,20955577,20955713,20955991,20956095,20956167,20956272,20956493,20956566,20956715,20956904,20957049,20957101,20957270,20957441,20963413,20965483,20966916,20974294,20985840,20988131,20992320,20993279,20993793,20994007,20994319,20995262,20995650,21026219,21028559,21028941,21029285,21029935,21031695,21032177,21032855,21034016,21036631,21045351,21047183,21047795,21084646,21084921,21085437,21086161,21086469,21088387,21088978,21090092,21090652,21091116,21091841,21092242,21092901,21094037,21094457,21095836,21096614,21098213,21099357,21130423,21131125,21161247,21161414,21161663,21162196,21162696,21162781,21162894,21162944,21163058,21163100,21163142,21163182,21163222,21163512,21163536,21174428,21177230,21179005,21181570,21182883,21184170,21188186,21194192,21194543,21195107,21195227,21195279,21195404,21195666,21196599,2119685', 'assoc_port': '20943977:20944160,20943978:20944120,20944758:20945237,20945563:20945717,20946203:20946246,20946649:20946805,20947068:20947245,20948284:20948307,20949000:20949096,20949182:20949195,20949476:20949531,20949744:20949784,20950040:20950076,20950383:20950453,20950736:20950834,20951513:20951596,20952015:20952107,20952421:20952476,20952779:20952874,20953467:20953604,20954162:20954221,20955265:20955323,20955518:20955577,20955658:20955713,20955904:20955991,20956041:20956095,20956149:20956167,20956256:20956272,20956405:20956493,20956553:20956566,20956666:20956715,20956812:20956904,20956953:20957049,20957085:20957101,20957252:20957270,20957383:20957441,20963097:20963413,20965279:20965483,20966465:20966916,20972824:20974294,20981624:20995262,20983933:20995650,20985803:20985840,20987762:20988131,20989996:20993279,20992202:20992320,20993557:20994007,20993558:20993793,20994210:20994319,21009642:21026219,21027618:21047183,21027619:21047795,21027668:21045351,21027673:21036631,21027677:21032855,21027678:21029285,21027679:2102993', 'assoc_mat': '20943977:pet_fonce:4230:20944160,20943978:pet_fonce:4230:20944120,20944758:pet_fonce:4230:20945237,20945563:pet_fonce:4230:20945717,20946203:pet_fonce:4230:20946246,20946649:pet_fonce:4230:20946805,20947068:pet_fonce:4230:20947245,20948284:pet_fonce:4230:20948307,20949000:pet_fonce:4230:20949096,20949182:pet_fonce:4230:20949195,20949476:pet_fonce:4230:20949531,20949744:pet_fonce:4230:20949784,20950040:pet_fonce:4230:20950076,20950383:pet_fonce:4230:20950453,20950736:pet_fonce:4230:20950834,20951513:pet_fonce:4230:20951596,20952015:pet_fonce:4230:20952107,20952421:pet_fonce:4230:20952476,20952779:pet_fonce:4230:20952874,20953467:pet_fonce:4230:20953604,20954162:pet_fonce:4230:20954221,20955265:pet_fonce:4230:20955323,20955518:pet_fonce:4230:20955577,20955658:pet_fonce:4230:20955713,20955904:pet_fonce:4230:20955991,20956041:pet_fonce:4230:20956095,20956149:pet_fonce:4230:20956167,20956256:pet_fonce:4230:20956272,20956405:pet_fonce:4230:20956493,20956553:pet_fonce:4230:20956566,20956666:pet_fonce:4230:20956715,2'}), 'main_stat': {'nb_photos': 911}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-03', 0.6199313122644925),)]} filepath : /data_2/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_03_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', '2.2%', 10143], 'carton': ['carton', '7.34%', 46413], 'metal': ['metal', '0.12%', 638], 'papier': ['papier', '29.23%', 167801], 'pehd': ['pehd', '0.57%', 1625], 'pet_clair': ['pet_clair', '1.69%', 12829], 'pet_fonce': ['pet_fonce', '0.7%', 856]}} 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_03_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/SCCU_cam8 2.55user 2.81system 0:06.68elapsed 80%CPU (0avgtext+0avgdata 194848maxresident)k 8inputs+272outputs (10major+67820minor)pagefaults 0swaps