python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_2/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-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_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (5, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 03 mtr_id : dashboard_places : SCCU_cam7 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_cam7' 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 = 204 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 = 204 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 = 204 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_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-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 (1641155,1641377,1643791,1646910,1650538,1653393,1656909,1660071,1661843,1664138,1668386,1671933,1674574,1678157,1679833,1680086,1681717,1682883,1684045,1685100,1687701,1689509,1689932) 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.011491500604781164, 'nb_photo': 5037, 'list_port_cont': '20944841,20944963,20945643,20946731,20947282,20947498,20948498,20948695,20949137,20949229,20949897,20950415,20950754,20951124,20951833,20952030,20952427,20952901,20953514,20954942,20954988,20955215,20955280,20955537,20955778,20955910,20956062,20956314,20956424,20956685,20956852,20956964,20957140,20957345,20957475,20957530,20992729,20995304,20998781,20998866,20999090,20999133,20999230,20999260,20999301,20999407,20999481,20999595,20999645,20999710,20999752,20999782,21030744,21034271,21075144,21075203,21075359,21075398,21075440,21075645,21075885,21076031,21076590,21076648,21077221,21077537,21077606,21077871,21078193,21087891,21089936,21091554,21092114,21093236,21095070,21095462,21096415,21097509,21098329,21098690,21099508,21099947,21100409,21101178,21101714,21102137,21102904,21105473,21122085,21130208,21130935,21162633,21163269,21163298,21163373,21163589,21163625,21163664,21163705,21163783,21163852,21164075,21164111,21164704,21165015,21165303,21165606,21166122,21169162,21169284,21170339,21171105,21172141,2117357', 'assoc_port': '20944757:20944963,20944759:20944841,20945562:20945643,20946650:20946731,20947069:20947282,20947410:20947498,20948246:20948498,20948676:20948695,20948999:20949137,20949181:20949229,20949743:20949897,20950038:20951833,20950384:20950415,20950737:20950754,20951083:20951124,20952016:20952030,20952420:20952427,20952780:20952901,20953466:20953514,20954934:20954942,20954935:20954988,20955119:20955215,20955263:20955280,20955516:20955537,20955764:20955778,20955905:20955910,20956042:20956062,20956255:20956314,20956407:20956424,20956665:20956685,20956810:20956852,20956951:20956964,20957087:20957140,20957250:20957345,20957382:20957475,20957517:20957530,20992201:20992729,20993499:20999260,20993501:20999301,20993503:20999407,20993505:20999481,20993507:20999595,20993509:20999645,20993511:20999782,20993513:20999752,20993515:20999710,20993517:20999090,20993518:20999230,20993520:20999133,20993522:20998781,20993524:20998866,20995010:20995304,21027579:21075144,21027580:21075203,21027582:21075359,21027584:21075398,21027586:2107544', 'assoc_mat': '20944757:autre:4230:20944963,20944759:autre:4230:20944841,20945562:autre:4230:20945643,20946650:autre:4230:20946731,20947069:autre:4230:20947282,20947410:autre:4230:20947498,20948246:autre:4230:20948498,20948676:autre:4230:20948695,20948999:autre:4230:20949137,20949181:autre:4230:20949229,20949743:autre:4230:20949897,20950038:autre:4230:20951833,20950384:autre:4230:20950415,20950737:autre:4230:20950754,20951083:autre:4230:20951124,20952016:autre:4230:20952030,20952420:autre:4230:20952427,20952780:autre:4230:20952901,20953466:autre:4230:20953514,20954934:autre:4230:20954942,20954935:autre:4230:20954988,20955119:autre:4230:20955215,20955263:autre:4230:20955280,20955516:autre:4230:20955537,20955764:autre:4230:20955778,20955905:autre:4230:20955910,20956042:autre:4230:20956062,20956255:autre:4230:20956314,20956407:autre:4230:20956424,20956665:autre:4230:20956685,20956810:autre:4230:20956852,20956951:autre:4230:20956964,20957087:autre:4230:20957140,20957250:autre:4230:20957345,20957382:autre:4230:20957475,20957517:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0420538195284927, 'nb_photo': 25283, 'list_port_cont': '20944836,20944956,20945636,20946728,20947295,20947501,20948508,20948681,20949132,20949241,20949893,20950423,20950749,20951125,20951840,20952034,20952444,20952912,20953521,20954954,20954994,20955219,20955277,20955539,20955771,20955920,20956061,20956317,20956425,20956689,20956869,20956971,20957139,20957336,20957470,20957540,20992726,20995314,20998782,20998868,20999093,20999137,20999232,20999267,20999313,20999413,20999486,20999586,20999640,20999720,20999753,20999777,21030757,21034278,21075159,21075208,21075376,21075406,21075455,21075648,21075893,21076036,21076583,21076647,21077235,21077545,21077608,21077874,21078198,21087892,21089930,21091559,21092117,21093239,21095068,21095477,21096420,21097520,21098328,21098702,21099507,21099950,21100397,21101170,21101716,21102139,21102906,21105480,21122078,21130219,21130938,21162638,21163274,21163302,21163369,21163604,21163637,21163670,21163710,21163786,21163841,21164085,21164125,21164716,21165028,21165318,21165600,21166127,21169164,21169283,21170336,21171107,21172143,2117357', 'assoc_port': '20944757:20944956,20944759:20944836,20945562:20945636,20946650:20946728,20947069:20947295,20947410:20947501,20948246:20948508,20948676:20948681,20948999:20949132,20949181:20949241,20949743:20949893,20950038:20951840,20950384:20950423,20950737:20950749,20951083:20951125,20952016:20952034,20952420:20952444,20952780:20952912,20953466:20953521,20954934:20954954,20954935:20954994,20955119:20955219,20955263:20955277,20955516:20955539,20955764:20955771,20955905:20955920,20956042:20956061,20956255:20956317,20956407:20956425,20956665:20956689,20956810:20956869,20956951:20956971,20957087:20957139,20957250:20957336,20957382:20957470,20957517:20957540,20992201:20992726,20993499:20999267,20993501:20999313,20993503:20999413,20993505:20999486,20993507:20999586,20993509:20999640,20993511:20999777,20993513:20999753,20993515:20999720,20993517:20999093,20993518:20999232,20993520:20999137,20993522:20998782,20993524:20998868,20995010:20995314,21027579:21075159,21027580:21075208,21027582:21075376,21027584:21075406,21027586:2107545', 'assoc_mat': '20944757:carton:4230:20944956,20944759:carton:4230:20944836,20945562:carton:4230:20945636,20946650:carton:4230:20946728,20947069:carton:4230:20947295,20947410:carton:4230:20947501,20948246:carton:4230:20948508,20948676:carton:4230:20948681,20948999:carton:4230:20949132,20949181:carton:4230:20949241,20949743:carton:4230:20949893,20950038:carton:4230:20951840,20950384:carton:4230:20950423,20950737:carton:4230:20950749,20951083:carton:4230:20951125,20952016:carton:4230:20952034,20952420:carton:4230:20952444,20952780:carton:4230:20952912,20953466:carton:4230:20953521,20954934:carton:4230:20954954,20954935:carton:4230:20954994,20955119:carton:4230:20955219,20955263:carton:4230:20955277,20955516:carton:4230:20955539,20955764:carton:4230:20955771,20955905:carton:4230:20955920,20956042:carton:4230:20956061,20956255:carton:4230:20956317,20956407:carton:4230:20956425,20956665:carton:4230:20956689,20956810:carton:4230:20956869,20956951:carton:4230:20956971,20957087:carton:4230:20957139,20957250:carton:4230:20957336,2095'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0009834132349895368, 'nb_photo': 496, 'list_port_cont': '20944826,20944951,20946733,20947292,20948493,20948692,20949226,20949887,20950425,20950760,20951841,20952020,20952435,20952898,20953525,20954958,20954980,20955286,20955918,20956065,20956868,20956963,20957145,20957344,20957474,20998870,20999225,20999307,20999493,20999592,20999646,21030745,21075402,21075448,21075658,21076028,21076586,21076639,21077222,21077609,21087889,21089944,21091544,21092106,21093244,21095066,21095470,21096417,21102909,21105469,21130207,21130925,21162634,21163362,21163628,21163669,21163712,21163774,21163850,21164087,21164703,21165304,21166118,21169152,21169271,21170329,21171100,21172136,21173564,21175285,21176959,21181519,21182623,21196767,21197129,21197782,21197902,21198049,21199409,21212271,21212455,21212740,21212751,21212843,21214150,21245500,21245725,21246517,21246892,21247238,21247556,21247607,21291222,21294081,21297904,21303816,21304007,21316438,21316815,21317619,21317845,21318068,21318087,21318310,21368175,21368373,21368382,21368549,21368578,21368645,21368672,21368727,21368798,2136882', 'assoc_port': '20944757:20944951,20944759:20944826,20946650:20946733,20947069:20947292,20948246:20948493,20948676:20948692,20949181:20949226,20949743:20949887,20950038:20951841,20950384:20950425,20950737:20950760,20952016:20952020,20952420:20952435,20952780:20952898,20953466:20953525,20954934:20954958,20954935:20954980,20955263:20955286,20955905:20955918,20956042:20956065,20956810:20956868,20956951:20956963,20957087:20957145,20957250:20957344,20957382:20957474,20993501:20999307,20993505:20999493,20993507:20999592,20993509:20999646,20993518:20999225,20993524:20998870,21027584:21075402,21027586:21075448,21027588:21075658,21027592:21076028,21027594:21076639,21027596:21076586,21027600:21077222,21027602:21077609,21030443:21030745,21084513:21105469,21084521:21102909,21084535:21095470,21084537:21093244,21084539:21096417,21084541:21095066,21084543:21092106,21084545:21091544,21086705:21087889,21088949:21089944,21129072:21198049,21129073:21197782,21129075:21197902,21129078:21197129,21129088:21199409,21129091:21196767,21129937:2113020', 'assoc_mat': '20944757:metal:4230:20944951,20944759:metal:4230:20944826,20946650:metal:4230:20946733,20947069:metal:4230:20947292,20948246:metal:4230:20948493,20948676:metal:4230:20948692,20949181:metal:4230:20949226,20949743:metal:4230:20949887,20950038:metal:4230:20951841,20950384:metal:4230:20950425,20950737:metal:4230:20950760,20952016:metal:4230:20952020,20952420:metal:4230:20952435,20952780:metal:4230:20952898,20953466:metal:4230:20953525,20954934:metal:4230:20954958,20954935:metal:4230:20954980,20955263:metal:4230:20955286,20955905:metal:4230:20955918,20956042:metal:4230:20956065,20956810:metal:4230:20956868,20956951:metal:4230:20956963,20957087:metal:4230:20957145,20957250:metal:4230:20957344,20957382:metal:4230:20957474,20993501:metal:4230:20999307,20993505:metal:4230:20999493,20993507:metal:4230:20999592,20993509:metal:4230:20999646,20993518:metal:4230:20999225,20993524:metal:4230:20998870,21027584:metal:4230:21075402,21027586:metal:4230:21075448,21027588:metal:4230:21075658,21027592:metal:4230:21076028,21027594:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.15857779136019987, 'nb_photo': 104879, 'list_port_cont': '20944842,20944959,20945633,20946723,20947289,20947496,20948510,20948694,20949136,20949232,20949898,20950422,20950758,20951129,20951837,20952025,20952436,20952907,20953523,20954951,20954995,20955224,20955279,20955541,20955780,20955922,20956063,20956315,20956426,20956679,20956862,20956959,20957137,20957343,20957468,20957543,20992723,20995310,20998787,20998877,20999099,20999147,20999220,20999263,20999303,20999418,20999494,20999590,20999637,20999721,20999755,20999787,21030754,21034280,21075150,21075210,21075370,21075410,21075454,21075657,21075889,21076039,21076591,21076653,21077230,21077544,21077612,21077879,21078196,21087881,21089941,21091553,21092118,21093241,21095069,21095467,21096425,21097521,21098335,21098696,21099510,21099949,21100412,21101176,21101717,21102146,21102902,21105472,21122084,21130220,21130939,21162646,21163265,21163309,21163378,21163601,21163634,21163672,21163707,21163773,21163844,21164082,21164119,21164712,21165019,21165305,21165609,21166134,21169163,21169287,21170338,21171109,21172130,2117357', 'assoc_port': '20944757:20944959,20944759:20944842,20945562:20945633,20946650:20946723,20947069:20947289,20947410:20947496,20948246:20948510,20948676:20948694,20948999:20949136,20949181:20949232,20949743:20949898,20950038:20951837,20950384:20950422,20950737:20950758,20951083:20951129,20952016:20952025,20952420:20952436,20952780:20952907,20953466:20953523,20954934:20954951,20954935:20954995,20955119:20955224,20955263:20955279,20955516:20955541,20955764:20955780,20955905:20955922,20956042:20956063,20956255:20956315,20956407:20956426,20956665:20956679,20956810:20956862,20956951:20956959,20957087:20957137,20957250:20957343,20957382:20957468,20957517:20957543,20992201:20992723,20993499:20999263,20993501:20999303,20993503:20999418,20993505:20999494,20993507:20999590,20993509:20999637,20993511:20999787,20993513:20999755,20993515:20999721,20993517:20999099,20993518:20999220,20993520:20999147,20993522:20998787,20993524:20998877,20995010:20995310,21027579:21075150,21027580:21075210,21027582:21075370,21027584:21075410,21027586:2107545', 'assoc_mat': '20944757:papier:4230:20944959,20944759:papier:4230:20944842,20945562:papier:4230:20945633,20946650:papier:4230:20946723,20947069:papier:4230:20947289,20947410:papier:4230:20947496,20948246:papier:4230:20948510,20948676:papier:4230:20948694,20948999:papier:4230:20949136,20949181:papier:4230:20949232,20949743:papier:4230:20949898,20950038:papier:4230:20951837,20950384:papier:4230:20950422,20950737:papier:4230:20950758,20951083:papier:4230:20951129,20952016:papier:4230:20952025,20952420:papier:4230:20952436,20952780:papier:4230:20952907,20953466:papier:4230:20953523,20954934:papier:4230:20954951,20954935:papier:4230:20954995,20955119:papier:4230:20955224,20955263:papier:4230:20955279,20955516:papier:4230:20955541,20955764:papier:4230:20955780,20955905:papier:4230:20955922,20956042:papier:4230:20956063,20956255:papier:4230:20956315,20956407:papier:4230:20956426,20956665:papier:4230:20956679,20956810:papier:4230:20956862,20956951:papier:4230:20956959,20957087:papier:4230:20957137,20957250:papier:4230:20957343,2095'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003033172409714002, 'nb_photo': 595, 'list_port_cont': '20948504,20948682,20949134,20949242,20949903,20950420,20950755,20951838,20952023,20952437,20952908,20953527,20954950,20954983,20955216,20955785,20955924,20956312,20956427,20956677,20956860,20957536,20992720,20999141,20999310,20999411,20999491,20999793,21034281,21075445,21075656,21076038,21076594,21076655,21077234,21087888,21091561,21092119,21095071,21095465,21096421,21097515,21099956,21101179,21122073,21130204,21130942,21162644,21163271,21163311,21163379,21163639,21163668,21163713,21163781,21163845,21164081,21164117,21164719,21165029,21165601,21166129,21169288,21170331,21171117,21172137,21173578,21175296,21181522,21183829,21192588,21196761,21197791,21197905,21198044,21199403,21212561,21212747,21212897,21212972,21213017,21213059,21213099,21213173,21213246,21244628,21245497,21245735,21246089,21246423,21246519,21246901,21247616,21291214,21294113,21297912,21303813,21304029,21316454,21316828,21317851,21318066,21318299,21368172,21368277,21368392,21368589,21368656,21368729,21368797,21368832,21368946,21369487,2137078', 'assoc_port': '20948246:20948504,20948676:20948682,20948999:20949134,20949181:20949242,20949743:20949903,20950038:20951838,20950384:20950420,20950737:20950755,20952016:20952023,20952420:20952437,20952780:20952908,20953466:20953527,20954934:20954950,20954935:20954983,20955119:20955216,20955764:20955785,20955905:20955924,20956255:20956312,20956407:20956427,20956665:20956677,20956810:20956860,20957517:20957536,20992201:20992720,20993501:20999310,20993503:20999411,20993505:20999491,20993511:20999793,20993520:20999141,21027586:21075445,21027588:21075656,21027592:21076038,21027594:21076655,21027596:21076594,21027598:21122073,21027600:21077234,21033063:21034281,21084523:21099956,21084531:21097515,21084533:21101179,21084535:21095465,21084539:21096421,21084541:21095071,21084543:21092119,21084545:21091561,21086705:21087888,21129072:21198044,21129073:21197791,21129075:21197905,21129088:21199403,21129091:21196761,21129937:21130204,21130687:21130942,21160894:21165601,21160901:21165029,21160905:21166129,21160909:21164081,21160913:2116471', 'assoc_mat': '20948246:pehd:4230:20948504,20948676:pehd:4230:20948682,20948999:pehd:4230:20949134,20949181:pehd:4230:20949242,20949743:pehd:4230:20949903,20950038:pehd:4230:20951838,20950384:pehd:4230:20950420,20950737:pehd:4230:20950755,20952016:pehd:4230:20952023,20952420:pehd:4230:20952437,20952780:pehd:4230:20952908,20953466:pehd:4230:20953527,20954934:pehd:4230:20954950,20954935:pehd:4230:20954983,20955119:pehd:4230:20955216,20955764:pehd:4230:20955785,20955905:pehd:4230:20955924,20956255:pehd:4230:20956312,20956407:pehd:4230:20956427,20956665:pehd:4230:20956677,20956810:pehd:4230:20956860,20957517:pehd:4230:20957536,20992201:pehd:4230:20992720,20993501:pehd:4230:20999310,20993503:pehd:4230:20999411,20993505:pehd:4230:20999491,20993511:pehd:4230:20999793,20993520:pehd:4230:20999141,21027586:pehd:4230:21075445,21027588:pehd:4230:21075656,21027592:pehd:4230:21076038,21027594:pehd:4230:21076655,21027596:pehd:4230:21076594,21027598:pehd:4230:21122073,21027600:pehd:4230:21077234,21033063:pehd:4230:21034281,21084523:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00869854615063337, 'nb_photo': 6499, 'list_port_cont': '20944830,20944957,20945637,20946730,20947298,20947494,20948503,20948684,20949139,20949237,20949902,20950414,20950759,20951133,20951828,20952033,20952443,20952909,20953513,20954957,20954992,20955220,20955287,20955540,20955779,20955925,20956051,20956306,20956421,20956683,20956863,20956969,20957144,20957338,20957473,20957542,20992728,20995309,20998779,20998873,20999105,20999144,20999219,20999262,20999308,20999415,20999495,20999593,20999649,20999717,20999747,20999785,21030752,21034270,21075151,21075206,21075361,21075414,21075446,21075659,21075892,21076040,21076593,21076649,21077226,21077547,21077610,21077882,21078203,21087890,21089943,21091546,21092116,21093247,21095074,21095464,21096423,21097524,21098334,21098694,21099506,21099953,21100408,21101180,21101710,21102140,21102905,21105481,21122087,21130216,21130941,21162647,21163272,21163310,21163372,21163593,21163633,21163673,21163714,21163778,21163843,21164079,21164126,21164718,21165026,21165315,21165605,21166128,21169151,21169278,21170326,21171108,21172140,2117356', 'assoc_port': '20944757:20944957,20944759:20944830,20945562:20945637,20946650:20946730,20947069:20947298,20947410:20947494,20948246:20948503,20948676:20948684,20948999:20949139,20949181:20949237,20949743:20949902,20950038:20951828,20950384:20950414,20950737:20950759,20951083:20951133,20952016:20952033,20952420:20952443,20952780:20952909,20953466:20953513,20954934:20954957,20954935:20954992,20955119:20955220,20955263:20955287,20955516:20955540,20955764:20955779,20955905:20955925,20956042:20956051,20956255:20956306,20956407:20956421,20956665:20956683,20956810:20956863,20956951:20956969,20957087:20957144,20957250:20957338,20957382:20957473,20957517:20957542,20992201:20992728,20993499:20999262,20993501:20999308,20993503:20999415,20993505:20999495,20993507:20999593,20993509:20999649,20993511:20999785,20993513:20999747,20993515:20999717,20993517:20999105,20993518:20999219,20993520:20999144,20993522:20998779,20993524:20998873,20995010:20995309,21027579:21075151,21027580:21075206,21027582:21075361,21027584:21075414,21027586:2107544', 'assoc_mat': '20944757:pet_clair:4230:20944957,20944759:pet_clair:4230:20944830,20945562:pet_clair:4230:20945637,20946650:pet_clair:4230:20946730,20947069:pet_clair:4230:20947298,20947410:pet_clair:4230:20947494,20948246:pet_clair:4230:20948503,20948676:pet_clair:4230:20948684,20948999:pet_clair:4230:20949139,20949181:pet_clair:4230:20949237,20949743:pet_clair:4230:20949902,20950038:pet_clair:4230:20951828,20950384:pet_clair:4230:20950414,20950737:pet_clair:4230:20950759,20951083:pet_clair:4230:20951133,20952016:pet_clair:4230:20952033,20952420:pet_clair:4230:20952443,20952780:pet_clair:4230:20952909,20953466:pet_clair:4230:20953513,20954934:pet_clair:4230:20954957,20954935:pet_clair:4230:20954992,20955119:pet_clair:4230:20955220,20955263:pet_clair:4230:20955287,20955516:pet_clair:4230:20955540,20955764:pet_clair:4230:20955779,20955905:pet_clair:4230:20955925,20956042:pet_clair:4230:20956051,20956255:pet_clair:4230:20956306,20956407:pet_clair:4230:20956421,20956665:pet_clair:4230:20956683,20956810:pet_clair:4230:20956863,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002200922286199637, 'nb_photo': 244, 'list_port_cont': '20950417,20950753,20951128,20951834,20955782,20956059,20999490,20999719,20999750,20999786,21075653,21075895,21076035,21076646,21077237,21077613,21078200,21089940,21092122,21093245,21095064,21095476,21096414,21101181,21101719,21105471,21122086,21130932,21162645,21163640,21163777,21163851,21164112,21166133,21170332,21171116,21181524,21192590,21197128,21197518,21197793,21197914,21212277,21212704,21212857,21212912,21212974,21213013,21213110,21213127,21213228,21243769,21244626,21244797,21245510,21245732,21246091,21246430,21246511,21291221,21297915,21303815,21316448,21316725,21316819,21317854,21318184,21365887,21367284,21368177,21368393,21368540,21368655,21368801,21368827,21369008,21370339,21370778,21401071,21401270,21401482,21402035,21402095,21402251,21402801,21402858,21403311,21456659,21456864,21457114,21457575,21457678,21457824,21457923,21457972,21458060,21471578,21476939,21503233,21503312,21503516,21503646,21503686,21504068,21524037,21526203,21526395,21526636,21526656,21526722,21526761,21545094,21545265,2154529', 'assoc_port': '20950038:20951834,20950384:20950417,20950737:20950753,20951083:20951128,20955764:20955782,20956042:20956059,20993505:20999490,20993511:20999786,20993513:20999750,20993515:20999719,21027588:21075653,21027590:21075895,21027592:21076035,21027594:21076646,21027598:21122086,21027600:21077237,21027602:21077613,21027608:21078200,21084513:21105471,21084515:21101719,21084533:21101181,21084535:21095476,21084537:21093245,21084539:21096414,21084541:21095064,21084543:21092122,21088949:21089940,21129073:21197793,21129075:21197914,21129078:21197128,21129081:21197518,21130687:21130932,21160905:21166133,21160917:21164112,21160923:21163640,21160925:21163851,21162413:21162645,21163734:21163777,21170172:21170332,21170889:21171116,21181367:21181524,21192388:21192590,21211793:21213110,21211805:21213127,21211808:21213013,21211810:21213228,21211812:21212912,21211814:21212974,21211816:21212857,21211818:21212704,21211830:21212277,21243461:21246511,21243468:21246091,21243479:21246430,21243480:21245732,21243481:21245510,21243482:2124479', 'assoc_mat': '20950038:pet_fonce:4230:20951834,20950384:pet_fonce:4230:20950417,20950737:pet_fonce:4230:20950753,20951083:pet_fonce:4230:20951128,20955764:pet_fonce:4230:20955782,20956042:pet_fonce:4230:20956059,20993505:pet_fonce:4230:20999490,20993511:pet_fonce:4230:20999786,20993513:pet_fonce:4230:20999750,20993515:pet_fonce:4230:20999719,21027588:pet_fonce:4230:21075653,21027590:pet_fonce:4230:21075895,21027592:pet_fonce:4230:21076035,21027594:pet_fonce:4230:21076646,21027598:pet_fonce:4230:21122086,21027600:pet_fonce:4230:21077237,21027602:pet_fonce:4230:21077613,21027608:pet_fonce:4230:21078200,21084513:pet_fonce:4230:21105471,21084515:pet_fonce:4230:21101719,21084533:pet_fonce:4230:21101181,21084535:pet_fonce:4230:21095476,21084537:pet_fonce:4230:21093245,21084539:pet_fonce:4230:21096414,21084541:pet_fonce:4230:21095064,21084543:pet_fonce:4230:21092122,21088949:pet_fonce:4230:21089940,21129073:pet_fonce:4230:21197793,21129075:pet_fonce:4230:21197914,21129078:pet_fonce:4230:21197128,21129081:pet_fonce:4230:21197518,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(1641155,1641377,1643791,1646910,1650538,1653393,1656909,1660071,1661843,1664138,1668386,1671933,1674574,1678157,1679833,1680086,1681717,1682883,1684045,1685100,1687701,1689509,1689932)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2025-03-01' and date <= '2025-03-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((742,),), 'unwanted_material_monthly_percentage': ((0.8066036444536381,),), 'material_repartition': (('incineration', 737),), 'material_dict': {'incineration': 737}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 3, 1), 0.8113375861161847, 35), (datetime.date(2025, 3, 2), 0.8504317712871088, 29), (datetime.date(2025, 3, 3), 0.8869915804005813, 26), (datetime.date(2025, 3, 4), 0.8257926323704756, 33), (datetime.date(2025, 3, 5), 0.7526899545081115, 32), (datetime.date(2025, 3, 6), 0.7247064630125633, 17), (datetime.date(2025, 3, 7), 0.7332518294987034, 38), (datetime.date(2025, 3, 8), 0.7700949261094928, 31), (datetime.date(2025, 3, 9), 0.8635757769036043, 31), (datetime.date(2025, 3, 10), 0.8352427988346002, 38), (datetime.date(2025, 3, 11), 0.793289901802466, 42), (datetime.date(2025, 3, 12), 0.8127522222801009, 40), (datetime.date(2025, 3, 13), 0.8280239481676105, 36), (datetime.date(2025, 3, 14), 0.7653521029457784, 45), (datetime.date(2025, 3, 15), 0.8378833008804271, 38), (datetime.date(2025, 3, 16), 0.8955355859546758, 28), (datetime.date(2025, 3, 17), 0.8394205908008903, 43), (datetime.date(2025, 3, 18), 0.8403793040800775, 38), (datetime.date(2025, 3, 19), 0.8163741239297262, 27), (datetime.date(2025, 3, 20), 0.8220867514486085, 30), (datetime.date(2025, 3, 21), 0.7519495418303559, 32), (datetime.date(2025, 3, 22), 0.5895771477979268, 14), (datetime.date(2025, 3, 23), 0.7005002210829915, 14)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 3, 1), 0.8113375861161847, 35), (datetime.date(2025, 3, 2), 0.8504317712871088, 29), (datetime.date(2025, 3, 3), 0.8869915804005813, 26), (datetime.date(2025, 3, 4), 0.8257926323704756, 33), (datetime.date(2025, 3, 5), 0.7526899545081115, 32), (datetime.date(2025, 3, 6), 0.7247064630125633, 17), (datetime.date(2025, 3, 7), 0.7332518294987034, 38), (datetime.date(2025, 3, 8), 0.7700949261094928, 31), (datetime.date(2025, 3, 9), 0.8635757769036043, 31), (datetime.date(2025, 3, 10), 0.8352427988346002, 38), (datetime.date(2025, 3, 11), 0.793289901802466, 42), (datetime.date(2025, 3, 12), 0.8127522222801009, 40), (datetime.date(2025, 3, 13), 0.8280239481676105, 36), (datetime.date(2025, 3, 14), 0.7653521029457784, 45), (datetime.date(2025, 3, 15), 0.8378833008804271, 38), (datetime.date(2025, 3, 16), 0.8955355859546758, 28), (datetime.date(2025, 3, 17), 0.8394205908008903, 43), (datetime.date(2025, 3, 18), 0.8403793040800775, 38), (datetime.date(2025, 3, 19), 0.8163741239297262, 27), (datetime.date(2025, 3, 20), 0.8220867514486085, 30), (datetime.date(2025, 3, 21), 0.7519495418303559, 32), (datetime.date(2025, 3, 22), 0.5895771477979268, 14), (datetime.date(2025, 3, 23), 0.7005002210829915, 14))}, 'quality_array': [['-7.7564858101421645', '01032025'], ['-7.879297089221759', '02032025'], ['-6.570770044139666', '03032025'], ['-7.104577722334345', '04032025'], ['-7.5687398437228675', '05032025'], ['-7.764932975009913', '06032025'], ['-8.009686520503019', '07032025'], ['-7.9127824905463715', '08032025'], ['-7.743508880163758', '09032025'], ['-7.397728386602724', '10032025'], ['-7.495173439725212', '11032025'], ['-7.615539029727611', '12032025'], ['-7.509186732235089', '13032025'], ['-7.611185348975085', '14032025'], ['-7.524595712135079', '15032025'], ['-7.261252580367065', '16032025'], ['-6.93342132209533', '17032025'], ['-7.108237984689372', '18032025'], ['-7.051673285644271', '19032025'], ['-7.2136547904601', '20032025'], ['-7.552149759604954', '21032025'], ['-9.195921563940349', '22032025'], ['-9.270070348788982', '23032025']], 'number_of_batch': ((397,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011491500604781164, 'nb_photo': 5037, 'list_port_cont': '20944841,20944963,20945643,20946731,20947282,20947498,20948498,20948695,20949137,20949229,20949897,20950415,20950754,20951124,20951833,20952030,20952427,20952901,20953514,20954942,20954988,20955215,20955280,20955537,20955778,20955910,20956062,20956314,20956424,20956685,20956852,20956964,20957140,20957345,20957475,20957530,20992729,20995304,20998781,20998866,20999090,20999133,20999230,20999260,20999301,20999407,20999481,20999595,20999645,20999710,20999752,20999782,21030744,21034271,21075144,21075203,21075359,21075398,21075440,21075645,21075885,21076031,21076590,21076648,21077221,21077537,21077606,21077871,21078193,21087891,21089936,21091554,21092114,21093236,21095070,21095462,21096415,21097509,21098329,21098690,21099508,21099947,21100409,21101178,21101714,21102137,21102904,21105473,21122085,21130208,21130935,21162633,21163269,21163298,21163373,21163589,21163625,21163664,21163705,21163783,21163852,21164075,21164111,21164704,21165015,21165303,21165606,21166122,21169162,21169284,21170339,21171105,21172141,2117357', 'assoc_port': '20944757:20944963,20944759:20944841,20945562:20945643,20946650:20946731,20947069:20947282,20947410:20947498,20948246:20948498,20948676:20948695,20948999:20949137,20949181:20949229,20949743:20949897,20950038:20951833,20950384:20950415,20950737:20950754,20951083:20951124,20952016:20952030,20952420:20952427,20952780:20952901,20953466:20953514,20954934:20954942,20954935:20954988,20955119:20955215,20955263:20955280,20955516:20955537,20955764:20955778,20955905:20955910,20956042:20956062,20956255:20956314,20956407:20956424,20956665:20956685,20956810:20956852,20956951:20956964,20957087:20957140,20957250:20957345,20957382:20957475,20957517:20957530,20992201:20992729,20993499:20999260,20993501:20999301,20993503:20999407,20993505:20999481,20993507:20999595,20993509:20999645,20993511:20999782,20993513:20999752,20993515:20999710,20993517:20999090,20993518:20999230,20993520:20999133,20993522:20998781,20993524:20998866,20995010:20995304,21027579:21075144,21027580:21075203,21027582:21075359,21027584:21075398,21027586:2107544', 'assoc_mat': '20944757:autre:4230:20944963,20944759:autre:4230:20944841,20945562:autre:4230:20945643,20946650:autre:4230:20946731,20947069:autre:4230:20947282,20947410:autre:4230:20947498,20948246:autre:4230:20948498,20948676:autre:4230:20948695,20948999:autre:4230:20949137,20949181:autre:4230:20949229,20949743:autre:4230:20949897,20950038:autre:4230:20951833,20950384:autre:4230:20950415,20950737:autre:4230:20950754,20951083:autre:4230:20951124,20952016:autre:4230:20952030,20952420:autre:4230:20952427,20952780:autre:4230:20952901,20953466:autre:4230:20953514,20954934:autre:4230:20954942,20954935:autre:4230:20954988,20955119:autre:4230:20955215,20955263:autre:4230:20955280,20955516:autre:4230:20955537,20955764:autre:4230:20955778,20955905:autre:4230:20955910,20956042:autre:4230:20956062,20956255:autre:4230:20956314,20956407:autre:4230:20956424,20956665:autre:4230:20956685,20956810:autre:4230:20956852,20956951:autre:4230:20956964,20957087:autre:4230:20957140,20957250:autre:4230:20957345,20957382:autre:4230:20957475,20957517:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0420538195284927, 'nb_photo': 25283, 'list_port_cont': '20944836,20944956,20945636,20946728,20947295,20947501,20948508,20948681,20949132,20949241,20949893,20950423,20950749,20951125,20951840,20952034,20952444,20952912,20953521,20954954,20954994,20955219,20955277,20955539,20955771,20955920,20956061,20956317,20956425,20956689,20956869,20956971,20957139,20957336,20957470,20957540,20992726,20995314,20998782,20998868,20999093,20999137,20999232,20999267,20999313,20999413,20999486,20999586,20999640,20999720,20999753,20999777,21030757,21034278,21075159,21075208,21075376,21075406,21075455,21075648,21075893,21076036,21076583,21076647,21077235,21077545,21077608,21077874,21078198,21087892,21089930,21091559,21092117,21093239,21095068,21095477,21096420,21097520,21098328,21098702,21099507,21099950,21100397,21101170,21101716,21102139,21102906,21105480,21122078,21130219,21130938,21162638,21163274,21163302,21163369,21163604,21163637,21163670,21163710,21163786,21163841,21164085,21164125,21164716,21165028,21165318,21165600,21166127,21169164,21169283,21170336,21171107,21172143,2117357', 'assoc_port': '20944757:20944956,20944759:20944836,20945562:20945636,20946650:20946728,20947069:20947295,20947410:20947501,20948246:20948508,20948676:20948681,20948999:20949132,20949181:20949241,20949743:20949893,20950038:20951840,20950384:20950423,20950737:20950749,20951083:20951125,20952016:20952034,20952420:20952444,20952780:20952912,20953466:20953521,20954934:20954954,20954935:20954994,20955119:20955219,20955263:20955277,20955516:20955539,20955764:20955771,20955905:20955920,20956042:20956061,20956255:20956317,20956407:20956425,20956665:20956689,20956810:20956869,20956951:20956971,20957087:20957139,20957250:20957336,20957382:20957470,20957517:20957540,20992201:20992726,20993499:20999267,20993501:20999313,20993503:20999413,20993505:20999486,20993507:20999586,20993509:20999640,20993511:20999777,20993513:20999753,20993515:20999720,20993517:20999093,20993518:20999232,20993520:20999137,20993522:20998782,20993524:20998868,20995010:20995314,21027579:21075159,21027580:21075208,21027582:21075376,21027584:21075406,21027586:2107545', 'assoc_mat': '20944757:carton:4230:20944956,20944759:carton:4230:20944836,20945562:carton:4230:20945636,20946650:carton:4230:20946728,20947069:carton:4230:20947295,20947410:carton:4230:20947501,20948246:carton:4230:20948508,20948676:carton:4230:20948681,20948999:carton:4230:20949132,20949181:carton:4230:20949241,20949743:carton:4230:20949893,20950038:carton:4230:20951840,20950384:carton:4230:20950423,20950737:carton:4230:20950749,20951083:carton:4230:20951125,20952016:carton:4230:20952034,20952420:carton:4230:20952444,20952780:carton:4230:20952912,20953466:carton:4230:20953521,20954934:carton:4230:20954954,20954935:carton:4230:20954994,20955119:carton:4230:20955219,20955263:carton:4230:20955277,20955516:carton:4230:20955539,20955764:carton:4230:20955771,20955905:carton:4230:20955920,20956042:carton:4230:20956061,20956255:carton:4230:20956317,20956407:carton:4230:20956425,20956665:carton:4230:20956689,20956810:carton:4230:20956869,20956951:carton:4230:20956971,20957087:carton:4230:20957139,20957250:carton:4230:20957336,2095'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0009834132349895368, 'nb_photo': 496, 'list_port_cont': '20944826,20944951,20946733,20947292,20948493,20948692,20949226,20949887,20950425,20950760,20951841,20952020,20952435,20952898,20953525,20954958,20954980,20955286,20955918,20956065,20956868,20956963,20957145,20957344,20957474,20998870,20999225,20999307,20999493,20999592,20999646,21030745,21075402,21075448,21075658,21076028,21076586,21076639,21077222,21077609,21087889,21089944,21091544,21092106,21093244,21095066,21095470,21096417,21102909,21105469,21130207,21130925,21162634,21163362,21163628,21163669,21163712,21163774,21163850,21164087,21164703,21165304,21166118,21169152,21169271,21170329,21171100,21172136,21173564,21175285,21176959,21181519,21182623,21196767,21197129,21197782,21197902,21198049,21199409,21212271,21212455,21212740,21212751,21212843,21214150,21245500,21245725,21246517,21246892,21247238,21247556,21247607,21291222,21294081,21297904,21303816,21304007,21316438,21316815,21317619,21317845,21318068,21318087,21318310,21368175,21368373,21368382,21368549,21368578,21368645,21368672,21368727,21368798,2136882', 'assoc_port': '20944757:20944951,20944759:20944826,20946650:20946733,20947069:20947292,20948246:20948493,20948676:20948692,20949181:20949226,20949743:20949887,20950038:20951841,20950384:20950425,20950737:20950760,20952016:20952020,20952420:20952435,20952780:20952898,20953466:20953525,20954934:20954958,20954935:20954980,20955263:20955286,20955905:20955918,20956042:20956065,20956810:20956868,20956951:20956963,20957087:20957145,20957250:20957344,20957382:20957474,20993501:20999307,20993505:20999493,20993507:20999592,20993509:20999646,20993518:20999225,20993524:20998870,21027584:21075402,21027586:21075448,21027588:21075658,21027592:21076028,21027594:21076639,21027596:21076586,21027600:21077222,21027602:21077609,21030443:21030745,21084513:21105469,21084521:21102909,21084535:21095470,21084537:21093244,21084539:21096417,21084541:21095066,21084543:21092106,21084545:21091544,21086705:21087889,21088949:21089944,21129072:21198049,21129073:21197782,21129075:21197902,21129078:21197129,21129088:21199409,21129091:21196767,21129937:2113020', 'assoc_mat': '20944757:metal:4230:20944951,20944759:metal:4230:20944826,20946650:metal:4230:20946733,20947069:metal:4230:20947292,20948246:metal:4230:20948493,20948676:metal:4230:20948692,20949181:metal:4230:20949226,20949743:metal:4230:20949887,20950038:metal:4230:20951841,20950384:metal:4230:20950425,20950737:metal:4230:20950760,20952016:metal:4230:20952020,20952420:metal:4230:20952435,20952780:metal:4230:20952898,20953466:metal:4230:20953525,20954934:metal:4230:20954958,20954935:metal:4230:20954980,20955263:metal:4230:20955286,20955905:metal:4230:20955918,20956042:metal:4230:20956065,20956810:metal:4230:20956868,20956951:metal:4230:20956963,20957087:metal:4230:20957145,20957250:metal:4230:20957344,20957382:metal:4230:20957474,20993501:metal:4230:20999307,20993505:metal:4230:20999493,20993507:metal:4230:20999592,20993509:metal:4230:20999646,20993518:metal:4230:20999225,20993524:metal:4230:20998870,21027584:metal:4230:21075402,21027586:metal:4230:21075448,21027588:metal:4230:21075658,21027592:metal:4230:21076028,21027594:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.15857779136019987, 'nb_photo': 104879, 'list_port_cont': '20944842,20944959,20945633,20946723,20947289,20947496,20948510,20948694,20949136,20949232,20949898,20950422,20950758,20951129,20951837,20952025,20952436,20952907,20953523,20954951,20954995,20955224,20955279,20955541,20955780,20955922,20956063,20956315,20956426,20956679,20956862,20956959,20957137,20957343,20957468,20957543,20992723,20995310,20998787,20998877,20999099,20999147,20999220,20999263,20999303,20999418,20999494,20999590,20999637,20999721,20999755,20999787,21030754,21034280,21075150,21075210,21075370,21075410,21075454,21075657,21075889,21076039,21076591,21076653,21077230,21077544,21077612,21077879,21078196,21087881,21089941,21091553,21092118,21093241,21095069,21095467,21096425,21097521,21098335,21098696,21099510,21099949,21100412,21101176,21101717,21102146,21102902,21105472,21122084,21130220,21130939,21162646,21163265,21163309,21163378,21163601,21163634,21163672,21163707,21163773,21163844,21164082,21164119,21164712,21165019,21165305,21165609,21166134,21169163,21169287,21170338,21171109,21172130,2117357', 'assoc_port': '20944757:20944959,20944759:20944842,20945562:20945633,20946650:20946723,20947069:20947289,20947410:20947496,20948246:20948510,20948676:20948694,20948999:20949136,20949181:20949232,20949743:20949898,20950038:20951837,20950384:20950422,20950737:20950758,20951083:20951129,20952016:20952025,20952420:20952436,20952780:20952907,20953466:20953523,20954934:20954951,20954935:20954995,20955119:20955224,20955263:20955279,20955516:20955541,20955764:20955780,20955905:20955922,20956042:20956063,20956255:20956315,20956407:20956426,20956665:20956679,20956810:20956862,20956951:20956959,20957087:20957137,20957250:20957343,20957382:20957468,20957517:20957543,20992201:20992723,20993499:20999263,20993501:20999303,20993503:20999418,20993505:20999494,20993507:20999590,20993509:20999637,20993511:20999787,20993513:20999755,20993515:20999721,20993517:20999099,20993518:20999220,20993520:20999147,20993522:20998787,20993524:20998877,20995010:20995310,21027579:21075150,21027580:21075210,21027582:21075370,21027584:21075410,21027586:2107545', 'assoc_mat': '20944757:papier:4230:20944959,20944759:papier:4230:20944842,20945562:papier:4230:20945633,20946650:papier:4230:20946723,20947069:papier:4230:20947289,20947410:papier:4230:20947496,20948246:papier:4230:20948510,20948676:papier:4230:20948694,20948999:papier:4230:20949136,20949181:papier:4230:20949232,20949743:papier:4230:20949898,20950038:papier:4230:20951837,20950384:papier:4230:20950422,20950737:papier:4230:20950758,20951083:papier:4230:20951129,20952016:papier:4230:20952025,20952420:papier:4230:20952436,20952780:papier:4230:20952907,20953466:papier:4230:20953523,20954934:papier:4230:20954951,20954935:papier:4230:20954995,20955119:papier:4230:20955224,20955263:papier:4230:20955279,20955516:papier:4230:20955541,20955764:papier:4230:20955780,20955905:papier:4230:20955922,20956042:papier:4230:20956063,20956255:papier:4230:20956315,20956407:papier:4230:20956426,20956665:papier:4230:20956679,20956810:papier:4230:20956862,20956951:papier:4230:20956959,20957087:papier:4230:20957137,20957250:papier:4230:20957343,2095'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003033172409714002, 'nb_photo': 595, 'list_port_cont': '20948504,20948682,20949134,20949242,20949903,20950420,20950755,20951838,20952023,20952437,20952908,20953527,20954950,20954983,20955216,20955785,20955924,20956312,20956427,20956677,20956860,20957536,20992720,20999141,20999310,20999411,20999491,20999793,21034281,21075445,21075656,21076038,21076594,21076655,21077234,21087888,21091561,21092119,21095071,21095465,21096421,21097515,21099956,21101179,21122073,21130204,21130942,21162644,21163271,21163311,21163379,21163639,21163668,21163713,21163781,21163845,21164081,21164117,21164719,21165029,21165601,21166129,21169288,21170331,21171117,21172137,21173578,21175296,21181522,21183829,21192588,21196761,21197791,21197905,21198044,21199403,21212561,21212747,21212897,21212972,21213017,21213059,21213099,21213173,21213246,21244628,21245497,21245735,21246089,21246423,21246519,21246901,21247616,21291214,21294113,21297912,21303813,21304029,21316454,21316828,21317851,21318066,21318299,21368172,21368277,21368392,21368589,21368656,21368729,21368797,21368832,21368946,21369487,2137078', 'assoc_port': '20948246:20948504,20948676:20948682,20948999:20949134,20949181:20949242,20949743:20949903,20950038:20951838,20950384:20950420,20950737:20950755,20952016:20952023,20952420:20952437,20952780:20952908,20953466:20953527,20954934:20954950,20954935:20954983,20955119:20955216,20955764:20955785,20955905:20955924,20956255:20956312,20956407:20956427,20956665:20956677,20956810:20956860,20957517:20957536,20992201:20992720,20993501:20999310,20993503:20999411,20993505:20999491,20993511:20999793,20993520:20999141,21027586:21075445,21027588:21075656,21027592:21076038,21027594:21076655,21027596:21076594,21027598:21122073,21027600:21077234,21033063:21034281,21084523:21099956,21084531:21097515,21084533:21101179,21084535:21095465,21084539:21096421,21084541:21095071,21084543:21092119,21084545:21091561,21086705:21087888,21129072:21198044,21129073:21197791,21129075:21197905,21129088:21199403,21129091:21196761,21129937:21130204,21130687:21130942,21160894:21165601,21160901:21165029,21160905:21166129,21160909:21164081,21160913:2116471', 'assoc_mat': '20948246:pehd:4230:20948504,20948676:pehd:4230:20948682,20948999:pehd:4230:20949134,20949181:pehd:4230:20949242,20949743:pehd:4230:20949903,20950038:pehd:4230:20951838,20950384:pehd:4230:20950420,20950737:pehd:4230:20950755,20952016:pehd:4230:20952023,20952420:pehd:4230:20952437,20952780:pehd:4230:20952908,20953466:pehd:4230:20953527,20954934:pehd:4230:20954950,20954935:pehd:4230:20954983,20955119:pehd:4230:20955216,20955764:pehd:4230:20955785,20955905:pehd:4230:20955924,20956255:pehd:4230:20956312,20956407:pehd:4230:20956427,20956665:pehd:4230:20956677,20956810:pehd:4230:20956860,20957517:pehd:4230:20957536,20992201:pehd:4230:20992720,20993501:pehd:4230:20999310,20993503:pehd:4230:20999411,20993505:pehd:4230:20999491,20993511:pehd:4230:20999793,20993520:pehd:4230:20999141,21027586:pehd:4230:21075445,21027588:pehd:4230:21075656,21027592:pehd:4230:21076038,21027594:pehd:4230:21076655,21027596:pehd:4230:21076594,21027598:pehd:4230:21122073,21027600:pehd:4230:21077234,21033063:pehd:4230:21034281,21084523:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00869854615063337, 'nb_photo': 6499, 'list_port_cont': '20944830,20944957,20945637,20946730,20947298,20947494,20948503,20948684,20949139,20949237,20949902,20950414,20950759,20951133,20951828,20952033,20952443,20952909,20953513,20954957,20954992,20955220,20955287,20955540,20955779,20955925,20956051,20956306,20956421,20956683,20956863,20956969,20957144,20957338,20957473,20957542,20992728,20995309,20998779,20998873,20999105,20999144,20999219,20999262,20999308,20999415,20999495,20999593,20999649,20999717,20999747,20999785,21030752,21034270,21075151,21075206,21075361,21075414,21075446,21075659,21075892,21076040,21076593,21076649,21077226,21077547,21077610,21077882,21078203,21087890,21089943,21091546,21092116,21093247,21095074,21095464,21096423,21097524,21098334,21098694,21099506,21099953,21100408,21101180,21101710,21102140,21102905,21105481,21122087,21130216,21130941,21162647,21163272,21163310,21163372,21163593,21163633,21163673,21163714,21163778,21163843,21164079,21164126,21164718,21165026,21165315,21165605,21166128,21169151,21169278,21170326,21171108,21172140,2117356', 'assoc_port': '20944757:20944957,20944759:20944830,20945562:20945637,20946650:20946730,20947069:20947298,20947410:20947494,20948246:20948503,20948676:20948684,20948999:20949139,20949181:20949237,20949743:20949902,20950038:20951828,20950384:20950414,20950737:20950759,20951083:20951133,20952016:20952033,20952420:20952443,20952780:20952909,20953466:20953513,20954934:20954957,20954935:20954992,20955119:20955220,20955263:20955287,20955516:20955540,20955764:20955779,20955905:20955925,20956042:20956051,20956255:20956306,20956407:20956421,20956665:20956683,20956810:20956863,20956951:20956969,20957087:20957144,20957250:20957338,20957382:20957473,20957517:20957542,20992201:20992728,20993499:20999262,20993501:20999308,20993503:20999415,20993505:20999495,20993507:20999593,20993509:20999649,20993511:20999785,20993513:20999747,20993515:20999717,20993517:20999105,20993518:20999219,20993520:20999144,20993522:20998779,20993524:20998873,20995010:20995309,21027579:21075151,21027580:21075206,21027582:21075361,21027584:21075414,21027586:2107544', 'assoc_mat': '20944757:pet_clair:4230:20944957,20944759:pet_clair:4230:20944830,20945562:pet_clair:4230:20945637,20946650:pet_clair:4230:20946730,20947069:pet_clair:4230:20947298,20947410:pet_clair:4230:20947494,20948246:pet_clair:4230:20948503,20948676:pet_clair:4230:20948684,20948999:pet_clair:4230:20949139,20949181:pet_clair:4230:20949237,20949743:pet_clair:4230:20949902,20950038:pet_clair:4230:20951828,20950384:pet_clair:4230:20950414,20950737:pet_clair:4230:20950759,20951083:pet_clair:4230:20951133,20952016:pet_clair:4230:20952033,20952420:pet_clair:4230:20952443,20952780:pet_clair:4230:20952909,20953466:pet_clair:4230:20953513,20954934:pet_clair:4230:20954957,20954935:pet_clair:4230:20954992,20955119:pet_clair:4230:20955220,20955263:pet_clair:4230:20955287,20955516:pet_clair:4230:20955540,20955764:pet_clair:4230:20955779,20955905:pet_clair:4230:20955925,20956042:pet_clair:4230:20956051,20956255:pet_clair:4230:20956306,20956407:pet_clair:4230:20956421,20956665:pet_clair:4230:20956683,20956810:pet_clair:4230:20956863,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002200922286199637, 'nb_photo': 244, 'list_port_cont': '20950417,20950753,20951128,20951834,20955782,20956059,20999490,20999719,20999750,20999786,21075653,21075895,21076035,21076646,21077237,21077613,21078200,21089940,21092122,21093245,21095064,21095476,21096414,21101181,21101719,21105471,21122086,21130932,21162645,21163640,21163777,21163851,21164112,21166133,21170332,21171116,21181524,21192590,21197128,21197518,21197793,21197914,21212277,21212704,21212857,21212912,21212974,21213013,21213110,21213127,21213228,21243769,21244626,21244797,21245510,21245732,21246091,21246430,21246511,21291221,21297915,21303815,21316448,21316725,21316819,21317854,21318184,21365887,21367284,21368177,21368393,21368540,21368655,21368801,21368827,21369008,21370339,21370778,21401071,21401270,21401482,21402035,21402095,21402251,21402801,21402858,21403311,21456659,21456864,21457114,21457575,21457678,21457824,21457923,21457972,21458060,21471578,21476939,21503233,21503312,21503516,21503646,21503686,21504068,21524037,21526203,21526395,21526636,21526656,21526722,21526761,21545094,21545265,2154529', 'assoc_port': '20950038:20951834,20950384:20950417,20950737:20950753,20951083:20951128,20955764:20955782,20956042:20956059,20993505:20999490,20993511:20999786,20993513:20999750,20993515:20999719,21027588:21075653,21027590:21075895,21027592:21076035,21027594:21076646,21027598:21122086,21027600:21077237,21027602:21077613,21027608:21078200,21084513:21105471,21084515:21101719,21084533:21101181,21084535:21095476,21084537:21093245,21084539:21096414,21084541:21095064,21084543:21092122,21088949:21089940,21129073:21197793,21129075:21197914,21129078:21197128,21129081:21197518,21130687:21130932,21160905:21166133,21160917:21164112,21160923:21163640,21160925:21163851,21162413:21162645,21163734:21163777,21170172:21170332,21170889:21171116,21181367:21181524,21192388:21192590,21211793:21213110,21211805:21213127,21211808:21213013,21211810:21213228,21211812:21212912,21211814:21212974,21211816:21212857,21211818:21212704,21211830:21212277,21243461:21246511,21243468:21246091,21243479:21246430,21243480:21245732,21243481:21245510,21243482:2124479', 'assoc_mat': '20950038:pet_fonce:4230:20951834,20950384:pet_fonce:4230:20950417,20950737:pet_fonce:4230:20950753,20951083:pet_fonce:4230:20951128,20955764:pet_fonce:4230:20955782,20956042:pet_fonce:4230:20956059,20993505:pet_fonce:4230:20999490,20993511:pet_fonce:4230:20999786,20993513:pet_fonce:4230:20999750,20993515:pet_fonce:4230:20999719,21027588:pet_fonce:4230:21075653,21027590:pet_fonce:4230:21075895,21027592:pet_fonce:4230:21076035,21027594:pet_fonce:4230:21076646,21027598:pet_fonce:4230:21122086,21027600:pet_fonce:4230:21077237,21027602:pet_fonce:4230:21077613,21027608:pet_fonce:4230:21078200,21084513:pet_fonce:4230:21105471,21084515:pet_fonce:4230:21101719,21084533:pet_fonce:4230:21101181,21084535:pet_fonce:4230:21095476,21084537:pet_fonce:4230:21093245,21084539:pet_fonce:4230:21096414,21084541:pet_fonce:4230:21095064,21084543:pet_fonce:4230:21092122,21088949:pet_fonce:4230:21089940,21129073:pet_fonce:4230:21197793,21129075:pet_fonce:4230:21197914,21129078:pet_fonce:4230:21197128,21129081:pet_fonce:4230:21197518,2'}), 'main_stat': {'nb_photos': 742}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-03', 0.8066036444536381),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((742,),), 'unwanted_material_monthly_percentage': ((0.8066036444536381,),), 'material_repartition': (('incineration', 737),), 'material_dict': {'incineration': 737}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 3, 1), 0.8113375861161847, 35), (datetime.date(2025, 3, 2), 0.8504317712871088, 29), (datetime.date(2025, 3, 3), 0.8869915804005813, 26), (datetime.date(2025, 3, 4), 0.8257926323704756, 33), (datetime.date(2025, 3, 5), 0.7526899545081115, 32), (datetime.date(2025, 3, 6), 0.7247064630125633, 17), (datetime.date(2025, 3, 7), 0.7332518294987034, 38), (datetime.date(2025, 3, 8), 0.7700949261094928, 31), (datetime.date(2025, 3, 9), 0.8635757769036043, 31), (datetime.date(2025, 3, 10), 0.8352427988346002, 38), (datetime.date(2025, 3, 11), 0.793289901802466, 42), (datetime.date(2025, 3, 12), 0.8127522222801009, 40), (datetime.date(2025, 3, 13), 0.8280239481676105, 36), (datetime.date(2025, 3, 14), 0.7653521029457784, 45), (datetime.date(2025, 3, 15), 0.8378833008804271, 38), (datetime.date(2025, 3, 16), 0.8955355859546758, 28), (datetime.date(2025, 3, 17), 0.8394205908008903, 43), (datetime.date(2025, 3, 18), 0.8403793040800775, 38), (datetime.date(2025, 3, 19), 0.8163741239297262, 27), (datetime.date(2025, 3, 20), 0.8220867514486085, 30), (datetime.date(2025, 3, 21), 0.7519495418303559, 32), (datetime.date(2025, 3, 22), 0.5895771477979268, 14), (datetime.date(2025, 3, 23), 0.7005002210829915, 14)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 3, 1), 0.8113375861161847, 35), (datetime.date(2025, 3, 2), 0.8504317712871088, 29), (datetime.date(2025, 3, 3), 0.8869915804005813, 26), (datetime.date(2025, 3, 4), 0.8257926323704756, 33), (datetime.date(2025, 3, 5), 0.7526899545081115, 32), (datetime.date(2025, 3, 6), 0.7247064630125633, 17), (datetime.date(2025, 3, 7), 0.7332518294987034, 38), (datetime.date(2025, 3, 8), 0.7700949261094928, 31), (datetime.date(2025, 3, 9), 0.8635757769036043, 31), (datetime.date(2025, 3, 10), 0.8352427988346002, 38), (datetime.date(2025, 3, 11), 0.793289901802466, 42), (datetime.date(2025, 3, 12), 0.8127522222801009, 40), (datetime.date(2025, 3, 13), 0.8280239481676105, 36), (datetime.date(2025, 3, 14), 0.7653521029457784, 45), (datetime.date(2025, 3, 15), 0.8378833008804271, 38), (datetime.date(2025, 3, 16), 0.8955355859546758, 28), (datetime.date(2025, 3, 17), 0.8394205908008903, 43), (datetime.date(2025, 3, 18), 0.8403793040800775, 38), (datetime.date(2025, 3, 19), 0.8163741239297262, 27), (datetime.date(2025, 3, 20), 0.8220867514486085, 30), (datetime.date(2025, 3, 21), 0.7519495418303559, 32), (datetime.date(2025, 3, 22), 0.5895771477979268, 14), (datetime.date(2025, 3, 23), 0.7005002210829915, 14))}, 'quality_array': [['-7.7564858101421645', '01032025'], ['-7.879297089221759', '02032025'], ['-6.570770044139666', '03032025'], ['-7.104577722334345', '04032025'], ['-7.5687398437228675', '05032025'], ['-7.764932975009913', '06032025'], ['-8.009686520503019', '07032025'], ['-7.9127824905463715', '08032025'], ['-7.743508880163758', '09032025'], ['-7.397728386602724', '10032025'], ['-7.495173439725212', '11032025'], ['-7.615539029727611', '12032025'], ['-7.509186732235089', '13032025'], ['-7.611185348975085', '14032025'], ['-7.524595712135079', '15032025'], ['-7.261252580367065', '16032025'], ['-6.93342132209533', '17032025'], ['-7.108237984689372', '18032025'], ['-7.051673285644271', '19032025'], ['-7.2136547904601', '20032025'], ['-7.552149759604954', '21032025'], ['-9.195921563940349', '22032025'], ['-9.270070348788982', '23032025']], 'number_of_batch': ((397,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011491500604781164, 'nb_photo': 5037, 'list_port_cont': '20944841,20944963,20945643,20946731,20947282,20947498,20948498,20948695,20949137,20949229,20949897,20950415,20950754,20951124,20951833,20952030,20952427,20952901,20953514,20954942,20954988,20955215,20955280,20955537,20955778,20955910,20956062,20956314,20956424,20956685,20956852,20956964,20957140,20957345,20957475,20957530,20992729,20995304,20998781,20998866,20999090,20999133,20999230,20999260,20999301,20999407,20999481,20999595,20999645,20999710,20999752,20999782,21030744,21034271,21075144,21075203,21075359,21075398,21075440,21075645,21075885,21076031,21076590,21076648,21077221,21077537,21077606,21077871,21078193,21087891,21089936,21091554,21092114,21093236,21095070,21095462,21096415,21097509,21098329,21098690,21099508,21099947,21100409,21101178,21101714,21102137,21102904,21105473,21122085,21130208,21130935,21162633,21163269,21163298,21163373,21163589,21163625,21163664,21163705,21163783,21163852,21164075,21164111,21164704,21165015,21165303,21165606,21166122,21169162,21169284,21170339,21171105,21172141,2117357', 'assoc_port': '20944757:20944963,20944759:20944841,20945562:20945643,20946650:20946731,20947069:20947282,20947410:20947498,20948246:20948498,20948676:20948695,20948999:20949137,20949181:20949229,20949743:20949897,20950038:20951833,20950384:20950415,20950737:20950754,20951083:20951124,20952016:20952030,20952420:20952427,20952780:20952901,20953466:20953514,20954934:20954942,20954935:20954988,20955119:20955215,20955263:20955280,20955516:20955537,20955764:20955778,20955905:20955910,20956042:20956062,20956255:20956314,20956407:20956424,20956665:20956685,20956810:20956852,20956951:20956964,20957087:20957140,20957250:20957345,20957382:20957475,20957517:20957530,20992201:20992729,20993499:20999260,20993501:20999301,20993503:20999407,20993505:20999481,20993507:20999595,20993509:20999645,20993511:20999782,20993513:20999752,20993515:20999710,20993517:20999090,20993518:20999230,20993520:20999133,20993522:20998781,20993524:20998866,20995010:20995304,21027579:21075144,21027580:21075203,21027582:21075359,21027584:21075398,21027586:2107544', 'assoc_mat': '20944757:autre:4230:20944963,20944759:autre:4230:20944841,20945562:autre:4230:20945643,20946650:autre:4230:20946731,20947069:autre:4230:20947282,20947410:autre:4230:20947498,20948246:autre:4230:20948498,20948676:autre:4230:20948695,20948999:autre:4230:20949137,20949181:autre:4230:20949229,20949743:autre:4230:20949897,20950038:autre:4230:20951833,20950384:autre:4230:20950415,20950737:autre:4230:20950754,20951083:autre:4230:20951124,20952016:autre:4230:20952030,20952420:autre:4230:20952427,20952780:autre:4230:20952901,20953466:autre:4230:20953514,20954934:autre:4230:20954942,20954935:autre:4230:20954988,20955119:autre:4230:20955215,20955263:autre:4230:20955280,20955516:autre:4230:20955537,20955764:autre:4230:20955778,20955905:autre:4230:20955910,20956042:autre:4230:20956062,20956255:autre:4230:20956314,20956407:autre:4230:20956424,20956665:autre:4230:20956685,20956810:autre:4230:20956852,20956951:autre:4230:20956964,20957087:autre:4230:20957140,20957250:autre:4230:20957345,20957382:autre:4230:20957475,20957517:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0420538195284927, 'nb_photo': 25283, 'list_port_cont': '20944836,20944956,20945636,20946728,20947295,20947501,20948508,20948681,20949132,20949241,20949893,20950423,20950749,20951125,20951840,20952034,20952444,20952912,20953521,20954954,20954994,20955219,20955277,20955539,20955771,20955920,20956061,20956317,20956425,20956689,20956869,20956971,20957139,20957336,20957470,20957540,20992726,20995314,20998782,20998868,20999093,20999137,20999232,20999267,20999313,20999413,20999486,20999586,20999640,20999720,20999753,20999777,21030757,21034278,21075159,21075208,21075376,21075406,21075455,21075648,21075893,21076036,21076583,21076647,21077235,21077545,21077608,21077874,21078198,21087892,21089930,21091559,21092117,21093239,21095068,21095477,21096420,21097520,21098328,21098702,21099507,21099950,21100397,21101170,21101716,21102139,21102906,21105480,21122078,21130219,21130938,21162638,21163274,21163302,21163369,21163604,21163637,21163670,21163710,21163786,21163841,21164085,21164125,21164716,21165028,21165318,21165600,21166127,21169164,21169283,21170336,21171107,21172143,2117357', 'assoc_port': '20944757:20944956,20944759:20944836,20945562:20945636,20946650:20946728,20947069:20947295,20947410:20947501,20948246:20948508,20948676:20948681,20948999:20949132,20949181:20949241,20949743:20949893,20950038:20951840,20950384:20950423,20950737:20950749,20951083:20951125,20952016:20952034,20952420:20952444,20952780:20952912,20953466:20953521,20954934:20954954,20954935:20954994,20955119:20955219,20955263:20955277,20955516:20955539,20955764:20955771,20955905:20955920,20956042:20956061,20956255:20956317,20956407:20956425,20956665:20956689,20956810:20956869,20956951:20956971,20957087:20957139,20957250:20957336,20957382:20957470,20957517:20957540,20992201:20992726,20993499:20999267,20993501:20999313,20993503:20999413,20993505:20999486,20993507:20999586,20993509:20999640,20993511:20999777,20993513:20999753,20993515:20999720,20993517:20999093,20993518:20999232,20993520:20999137,20993522:20998782,20993524:20998868,20995010:20995314,21027579:21075159,21027580:21075208,21027582:21075376,21027584:21075406,21027586:2107545', 'assoc_mat': '20944757:carton:4230:20944956,20944759:carton:4230:20944836,20945562:carton:4230:20945636,20946650:carton:4230:20946728,20947069:carton:4230:20947295,20947410:carton:4230:20947501,20948246:carton:4230:20948508,20948676:carton:4230:20948681,20948999:carton:4230:20949132,20949181:carton:4230:20949241,20949743:carton:4230:20949893,20950038:carton:4230:20951840,20950384:carton:4230:20950423,20950737:carton:4230:20950749,20951083:carton:4230:20951125,20952016:carton:4230:20952034,20952420:carton:4230:20952444,20952780:carton:4230:20952912,20953466:carton:4230:20953521,20954934:carton:4230:20954954,20954935:carton:4230:20954994,20955119:carton:4230:20955219,20955263:carton:4230:20955277,20955516:carton:4230:20955539,20955764:carton:4230:20955771,20955905:carton:4230:20955920,20956042:carton:4230:20956061,20956255:carton:4230:20956317,20956407:carton:4230:20956425,20956665:carton:4230:20956689,20956810:carton:4230:20956869,20956951:carton:4230:20956971,20957087:carton:4230:20957139,20957250:carton:4230:20957336,2095'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0009834132349895368, 'nb_photo': 496, 'list_port_cont': '20944826,20944951,20946733,20947292,20948493,20948692,20949226,20949887,20950425,20950760,20951841,20952020,20952435,20952898,20953525,20954958,20954980,20955286,20955918,20956065,20956868,20956963,20957145,20957344,20957474,20998870,20999225,20999307,20999493,20999592,20999646,21030745,21075402,21075448,21075658,21076028,21076586,21076639,21077222,21077609,21087889,21089944,21091544,21092106,21093244,21095066,21095470,21096417,21102909,21105469,21130207,21130925,21162634,21163362,21163628,21163669,21163712,21163774,21163850,21164087,21164703,21165304,21166118,21169152,21169271,21170329,21171100,21172136,21173564,21175285,21176959,21181519,21182623,21196767,21197129,21197782,21197902,21198049,21199409,21212271,21212455,21212740,21212751,21212843,21214150,21245500,21245725,21246517,21246892,21247238,21247556,21247607,21291222,21294081,21297904,21303816,21304007,21316438,21316815,21317619,21317845,21318068,21318087,21318310,21368175,21368373,21368382,21368549,21368578,21368645,21368672,21368727,21368798,2136882', 'assoc_port': '20944757:20944951,20944759:20944826,20946650:20946733,20947069:20947292,20948246:20948493,20948676:20948692,20949181:20949226,20949743:20949887,20950038:20951841,20950384:20950425,20950737:20950760,20952016:20952020,20952420:20952435,20952780:20952898,20953466:20953525,20954934:20954958,20954935:20954980,20955263:20955286,20955905:20955918,20956042:20956065,20956810:20956868,20956951:20956963,20957087:20957145,20957250:20957344,20957382:20957474,20993501:20999307,20993505:20999493,20993507:20999592,20993509:20999646,20993518:20999225,20993524:20998870,21027584:21075402,21027586:21075448,21027588:21075658,21027592:21076028,21027594:21076639,21027596:21076586,21027600:21077222,21027602:21077609,21030443:21030745,21084513:21105469,21084521:21102909,21084535:21095470,21084537:21093244,21084539:21096417,21084541:21095066,21084543:21092106,21084545:21091544,21086705:21087889,21088949:21089944,21129072:21198049,21129073:21197782,21129075:21197902,21129078:21197129,21129088:21199409,21129091:21196767,21129937:2113020', 'assoc_mat': '20944757:metal:4230:20944951,20944759:metal:4230:20944826,20946650:metal:4230:20946733,20947069:metal:4230:20947292,20948246:metal:4230:20948493,20948676:metal:4230:20948692,20949181:metal:4230:20949226,20949743:metal:4230:20949887,20950038:metal:4230:20951841,20950384:metal:4230:20950425,20950737:metal:4230:20950760,20952016:metal:4230:20952020,20952420:metal:4230:20952435,20952780:metal:4230:20952898,20953466:metal:4230:20953525,20954934:metal:4230:20954958,20954935:metal:4230:20954980,20955263:metal:4230:20955286,20955905:metal:4230:20955918,20956042:metal:4230:20956065,20956810:metal:4230:20956868,20956951:metal:4230:20956963,20957087:metal:4230:20957145,20957250:metal:4230:20957344,20957382:metal:4230:20957474,20993501:metal:4230:20999307,20993505:metal:4230:20999493,20993507:metal:4230:20999592,20993509:metal:4230:20999646,20993518:metal:4230:20999225,20993524:metal:4230:20998870,21027584:metal:4230:21075402,21027586:metal:4230:21075448,21027588:metal:4230:21075658,21027592:metal:4230:21076028,21027594:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.15857779136019987, 'nb_photo': 104879, 'list_port_cont': '20944842,20944959,20945633,20946723,20947289,20947496,20948510,20948694,20949136,20949232,20949898,20950422,20950758,20951129,20951837,20952025,20952436,20952907,20953523,20954951,20954995,20955224,20955279,20955541,20955780,20955922,20956063,20956315,20956426,20956679,20956862,20956959,20957137,20957343,20957468,20957543,20992723,20995310,20998787,20998877,20999099,20999147,20999220,20999263,20999303,20999418,20999494,20999590,20999637,20999721,20999755,20999787,21030754,21034280,21075150,21075210,21075370,21075410,21075454,21075657,21075889,21076039,21076591,21076653,21077230,21077544,21077612,21077879,21078196,21087881,21089941,21091553,21092118,21093241,21095069,21095467,21096425,21097521,21098335,21098696,21099510,21099949,21100412,21101176,21101717,21102146,21102902,21105472,21122084,21130220,21130939,21162646,21163265,21163309,21163378,21163601,21163634,21163672,21163707,21163773,21163844,21164082,21164119,21164712,21165019,21165305,21165609,21166134,21169163,21169287,21170338,21171109,21172130,2117357', 'assoc_port': '20944757:20944959,20944759:20944842,20945562:20945633,20946650:20946723,20947069:20947289,20947410:20947496,20948246:20948510,20948676:20948694,20948999:20949136,20949181:20949232,20949743:20949898,20950038:20951837,20950384:20950422,20950737:20950758,20951083:20951129,20952016:20952025,20952420:20952436,20952780:20952907,20953466:20953523,20954934:20954951,20954935:20954995,20955119:20955224,20955263:20955279,20955516:20955541,20955764:20955780,20955905:20955922,20956042:20956063,20956255:20956315,20956407:20956426,20956665:20956679,20956810:20956862,20956951:20956959,20957087:20957137,20957250:20957343,20957382:20957468,20957517:20957543,20992201:20992723,20993499:20999263,20993501:20999303,20993503:20999418,20993505:20999494,20993507:20999590,20993509:20999637,20993511:20999787,20993513:20999755,20993515:20999721,20993517:20999099,20993518:20999220,20993520:20999147,20993522:20998787,20993524:20998877,20995010:20995310,21027579:21075150,21027580:21075210,21027582:21075370,21027584:21075410,21027586:2107545', 'assoc_mat': '20944757:papier:4230:20944959,20944759:papier:4230:20944842,20945562:papier:4230:20945633,20946650:papier:4230:20946723,20947069:papier:4230:20947289,20947410:papier:4230:20947496,20948246:papier:4230:20948510,20948676:papier:4230:20948694,20948999:papier:4230:20949136,20949181:papier:4230:20949232,20949743:papier:4230:20949898,20950038:papier:4230:20951837,20950384:papier:4230:20950422,20950737:papier:4230:20950758,20951083:papier:4230:20951129,20952016:papier:4230:20952025,20952420:papier:4230:20952436,20952780:papier:4230:20952907,20953466:papier:4230:20953523,20954934:papier:4230:20954951,20954935:papier:4230:20954995,20955119:papier:4230:20955224,20955263:papier:4230:20955279,20955516:papier:4230:20955541,20955764:papier:4230:20955780,20955905:papier:4230:20955922,20956042:papier:4230:20956063,20956255:papier:4230:20956315,20956407:papier:4230:20956426,20956665:papier:4230:20956679,20956810:papier:4230:20956862,20956951:papier:4230:20956959,20957087:papier:4230:20957137,20957250:papier:4230:20957343,2095'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003033172409714002, 'nb_photo': 595, 'list_port_cont': '20948504,20948682,20949134,20949242,20949903,20950420,20950755,20951838,20952023,20952437,20952908,20953527,20954950,20954983,20955216,20955785,20955924,20956312,20956427,20956677,20956860,20957536,20992720,20999141,20999310,20999411,20999491,20999793,21034281,21075445,21075656,21076038,21076594,21076655,21077234,21087888,21091561,21092119,21095071,21095465,21096421,21097515,21099956,21101179,21122073,21130204,21130942,21162644,21163271,21163311,21163379,21163639,21163668,21163713,21163781,21163845,21164081,21164117,21164719,21165029,21165601,21166129,21169288,21170331,21171117,21172137,21173578,21175296,21181522,21183829,21192588,21196761,21197791,21197905,21198044,21199403,21212561,21212747,21212897,21212972,21213017,21213059,21213099,21213173,21213246,21244628,21245497,21245735,21246089,21246423,21246519,21246901,21247616,21291214,21294113,21297912,21303813,21304029,21316454,21316828,21317851,21318066,21318299,21368172,21368277,21368392,21368589,21368656,21368729,21368797,21368832,21368946,21369487,2137078', 'assoc_port': '20948246:20948504,20948676:20948682,20948999:20949134,20949181:20949242,20949743:20949903,20950038:20951838,20950384:20950420,20950737:20950755,20952016:20952023,20952420:20952437,20952780:20952908,20953466:20953527,20954934:20954950,20954935:20954983,20955119:20955216,20955764:20955785,20955905:20955924,20956255:20956312,20956407:20956427,20956665:20956677,20956810:20956860,20957517:20957536,20992201:20992720,20993501:20999310,20993503:20999411,20993505:20999491,20993511:20999793,20993520:20999141,21027586:21075445,21027588:21075656,21027592:21076038,21027594:21076655,21027596:21076594,21027598:21122073,21027600:21077234,21033063:21034281,21084523:21099956,21084531:21097515,21084533:21101179,21084535:21095465,21084539:21096421,21084541:21095071,21084543:21092119,21084545:21091561,21086705:21087888,21129072:21198044,21129073:21197791,21129075:21197905,21129088:21199403,21129091:21196761,21129937:21130204,21130687:21130942,21160894:21165601,21160901:21165029,21160905:21166129,21160909:21164081,21160913:2116471', 'assoc_mat': '20948246:pehd:4230:20948504,20948676:pehd:4230:20948682,20948999:pehd:4230:20949134,20949181:pehd:4230:20949242,20949743:pehd:4230:20949903,20950038:pehd:4230:20951838,20950384:pehd:4230:20950420,20950737:pehd:4230:20950755,20952016:pehd:4230:20952023,20952420:pehd:4230:20952437,20952780:pehd:4230:20952908,20953466:pehd:4230:20953527,20954934:pehd:4230:20954950,20954935:pehd:4230:20954983,20955119:pehd:4230:20955216,20955764:pehd:4230:20955785,20955905:pehd:4230:20955924,20956255:pehd:4230:20956312,20956407:pehd:4230:20956427,20956665:pehd:4230:20956677,20956810:pehd:4230:20956860,20957517:pehd:4230:20957536,20992201:pehd:4230:20992720,20993501:pehd:4230:20999310,20993503:pehd:4230:20999411,20993505:pehd:4230:20999491,20993511:pehd:4230:20999793,20993520:pehd:4230:20999141,21027586:pehd:4230:21075445,21027588:pehd:4230:21075656,21027592:pehd:4230:21076038,21027594:pehd:4230:21076655,21027596:pehd:4230:21076594,21027598:pehd:4230:21122073,21027600:pehd:4230:21077234,21033063:pehd:4230:21034281,21084523:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00869854615063337, 'nb_photo': 6499, 'list_port_cont': '20944830,20944957,20945637,20946730,20947298,20947494,20948503,20948684,20949139,20949237,20949902,20950414,20950759,20951133,20951828,20952033,20952443,20952909,20953513,20954957,20954992,20955220,20955287,20955540,20955779,20955925,20956051,20956306,20956421,20956683,20956863,20956969,20957144,20957338,20957473,20957542,20992728,20995309,20998779,20998873,20999105,20999144,20999219,20999262,20999308,20999415,20999495,20999593,20999649,20999717,20999747,20999785,21030752,21034270,21075151,21075206,21075361,21075414,21075446,21075659,21075892,21076040,21076593,21076649,21077226,21077547,21077610,21077882,21078203,21087890,21089943,21091546,21092116,21093247,21095074,21095464,21096423,21097524,21098334,21098694,21099506,21099953,21100408,21101180,21101710,21102140,21102905,21105481,21122087,21130216,21130941,21162647,21163272,21163310,21163372,21163593,21163633,21163673,21163714,21163778,21163843,21164079,21164126,21164718,21165026,21165315,21165605,21166128,21169151,21169278,21170326,21171108,21172140,2117356', 'assoc_port': '20944757:20944957,20944759:20944830,20945562:20945637,20946650:20946730,20947069:20947298,20947410:20947494,20948246:20948503,20948676:20948684,20948999:20949139,20949181:20949237,20949743:20949902,20950038:20951828,20950384:20950414,20950737:20950759,20951083:20951133,20952016:20952033,20952420:20952443,20952780:20952909,20953466:20953513,20954934:20954957,20954935:20954992,20955119:20955220,20955263:20955287,20955516:20955540,20955764:20955779,20955905:20955925,20956042:20956051,20956255:20956306,20956407:20956421,20956665:20956683,20956810:20956863,20956951:20956969,20957087:20957144,20957250:20957338,20957382:20957473,20957517:20957542,20992201:20992728,20993499:20999262,20993501:20999308,20993503:20999415,20993505:20999495,20993507:20999593,20993509:20999649,20993511:20999785,20993513:20999747,20993515:20999717,20993517:20999105,20993518:20999219,20993520:20999144,20993522:20998779,20993524:20998873,20995010:20995309,21027579:21075151,21027580:21075206,21027582:21075361,21027584:21075414,21027586:2107544', 'assoc_mat': '20944757:pet_clair:4230:20944957,20944759:pet_clair:4230:20944830,20945562:pet_clair:4230:20945637,20946650:pet_clair:4230:20946730,20947069:pet_clair:4230:20947298,20947410:pet_clair:4230:20947494,20948246:pet_clair:4230:20948503,20948676:pet_clair:4230:20948684,20948999:pet_clair:4230:20949139,20949181:pet_clair:4230:20949237,20949743:pet_clair:4230:20949902,20950038:pet_clair:4230:20951828,20950384:pet_clair:4230:20950414,20950737:pet_clair:4230:20950759,20951083:pet_clair:4230:20951133,20952016:pet_clair:4230:20952033,20952420:pet_clair:4230:20952443,20952780:pet_clair:4230:20952909,20953466:pet_clair:4230:20953513,20954934:pet_clair:4230:20954957,20954935:pet_clair:4230:20954992,20955119:pet_clair:4230:20955220,20955263:pet_clair:4230:20955287,20955516:pet_clair:4230:20955540,20955764:pet_clair:4230:20955779,20955905:pet_clair:4230:20955925,20956042:pet_clair:4230:20956051,20956255:pet_clair:4230:20956306,20956407:pet_clair:4230:20956421,20956665:pet_clair:4230:20956683,20956810:pet_clair:4230:20956863,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002200922286199637, 'nb_photo': 244, 'list_port_cont': '20950417,20950753,20951128,20951834,20955782,20956059,20999490,20999719,20999750,20999786,21075653,21075895,21076035,21076646,21077237,21077613,21078200,21089940,21092122,21093245,21095064,21095476,21096414,21101181,21101719,21105471,21122086,21130932,21162645,21163640,21163777,21163851,21164112,21166133,21170332,21171116,21181524,21192590,21197128,21197518,21197793,21197914,21212277,21212704,21212857,21212912,21212974,21213013,21213110,21213127,21213228,21243769,21244626,21244797,21245510,21245732,21246091,21246430,21246511,21291221,21297915,21303815,21316448,21316725,21316819,21317854,21318184,21365887,21367284,21368177,21368393,21368540,21368655,21368801,21368827,21369008,21370339,21370778,21401071,21401270,21401482,21402035,21402095,21402251,21402801,21402858,21403311,21456659,21456864,21457114,21457575,21457678,21457824,21457923,21457972,21458060,21471578,21476939,21503233,21503312,21503516,21503646,21503686,21504068,21524037,21526203,21526395,21526636,21526656,21526722,21526761,21545094,21545265,2154529', 'assoc_port': '20950038:20951834,20950384:20950417,20950737:20950753,20951083:20951128,20955764:20955782,20956042:20956059,20993505:20999490,20993511:20999786,20993513:20999750,20993515:20999719,21027588:21075653,21027590:21075895,21027592:21076035,21027594:21076646,21027598:21122086,21027600:21077237,21027602:21077613,21027608:21078200,21084513:21105471,21084515:21101719,21084533:21101181,21084535:21095476,21084537:21093245,21084539:21096414,21084541:21095064,21084543:21092122,21088949:21089940,21129073:21197793,21129075:21197914,21129078:21197128,21129081:21197518,21130687:21130932,21160905:21166133,21160917:21164112,21160923:21163640,21160925:21163851,21162413:21162645,21163734:21163777,21170172:21170332,21170889:21171116,21181367:21181524,21192388:21192590,21211793:21213110,21211805:21213127,21211808:21213013,21211810:21213228,21211812:21212912,21211814:21212974,21211816:21212857,21211818:21212704,21211830:21212277,21243461:21246511,21243468:21246091,21243479:21246430,21243480:21245732,21243481:21245510,21243482:2124479', 'assoc_mat': '20950038:pet_fonce:4230:20951834,20950384:pet_fonce:4230:20950417,20950737:pet_fonce:4230:20950753,20951083:pet_fonce:4230:20951128,20955764:pet_fonce:4230:20955782,20956042:pet_fonce:4230:20956059,20993505:pet_fonce:4230:20999490,20993511:pet_fonce:4230:20999786,20993513:pet_fonce:4230:20999750,20993515:pet_fonce:4230:20999719,21027588:pet_fonce:4230:21075653,21027590:pet_fonce:4230:21075895,21027592:pet_fonce:4230:21076035,21027594:pet_fonce:4230:21076646,21027598:pet_fonce:4230:21122086,21027600:pet_fonce:4230:21077237,21027602:pet_fonce:4230:21077613,21027608:pet_fonce:4230:21078200,21084513:pet_fonce:4230:21105471,21084515:pet_fonce:4230:21101719,21084533:pet_fonce:4230:21101181,21084535:pet_fonce:4230:21095476,21084537:pet_fonce:4230:21093245,21084539:pet_fonce:4230:21096414,21084541:pet_fonce:4230:21095064,21084543:pet_fonce:4230:21092122,21088949:pet_fonce:4230:21089940,21129073:pet_fonce:4230:21197793,21129075:pet_fonce:4230:21197914,21129078:pet_fonce:4230:21197128,21129081:pet_fonce:4230:21197518,2'}), 'main_stat': {'nb_photos': 742}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-03', 0.8066036444536381),)]} filepath : /data_2/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_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', '1.15%', 5037], 'carton': ['carton', '4.21%', 25283], 'metal': ['metal', '0.1%', 496], 'papier': ['papier', '15.86%', 104879], 'pehd': ['pehd', '0.3%', 595], 'pet_clair': ['pet_clair', '0.87%', 6499], 'pet_fonce': ['pet_fonce', '0.22%', 244]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_03_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/SCCU_cam7 2.97user 2.30system 0:05.43elapsed 97%CPU (0avgtext+0avgdata 195956maxresident)k 4728inputs+280outputs (85major+51533minor)pagefaults 0swaps