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_4/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-06 _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 : (6, 30) 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 : (6, 30) 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 : 06 mtr_id : dashboard_places : SCCU_cam7 date : 2025-06 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-06%') and created_at like '%2025-06%'))); nb_day : (6, 30) 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) = 06 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) = 06 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 '%062025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-06-01 : dt_date_just_month_year : 2025-06-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-06-01" AND ded.date <= "2025-06-30" 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 (1862600,1866481,1870983,1873059,1876531,1884730,1887900,1893001,1896976,1900233,1903352,1907899,1909901,1910820,1913555,1915959,1918606,1921320,1924876,1926450,1926699,1930466,1930463,1931910,1935576,1937304,1940055,1940584,1944934) 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.012757247450136492, 'nb_photo': 16925, 'list_port_cont': '23520069,23520972,23521040,23521196,23521233,23521349,23521379,23521399,23521470,23521524,23521560,23521596,23521725,23521757,23521887,23521949,23522040,23522151,23522236,23522354,23522423,23522470,23522535,23523143,23567849,23568071,23568153,23568213,23568252,23568299,23568347,23568459,23568634,23568699,23568857,23568911,23568973,23569065,23569112,23569182,23569236,23569272,23569340,23569487,23569609,23569642,23570624,23572418,23574327,23574352,23574982,23575629,23576070,23576843,23581468,23581552,23581670,23581798,23582166,23583564,23584612,23585297,23588021,23590744,23592806,23594659,23596892,23598831,23600346,23601969,23620876,23620907,23644750,23645976,23648695,23649365,23649413,23649482,23649565,23649647,23649732,23649864,23649973,23650085,23650133,23650172,23650275,23650389,23650497,23650512,23650633,23650710,23650786,23650892,23650970,23651589,23690054,23690143,23690188,23690214,23690276,23690321,23690355,23690414,23690486,23690522,23690620,23690642,23690698,23750740,23750824,23750926,23750963,2375099', 'assoc_port': '23519889:23522470,23519891:23522040,23519893:23522423,23519895:23522151,23519897:23522236,23519899:23521887,23519901:23522354,23519903:23521949,23519906:23521596,23519908:23521725,23519911:23521757,23519913:23521379,23519916:23521560,23519919:23521233,23519921:23521399,23519924:23521349,23519927:23521196,23519929:23521524,23519932:23520972,23519934:23521040,23519937:23521470,23519940:23520069,23522492:23522535,23522700:23523143,23567605:23569609,23567622:23569642,23567627:23569487,23567631:23569340,23567635:23569236,23567637:23568973,23567641:23569272,23567644:23569065,23567647:23569182,23567666:23568857,23567669:23568911,23567670:23569112,23567688:23568699,23567689:23568347,23567691:23568459,23567693:23568634,23567694:23568252,23567696:23568213,23567697:23568299,23567699:23568071,23567701:23567849,23567702:23568153,23570268:23570624,23572188:23572418,23574051:23574327,23574053:23574352,23574811:23574982,23575398:23575629,23575928:23576070,23576664:23576843,23581242:23581552,23581245:23581670,23581248:2358146', 'assoc_mat': '23519889:autre:4230:23522470,23519891:autre:4230:23522040,23519893:autre:4230:23522423,23519895:autre:4230:23522151,23519897:autre:4230:23522236,23519899:autre:4230:23521887,23519901:autre:4230:23522354,23519903:autre:4230:23521949,23519906:autre:4230:23521596,23519908:autre:4230:23521725,23519911:autre:4230:23521757,23519913:autre:4230:23521379,23519916:autre:4230:23521560,23519919:autre:4230:23521233,23519921:autre:4230:23521399,23519924:autre:4230:23521349,23519927:autre:4230:23521196,23519929:autre:4230:23521524,23519932:autre:4230:23520972,23519934:autre:4230:23521040,23519937:autre:4230:23521470,23519940:autre:4230:23520069,23522492:autre:4230:23522535,23522700:autre:4230:23523143,23567605:autre:4230:23569609,23567622:autre:4230:23569642,23567627:autre:4230:23569487,23567631:autre:4230:23569340,23567635:autre:4230:23569236,23567637:autre:4230:23568973,23567641:autre:4230:23569272,23567644:autre:4230:23569065,23567647:autre:4230:23569182,23567666:autre:4230:23568857,23567669:autre:4230:23568911,23567670:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04773020525878231, 'nb_photo': 115629, 'list_port_cont': '23520079,23520979,23521054,23521192,23521232,23521355,23521386,23521400,23521479,23521529,23521568,23521607,23521727,23521766,23521888,23521958,23522041,23522142,23522234,23522358,23522430,23522468,23522544,23523156,23567858,23568079,23568158,23568208,23568263,23568302,23568348,23568451,23568625,23568706,23568864,23568916,23568976,23569064,23569119,23569199,23569230,23569273,23569349,23569486,23569597,23569633,23570629,23572414,23574335,23574350,23574996,23575640,23576080,23576855,23581470,23581551,23581687,23581808,23582178,23583569,23584619,23585295,23588013,23590748,23592805,23594663,23596896,23598833,23600348,23601964,23620864,23620918,23644746,23645983,23648686,23649377,23649411,23649480,23649555,23649650,23649729,23649861,23649980,23650088,23650138,23650181,23650273,23650393,23650499,23650534,23650623,23650713,23650798,23650898,23650964,23651584,23690071,23690160,23690191,23690230,23690267,23690313,23690356,23690406,23690482,23690529,23690618,23690653,23690703,23750753,23750836,23750917,23750961,2375099', 'assoc_port': '23519889:23522468,23519891:23522041,23519893:23522430,23519895:23522142,23519897:23522234,23519899:23521888,23519901:23522358,23519903:23521958,23519906:23521607,23519908:23521727,23519911:23521766,23519913:23521386,23519916:23521568,23519919:23521232,23519921:23521400,23519924:23521355,23519927:23521192,23519929:23521529,23519932:23520979,23519934:23521054,23519937:23521479,23519940:23520079,23522492:23522544,23522700:23523156,23567605:23569597,23567622:23569633,23567627:23569486,23567631:23569349,23567635:23569230,23567637:23568976,23567641:23569273,23567644:23569064,23567647:23569199,23567666:23568864,23567669:23568916,23567670:23569119,23567688:23568706,23567689:23568348,23567691:23568451,23567693:23568625,23567694:23568263,23567696:23568208,23567697:23568302,23567699:23568079,23567701:23567858,23567702:23568158,23570268:23570629,23572188:23572414,23574051:23574335,23574053:23574350,23574811:23574996,23575398:23575640,23575928:23576080,23576664:23576855,23581242:23581551,23581245:23581687,23581248:2358147', 'assoc_mat': '23519889:carton:4230:23522468,23519891:carton:4230:23522041,23519893:carton:4230:23522430,23519895:carton:4230:23522142,23519897:carton:4230:23522234,23519899:carton:4230:23521888,23519901:carton:4230:23522358,23519903:carton:4230:23521958,23519906:carton:4230:23521607,23519908:carton:4230:23521727,23519911:carton:4230:23521766,23519913:carton:4230:23521386,23519916:carton:4230:23521568,23519919:carton:4230:23521232,23519921:carton:4230:23521400,23519924:carton:4230:23521355,23519927:carton:4230:23521192,23519929:carton:4230:23521529,23519932:carton:4230:23520979,23519934:carton:4230:23521054,23519937:carton:4230:23521479,23519940:carton:4230:23520079,23522492:carton:4230:23522544,23522700:carton:4230:23523156,23567605:carton:4230:23569597,23567622:carton:4230:23569633,23567627:carton:4230:23569486,23567631:carton:4230:23569349,23567635:carton:4230:23569230,23567637:carton:4230:23568976,23567641:carton:4230:23569273,23567644:carton:4230:23569064,23567647:carton:4230:23569199,23567666:carton:4230:23568864,2356'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012874023051084246, 'nb_photo': 2191, 'list_port_cont': '23520066,23520982,23521046,23521187,23521236,23521351,23521380,23521395,23521468,23521574,23521733,23521760,23521954,23522034,23522149,23522224,23522348,23522429,23522461,23522533,23523141,23567843,23568077,23568146,23568251,23568301,23568448,23568701,23568853,23568904,23569054,23569106,23569193,23569225,23569269,23569348,23569479,23569592,23569643,23572413,23574328,23574357,23574988,23575642,23576857,23581472,23581681,23581792,23582180,23583567,23584613,23585285,23588011,23590735,23592799,23594649,23596885,23598840,23600352,23601953,23620905,23648684,23649371,23649410,23649483,23649560,23649640,23649739,23649979,23650076,23650122,23650180,23650276,23650400,23650630,23650701,23650783,23650973,23651572,23690070,23690156,23690182,23690261,23690320,23690344,23690407,23690479,23690518,23690616,23690647,23690678,23750742,23750838,23750919,23750952,23751013,23751067,23751107,23751173,23751202,23751253,23751402,23751477,23752179,23752439,23752553,23752738,23752836,23753165,23753517,23753632,23753746,23753915,2375421', 'assoc_port': '23519889:23522461,23519891:23522034,23519893:23522429,23519895:23522149,23519897:23522224,23519901:23522348,23519903:23521954,23519908:23521733,23519911:23521760,23519913:23521380,23519916:23521574,23519919:23521236,23519921:23521395,23519924:23521351,23519927:23521187,23519932:23520982,23519934:23521046,23519937:23521468,23519940:23520066,23522492:23522533,23522700:23523141,23567605:23569592,23567622:23569643,23567627:23569479,23567631:23569348,23567635:23569225,23567641:23569269,23567644:23569054,23567647:23569193,23567666:23568853,23567669:23568904,23567670:23569106,23567688:23568701,23567691:23568448,23567694:23568251,23567697:23568301,23567699:23568077,23567701:23567843,23567702:23568146,23572188:23572413,23574051:23574328,23574053:23574357,23574811:23574988,23575398:23575642,23576664:23576857,23581245:23581681,23581248:23581472,23581337:23581792,23582093:23582180,23583098:23583567,23584455:23584613,23585041:23585285,23587481:23588011,23590226:23590735,23592363:23592799,23594566:23594649,23596200:2359688', 'assoc_mat': '23519889:metal:4230:23522461,23519891:metal:4230:23522034,23519893:metal:4230:23522429,23519895:metal:4230:23522149,23519897:metal:4230:23522224,23519901:metal:4230:23522348,23519903:metal:4230:23521954,23519908:metal:4230:23521733,23519911:metal:4230:23521760,23519913:metal:4230:23521380,23519916:metal:4230:23521574,23519919:metal:4230:23521236,23519921:metal:4230:23521395,23519924:metal:4230:23521351,23519927:metal:4230:23521187,23519932:metal:4230:23520982,23519934:metal:4230:23521046,23519937:metal:4230:23521468,23519940:metal:4230:23520066,23522492:metal:4230:23522533,23522700:metal:4230:23523141,23567605:metal:4230:23569592,23567622:metal:4230:23569643,23567627:metal:4230:23569479,23567631:metal:4230:23569348,23567635:metal:4230:23569225,23567641:metal:4230:23569269,23567644:metal:4230:23569054,23567647:metal:4230:23569193,23567666:metal:4230:23568853,23567669:metal:4230:23568904,23567670:metal:4230:23569106,23567688:metal:4230:23568701,23567691:metal:4230:23568448,23567694:metal:4230:23568251,23567697:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.13705147901294307, 'nb_photo': 333033, 'list_port_cont': '23520080,23520970,23521052,23521197,23521235,23521346,23521388,23521411,23521474,23521537,23521573,23521601,23521724,23521762,23521884,23521959,23522032,23522156,23522242,23522357,23522432,23522467,23522549,23523158,23567856,23568076,23568151,23568218,23568258,23568296,23568361,23568453,23568633,23568694,23568863,23568908,23568979,23569059,23569107,23569198,23569224,23569268,23569339,23569491,23569607,23569647,23570628,23572415,23574343,23574355,23574992,23575645,23576086,23576853,23581478,23581547,23581684,23581796,23582173,23583571,23584620,23585293,23588003,23590740,23592804,23594664,23596902,23598829,23600345,23601963,23620866,23620913,23644752,23645991,23648682,23649380,23649420,23649489,23649564,23649652,23649735,23649866,23649969,23650073,23650130,23650177,23650280,23650398,23650501,23650532,23650632,23650707,23650793,23650904,23650972,23651581,23690068,23690153,23690193,23690227,23690269,23690323,23690360,23690418,23690485,23690527,23690617,23690652,23690718,23750754,23750833,23750922,23750965,2375100', 'assoc_port': '23519889:23522467,23519891:23522032,23519893:23522432,23519895:23522156,23519897:23522242,23519899:23521884,23519901:23522357,23519903:23521959,23519906:23521601,23519908:23521724,23519911:23521762,23519913:23521388,23519916:23521573,23519919:23521235,23519921:23521411,23519924:23521346,23519927:23521197,23519929:23521537,23519932:23520970,23519934:23521052,23519937:23521474,23519940:23520080,23522492:23522549,23522700:23523158,23567605:23569607,23567622:23569647,23567627:23569491,23567631:23569339,23567635:23569224,23567637:23568979,23567641:23569268,23567644:23569059,23567647:23569198,23567666:23568863,23567669:23568908,23567670:23569107,23567688:23568694,23567689:23568361,23567691:23568453,23567693:23568633,23567694:23568258,23567696:23568218,23567697:23568296,23567699:23568076,23567701:23567856,23567702:23568151,23570268:23570628,23572188:23572415,23574051:23574343,23574053:23574355,23574811:23574992,23575398:23575645,23575928:23576086,23576664:23576853,23581242:23581547,23581245:23581684,23581248:2358147', 'assoc_mat': '23519889:papier:4230:23522467,23519891:papier:4230:23522032,23519893:papier:4230:23522432,23519895:papier:4230:23522156,23519897:papier:4230:23522242,23519899:papier:4230:23521884,23519901:papier:4230:23522357,23519903:papier:4230:23521959,23519906:papier:4230:23521601,23519908:papier:4230:23521724,23519911:papier:4230:23521762,23519913:papier:4230:23521388,23519916:papier:4230:23521573,23519919:papier:4230:23521235,23519921:papier:4230:23521411,23519924:papier:4230:23521346,23519927:papier:4230:23521197,23519929:papier:4230:23521537,23519932:papier:4230:23520970,23519934:papier:4230:23521052,23519937:papier:4230:23521474,23519940:papier:4230:23520080,23522492:papier:4230:23522549,23522700:papier:4230:23523158,23567605:papier:4230:23569607,23567622:papier:4230:23569647,23567627:papier:4230:23569491,23567631:papier:4230:23569339,23567635:papier:4230:23569224,23567637:papier:4230:23568979,23567641:papier:4230:23569268,23567644:papier:4230:23569059,23567647:papier:4230:23569198,23567666:papier:4230:23568863,2356'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0020040128880148113, 'nb_photo': 1177, 'list_port_cont': '23521234,23521564,23521610,23521731,23521763,23521874,23521962,23522044,23522154,23522252,23522356,23522434,23522462,23523155,23567857,23568083,23568160,23568211,23568247,23568289,23568360,23568455,23568635,23568705,23568856,23568913,23569063,23569113,23569192,23569265,23569344,23569485,23569606,23569644,23570617,23572423,23574336,23574358,23574999,23575633,23576848,23581480,23581806,23582179,23583576,23584609,23588023,23590739,23592807,23600353,23644753,23649366,23649734,23649976,23650087,23650139,23650179,23650403,23650627,23650702,23650790,23650902,23650967,23690065,23690154,23690184,23690273,23690420,23750747,23750829,23750925,23750958,23751008,23751053,23751112,23751168,23751209,23751260,23751414,23751478,23752188,23752448,23752560,23752742,23752839,23753635,23753911,23754366,23754956,23755272,23755425,23756031,23794671,23794803,23795023,23795170,23795217,23795255,23795485,23795588,23795705,23795834,23795900,23795999,23796046,23798635,23803714,23804936,23806931,23807842,23810167,23811190,23812121,2381300', 'assoc_port': '23519889:23522462,23519891:23522044,23519893:23522434,23519895:23522154,23519897:23522252,23519899:23521874,23519901:23522356,23519903:23521962,23519906:23521610,23519908:23521731,23519911:23521763,23519916:23521564,23519919:23521234,23522700:23523155,23567605:23569606,23567622:23569644,23567627:23569485,23567631:23569344,23567641:23569265,23567644:23569063,23567647:23569192,23567666:23568856,23567669:23568913,23567670:23569113,23567688:23568705,23567689:23568360,23567691:23568455,23567693:23568635,23567694:23568247,23567696:23568211,23567697:23568289,23567699:23568083,23567701:23567857,23567702:23568160,23570268:23570617,23572188:23572423,23574051:23574336,23574053:23574358,23574811:23574999,23575398:23575633,23576664:23576848,23581248:23581480,23581337:23581806,23582093:23582179,23583098:23583576,23584455:23584609,23587481:23588023,23590226:23590739,23592363:23592807,23600132:23600353,23639561:23644753,23645590:23650902,23645595:23650967,23645598:23650702,23645601:23650790,23645607:23650403,23645608:2365062', 'assoc_mat': '23519889:pehd:4230:23522462,23519891:pehd:4230:23522044,23519893:pehd:4230:23522434,23519895:pehd:4230:23522154,23519897:pehd:4230:23522252,23519899:pehd:4230:23521874,23519901:pehd:4230:23522356,23519903:pehd:4230:23521962,23519906:pehd:4230:23521610,23519908:pehd:4230:23521731,23519911:pehd:4230:23521763,23519916:pehd:4230:23521564,23519919:pehd:4230:23521234,23522700:pehd:4230:23523155,23567605:pehd:4230:23569606,23567622:pehd:4230:23569644,23567627:pehd:4230:23569485,23567631:pehd:4230:23569344,23567641:pehd:4230:23569265,23567644:pehd:4230:23569063,23567647:pehd:4230:23569192,23567666:pehd:4230:23568856,23567669:pehd:4230:23568913,23567670:pehd:4230:23569113,23567688:pehd:4230:23568705,23567689:pehd:4230:23568360,23567691:pehd:4230:23568455,23567693:pehd:4230:23568635,23567694:pehd:4230:23568247,23567696:pehd:4230:23568211,23567697:pehd:4230:23568289,23567699:pehd:4230:23568083,23567701:pehd:4230:23567857,23567702:pehd:4230:23568160,23570268:pehd:4230:23570617,23572188:pehd:4230:23572423,23574051:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013610914146798315, 'nb_photo': 18455, 'list_port_cont': '23520082,23520983,23521055,23521189,23521228,23521345,23521387,23521407,23521467,23521535,23521569,23521602,23521719,23521765,23521885,23521953,23522046,23522152,23522246,23522359,23522428,23522466,23522541,23523148,23567848,23568081,23568156,23568215,23568257,23568290,23568351,23568460,23568628,23568703,23568861,23568915,23568982,23569062,23569117,23569185,23569234,23569261,23569350,23569489,23569599,23569635,23570626,23572412,23574344,23574349,23574986,23575644,23576087,23576852,23581466,23581546,23581677,23581807,23582172,23583579,23584618,23585298,23588015,23590749,23592796,23594652,23596891,23598843,23600351,23601956,23620873,23620912,23644742,23645984,23648696,23649378,23649422,23649490,23649563,23649639,23649738,23649852,23649975,23650089,23650136,23650169,23650281,23650391,23650498,23650528,23650639,23650711,23650795,23650900,23650969,23651586,23690066,23690155,23690196,23690231,23690272,23690318,23690350,23690419,23690472,23690533,23690610,23690656,23690717,23750752,23750834,23750924,23750966,2375100', 'assoc_port': '23519889:23522466,23519891:23522046,23519893:23522428,23519895:23522152,23519897:23522246,23519899:23521885,23519901:23522359,23519903:23521953,23519906:23521602,23519908:23521719,23519911:23521765,23519913:23521387,23519916:23521569,23519919:23521228,23519921:23521407,23519924:23521345,23519927:23521189,23519929:23521535,23519932:23520983,23519934:23521055,23519937:23521467,23519940:23520082,23522492:23522541,23522700:23523148,23567605:23569599,23567622:23569635,23567627:23569489,23567631:23569350,23567635:23569234,23567637:23568982,23567641:23569261,23567644:23569062,23567647:23569185,23567666:23568861,23567669:23568915,23567670:23569117,23567688:23568703,23567689:23568351,23567691:23568460,23567693:23568628,23567694:23568257,23567696:23568215,23567697:23568290,23567699:23568081,23567701:23567848,23567702:23568156,23570268:23570626,23572188:23572412,23574051:23574344,23574053:23574349,23574811:23574986,23575398:23575644,23575928:23576087,23576664:23576852,23581242:23581546,23581245:23581677,23581248:2358146', 'assoc_mat': '23519889:pet_clair:4230:23522466,23519891:pet_clair:4230:23522046,23519893:pet_clair:4230:23522428,23519895:pet_clair:4230:23522152,23519897:pet_clair:4230:23522246,23519899:pet_clair:4230:23521885,23519901:pet_clair:4230:23522359,23519903:pet_clair:4230:23521953,23519906:pet_clair:4230:23521602,23519908:pet_clair:4230:23521719,23519911:pet_clair:4230:23521765,23519913:pet_clair:4230:23521387,23519916:pet_clair:4230:23521569,23519919:pet_clair:4230:23521228,23519921:pet_clair:4230:23521407,23519924:pet_clair:4230:23521345,23519927:pet_clair:4230:23521189,23519929:pet_clair:4230:23521535,23519932:pet_clair:4230:23520983,23519934:pet_clair:4230:23521055,23519937:pet_clair:4230:23521467,23519940:pet_clair:4230:23520082,23522492:pet_clair:4230:23522541,23522700:pet_clair:4230:23523148,23567605:pet_clair:4230:23569599,23567622:pet_clair:4230:23569635,23567627:pet_clair:4230:23569489,23567631:pet_clair:4230:23569350,23567635:pet_clair:4230:23569234,23567637:pet_clair:4230:23568982,23567641:pet_clair:4230:23569261,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001424033822551599, 'nb_photo': 563, 'list_port_cont': '23520973,23521200,23521389,23521405,23521728,23521768,23522146,23522251,23522464,23567855,23568073,23568157,23568216,23568262,23568300,23568359,23568457,23568627,23568702,23568867,23568906,23569067,23569640,23570631,23572419,23574359,23575000,23575637,23576082,23576856,23581469,23581544,23581679,23581809,23582171,23583575,23584617,23592795,23601966,23644743,23645992,23649561,23649730,23650083,23650137,23650174,23650278,23650397,23650500,23650906,23650958,23690421,23690484,23750970,23751006,23751116,23751216,23751259,23752746,23752838,23753170,23753526,23753622,23753744,23753917,23754089,23754787,23755419,23755851,23794676,23795220,23795262,23795486,23795590,23795839,23795892,23796043,23798636,23806925,23807843,23811199,23813001,23814434,23815575,23820490,23821795,23823267,23825293,23825596,23825930,23826804,23829316,23878534,23878838,23879025,23879067,23879152,23879269,23879504,23879536,23879846,23879986,23921190,23921216,23921357,23921492,23921561,23921591,23921683,23921860,23921928,23921981,23922294,2392240', 'assoc_port': '23519889:23522464,23519895:23522146,23519897:23522251,23519908:23521728,23519911:23521768,23519913:23521389,23519921:23521405,23519927:23521200,23519932:23520973,23567622:23569640,23567644:23569067,23567666:23568867,23567669:23568906,23567688:23568702,23567689:23568359,23567691:23568457,23567693:23568627,23567694:23568262,23567696:23568216,23567697:23568300,23567699:23568073,23567701:23567855,23567702:23568157,23570268:23570631,23572188:23572419,23574053:23574359,23574811:23575000,23575398:23575637,23575928:23576082,23576664:23576856,23581242:23581544,23581245:23581679,23581248:23581469,23581337:23581809,23582093:23582171,23583098:23583575,23584455:23584617,23592363:23592795,23601603:23601966,23639561:23644743,23645590:23650906,23645593:23645992,23645595:23650958,23645602:23650500,23645606:23650278,23645607:23650397,23645609:23650083,23645610:23650137,23645612:23650174,23645614:23649730,23645617:23649561,23689957:23690484,23689965:23690421,23749576:23751006,23749577:23751116,23749578:23751216,23749579:2375125', 'assoc_mat': '23519889:pet_fonce:4230:23522464,23519895:pet_fonce:4230:23522146,23519897:pet_fonce:4230:23522251,23519908:pet_fonce:4230:23521728,23519911:pet_fonce:4230:23521768,23519913:pet_fonce:4230:23521389,23519921:pet_fonce:4230:23521405,23519927:pet_fonce:4230:23521200,23519932:pet_fonce:4230:23520973,23567622:pet_fonce:4230:23569640,23567644:pet_fonce:4230:23569067,23567666:pet_fonce:4230:23568867,23567669:pet_fonce:4230:23568906,23567688:pet_fonce:4230:23568702,23567689:pet_fonce:4230:23568359,23567691:pet_fonce:4230:23568457,23567693:pet_fonce:4230:23568627,23567694:pet_fonce:4230:23568262,23567696:pet_fonce:4230:23568216,23567697:pet_fonce:4230:23568300,23567699:pet_fonce:4230:23568073,23567701:pet_fonce:4230:23567855,23567702:pet_fonce:4230:23568157,23570268:pet_fonce:4230:23570631,23572188:pet_fonce:4230:23572419,23574053:pet_fonce:4230:23574359,23574811:pet_fonce:4230:23575000,23575398:pet_fonce:4230:23575637,23575928:pet_fonce:4230:23576082,23576664:pet_fonce:4230:23576856,23581242:pet_fonce:4230:23581544,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(1862600,1866481,1870983,1873059,1876531,1884730,1887900,1893001,1896976,1900233,1903352,1907899,1909901,1910820,1913555,1915959,1918606,1921320,1924876,1926450,1926699,1930466,1930463,1931910,1935576,1937304,1940055,1940584,1944934)); 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-06-01' and date <= '2025-06-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1856,),), 'unwanted_material_monthly_percentage': ((0.7951091028734574,),), 'material_repartition': (('incineration', 1856),), 'material_dict': {'incineration': 1856}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 6, 1), 0.7881576320984379, 62), (datetime.date(2025, 6, 2), 0.7923232670826293, 72), (datetime.date(2025, 6, 3), 0.80857038106225, 83), (datetime.date(2025, 6, 4), 0.8174676273583278, 83), (datetime.date(2025, 6, 5), 0.8353599669395859, 43), (datetime.date(2025, 6, 7), 0.7651926529982277, 35), (datetime.date(2025, 6, 8), 0.8095414984082948, 74), (datetime.date(2025, 6, 9), 0.8163204612751886, 70), (datetime.date(2025, 6, 10), 0.7953409419977591, 72), (datetime.date(2025, 6, 11), 0.7831587450688039, 71), (datetime.date(2025, 6, 12), 0.7881257466272076, 77), (datetime.date(2025, 6, 13), 0.7877844504403962, 75), (datetime.date(2025, 6, 14), 0.7815377031718619, 73), (datetime.date(2025, 6, 15), 0.7459674470814955, 70), (datetime.date(2025, 6, 16), 0.8575089052803161, 34), (datetime.date(2025, 6, 17), 0.7960619201600626, 62), (datetime.date(2025, 6, 18), 0.7722859833068697, 11), (datetime.date(2025, 6, 19), 0.7879717707307862, 23), (datetime.date(2025, 6, 20), 0.8099729956962799, 76), (datetime.date(2025, 6, 21), 0.8009777779308856, 73), (datetime.date(2025, 6, 22), 0.8053866851863785, 83), (datetime.date(2025, 6, 23), 0.7794953022143188, 61), (datetime.date(2025, 6, 24), 0.7641542691660315, 69), (datetime.date(2025, 6, 25), 0.7514136763517343, 77), (datetime.date(2025, 6, 26), 0.7643952301893432, 68), (datetime.date(2025, 6, 27), 0.7601944413102477, 32), (datetime.date(2025, 6, 28), 0.7863008011883853, 83), (datetime.date(2025, 6, 29), 0.8497939266491364, 73), (datetime.date(2025, 6, 30), 0.8251304142685869, 71)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 6, 1), 0.7881576320984379, 62), (datetime.date(2025, 6, 2), 0.7923232670826293, 72), (datetime.date(2025, 6, 3), 0.80857038106225, 83), (datetime.date(2025, 6, 4), 0.8174676273583278, 83), (datetime.date(2025, 6, 5), 0.8353599669395859, 43), (datetime.date(2025, 6, 7), 0.7651926529982277, 35), (datetime.date(2025, 6, 8), 0.8095414984082948, 74), (datetime.date(2025, 6, 9), 0.8163204612751886, 70), (datetime.date(2025, 6, 10), 0.7953409419977591, 72), (datetime.date(2025, 6, 11), 0.7831587450688039, 71), (datetime.date(2025, 6, 12), 0.7881257466272076, 77), (datetime.date(2025, 6, 13), 0.7877844504403962, 75), (datetime.date(2025, 6, 14), 0.7815377031718619, 73), (datetime.date(2025, 6, 15), 0.7459674470814955, 70), (datetime.date(2025, 6, 16), 0.8575089052803161, 34), (datetime.date(2025, 6, 17), 0.7960619201600626, 62), (datetime.date(2025, 6, 18), 0.7722859833068697, 11), (datetime.date(2025, 6, 19), 0.7879717707307862, 23), (datetime.date(2025, 6, 20), 0.8099729956962799, 76), (datetime.date(2025, 6, 21), 0.8009777779308856, 73), (datetime.date(2025, 6, 22), 0.8053866851863785, 83), (datetime.date(2025, 6, 23), 0.7794953022143188, 61), (datetime.date(2025, 6, 24), 0.7641542691660315, 69), (datetime.date(2025, 6, 25), 0.7514136763517343, 77), (datetime.date(2025, 6, 26), 0.7643952301893432, 68), (datetime.date(2025, 6, 27), 0.7601944413102477, 32), (datetime.date(2025, 6, 28), 0.7863008011883853, 83), (datetime.date(2025, 6, 29), 0.8497939266491364, 73), (datetime.date(2025, 6, 30), 0.8251304142685869, 71))}, 'quality_array': [['-8.292719956648336', '01062025'], ['-8.39824021608985', '02062025'], ['-8.449391093278406', '03062025'], ['-8.462724844317123', '04062025'], ['-8.343710038142035', '05062025'], ['-8.141180255410566', '07062025'], ['-8.274546902013165', '08062025'], ['-8.258935721739052', '09062025'], ['-8.3121511871001', '10062025'], ['-8.439922868364233', '11062025'], ['-8.44934913856864', '12062025'], ['-8.416109406124376', '13062025'], ['-8.246330493543008', '14062025'], ['-8.25596097930803', '15062025'], ['-7.95359604744069', '16062025'], ['-8.260850650579323', '17062025'], ['-8.556785291342177', '18062025'], ['-8.527577363607044', '19062025'], ['-8.523348547349151', '20062025'], ['-8.456429055988243', '21062025'], ['-8.542500175573126', '22062025'], ['-8.468951915221304', '23062025'], ['-8.460376876808569', '24062025'], ['-8.413715334793322', '25062025'], ['-8.374562152624145', '26062025'], ['-8.303180942591181', '27062025'], ['-8.074195570590783', '28062025'], ['-8.279728058680337', '29062025'], ['-8.133184702284709', '30062025']], 'number_of_batch': ((605,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012757247450136492, 'nb_photo': 16925, 'list_port_cont': '23520069,23520972,23521040,23521196,23521233,23521349,23521379,23521399,23521470,23521524,23521560,23521596,23521725,23521757,23521887,23521949,23522040,23522151,23522236,23522354,23522423,23522470,23522535,23523143,23567849,23568071,23568153,23568213,23568252,23568299,23568347,23568459,23568634,23568699,23568857,23568911,23568973,23569065,23569112,23569182,23569236,23569272,23569340,23569487,23569609,23569642,23570624,23572418,23574327,23574352,23574982,23575629,23576070,23576843,23581468,23581552,23581670,23581798,23582166,23583564,23584612,23585297,23588021,23590744,23592806,23594659,23596892,23598831,23600346,23601969,23620876,23620907,23644750,23645976,23648695,23649365,23649413,23649482,23649565,23649647,23649732,23649864,23649973,23650085,23650133,23650172,23650275,23650389,23650497,23650512,23650633,23650710,23650786,23650892,23650970,23651589,23690054,23690143,23690188,23690214,23690276,23690321,23690355,23690414,23690486,23690522,23690620,23690642,23690698,23750740,23750824,23750926,23750963,2375099', 'assoc_port': '23519889:23522470,23519891:23522040,23519893:23522423,23519895:23522151,23519897:23522236,23519899:23521887,23519901:23522354,23519903:23521949,23519906:23521596,23519908:23521725,23519911:23521757,23519913:23521379,23519916:23521560,23519919:23521233,23519921:23521399,23519924:23521349,23519927:23521196,23519929:23521524,23519932:23520972,23519934:23521040,23519937:23521470,23519940:23520069,23522492:23522535,23522700:23523143,23567605:23569609,23567622:23569642,23567627:23569487,23567631:23569340,23567635:23569236,23567637:23568973,23567641:23569272,23567644:23569065,23567647:23569182,23567666:23568857,23567669:23568911,23567670:23569112,23567688:23568699,23567689:23568347,23567691:23568459,23567693:23568634,23567694:23568252,23567696:23568213,23567697:23568299,23567699:23568071,23567701:23567849,23567702:23568153,23570268:23570624,23572188:23572418,23574051:23574327,23574053:23574352,23574811:23574982,23575398:23575629,23575928:23576070,23576664:23576843,23581242:23581552,23581245:23581670,23581248:2358146', 'assoc_mat': '23519889:autre:4230:23522470,23519891:autre:4230:23522040,23519893:autre:4230:23522423,23519895:autre:4230:23522151,23519897:autre:4230:23522236,23519899:autre:4230:23521887,23519901:autre:4230:23522354,23519903:autre:4230:23521949,23519906:autre:4230:23521596,23519908:autre:4230:23521725,23519911:autre:4230:23521757,23519913:autre:4230:23521379,23519916:autre:4230:23521560,23519919:autre:4230:23521233,23519921:autre:4230:23521399,23519924:autre:4230:23521349,23519927:autre:4230:23521196,23519929:autre:4230:23521524,23519932:autre:4230:23520972,23519934:autre:4230:23521040,23519937:autre:4230:23521470,23519940:autre:4230:23520069,23522492:autre:4230:23522535,23522700:autre:4230:23523143,23567605:autre:4230:23569609,23567622:autre:4230:23569642,23567627:autre:4230:23569487,23567631:autre:4230:23569340,23567635:autre:4230:23569236,23567637:autre:4230:23568973,23567641:autre:4230:23569272,23567644:autre:4230:23569065,23567647:autre:4230:23569182,23567666:autre:4230:23568857,23567669:autre:4230:23568911,23567670:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04773020525878231, 'nb_photo': 115629, 'list_port_cont': '23520079,23520979,23521054,23521192,23521232,23521355,23521386,23521400,23521479,23521529,23521568,23521607,23521727,23521766,23521888,23521958,23522041,23522142,23522234,23522358,23522430,23522468,23522544,23523156,23567858,23568079,23568158,23568208,23568263,23568302,23568348,23568451,23568625,23568706,23568864,23568916,23568976,23569064,23569119,23569199,23569230,23569273,23569349,23569486,23569597,23569633,23570629,23572414,23574335,23574350,23574996,23575640,23576080,23576855,23581470,23581551,23581687,23581808,23582178,23583569,23584619,23585295,23588013,23590748,23592805,23594663,23596896,23598833,23600348,23601964,23620864,23620918,23644746,23645983,23648686,23649377,23649411,23649480,23649555,23649650,23649729,23649861,23649980,23650088,23650138,23650181,23650273,23650393,23650499,23650534,23650623,23650713,23650798,23650898,23650964,23651584,23690071,23690160,23690191,23690230,23690267,23690313,23690356,23690406,23690482,23690529,23690618,23690653,23690703,23750753,23750836,23750917,23750961,2375099', 'assoc_port': '23519889:23522468,23519891:23522041,23519893:23522430,23519895:23522142,23519897:23522234,23519899:23521888,23519901:23522358,23519903:23521958,23519906:23521607,23519908:23521727,23519911:23521766,23519913:23521386,23519916:23521568,23519919:23521232,23519921:23521400,23519924:23521355,23519927:23521192,23519929:23521529,23519932:23520979,23519934:23521054,23519937:23521479,23519940:23520079,23522492:23522544,23522700:23523156,23567605:23569597,23567622:23569633,23567627:23569486,23567631:23569349,23567635:23569230,23567637:23568976,23567641:23569273,23567644:23569064,23567647:23569199,23567666:23568864,23567669:23568916,23567670:23569119,23567688:23568706,23567689:23568348,23567691:23568451,23567693:23568625,23567694:23568263,23567696:23568208,23567697:23568302,23567699:23568079,23567701:23567858,23567702:23568158,23570268:23570629,23572188:23572414,23574051:23574335,23574053:23574350,23574811:23574996,23575398:23575640,23575928:23576080,23576664:23576855,23581242:23581551,23581245:23581687,23581248:2358147', 'assoc_mat': '23519889:carton:4230:23522468,23519891:carton:4230:23522041,23519893:carton:4230:23522430,23519895:carton:4230:23522142,23519897:carton:4230:23522234,23519899:carton:4230:23521888,23519901:carton:4230:23522358,23519903:carton:4230:23521958,23519906:carton:4230:23521607,23519908:carton:4230:23521727,23519911:carton:4230:23521766,23519913:carton:4230:23521386,23519916:carton:4230:23521568,23519919:carton:4230:23521232,23519921:carton:4230:23521400,23519924:carton:4230:23521355,23519927:carton:4230:23521192,23519929:carton:4230:23521529,23519932:carton:4230:23520979,23519934:carton:4230:23521054,23519937:carton:4230:23521479,23519940:carton:4230:23520079,23522492:carton:4230:23522544,23522700:carton:4230:23523156,23567605:carton:4230:23569597,23567622:carton:4230:23569633,23567627:carton:4230:23569486,23567631:carton:4230:23569349,23567635:carton:4230:23569230,23567637:carton:4230:23568976,23567641:carton:4230:23569273,23567644:carton:4230:23569064,23567647:carton:4230:23569199,23567666:carton:4230:23568864,2356'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012874023051084246, 'nb_photo': 2191, 'list_port_cont': '23520066,23520982,23521046,23521187,23521236,23521351,23521380,23521395,23521468,23521574,23521733,23521760,23521954,23522034,23522149,23522224,23522348,23522429,23522461,23522533,23523141,23567843,23568077,23568146,23568251,23568301,23568448,23568701,23568853,23568904,23569054,23569106,23569193,23569225,23569269,23569348,23569479,23569592,23569643,23572413,23574328,23574357,23574988,23575642,23576857,23581472,23581681,23581792,23582180,23583567,23584613,23585285,23588011,23590735,23592799,23594649,23596885,23598840,23600352,23601953,23620905,23648684,23649371,23649410,23649483,23649560,23649640,23649739,23649979,23650076,23650122,23650180,23650276,23650400,23650630,23650701,23650783,23650973,23651572,23690070,23690156,23690182,23690261,23690320,23690344,23690407,23690479,23690518,23690616,23690647,23690678,23750742,23750838,23750919,23750952,23751013,23751067,23751107,23751173,23751202,23751253,23751402,23751477,23752179,23752439,23752553,23752738,23752836,23753165,23753517,23753632,23753746,23753915,2375421', 'assoc_port': '23519889:23522461,23519891:23522034,23519893:23522429,23519895:23522149,23519897:23522224,23519901:23522348,23519903:23521954,23519908:23521733,23519911:23521760,23519913:23521380,23519916:23521574,23519919:23521236,23519921:23521395,23519924:23521351,23519927:23521187,23519932:23520982,23519934:23521046,23519937:23521468,23519940:23520066,23522492:23522533,23522700:23523141,23567605:23569592,23567622:23569643,23567627:23569479,23567631:23569348,23567635:23569225,23567641:23569269,23567644:23569054,23567647:23569193,23567666:23568853,23567669:23568904,23567670:23569106,23567688:23568701,23567691:23568448,23567694:23568251,23567697:23568301,23567699:23568077,23567701:23567843,23567702:23568146,23572188:23572413,23574051:23574328,23574053:23574357,23574811:23574988,23575398:23575642,23576664:23576857,23581245:23581681,23581248:23581472,23581337:23581792,23582093:23582180,23583098:23583567,23584455:23584613,23585041:23585285,23587481:23588011,23590226:23590735,23592363:23592799,23594566:23594649,23596200:2359688', 'assoc_mat': '23519889:metal:4230:23522461,23519891:metal:4230:23522034,23519893:metal:4230:23522429,23519895:metal:4230:23522149,23519897:metal:4230:23522224,23519901:metal:4230:23522348,23519903:metal:4230:23521954,23519908:metal:4230:23521733,23519911:metal:4230:23521760,23519913:metal:4230:23521380,23519916:metal:4230:23521574,23519919:metal:4230:23521236,23519921:metal:4230:23521395,23519924:metal:4230:23521351,23519927:metal:4230:23521187,23519932:metal:4230:23520982,23519934:metal:4230:23521046,23519937:metal:4230:23521468,23519940:metal:4230:23520066,23522492:metal:4230:23522533,23522700:metal:4230:23523141,23567605:metal:4230:23569592,23567622:metal:4230:23569643,23567627:metal:4230:23569479,23567631:metal:4230:23569348,23567635:metal:4230:23569225,23567641:metal:4230:23569269,23567644:metal:4230:23569054,23567647:metal:4230:23569193,23567666:metal:4230:23568853,23567669:metal:4230:23568904,23567670:metal:4230:23569106,23567688:metal:4230:23568701,23567691:metal:4230:23568448,23567694:metal:4230:23568251,23567697:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.13705147901294307, 'nb_photo': 333033, 'list_port_cont': '23520080,23520970,23521052,23521197,23521235,23521346,23521388,23521411,23521474,23521537,23521573,23521601,23521724,23521762,23521884,23521959,23522032,23522156,23522242,23522357,23522432,23522467,23522549,23523158,23567856,23568076,23568151,23568218,23568258,23568296,23568361,23568453,23568633,23568694,23568863,23568908,23568979,23569059,23569107,23569198,23569224,23569268,23569339,23569491,23569607,23569647,23570628,23572415,23574343,23574355,23574992,23575645,23576086,23576853,23581478,23581547,23581684,23581796,23582173,23583571,23584620,23585293,23588003,23590740,23592804,23594664,23596902,23598829,23600345,23601963,23620866,23620913,23644752,23645991,23648682,23649380,23649420,23649489,23649564,23649652,23649735,23649866,23649969,23650073,23650130,23650177,23650280,23650398,23650501,23650532,23650632,23650707,23650793,23650904,23650972,23651581,23690068,23690153,23690193,23690227,23690269,23690323,23690360,23690418,23690485,23690527,23690617,23690652,23690718,23750754,23750833,23750922,23750965,2375100', 'assoc_port': '23519889:23522467,23519891:23522032,23519893:23522432,23519895:23522156,23519897:23522242,23519899:23521884,23519901:23522357,23519903:23521959,23519906:23521601,23519908:23521724,23519911:23521762,23519913:23521388,23519916:23521573,23519919:23521235,23519921:23521411,23519924:23521346,23519927:23521197,23519929:23521537,23519932:23520970,23519934:23521052,23519937:23521474,23519940:23520080,23522492:23522549,23522700:23523158,23567605:23569607,23567622:23569647,23567627:23569491,23567631:23569339,23567635:23569224,23567637:23568979,23567641:23569268,23567644:23569059,23567647:23569198,23567666:23568863,23567669:23568908,23567670:23569107,23567688:23568694,23567689:23568361,23567691:23568453,23567693:23568633,23567694:23568258,23567696:23568218,23567697:23568296,23567699:23568076,23567701:23567856,23567702:23568151,23570268:23570628,23572188:23572415,23574051:23574343,23574053:23574355,23574811:23574992,23575398:23575645,23575928:23576086,23576664:23576853,23581242:23581547,23581245:23581684,23581248:2358147', 'assoc_mat': '23519889:papier:4230:23522467,23519891:papier:4230:23522032,23519893:papier:4230:23522432,23519895:papier:4230:23522156,23519897:papier:4230:23522242,23519899:papier:4230:23521884,23519901:papier:4230:23522357,23519903:papier:4230:23521959,23519906:papier:4230:23521601,23519908:papier:4230:23521724,23519911:papier:4230:23521762,23519913:papier:4230:23521388,23519916:papier:4230:23521573,23519919:papier:4230:23521235,23519921:papier:4230:23521411,23519924:papier:4230:23521346,23519927:papier:4230:23521197,23519929:papier:4230:23521537,23519932:papier:4230:23520970,23519934:papier:4230:23521052,23519937:papier:4230:23521474,23519940:papier:4230:23520080,23522492:papier:4230:23522549,23522700:papier:4230:23523158,23567605:papier:4230:23569607,23567622:papier:4230:23569647,23567627:papier:4230:23569491,23567631:papier:4230:23569339,23567635:papier:4230:23569224,23567637:papier:4230:23568979,23567641:papier:4230:23569268,23567644:papier:4230:23569059,23567647:papier:4230:23569198,23567666:papier:4230:23568863,2356'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0020040128880148113, 'nb_photo': 1177, 'list_port_cont': '23521234,23521564,23521610,23521731,23521763,23521874,23521962,23522044,23522154,23522252,23522356,23522434,23522462,23523155,23567857,23568083,23568160,23568211,23568247,23568289,23568360,23568455,23568635,23568705,23568856,23568913,23569063,23569113,23569192,23569265,23569344,23569485,23569606,23569644,23570617,23572423,23574336,23574358,23574999,23575633,23576848,23581480,23581806,23582179,23583576,23584609,23588023,23590739,23592807,23600353,23644753,23649366,23649734,23649976,23650087,23650139,23650179,23650403,23650627,23650702,23650790,23650902,23650967,23690065,23690154,23690184,23690273,23690420,23750747,23750829,23750925,23750958,23751008,23751053,23751112,23751168,23751209,23751260,23751414,23751478,23752188,23752448,23752560,23752742,23752839,23753635,23753911,23754366,23754956,23755272,23755425,23756031,23794671,23794803,23795023,23795170,23795217,23795255,23795485,23795588,23795705,23795834,23795900,23795999,23796046,23798635,23803714,23804936,23806931,23807842,23810167,23811190,23812121,2381300', 'assoc_port': '23519889:23522462,23519891:23522044,23519893:23522434,23519895:23522154,23519897:23522252,23519899:23521874,23519901:23522356,23519903:23521962,23519906:23521610,23519908:23521731,23519911:23521763,23519916:23521564,23519919:23521234,23522700:23523155,23567605:23569606,23567622:23569644,23567627:23569485,23567631:23569344,23567641:23569265,23567644:23569063,23567647:23569192,23567666:23568856,23567669:23568913,23567670:23569113,23567688:23568705,23567689:23568360,23567691:23568455,23567693:23568635,23567694:23568247,23567696:23568211,23567697:23568289,23567699:23568083,23567701:23567857,23567702:23568160,23570268:23570617,23572188:23572423,23574051:23574336,23574053:23574358,23574811:23574999,23575398:23575633,23576664:23576848,23581248:23581480,23581337:23581806,23582093:23582179,23583098:23583576,23584455:23584609,23587481:23588023,23590226:23590739,23592363:23592807,23600132:23600353,23639561:23644753,23645590:23650902,23645595:23650967,23645598:23650702,23645601:23650790,23645607:23650403,23645608:2365062', 'assoc_mat': '23519889:pehd:4230:23522462,23519891:pehd:4230:23522044,23519893:pehd:4230:23522434,23519895:pehd:4230:23522154,23519897:pehd:4230:23522252,23519899:pehd:4230:23521874,23519901:pehd:4230:23522356,23519903:pehd:4230:23521962,23519906:pehd:4230:23521610,23519908:pehd:4230:23521731,23519911:pehd:4230:23521763,23519916:pehd:4230:23521564,23519919:pehd:4230:23521234,23522700:pehd:4230:23523155,23567605:pehd:4230:23569606,23567622:pehd:4230:23569644,23567627:pehd:4230:23569485,23567631:pehd:4230:23569344,23567641:pehd:4230:23569265,23567644:pehd:4230:23569063,23567647:pehd:4230:23569192,23567666:pehd:4230:23568856,23567669:pehd:4230:23568913,23567670:pehd:4230:23569113,23567688:pehd:4230:23568705,23567689:pehd:4230:23568360,23567691:pehd:4230:23568455,23567693:pehd:4230:23568635,23567694:pehd:4230:23568247,23567696:pehd:4230:23568211,23567697:pehd:4230:23568289,23567699:pehd:4230:23568083,23567701:pehd:4230:23567857,23567702:pehd:4230:23568160,23570268:pehd:4230:23570617,23572188:pehd:4230:23572423,23574051:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013610914146798315, 'nb_photo': 18455, 'list_port_cont': '23520082,23520983,23521055,23521189,23521228,23521345,23521387,23521407,23521467,23521535,23521569,23521602,23521719,23521765,23521885,23521953,23522046,23522152,23522246,23522359,23522428,23522466,23522541,23523148,23567848,23568081,23568156,23568215,23568257,23568290,23568351,23568460,23568628,23568703,23568861,23568915,23568982,23569062,23569117,23569185,23569234,23569261,23569350,23569489,23569599,23569635,23570626,23572412,23574344,23574349,23574986,23575644,23576087,23576852,23581466,23581546,23581677,23581807,23582172,23583579,23584618,23585298,23588015,23590749,23592796,23594652,23596891,23598843,23600351,23601956,23620873,23620912,23644742,23645984,23648696,23649378,23649422,23649490,23649563,23649639,23649738,23649852,23649975,23650089,23650136,23650169,23650281,23650391,23650498,23650528,23650639,23650711,23650795,23650900,23650969,23651586,23690066,23690155,23690196,23690231,23690272,23690318,23690350,23690419,23690472,23690533,23690610,23690656,23690717,23750752,23750834,23750924,23750966,2375100', 'assoc_port': '23519889:23522466,23519891:23522046,23519893:23522428,23519895:23522152,23519897:23522246,23519899:23521885,23519901:23522359,23519903:23521953,23519906:23521602,23519908:23521719,23519911:23521765,23519913:23521387,23519916:23521569,23519919:23521228,23519921:23521407,23519924:23521345,23519927:23521189,23519929:23521535,23519932:23520983,23519934:23521055,23519937:23521467,23519940:23520082,23522492:23522541,23522700:23523148,23567605:23569599,23567622:23569635,23567627:23569489,23567631:23569350,23567635:23569234,23567637:23568982,23567641:23569261,23567644:23569062,23567647:23569185,23567666:23568861,23567669:23568915,23567670:23569117,23567688:23568703,23567689:23568351,23567691:23568460,23567693:23568628,23567694:23568257,23567696:23568215,23567697:23568290,23567699:23568081,23567701:23567848,23567702:23568156,23570268:23570626,23572188:23572412,23574051:23574344,23574053:23574349,23574811:23574986,23575398:23575644,23575928:23576087,23576664:23576852,23581242:23581546,23581245:23581677,23581248:2358146', 'assoc_mat': '23519889:pet_clair:4230:23522466,23519891:pet_clair:4230:23522046,23519893:pet_clair:4230:23522428,23519895:pet_clair:4230:23522152,23519897:pet_clair:4230:23522246,23519899:pet_clair:4230:23521885,23519901:pet_clair:4230:23522359,23519903:pet_clair:4230:23521953,23519906:pet_clair:4230:23521602,23519908:pet_clair:4230:23521719,23519911:pet_clair:4230:23521765,23519913:pet_clair:4230:23521387,23519916:pet_clair:4230:23521569,23519919:pet_clair:4230:23521228,23519921:pet_clair:4230:23521407,23519924:pet_clair:4230:23521345,23519927:pet_clair:4230:23521189,23519929:pet_clair:4230:23521535,23519932:pet_clair:4230:23520983,23519934:pet_clair:4230:23521055,23519937:pet_clair:4230:23521467,23519940:pet_clair:4230:23520082,23522492:pet_clair:4230:23522541,23522700:pet_clair:4230:23523148,23567605:pet_clair:4230:23569599,23567622:pet_clair:4230:23569635,23567627:pet_clair:4230:23569489,23567631:pet_clair:4230:23569350,23567635:pet_clair:4230:23569234,23567637:pet_clair:4230:23568982,23567641:pet_clair:4230:23569261,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001424033822551599, 'nb_photo': 563, 'list_port_cont': '23520973,23521200,23521389,23521405,23521728,23521768,23522146,23522251,23522464,23567855,23568073,23568157,23568216,23568262,23568300,23568359,23568457,23568627,23568702,23568867,23568906,23569067,23569640,23570631,23572419,23574359,23575000,23575637,23576082,23576856,23581469,23581544,23581679,23581809,23582171,23583575,23584617,23592795,23601966,23644743,23645992,23649561,23649730,23650083,23650137,23650174,23650278,23650397,23650500,23650906,23650958,23690421,23690484,23750970,23751006,23751116,23751216,23751259,23752746,23752838,23753170,23753526,23753622,23753744,23753917,23754089,23754787,23755419,23755851,23794676,23795220,23795262,23795486,23795590,23795839,23795892,23796043,23798636,23806925,23807843,23811199,23813001,23814434,23815575,23820490,23821795,23823267,23825293,23825596,23825930,23826804,23829316,23878534,23878838,23879025,23879067,23879152,23879269,23879504,23879536,23879846,23879986,23921190,23921216,23921357,23921492,23921561,23921591,23921683,23921860,23921928,23921981,23922294,2392240', 'assoc_port': '23519889:23522464,23519895:23522146,23519897:23522251,23519908:23521728,23519911:23521768,23519913:23521389,23519921:23521405,23519927:23521200,23519932:23520973,23567622:23569640,23567644:23569067,23567666:23568867,23567669:23568906,23567688:23568702,23567689:23568359,23567691:23568457,23567693:23568627,23567694:23568262,23567696:23568216,23567697:23568300,23567699:23568073,23567701:23567855,23567702:23568157,23570268:23570631,23572188:23572419,23574053:23574359,23574811:23575000,23575398:23575637,23575928:23576082,23576664:23576856,23581242:23581544,23581245:23581679,23581248:23581469,23581337:23581809,23582093:23582171,23583098:23583575,23584455:23584617,23592363:23592795,23601603:23601966,23639561:23644743,23645590:23650906,23645593:23645992,23645595:23650958,23645602:23650500,23645606:23650278,23645607:23650397,23645609:23650083,23645610:23650137,23645612:23650174,23645614:23649730,23645617:23649561,23689957:23690484,23689965:23690421,23749576:23751006,23749577:23751116,23749578:23751216,23749579:2375125', 'assoc_mat': '23519889:pet_fonce:4230:23522464,23519895:pet_fonce:4230:23522146,23519897:pet_fonce:4230:23522251,23519908:pet_fonce:4230:23521728,23519911:pet_fonce:4230:23521768,23519913:pet_fonce:4230:23521389,23519921:pet_fonce:4230:23521405,23519927:pet_fonce:4230:23521200,23519932:pet_fonce:4230:23520973,23567622:pet_fonce:4230:23569640,23567644:pet_fonce:4230:23569067,23567666:pet_fonce:4230:23568867,23567669:pet_fonce:4230:23568906,23567688:pet_fonce:4230:23568702,23567689:pet_fonce:4230:23568359,23567691:pet_fonce:4230:23568457,23567693:pet_fonce:4230:23568627,23567694:pet_fonce:4230:23568262,23567696:pet_fonce:4230:23568216,23567697:pet_fonce:4230:23568300,23567699:pet_fonce:4230:23568073,23567701:pet_fonce:4230:23567855,23567702:pet_fonce:4230:23568157,23570268:pet_fonce:4230:23570631,23572188:pet_fonce:4230:23572419,23574053:pet_fonce:4230:23574359,23574811:pet_fonce:4230:23575000,23575398:pet_fonce:4230:23575637,23575928:pet_fonce:4230:23576082,23576664:pet_fonce:4230:23576856,23581242:pet_fonce:4230:23581544,2'}), 'main_stat': {'nb_photos': 1856}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-06', 0.7951091028734574),)]} 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': ((1856,),), 'unwanted_material_monthly_percentage': ((0.7951091028734574,),), 'material_repartition': (('incineration', 1856),), 'material_dict': {'incineration': 1856}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 6, 1), 0.7881576320984379, 62), (datetime.date(2025, 6, 2), 0.7923232670826293, 72), (datetime.date(2025, 6, 3), 0.80857038106225, 83), (datetime.date(2025, 6, 4), 0.8174676273583278, 83), (datetime.date(2025, 6, 5), 0.8353599669395859, 43), (datetime.date(2025, 6, 7), 0.7651926529982277, 35), (datetime.date(2025, 6, 8), 0.8095414984082948, 74), (datetime.date(2025, 6, 9), 0.8163204612751886, 70), (datetime.date(2025, 6, 10), 0.7953409419977591, 72), (datetime.date(2025, 6, 11), 0.7831587450688039, 71), (datetime.date(2025, 6, 12), 0.7881257466272076, 77), (datetime.date(2025, 6, 13), 0.7877844504403962, 75), (datetime.date(2025, 6, 14), 0.7815377031718619, 73), (datetime.date(2025, 6, 15), 0.7459674470814955, 70), (datetime.date(2025, 6, 16), 0.8575089052803161, 34), (datetime.date(2025, 6, 17), 0.7960619201600626, 62), (datetime.date(2025, 6, 18), 0.7722859833068697, 11), (datetime.date(2025, 6, 19), 0.7879717707307862, 23), (datetime.date(2025, 6, 20), 0.8099729956962799, 76), (datetime.date(2025, 6, 21), 0.8009777779308856, 73), (datetime.date(2025, 6, 22), 0.8053866851863785, 83), (datetime.date(2025, 6, 23), 0.7794953022143188, 61), (datetime.date(2025, 6, 24), 0.7641542691660315, 69), (datetime.date(2025, 6, 25), 0.7514136763517343, 77), (datetime.date(2025, 6, 26), 0.7643952301893432, 68), (datetime.date(2025, 6, 27), 0.7601944413102477, 32), (datetime.date(2025, 6, 28), 0.7863008011883853, 83), (datetime.date(2025, 6, 29), 0.8497939266491364, 73), (datetime.date(2025, 6, 30), 0.8251304142685869, 71)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 6, 1), 0.7881576320984379, 62), (datetime.date(2025, 6, 2), 0.7923232670826293, 72), (datetime.date(2025, 6, 3), 0.80857038106225, 83), (datetime.date(2025, 6, 4), 0.8174676273583278, 83), (datetime.date(2025, 6, 5), 0.8353599669395859, 43), (datetime.date(2025, 6, 7), 0.7651926529982277, 35), (datetime.date(2025, 6, 8), 0.8095414984082948, 74), (datetime.date(2025, 6, 9), 0.8163204612751886, 70), (datetime.date(2025, 6, 10), 0.7953409419977591, 72), (datetime.date(2025, 6, 11), 0.7831587450688039, 71), (datetime.date(2025, 6, 12), 0.7881257466272076, 77), (datetime.date(2025, 6, 13), 0.7877844504403962, 75), (datetime.date(2025, 6, 14), 0.7815377031718619, 73), (datetime.date(2025, 6, 15), 0.7459674470814955, 70), (datetime.date(2025, 6, 16), 0.8575089052803161, 34), (datetime.date(2025, 6, 17), 0.7960619201600626, 62), (datetime.date(2025, 6, 18), 0.7722859833068697, 11), (datetime.date(2025, 6, 19), 0.7879717707307862, 23), (datetime.date(2025, 6, 20), 0.8099729956962799, 76), (datetime.date(2025, 6, 21), 0.8009777779308856, 73), (datetime.date(2025, 6, 22), 0.8053866851863785, 83), (datetime.date(2025, 6, 23), 0.7794953022143188, 61), (datetime.date(2025, 6, 24), 0.7641542691660315, 69), (datetime.date(2025, 6, 25), 0.7514136763517343, 77), (datetime.date(2025, 6, 26), 0.7643952301893432, 68), (datetime.date(2025, 6, 27), 0.7601944413102477, 32), (datetime.date(2025, 6, 28), 0.7863008011883853, 83), (datetime.date(2025, 6, 29), 0.8497939266491364, 73), (datetime.date(2025, 6, 30), 0.8251304142685869, 71))}, 'quality_array': [['-8.292719956648336', '01062025'], ['-8.39824021608985', '02062025'], ['-8.449391093278406', '03062025'], ['-8.462724844317123', '04062025'], ['-8.343710038142035', '05062025'], ['-8.141180255410566', '07062025'], ['-8.274546902013165', '08062025'], ['-8.258935721739052', '09062025'], ['-8.3121511871001', '10062025'], ['-8.439922868364233', '11062025'], ['-8.44934913856864', '12062025'], ['-8.416109406124376', '13062025'], ['-8.246330493543008', '14062025'], ['-8.25596097930803', '15062025'], ['-7.95359604744069', '16062025'], ['-8.260850650579323', '17062025'], ['-8.556785291342177', '18062025'], ['-8.527577363607044', '19062025'], ['-8.523348547349151', '20062025'], ['-8.456429055988243', '21062025'], ['-8.542500175573126', '22062025'], ['-8.468951915221304', '23062025'], ['-8.460376876808569', '24062025'], ['-8.413715334793322', '25062025'], ['-8.374562152624145', '26062025'], ['-8.303180942591181', '27062025'], ['-8.074195570590783', '28062025'], ['-8.279728058680337', '29062025'], ['-8.133184702284709', '30062025']], 'number_of_batch': ((605,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012757247450136492, 'nb_photo': 16925, 'list_port_cont': '23520069,23520972,23521040,23521196,23521233,23521349,23521379,23521399,23521470,23521524,23521560,23521596,23521725,23521757,23521887,23521949,23522040,23522151,23522236,23522354,23522423,23522470,23522535,23523143,23567849,23568071,23568153,23568213,23568252,23568299,23568347,23568459,23568634,23568699,23568857,23568911,23568973,23569065,23569112,23569182,23569236,23569272,23569340,23569487,23569609,23569642,23570624,23572418,23574327,23574352,23574982,23575629,23576070,23576843,23581468,23581552,23581670,23581798,23582166,23583564,23584612,23585297,23588021,23590744,23592806,23594659,23596892,23598831,23600346,23601969,23620876,23620907,23644750,23645976,23648695,23649365,23649413,23649482,23649565,23649647,23649732,23649864,23649973,23650085,23650133,23650172,23650275,23650389,23650497,23650512,23650633,23650710,23650786,23650892,23650970,23651589,23690054,23690143,23690188,23690214,23690276,23690321,23690355,23690414,23690486,23690522,23690620,23690642,23690698,23750740,23750824,23750926,23750963,2375099', 'assoc_port': '23519889:23522470,23519891:23522040,23519893:23522423,23519895:23522151,23519897:23522236,23519899:23521887,23519901:23522354,23519903:23521949,23519906:23521596,23519908:23521725,23519911:23521757,23519913:23521379,23519916:23521560,23519919:23521233,23519921:23521399,23519924:23521349,23519927:23521196,23519929:23521524,23519932:23520972,23519934:23521040,23519937:23521470,23519940:23520069,23522492:23522535,23522700:23523143,23567605:23569609,23567622:23569642,23567627:23569487,23567631:23569340,23567635:23569236,23567637:23568973,23567641:23569272,23567644:23569065,23567647:23569182,23567666:23568857,23567669:23568911,23567670:23569112,23567688:23568699,23567689:23568347,23567691:23568459,23567693:23568634,23567694:23568252,23567696:23568213,23567697:23568299,23567699:23568071,23567701:23567849,23567702:23568153,23570268:23570624,23572188:23572418,23574051:23574327,23574053:23574352,23574811:23574982,23575398:23575629,23575928:23576070,23576664:23576843,23581242:23581552,23581245:23581670,23581248:2358146', 'assoc_mat': '23519889:autre:4230:23522470,23519891:autre:4230:23522040,23519893:autre:4230:23522423,23519895:autre:4230:23522151,23519897:autre:4230:23522236,23519899:autre:4230:23521887,23519901:autre:4230:23522354,23519903:autre:4230:23521949,23519906:autre:4230:23521596,23519908:autre:4230:23521725,23519911:autre:4230:23521757,23519913:autre:4230:23521379,23519916:autre:4230:23521560,23519919:autre:4230:23521233,23519921:autre:4230:23521399,23519924:autre:4230:23521349,23519927:autre:4230:23521196,23519929:autre:4230:23521524,23519932:autre:4230:23520972,23519934:autre:4230:23521040,23519937:autre:4230:23521470,23519940:autre:4230:23520069,23522492:autre:4230:23522535,23522700:autre:4230:23523143,23567605:autre:4230:23569609,23567622:autre:4230:23569642,23567627:autre:4230:23569487,23567631:autre:4230:23569340,23567635:autre:4230:23569236,23567637:autre:4230:23568973,23567641:autre:4230:23569272,23567644:autre:4230:23569065,23567647:autre:4230:23569182,23567666:autre:4230:23568857,23567669:autre:4230:23568911,23567670:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04773020525878231, 'nb_photo': 115629, 'list_port_cont': '23520079,23520979,23521054,23521192,23521232,23521355,23521386,23521400,23521479,23521529,23521568,23521607,23521727,23521766,23521888,23521958,23522041,23522142,23522234,23522358,23522430,23522468,23522544,23523156,23567858,23568079,23568158,23568208,23568263,23568302,23568348,23568451,23568625,23568706,23568864,23568916,23568976,23569064,23569119,23569199,23569230,23569273,23569349,23569486,23569597,23569633,23570629,23572414,23574335,23574350,23574996,23575640,23576080,23576855,23581470,23581551,23581687,23581808,23582178,23583569,23584619,23585295,23588013,23590748,23592805,23594663,23596896,23598833,23600348,23601964,23620864,23620918,23644746,23645983,23648686,23649377,23649411,23649480,23649555,23649650,23649729,23649861,23649980,23650088,23650138,23650181,23650273,23650393,23650499,23650534,23650623,23650713,23650798,23650898,23650964,23651584,23690071,23690160,23690191,23690230,23690267,23690313,23690356,23690406,23690482,23690529,23690618,23690653,23690703,23750753,23750836,23750917,23750961,2375099', 'assoc_port': '23519889:23522468,23519891:23522041,23519893:23522430,23519895:23522142,23519897:23522234,23519899:23521888,23519901:23522358,23519903:23521958,23519906:23521607,23519908:23521727,23519911:23521766,23519913:23521386,23519916:23521568,23519919:23521232,23519921:23521400,23519924:23521355,23519927:23521192,23519929:23521529,23519932:23520979,23519934:23521054,23519937:23521479,23519940:23520079,23522492:23522544,23522700:23523156,23567605:23569597,23567622:23569633,23567627:23569486,23567631:23569349,23567635:23569230,23567637:23568976,23567641:23569273,23567644:23569064,23567647:23569199,23567666:23568864,23567669:23568916,23567670:23569119,23567688:23568706,23567689:23568348,23567691:23568451,23567693:23568625,23567694:23568263,23567696:23568208,23567697:23568302,23567699:23568079,23567701:23567858,23567702:23568158,23570268:23570629,23572188:23572414,23574051:23574335,23574053:23574350,23574811:23574996,23575398:23575640,23575928:23576080,23576664:23576855,23581242:23581551,23581245:23581687,23581248:2358147', 'assoc_mat': '23519889:carton:4230:23522468,23519891:carton:4230:23522041,23519893:carton:4230:23522430,23519895:carton:4230:23522142,23519897:carton:4230:23522234,23519899:carton:4230:23521888,23519901:carton:4230:23522358,23519903:carton:4230:23521958,23519906:carton:4230:23521607,23519908:carton:4230:23521727,23519911:carton:4230:23521766,23519913:carton:4230:23521386,23519916:carton:4230:23521568,23519919:carton:4230:23521232,23519921:carton:4230:23521400,23519924:carton:4230:23521355,23519927:carton:4230:23521192,23519929:carton:4230:23521529,23519932:carton:4230:23520979,23519934:carton:4230:23521054,23519937:carton:4230:23521479,23519940:carton:4230:23520079,23522492:carton:4230:23522544,23522700:carton:4230:23523156,23567605:carton:4230:23569597,23567622:carton:4230:23569633,23567627:carton:4230:23569486,23567631:carton:4230:23569349,23567635:carton:4230:23569230,23567637:carton:4230:23568976,23567641:carton:4230:23569273,23567644:carton:4230:23569064,23567647:carton:4230:23569199,23567666:carton:4230:23568864,2356'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012874023051084246, 'nb_photo': 2191, 'list_port_cont': '23520066,23520982,23521046,23521187,23521236,23521351,23521380,23521395,23521468,23521574,23521733,23521760,23521954,23522034,23522149,23522224,23522348,23522429,23522461,23522533,23523141,23567843,23568077,23568146,23568251,23568301,23568448,23568701,23568853,23568904,23569054,23569106,23569193,23569225,23569269,23569348,23569479,23569592,23569643,23572413,23574328,23574357,23574988,23575642,23576857,23581472,23581681,23581792,23582180,23583567,23584613,23585285,23588011,23590735,23592799,23594649,23596885,23598840,23600352,23601953,23620905,23648684,23649371,23649410,23649483,23649560,23649640,23649739,23649979,23650076,23650122,23650180,23650276,23650400,23650630,23650701,23650783,23650973,23651572,23690070,23690156,23690182,23690261,23690320,23690344,23690407,23690479,23690518,23690616,23690647,23690678,23750742,23750838,23750919,23750952,23751013,23751067,23751107,23751173,23751202,23751253,23751402,23751477,23752179,23752439,23752553,23752738,23752836,23753165,23753517,23753632,23753746,23753915,2375421', 'assoc_port': '23519889:23522461,23519891:23522034,23519893:23522429,23519895:23522149,23519897:23522224,23519901:23522348,23519903:23521954,23519908:23521733,23519911:23521760,23519913:23521380,23519916:23521574,23519919:23521236,23519921:23521395,23519924:23521351,23519927:23521187,23519932:23520982,23519934:23521046,23519937:23521468,23519940:23520066,23522492:23522533,23522700:23523141,23567605:23569592,23567622:23569643,23567627:23569479,23567631:23569348,23567635:23569225,23567641:23569269,23567644:23569054,23567647:23569193,23567666:23568853,23567669:23568904,23567670:23569106,23567688:23568701,23567691:23568448,23567694:23568251,23567697:23568301,23567699:23568077,23567701:23567843,23567702:23568146,23572188:23572413,23574051:23574328,23574053:23574357,23574811:23574988,23575398:23575642,23576664:23576857,23581245:23581681,23581248:23581472,23581337:23581792,23582093:23582180,23583098:23583567,23584455:23584613,23585041:23585285,23587481:23588011,23590226:23590735,23592363:23592799,23594566:23594649,23596200:2359688', 'assoc_mat': '23519889:metal:4230:23522461,23519891:metal:4230:23522034,23519893:metal:4230:23522429,23519895:metal:4230:23522149,23519897:metal:4230:23522224,23519901:metal:4230:23522348,23519903:metal:4230:23521954,23519908:metal:4230:23521733,23519911:metal:4230:23521760,23519913:metal:4230:23521380,23519916:metal:4230:23521574,23519919:metal:4230:23521236,23519921:metal:4230:23521395,23519924:metal:4230:23521351,23519927:metal:4230:23521187,23519932:metal:4230:23520982,23519934:metal:4230:23521046,23519937:metal:4230:23521468,23519940:metal:4230:23520066,23522492:metal:4230:23522533,23522700:metal:4230:23523141,23567605:metal:4230:23569592,23567622:metal:4230:23569643,23567627:metal:4230:23569479,23567631:metal:4230:23569348,23567635:metal:4230:23569225,23567641:metal:4230:23569269,23567644:metal:4230:23569054,23567647:metal:4230:23569193,23567666:metal:4230:23568853,23567669:metal:4230:23568904,23567670:metal:4230:23569106,23567688:metal:4230:23568701,23567691:metal:4230:23568448,23567694:metal:4230:23568251,23567697:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.13705147901294307, 'nb_photo': 333033, 'list_port_cont': '23520080,23520970,23521052,23521197,23521235,23521346,23521388,23521411,23521474,23521537,23521573,23521601,23521724,23521762,23521884,23521959,23522032,23522156,23522242,23522357,23522432,23522467,23522549,23523158,23567856,23568076,23568151,23568218,23568258,23568296,23568361,23568453,23568633,23568694,23568863,23568908,23568979,23569059,23569107,23569198,23569224,23569268,23569339,23569491,23569607,23569647,23570628,23572415,23574343,23574355,23574992,23575645,23576086,23576853,23581478,23581547,23581684,23581796,23582173,23583571,23584620,23585293,23588003,23590740,23592804,23594664,23596902,23598829,23600345,23601963,23620866,23620913,23644752,23645991,23648682,23649380,23649420,23649489,23649564,23649652,23649735,23649866,23649969,23650073,23650130,23650177,23650280,23650398,23650501,23650532,23650632,23650707,23650793,23650904,23650972,23651581,23690068,23690153,23690193,23690227,23690269,23690323,23690360,23690418,23690485,23690527,23690617,23690652,23690718,23750754,23750833,23750922,23750965,2375100', 'assoc_port': '23519889:23522467,23519891:23522032,23519893:23522432,23519895:23522156,23519897:23522242,23519899:23521884,23519901:23522357,23519903:23521959,23519906:23521601,23519908:23521724,23519911:23521762,23519913:23521388,23519916:23521573,23519919:23521235,23519921:23521411,23519924:23521346,23519927:23521197,23519929:23521537,23519932:23520970,23519934:23521052,23519937:23521474,23519940:23520080,23522492:23522549,23522700:23523158,23567605:23569607,23567622:23569647,23567627:23569491,23567631:23569339,23567635:23569224,23567637:23568979,23567641:23569268,23567644:23569059,23567647:23569198,23567666:23568863,23567669:23568908,23567670:23569107,23567688:23568694,23567689:23568361,23567691:23568453,23567693:23568633,23567694:23568258,23567696:23568218,23567697:23568296,23567699:23568076,23567701:23567856,23567702:23568151,23570268:23570628,23572188:23572415,23574051:23574343,23574053:23574355,23574811:23574992,23575398:23575645,23575928:23576086,23576664:23576853,23581242:23581547,23581245:23581684,23581248:2358147', 'assoc_mat': '23519889:papier:4230:23522467,23519891:papier:4230:23522032,23519893:papier:4230:23522432,23519895:papier:4230:23522156,23519897:papier:4230:23522242,23519899:papier:4230:23521884,23519901:papier:4230:23522357,23519903:papier:4230:23521959,23519906:papier:4230:23521601,23519908:papier:4230:23521724,23519911:papier:4230:23521762,23519913:papier:4230:23521388,23519916:papier:4230:23521573,23519919:papier:4230:23521235,23519921:papier:4230:23521411,23519924:papier:4230:23521346,23519927:papier:4230:23521197,23519929:papier:4230:23521537,23519932:papier:4230:23520970,23519934:papier:4230:23521052,23519937:papier:4230:23521474,23519940:papier:4230:23520080,23522492:papier:4230:23522549,23522700:papier:4230:23523158,23567605:papier:4230:23569607,23567622:papier:4230:23569647,23567627:papier:4230:23569491,23567631:papier:4230:23569339,23567635:papier:4230:23569224,23567637:papier:4230:23568979,23567641:papier:4230:23569268,23567644:papier:4230:23569059,23567647:papier:4230:23569198,23567666:papier:4230:23568863,2356'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0020040128880148113, 'nb_photo': 1177, 'list_port_cont': '23521234,23521564,23521610,23521731,23521763,23521874,23521962,23522044,23522154,23522252,23522356,23522434,23522462,23523155,23567857,23568083,23568160,23568211,23568247,23568289,23568360,23568455,23568635,23568705,23568856,23568913,23569063,23569113,23569192,23569265,23569344,23569485,23569606,23569644,23570617,23572423,23574336,23574358,23574999,23575633,23576848,23581480,23581806,23582179,23583576,23584609,23588023,23590739,23592807,23600353,23644753,23649366,23649734,23649976,23650087,23650139,23650179,23650403,23650627,23650702,23650790,23650902,23650967,23690065,23690154,23690184,23690273,23690420,23750747,23750829,23750925,23750958,23751008,23751053,23751112,23751168,23751209,23751260,23751414,23751478,23752188,23752448,23752560,23752742,23752839,23753635,23753911,23754366,23754956,23755272,23755425,23756031,23794671,23794803,23795023,23795170,23795217,23795255,23795485,23795588,23795705,23795834,23795900,23795999,23796046,23798635,23803714,23804936,23806931,23807842,23810167,23811190,23812121,2381300', 'assoc_port': '23519889:23522462,23519891:23522044,23519893:23522434,23519895:23522154,23519897:23522252,23519899:23521874,23519901:23522356,23519903:23521962,23519906:23521610,23519908:23521731,23519911:23521763,23519916:23521564,23519919:23521234,23522700:23523155,23567605:23569606,23567622:23569644,23567627:23569485,23567631:23569344,23567641:23569265,23567644:23569063,23567647:23569192,23567666:23568856,23567669:23568913,23567670:23569113,23567688:23568705,23567689:23568360,23567691:23568455,23567693:23568635,23567694:23568247,23567696:23568211,23567697:23568289,23567699:23568083,23567701:23567857,23567702:23568160,23570268:23570617,23572188:23572423,23574051:23574336,23574053:23574358,23574811:23574999,23575398:23575633,23576664:23576848,23581248:23581480,23581337:23581806,23582093:23582179,23583098:23583576,23584455:23584609,23587481:23588023,23590226:23590739,23592363:23592807,23600132:23600353,23639561:23644753,23645590:23650902,23645595:23650967,23645598:23650702,23645601:23650790,23645607:23650403,23645608:2365062', 'assoc_mat': '23519889:pehd:4230:23522462,23519891:pehd:4230:23522044,23519893:pehd:4230:23522434,23519895:pehd:4230:23522154,23519897:pehd:4230:23522252,23519899:pehd:4230:23521874,23519901:pehd:4230:23522356,23519903:pehd:4230:23521962,23519906:pehd:4230:23521610,23519908:pehd:4230:23521731,23519911:pehd:4230:23521763,23519916:pehd:4230:23521564,23519919:pehd:4230:23521234,23522700:pehd:4230:23523155,23567605:pehd:4230:23569606,23567622:pehd:4230:23569644,23567627:pehd:4230:23569485,23567631:pehd:4230:23569344,23567641:pehd:4230:23569265,23567644:pehd:4230:23569063,23567647:pehd:4230:23569192,23567666:pehd:4230:23568856,23567669:pehd:4230:23568913,23567670:pehd:4230:23569113,23567688:pehd:4230:23568705,23567689:pehd:4230:23568360,23567691:pehd:4230:23568455,23567693:pehd:4230:23568635,23567694:pehd:4230:23568247,23567696:pehd:4230:23568211,23567697:pehd:4230:23568289,23567699:pehd:4230:23568083,23567701:pehd:4230:23567857,23567702:pehd:4230:23568160,23570268:pehd:4230:23570617,23572188:pehd:4230:23572423,23574051:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013610914146798315, 'nb_photo': 18455, 'list_port_cont': '23520082,23520983,23521055,23521189,23521228,23521345,23521387,23521407,23521467,23521535,23521569,23521602,23521719,23521765,23521885,23521953,23522046,23522152,23522246,23522359,23522428,23522466,23522541,23523148,23567848,23568081,23568156,23568215,23568257,23568290,23568351,23568460,23568628,23568703,23568861,23568915,23568982,23569062,23569117,23569185,23569234,23569261,23569350,23569489,23569599,23569635,23570626,23572412,23574344,23574349,23574986,23575644,23576087,23576852,23581466,23581546,23581677,23581807,23582172,23583579,23584618,23585298,23588015,23590749,23592796,23594652,23596891,23598843,23600351,23601956,23620873,23620912,23644742,23645984,23648696,23649378,23649422,23649490,23649563,23649639,23649738,23649852,23649975,23650089,23650136,23650169,23650281,23650391,23650498,23650528,23650639,23650711,23650795,23650900,23650969,23651586,23690066,23690155,23690196,23690231,23690272,23690318,23690350,23690419,23690472,23690533,23690610,23690656,23690717,23750752,23750834,23750924,23750966,2375100', 'assoc_port': '23519889:23522466,23519891:23522046,23519893:23522428,23519895:23522152,23519897:23522246,23519899:23521885,23519901:23522359,23519903:23521953,23519906:23521602,23519908:23521719,23519911:23521765,23519913:23521387,23519916:23521569,23519919:23521228,23519921:23521407,23519924:23521345,23519927:23521189,23519929:23521535,23519932:23520983,23519934:23521055,23519937:23521467,23519940:23520082,23522492:23522541,23522700:23523148,23567605:23569599,23567622:23569635,23567627:23569489,23567631:23569350,23567635:23569234,23567637:23568982,23567641:23569261,23567644:23569062,23567647:23569185,23567666:23568861,23567669:23568915,23567670:23569117,23567688:23568703,23567689:23568351,23567691:23568460,23567693:23568628,23567694:23568257,23567696:23568215,23567697:23568290,23567699:23568081,23567701:23567848,23567702:23568156,23570268:23570626,23572188:23572412,23574051:23574344,23574053:23574349,23574811:23574986,23575398:23575644,23575928:23576087,23576664:23576852,23581242:23581546,23581245:23581677,23581248:2358146', 'assoc_mat': '23519889:pet_clair:4230:23522466,23519891:pet_clair:4230:23522046,23519893:pet_clair:4230:23522428,23519895:pet_clair:4230:23522152,23519897:pet_clair:4230:23522246,23519899:pet_clair:4230:23521885,23519901:pet_clair:4230:23522359,23519903:pet_clair:4230:23521953,23519906:pet_clair:4230:23521602,23519908:pet_clair:4230:23521719,23519911:pet_clair:4230:23521765,23519913:pet_clair:4230:23521387,23519916:pet_clair:4230:23521569,23519919:pet_clair:4230:23521228,23519921:pet_clair:4230:23521407,23519924:pet_clair:4230:23521345,23519927:pet_clair:4230:23521189,23519929:pet_clair:4230:23521535,23519932:pet_clair:4230:23520983,23519934:pet_clair:4230:23521055,23519937:pet_clair:4230:23521467,23519940:pet_clair:4230:23520082,23522492:pet_clair:4230:23522541,23522700:pet_clair:4230:23523148,23567605:pet_clair:4230:23569599,23567622:pet_clair:4230:23569635,23567627:pet_clair:4230:23569489,23567631:pet_clair:4230:23569350,23567635:pet_clair:4230:23569234,23567637:pet_clair:4230:23568982,23567641:pet_clair:4230:23569261,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001424033822551599, 'nb_photo': 563, 'list_port_cont': '23520973,23521200,23521389,23521405,23521728,23521768,23522146,23522251,23522464,23567855,23568073,23568157,23568216,23568262,23568300,23568359,23568457,23568627,23568702,23568867,23568906,23569067,23569640,23570631,23572419,23574359,23575000,23575637,23576082,23576856,23581469,23581544,23581679,23581809,23582171,23583575,23584617,23592795,23601966,23644743,23645992,23649561,23649730,23650083,23650137,23650174,23650278,23650397,23650500,23650906,23650958,23690421,23690484,23750970,23751006,23751116,23751216,23751259,23752746,23752838,23753170,23753526,23753622,23753744,23753917,23754089,23754787,23755419,23755851,23794676,23795220,23795262,23795486,23795590,23795839,23795892,23796043,23798636,23806925,23807843,23811199,23813001,23814434,23815575,23820490,23821795,23823267,23825293,23825596,23825930,23826804,23829316,23878534,23878838,23879025,23879067,23879152,23879269,23879504,23879536,23879846,23879986,23921190,23921216,23921357,23921492,23921561,23921591,23921683,23921860,23921928,23921981,23922294,2392240', 'assoc_port': '23519889:23522464,23519895:23522146,23519897:23522251,23519908:23521728,23519911:23521768,23519913:23521389,23519921:23521405,23519927:23521200,23519932:23520973,23567622:23569640,23567644:23569067,23567666:23568867,23567669:23568906,23567688:23568702,23567689:23568359,23567691:23568457,23567693:23568627,23567694:23568262,23567696:23568216,23567697:23568300,23567699:23568073,23567701:23567855,23567702:23568157,23570268:23570631,23572188:23572419,23574053:23574359,23574811:23575000,23575398:23575637,23575928:23576082,23576664:23576856,23581242:23581544,23581245:23581679,23581248:23581469,23581337:23581809,23582093:23582171,23583098:23583575,23584455:23584617,23592363:23592795,23601603:23601966,23639561:23644743,23645590:23650906,23645593:23645992,23645595:23650958,23645602:23650500,23645606:23650278,23645607:23650397,23645609:23650083,23645610:23650137,23645612:23650174,23645614:23649730,23645617:23649561,23689957:23690484,23689965:23690421,23749576:23751006,23749577:23751116,23749578:23751216,23749579:2375125', 'assoc_mat': '23519889:pet_fonce:4230:23522464,23519895:pet_fonce:4230:23522146,23519897:pet_fonce:4230:23522251,23519908:pet_fonce:4230:23521728,23519911:pet_fonce:4230:23521768,23519913:pet_fonce:4230:23521389,23519921:pet_fonce:4230:23521405,23519927:pet_fonce:4230:23521200,23519932:pet_fonce:4230:23520973,23567622:pet_fonce:4230:23569640,23567644:pet_fonce:4230:23569067,23567666:pet_fonce:4230:23568867,23567669:pet_fonce:4230:23568906,23567688:pet_fonce:4230:23568702,23567689:pet_fonce:4230:23568359,23567691:pet_fonce:4230:23568457,23567693:pet_fonce:4230:23568627,23567694:pet_fonce:4230:23568262,23567696:pet_fonce:4230:23568216,23567697:pet_fonce:4230:23568300,23567699:pet_fonce:4230:23568073,23567701:pet_fonce:4230:23567855,23567702:pet_fonce:4230:23568157,23570268:pet_fonce:4230:23570631,23572188:pet_fonce:4230:23572419,23574053:pet_fonce:4230:23574359,23574811:pet_fonce:4230:23575000,23575398:pet_fonce:4230:23575637,23575928:pet_fonce:4230:23576082,23576664:pet_fonce:4230:23576856,23581242:pet_fonce:4230:23581544,2'}), 'main_stat': {'nb_photos': 1856}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-06', 0.7951091028734574),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_06_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.28%', 16925], 'carton': ['carton', '4.77%', 115629], 'metal': ['metal', '0.13%', 2191], 'papier': ['papier', '13.71%', 333033], 'pehd': ['pehd', '0.2%', 1177], 'pet_clair': ['pet_clair', '1.36%', 18455], 'pet_fonce': ['pet_fonce', '0.14%', 563]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_06_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.77user 1.87system 0:08.55elapsed 54%CPU (0avgtext+0avgdata 194752maxresident)k 16inputs+272outputs (1major+80490minor)pagefaults 0swaps