python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_2/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-04 _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 : (1, 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 : (1, 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 : 04 mtr_id : dashboard_places : SCCU_cam7 date : 2025-04 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-04%') and created_at like '%2025-04%'))); nb_day : (1, 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) = 04 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) = 04 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 '%042025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-04-01 : dt_date_just_month_year : 2025-04-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-04-01" AND ded.date <= "2025-04-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 (1716895,1719585,1721913,1724718,1728628,1732674,1737100,1739969,1740372,1743245,1747175,1751188,1755046,1757998,1760299,1764574,1769006) 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.01710798330010659, 'nb_photo': 9026, 'list_port_cont': '21939601,21941681,21942409,21943095,21944084,21944767,21945369,21948363,21950619,21952609,21954540,21956454,21958369,21959228,21959257,21959317,21959736,21959842,21959904,21960120,21961564,21962676,21963045,21988349,21990216,21990270,21990307,21990404,21990523,21990694,21990729,21990794,21990968,21990992,21991061,21991203,21991276,21991394,21991480,21991548,21991628,21991712,21991804,21991877,21991987,21993976,21996736,22001052,22003163,22004853,22005531,22006171,22007491,22010170,22012475,22015375,22017637,22020479,22022646,22023697,22026053,22052569,22052953,22053004,22053207,22053223,22053239,22053309,22053379,22053418,22053448,22053896,22084673,22104450,22104828,22108105,22108378,22108463,22108623,22108902,22160356,22160635,22160927,22161249,22161542,22161674,22161703,22161769,22161883,22162102,22162433,22162473,22162803,22163375,22164138,22166240,22225558,22228570,22228733,22228869,22228950,22229017,22229063,22229089,22229131,22229177,22229266,22229420,22229473,22229515,22229554,22229640,22229653,2222983', 'assoc_port': '21938966:21939601,21941366:21941681,21942267:21942409,21942958:21943095,21943749:21944084,21944563:21944767,21945209:21945369,21948069:21948363,21950039:21950619,21951757:21952609,21953974:21954540,21956170:21956454,21958148:21958369,21959026:21960120,21959031:21959904,21959035:21959736,21959040:21959842,21959045:21959228,21959050:21959257,21959052:21963045,21959053:21959317,21960936:21961564,21962468:21962676,21987804:21988349,21989948:21991712,21989952:21991628,21989956:21991877,21989960:21991804,21989965:21991987,21989968:21991203,21989972:21990992,21989973:21991276,21989974:21991480,21989975:21991548,21989976:21990968,21989977:21990694,21989978:21991394,21989979:21991061,21989980:21990270,21989981:21990523,21989982:21990729,21989983:21990216,21989984:21990307,21989985:21990794,21989986:21990404,21992833:21993976,21995874:21996736,22000333:22001052,22000334:22005531,22002452:22003163,22004599:22004853,22005792:22006171,22007309:22007491,22009333:22010170,22012084:22012475,22014793:22015375,22017236:2201763', 'assoc_mat': '21938966:autre:4230:21939601,21941366:autre:4230:21941681,21942267:autre:4230:21942409,21942958:autre:4230:21943095,21943749:autre:4230:21944084,21944563:autre:4230:21944767,21945209:autre:4230:21945369,21948069:autre:4230:21948363,21950039:autre:4230:21950619,21951757:autre:4230:21952609,21953974:autre:4230:21954540,21956170:autre:4230:21956454,21958148:autre:4230:21958369,21959026:autre:4230:21960120,21959031:autre:4230:21959904,21959035:autre:4230:21959736,21959040:autre:4230:21959842,21959045:autre:4230:21959228,21959050:autre:4230:21959257,21959052:autre:4230:21963045,21959053:autre:4230:21959317,21960936:autre:4230:21961564,21962468:autre:4230:21962676,21987804:autre:4230:21988349,21989948:autre:4230:21991712,21989952:autre:4230:21991628,21989956:autre:4230:21991877,21989960:autre:4230:21991804,21989965:autre:4230:21991987,21989968:autre:4230:21991203,21989972:autre:4230:21990992,21989973:autre:4230:21991276,21989974:autre:4230:21991480,21989975:autre:4230:21991548,21989976:autre:4230:21990968,21989977:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.08129984111111323, 'nb_photo': 58837, 'list_port_cont': '21939598,21941670,21942408,21943093,21944079,21944762,21945383,21948356,21950614,21952610,21954544,21956466,21958370,21959233,21959268,21959310,21959747,21959845,21959914,21960130,21961578,21962673,21963048,21988354,21990226,21990282,21990315,21990398,21990509,21990706,21990738,21990799,21990965,21991001,21991072,21991213,21991285,21991396,21991485,21991556,21991631,21991706,21991795,21991894,21991984,21993984,21996737,22001063,22003162,22004849,22005540,22006162,22007507,22010161,22012471,22015373,22017643,22020477,22022655,22023701,22026054,22052557,22052961,22053003,22053201,22053220,22053255,22053314,22053381,22053425,22053439,22053890,22084672,22104462,22104824,22108100,22108385,22108473,22108626,22108912,22160352,22160636,22160928,22161247,22161536,22161676,22161710,22161765,22161877,22162104,22162435,22162475,22162799,22163379,22164136,22166236,22225569,22228571,22228728,22228872,22228954,22229023,22229052,22229101,22229129,22229173,22229269,22229419,22229480,22229511,22229557,22229650,22229660,2222983', 'assoc_port': '21938966:21939598,21941366:21941670,21942267:21942408,21942958:21943093,21943749:21944079,21944563:21944762,21945209:21945383,21948069:21948356,21950039:21950614,21951757:21952610,21953974:21954544,21956170:21956466,21958148:21958370,21959026:21960130,21959031:21959914,21959035:21959747,21959040:21959845,21959045:21959233,21959050:21959268,21959052:21963048,21959053:21959310,21960936:21961578,21962468:21962673,21987804:21988354,21989948:21991706,21989952:21991631,21989956:21991894,21989960:21991795,21989965:21991984,21989968:21991213,21989972:21991001,21989973:21991285,21989974:21991485,21989975:21991556,21989976:21990965,21989977:21990706,21989978:21991396,21989979:21991072,21989980:21990282,21989981:21990509,21989982:21990738,21989983:21990226,21989984:21990315,21989985:21990799,21989986:21990398,21992833:21993984,21995874:21996737,22000333:22001063,22000334:22005540,22002452:22003162,22004599:22004849,22005792:22006162,22007309:22007507,22009333:22010161,22012084:22012471,22014793:22015373,22017236:2201764', 'assoc_mat': '21938966:carton:4230:21939598,21941366:carton:4230:21941670,21942267:carton:4230:21942408,21942958:carton:4230:21943093,21943749:carton:4230:21944079,21944563:carton:4230:21944762,21945209:carton:4230:21945383,21948069:carton:4230:21948356,21950039:carton:4230:21950614,21951757:carton:4230:21952610,21953974:carton:4230:21954544,21956170:carton:4230:21956466,21958148:carton:4230:21958370,21959026:carton:4230:21960130,21959031:carton:4230:21959914,21959035:carton:4230:21959747,21959040:carton:4230:21959845,21959045:carton:4230:21959233,21959050:carton:4230:21959268,21959052:carton:4230:21963048,21959053:carton:4230:21959310,21960936:carton:4230:21961578,21962468:carton:4230:21962673,21987804:carton:4230:21988354,21989948:carton:4230:21991706,21989952:carton:4230:21991631,21989956:carton:4230:21991894,21989960:carton:4230:21991795,21989965:carton:4230:21991984,21989968:carton:4230:21991213,21989972:carton:4230:21991001,21989973:carton:4230:21991285,21989974:carton:4230:21991485,21989975:carton:4230:21991556,2198'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001435475852499802, 'nb_photo': 990, 'list_port_cont': '21939595,21941669,21942394,21943080,21944085,21944763,21945382,21948357,21950622,21952608,21954537,21956465,21958364,21959231,21959259,21959322,21959748,21959834,21959902,21960123,21961577,21962661,21963052,21988342,21990218,21990277,21990317,21990406,21990518,21990705,21990734,21990802,21990959,21990999,21991068,21991259,21991389,21991476,21991549,21991620,21991701,21991796,21991886,21991986,21993983,21996728,22001059,22003147,22005530,22006157,22012468,22015363,22017636,22020486,22022653,22023696,22026045,22052952,22053001,22053214,22053232,22053251,22053321,22053377,22053426,22053455,22053899,22084677,22104460,22104826,22108101,22108375,22108474,22108617,22108911,22160336,22160633,22160924,22161246,22161540,22161677,22161775,22161884,22162101,22162421,22162458,22163384,22164131,22166244,22225564,22228575,22228884,22228942,22229056,22229097,22229134,22229176,22229260,22229406,22229490,22229509,22229553,22229652,22229656,22229827,22244553,22245610,22246245,22247485,22248762,22250466,22250774,22253470,2225375', 'assoc_port': '21938966:21939595,21941366:21941669,21942267:21942394,21942958:21943080,21943749:21944085,21944563:21944763,21945209:21945382,21948069:21948357,21950039:21950622,21951757:21952608,21953974:21954537,21956170:21956465,21958148:21958364,21959026:21960123,21959031:21959902,21959035:21959748,21959040:21959834,21959045:21959231,21959050:21959259,21959052:21963052,21959053:21959322,21960936:21961577,21962468:21962661,21987804:21988342,21989948:21991701,21989952:21991620,21989956:21991886,21989960:21991796,21989965:21991986,21989972:21990999,21989973:21991259,21989974:21991476,21989975:21991549,21989976:21990959,21989977:21990705,21989978:21991389,21989979:21991068,21989980:21990277,21989981:21990518,21989982:21990734,21989983:21990218,21989984:21990317,21989985:21990802,21989986:21990406,21992833:21993983,21995874:21996728,22000333:22001059,22000334:22005530,22002452:22003147,22005792:22006157,22012084:22012468,22014793:22015363,22017236:22017636,22019600:22020486,22022111:22022653,22023288:22023696,22024544:2202604', 'assoc_mat': '21938966:metal:4230:21939595,21941366:metal:4230:21941669,21942267:metal:4230:21942394,21942958:metal:4230:21943080,21943749:metal:4230:21944085,21944563:metal:4230:21944763,21945209:metal:4230:21945382,21948069:metal:4230:21948357,21950039:metal:4230:21950622,21951757:metal:4230:21952608,21953974:metal:4230:21954537,21956170:metal:4230:21956465,21958148:metal:4230:21958364,21959026:metal:4230:21960123,21959031:metal:4230:21959902,21959035:metal:4230:21959748,21959040:metal:4230:21959834,21959045:metal:4230:21959231,21959050:metal:4230:21959259,21959052:metal:4230:21963052,21959053:metal:4230:21959322,21960936:metal:4230:21961577,21962468:metal:4230:21962661,21987804:metal:4230:21988342,21989948:metal:4230:21991701,21989952:metal:4230:21991620,21989956:metal:4230:21991886,21989960:metal:4230:21991796,21989965:metal:4230:21991986,21989972:metal:4230:21990999,21989973:metal:4230:21991259,21989974:metal:4230:21991476,21989975:metal:4230:21991549,21989976:metal:4230:21990959,21989977:metal:4230:21990705,21989978:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2443286200194282, 'nb_photo': 187666, 'list_port_cont': '21939593,21941680,21942403,21943094,21944089,21944770,21945381,21948359,21950627,21952606,21954534,21956458,21958367,21959226,21959266,21959321,21959745,21959844,21959917,21960131,21961568,21962677,21963057,21988355,21990222,21990280,21990309,21990400,21990522,21990696,21990742,21990803,21990966,21991006,21991064,21991209,21991284,21991391,21991475,21991555,21991629,21991709,21991807,21991890,21991991,21993982,21996734,22001060,22003160,22004847,22005535,22006161,22007504,22010166,22012477,22015379,22017633,22020491,22022656,22023705,22026043,22052567,22052960,22053011,22053213,22053224,22053263,22053322,22053384,22053422,22053461,22053894,22084675,22104467,22104829,22108103,22108384,22108479,22108613,22108908,22160351,22160637,22160925,22161252,22161546,22161682,22161714,22161771,22161887,22162100,22162437,22162474,22162798,22163370,22164137,22166246,22225562,22228574,22228721,22228896,22228957,22229029,22229064,22229103,22229136,22229164,22229274,22229407,22229486,22229519,22229551,22229638,22229667,2222982', 'assoc_port': '21938966:21939593,21941366:21941680,21942267:21942403,21942958:21943094,21943749:21944089,21944563:21944770,21945209:21945381,21948069:21948359,21950039:21950627,21951757:21952606,21953974:21954534,21956170:21956458,21958148:21958367,21959026:21960131,21959031:21959917,21959035:21959745,21959040:21959844,21959045:21959226,21959050:21959266,21959052:21963057,21959053:21959321,21960936:21961568,21962468:21962677,21987804:21988355,21989948:21991709,21989952:21991629,21989956:21991890,21989960:21991807,21989965:21991991,21989968:21991209,21989972:21991006,21989973:21991284,21989974:21991475,21989975:21991555,21989976:21990966,21989977:21990696,21989978:21991391,21989979:21991064,21989980:21990280,21989981:21990522,21989982:21990742,21989983:21990222,21989984:21990309,21989985:21990803,21989986:21990400,21992833:21993982,21995874:21996734,22000333:22001060,22000334:22005535,22002452:22003160,22004599:22004847,22005792:22006161,22007309:22007504,22009333:22010166,22012084:22012477,22014793:22015379,22017236:2201763', 'assoc_mat': '21938966:papier:4230:21939593,21941366:papier:4230:21941680,21942267:papier:4230:21942403,21942958:papier:4230:21943094,21943749:papier:4230:21944089,21944563:papier:4230:21944770,21945209:papier:4230:21945381,21948069:papier:4230:21948359,21950039:papier:4230:21950627,21951757:papier:4230:21952606,21953974:papier:4230:21954534,21956170:papier:4230:21956458,21958148:papier:4230:21958367,21959026:papier:4230:21960131,21959031:papier:4230:21959917,21959035:papier:4230:21959745,21959040:papier:4230:21959844,21959045:papier:4230:21959226,21959050:papier:4230:21959266,21959052:papier:4230:21963057,21959053:papier:4230:21959321,21960936:papier:4230:21961568,21962468:papier:4230:21962677,21987804:papier:4230:21988355,21989948:papier:4230:21991709,21989952:papier:4230:21991629,21989956:papier:4230:21991890,21989960:papier:4230:21991807,21989965:papier:4230:21991991,21989968:papier:4230:21991209,21989972:papier:4230:21991006,21989973:papier:4230:21991284,21989974:papier:4230:21991475,21989975:papier:4230:21991555,2198'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007074442176229884, 'nb_photo': 1832, 'list_port_cont': '21939596,21941679,21942411,21943083,21944081,21944771,21945380,21948360,21950616,21952603,21954538,21956459,21958374,21959220,21959269,21959313,21959753,21960126,21961570,21962665,21988345,21990223,21990281,21990321,21990392,21990516,21990703,21990739,21990804,21990957,21991004,21991060,21991204,21991286,21991390,21991473,21991546,21991621,21991704,21991800,21991885,21991983,21993985,21996733,22001054,22003159,22004846,22005539,22006168,22007497,22010168,22012480,22015369,22017635,22020484,22022647,22023706,22026048,22053211,22053227,22053259,22053319,22053389,22053415,22053453,22053892,22084671,22104461,22104823,22108094,22108389,22108475,22108620,22108901,22160355,22160638,22160917,22161251,22161538,22161675,22161716,22161779,22161890,22162097,22162434,22162467,22162804,22163373,22164143,22166241,22225570,22228569,22228732,22228893,22228958,22229021,22229067,22229104,22229139,22229174,22229272,22229421,22229484,22229513,22229561,22229649,22229669,22229818,22244525,22244560,22245614,22245784,22246242,2224750', 'assoc_port': '21938966:21939596,21941366:21941679,21942267:21942411,21942958:21943083,21943749:21944081,21944563:21944771,21945209:21945380,21948069:21948360,21950039:21950616,21951757:21952603,21953974:21954538,21956170:21956459,21958148:21958374,21959026:21960126,21959035:21959753,21959045:21959220,21959050:21959269,21959053:21959313,21960936:21961570,21962468:21962665,21987804:21988345,21989948:21991704,21989952:21991621,21989956:21991885,21989960:21991800,21989965:21991983,21989968:21991204,21989972:21991004,21989973:21991286,21989974:21991473,21989975:21991546,21989976:21990957,21989977:21990703,21989978:21991390,21989979:21991060,21989980:21990281,21989981:21990516,21989982:21990739,21989983:21990223,21989984:21990321,21989985:21990804,21989986:21990392,21992833:21993985,21995874:21996733,22000333:22001054,22000334:22005539,22002452:22003159,22004599:22004846,22005792:22006168,22007309:22007497,22009333:22010168,22012084:22012480,22014793:22015369,22017236:22017635,22019600:22020484,22022111:22022647,22023288:2202370', 'assoc_mat': '21938966:pehd:4230:21939596,21941366:pehd:4230:21941679,21942267:pehd:4230:21942411,21942958:pehd:4230:21943083,21943749:pehd:4230:21944081,21944563:pehd:4230:21944771,21945209:pehd:4230:21945380,21948069:pehd:4230:21948360,21950039:pehd:4230:21950616,21951757:pehd:4230:21952603,21953974:pehd:4230:21954538,21956170:pehd:4230:21956459,21958148:pehd:4230:21958374,21959026:pehd:4230:21960126,21959035:pehd:4230:21959753,21959045:pehd:4230:21959220,21959050:pehd:4230:21959269,21959053:pehd:4230:21959313,21960936:pehd:4230:21961570,21962468:pehd:4230:21962665,21987804:pehd:4230:21988345,21989948:pehd:4230:21991704,21989952:pehd:4230:21991621,21989956:pehd:4230:21991885,21989960:pehd:4230:21991800,21989965:pehd:4230:21991983,21989968:pehd:4230:21991204,21989972:pehd:4230:21991004,21989973:pehd:4230:21991286,21989974:pehd:4230:21991473,21989975:pehd:4230:21991546,21989976:pehd:4230:21990957,21989977:pehd:4230:21990703,21989978:pehd:4230:21991390,21989979:pehd:4230:21991060,21989980:pehd:4230:21990281,21989981:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.018687761646608056, 'nb_photo': 12881, 'list_port_cont': '21939599,21941682,21942407,21943092,21944083,21944773,21945379,21948364,21950623,21952605,21954545,21956462,21958365,21959232,21959267,21959318,21959750,21959833,21959918,21960115,21961574,21962675,21963055,21988357,21990227,21990283,21990319,21990396,21990524,21990702,21990740,21990798,21990958,21990996,21991073,21991205,21991280,21991397,21991478,21991554,21991626,21991703,21991797,21991891,21991993,21993986,21996731,22001062,22003161,22004848,22005533,22006167,22007506,22010167,22012476,22015374,22017644,22020487,22022659,22023707,22026051,22052566,22052959,22053010,22053203,22053230,22053261,22053316,22053374,22053416,22053452,22053888,22084642,22104454,22104827,22108102,22108382,22108478,22108625,22108906,22160342,22160641,22160926,22161244,22161544,22161683,22161708,22161777,22161889,22162098,22162431,22162471,22162802,22163374,22164142,22166242,22225559,22228573,22228731,22228901,22228953,22229031,22229060,22229096,22229140,22229175,22229264,22229418,22229485,22229496,22229563,22229643,22229668,2222982', 'assoc_port': '21938966:21939599,21941366:21941682,21942267:21942407,21942958:21943092,21943749:21944083,21944563:21944773,21945209:21945379,21948069:21948364,21950039:21950623,21951757:21952605,21953974:21954545,21956170:21956462,21958148:21958365,21959026:21960115,21959031:21959918,21959035:21959750,21959040:21959833,21959045:21959232,21959050:21959267,21959052:21963055,21959053:21959318,21960936:21961574,21962468:21962675,21987804:21988357,21989948:21991703,21989952:21991626,21989956:21991891,21989960:21991797,21989965:21991993,21989968:21991205,21989972:21990996,21989973:21991280,21989974:21991478,21989975:21991554,21989976:21990958,21989977:21990702,21989978:21991397,21989979:21991073,21989980:21990283,21989981:21990524,21989982:21990740,21989983:21990227,21989984:21990319,21989985:21990798,21989986:21990396,21992833:21993986,21995874:21996731,22000333:22001062,22000334:22005533,22002452:22003161,22004599:22004848,22005792:22006167,22007309:22007506,22009333:22010167,22012084:22012476,22014793:22015374,22017236:2201764', 'assoc_mat': '21938966:pet_clair:4230:21939599,21941366:pet_clair:4230:21941682,21942267:pet_clair:4230:21942407,21942958:pet_clair:4230:21943092,21943749:pet_clair:4230:21944083,21944563:pet_clair:4230:21944773,21945209:pet_clair:4230:21945379,21948069:pet_clair:4230:21948364,21950039:pet_clair:4230:21950623,21951757:pet_clair:4230:21952605,21953974:pet_clair:4230:21954545,21956170:pet_clair:4230:21956462,21958148:pet_clair:4230:21958365,21959026:pet_clair:4230:21960115,21959031:pet_clair:4230:21959918,21959035:pet_clair:4230:21959750,21959040:pet_clair:4230:21959833,21959045:pet_clair:4230:21959232,21959050:pet_clair:4230:21959267,21959052:pet_clair:4230:21963055,21959053:pet_clair:4230:21959318,21960936:pet_clair:4230:21961574,21962468:pet_clair:4230:21962675,21987804:pet_clair:4230:21988357,21989948:pet_clair:4230:21991703,21989952:pet_clair:4230:21991626,21989956:pet_clair:4230:21991891,21989960:pet_clair:4230:21991797,21989965:pet_clair:4230:21991993,21989968:pet_clair:4230:21991205,21989972:pet_clair:4230:21990996,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003330816102153536, 'nb_photo': 543, 'list_port_cont': '21939590,21941671,21942404,21944088,21944766,21945370,21948362,21952599,21954541,21956460,21959227,21959260,21959319,21959754,21959836,21959910,21960124,21962671,21988347,21990285,21990314,21990387,21990796,21990961,21991069,21991215,21991281,21991398,21991557,21991623,21993988,21996729,22001061,22005534,22006166,22012474,22015380,22017630,22020489,22022658,22023703,22026046,22053212,22053267,22053317,22053383,22053424,22053450,22053897,22084659,22104459,22104820,22108096,22108387,22108622,22108909,22160357,22160631,22161254,22161549,22161681,22161717,22161891,22162103,22162436,22162470,22162793,22163383,22164140,22225572,22228564,22228902,22229020,22229093,22229128,22229172,22229276,22229482,22229503,22229560,22229645,22229665,22229826,22244523,22244569,22245616,22245782,22246231,22247495,22248756,22250474,22253493,22253762,22254977,22255317,22264788,22265038,22265186,22265259,22265280,22265838,22266230,22272155,22272461,22279385,22280048,22280425,22281521,22320595,22320804,22320843,22320902,22320972,2232100', 'assoc_port': '21938966:21939590,21941366:21941671,21942267:21942404,21943749:21944088,21944563:21944766,21945209:21945370,21948069:21948362,21951757:21952599,21953974:21954541,21956170:21956460,21959026:21960124,21959031:21959910,21959035:21959754,21959040:21959836,21959045:21959227,21959050:21959260,21959053:21959319,21962468:21962671,21987804:21988347,21989952:21991623,21989968:21991215,21989973:21991281,21989975:21991557,21989976:21990961,21989978:21991398,21989979:21991069,21989980:21990285,21989984:21990314,21989985:21990796,21989986:21990387,21992833:21993988,21995874:21996729,22000333:22001061,22000334:22005534,22005792:22006166,22012084:22012474,22014793:22015380,22017236:22017630,22019600:22020489,22022111:22022658,22023288:22023703,22024544:22026046,22051180:22053450,22051183:22053897,22051186:22053212,22051189:22053267,22051192:22053424,22051195:22053317,22051198:22053383,22083860:22084659,22104053:22108096,22104055:22108387,22104059:22108622,22104061:22108909,22104063:22104820,22104065:22104459,22155656:2216035', 'assoc_mat': '21938966:pet_fonce:4230:21939590,21941366:pet_fonce:4230:21941671,21942267:pet_fonce:4230:21942404,21943749:pet_fonce:4230:21944088,21944563:pet_fonce:4230:21944766,21945209:pet_fonce:4230:21945370,21948069:pet_fonce:4230:21948362,21951757:pet_fonce:4230:21952599,21953974:pet_fonce:4230:21954541,21956170:pet_fonce:4230:21956460,21959026:pet_fonce:4230:21960124,21959031:pet_fonce:4230:21959910,21959035:pet_fonce:4230:21959754,21959040:pet_fonce:4230:21959836,21959045:pet_fonce:4230:21959227,21959050:pet_fonce:4230:21959260,21959053:pet_fonce:4230:21959319,21962468:pet_fonce:4230:21962671,21987804:pet_fonce:4230:21988347,21989952:pet_fonce:4230:21991623,21989968:pet_fonce:4230:21991215,21989973:pet_fonce:4230:21991281,21989975:pet_fonce:4230:21991557,21989976:pet_fonce:4230:21990961,21989978:pet_fonce:4230:21991398,21989979:pet_fonce:4230:21991069,21989980:pet_fonce:4230:21990285,21989984:pet_fonce:4230:21990314,21989985:pet_fonce:4230:21990796,21989986:pet_fonce:4230:21990387,21992833:pet_fonce:4230:21993988,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(1716895,1719585,1721913,1724718,1728628,1732674,1737100,1739969,1740372,1743245,1747175,1751188,1755046,1757998,1760299,1764574,1769006)); 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-04-01' and date <= '2025-04-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((805,),), 'unwanted_material_monthly_percentage': ((0.6710570826584132,),), 'material_repartition': (('incineration', 805),), 'material_dict': {'incineration': 805}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 4, 1), 0.6935783491794749, 65), (datetime.date(2025, 4, 2), 0.6695286637340163, 71), (datetime.date(2025, 4, 3), 0.6368699922778897, 39), (datetime.date(2025, 4, 15), 0.5960811296220269, 22), (datetime.date(2025, 4, 16), 0.5646443540829197, 22), (datetime.date(2025, 4, 17), 0.4733879569611351, 39), (datetime.date(2025, 4, 18), 0.4907815670896094, 45), (datetime.date(2025, 4, 19), 0.6122177050863425, 37), (datetime.date(2025, 4, 20), 0.7462809544151038, 45), (datetime.date(2025, 4, 21), 0.7847942632473991, 59), (datetime.date(2025, 4, 22), 0.7521401272030738, 59), (datetime.date(2025, 4, 23), 0.7243727500396162, 63), (datetime.date(2025, 4, 24), 0.7044213722102305, 61), (datetime.date(2025, 4, 25), 0.6637618480344828, 44), (datetime.date(2025, 4, 28), 0.7505083562551756, 32), (datetime.date(2025, 4, 29), 0.6978132230477234, 47), (datetime.date(2025, 4, 30), 0.6249106571929627, 55)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 4, 1), 0.6935783491794749, 65), (datetime.date(2025, 4, 2), 0.6695286637340163, 71), (datetime.date(2025, 4, 3), 0.6368699922778897, 39), (datetime.date(2025, 4, 15), 0.5960811296220269, 22), (datetime.date(2025, 4, 16), 0.5646443540829197, 22), (datetime.date(2025, 4, 17), 0.4733879569611351, 39), (datetime.date(2025, 4, 18), 0.4907815670896094, 45), (datetime.date(2025, 4, 19), 0.6122177050863425, 37), (datetime.date(2025, 4, 20), 0.7462809544151038, 45), (datetime.date(2025, 4, 21), 0.7847942632473991, 59), (datetime.date(2025, 4, 22), 0.7521401272030738, 59), (datetime.date(2025, 4, 23), 0.7243727500396162, 63), (datetime.date(2025, 4, 24), 0.7044213722102305, 61), (datetime.date(2025, 4, 25), 0.6637618480344828, 44), (datetime.date(2025, 4, 28), 0.7505083562551756, 32), (datetime.date(2025, 4, 29), 0.6978132230477234, 47), (datetime.date(2025, 4, 30), 0.6249106571929627, 55))}, 'quality_array': [['-8.880778818412889', '01042025'], ['-8.807361893677484', '02042025'], ['-8.814937540887842', '03042025'], ['-9.08118861015823', '15042025'], ['-9.050852158402256', '16042025'], ['-9.18970239431016', '17042025'], ['-9.309278360920988', '18042025'], ['-9.23684502857409', '19042025'], ['-9.294858454145828', '20042025'], ['-8.75266213946362', '21042025'], ['-7.671937806531269', '22042025'], ['-7.571581512939442', '23042025'], ['-7.700699554977796', '24042025'], ['-7.956789091257496', '25042025'], ['-7.52053880865751', '28042025'], ['-7.562322179597124', '29042025'], ['-7.767226598325833', '30042025']], 'number_of_batch': ((319,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01710798330010659, 'nb_photo': 9026, 'list_port_cont': '21939601,21941681,21942409,21943095,21944084,21944767,21945369,21948363,21950619,21952609,21954540,21956454,21958369,21959228,21959257,21959317,21959736,21959842,21959904,21960120,21961564,21962676,21963045,21988349,21990216,21990270,21990307,21990404,21990523,21990694,21990729,21990794,21990968,21990992,21991061,21991203,21991276,21991394,21991480,21991548,21991628,21991712,21991804,21991877,21991987,21993976,21996736,22001052,22003163,22004853,22005531,22006171,22007491,22010170,22012475,22015375,22017637,22020479,22022646,22023697,22026053,22052569,22052953,22053004,22053207,22053223,22053239,22053309,22053379,22053418,22053448,22053896,22084673,22104450,22104828,22108105,22108378,22108463,22108623,22108902,22160356,22160635,22160927,22161249,22161542,22161674,22161703,22161769,22161883,22162102,22162433,22162473,22162803,22163375,22164138,22166240,22225558,22228570,22228733,22228869,22228950,22229017,22229063,22229089,22229131,22229177,22229266,22229420,22229473,22229515,22229554,22229640,22229653,2222983', 'assoc_port': '21938966:21939601,21941366:21941681,21942267:21942409,21942958:21943095,21943749:21944084,21944563:21944767,21945209:21945369,21948069:21948363,21950039:21950619,21951757:21952609,21953974:21954540,21956170:21956454,21958148:21958369,21959026:21960120,21959031:21959904,21959035:21959736,21959040:21959842,21959045:21959228,21959050:21959257,21959052:21963045,21959053:21959317,21960936:21961564,21962468:21962676,21987804:21988349,21989948:21991712,21989952:21991628,21989956:21991877,21989960:21991804,21989965:21991987,21989968:21991203,21989972:21990992,21989973:21991276,21989974:21991480,21989975:21991548,21989976:21990968,21989977:21990694,21989978:21991394,21989979:21991061,21989980:21990270,21989981:21990523,21989982:21990729,21989983:21990216,21989984:21990307,21989985:21990794,21989986:21990404,21992833:21993976,21995874:21996736,22000333:22001052,22000334:22005531,22002452:22003163,22004599:22004853,22005792:22006171,22007309:22007491,22009333:22010170,22012084:22012475,22014793:22015375,22017236:2201763', 'assoc_mat': '21938966:autre:4230:21939601,21941366:autre:4230:21941681,21942267:autre:4230:21942409,21942958:autre:4230:21943095,21943749:autre:4230:21944084,21944563:autre:4230:21944767,21945209:autre:4230:21945369,21948069:autre:4230:21948363,21950039:autre:4230:21950619,21951757:autre:4230:21952609,21953974:autre:4230:21954540,21956170:autre:4230:21956454,21958148:autre:4230:21958369,21959026:autre:4230:21960120,21959031:autre:4230:21959904,21959035:autre:4230:21959736,21959040:autre:4230:21959842,21959045:autre:4230:21959228,21959050:autre:4230:21959257,21959052:autre:4230:21963045,21959053:autre:4230:21959317,21960936:autre:4230:21961564,21962468:autre:4230:21962676,21987804:autre:4230:21988349,21989948:autre:4230:21991712,21989952:autre:4230:21991628,21989956:autre:4230:21991877,21989960:autre:4230:21991804,21989965:autre:4230:21991987,21989968:autre:4230:21991203,21989972:autre:4230:21990992,21989973:autre:4230:21991276,21989974:autre:4230:21991480,21989975:autre:4230:21991548,21989976:autre:4230:21990968,21989977:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.08129984111111323, 'nb_photo': 58837, 'list_port_cont': '21939598,21941670,21942408,21943093,21944079,21944762,21945383,21948356,21950614,21952610,21954544,21956466,21958370,21959233,21959268,21959310,21959747,21959845,21959914,21960130,21961578,21962673,21963048,21988354,21990226,21990282,21990315,21990398,21990509,21990706,21990738,21990799,21990965,21991001,21991072,21991213,21991285,21991396,21991485,21991556,21991631,21991706,21991795,21991894,21991984,21993984,21996737,22001063,22003162,22004849,22005540,22006162,22007507,22010161,22012471,22015373,22017643,22020477,22022655,22023701,22026054,22052557,22052961,22053003,22053201,22053220,22053255,22053314,22053381,22053425,22053439,22053890,22084672,22104462,22104824,22108100,22108385,22108473,22108626,22108912,22160352,22160636,22160928,22161247,22161536,22161676,22161710,22161765,22161877,22162104,22162435,22162475,22162799,22163379,22164136,22166236,22225569,22228571,22228728,22228872,22228954,22229023,22229052,22229101,22229129,22229173,22229269,22229419,22229480,22229511,22229557,22229650,22229660,2222983', 'assoc_port': '21938966:21939598,21941366:21941670,21942267:21942408,21942958:21943093,21943749:21944079,21944563:21944762,21945209:21945383,21948069:21948356,21950039:21950614,21951757:21952610,21953974:21954544,21956170:21956466,21958148:21958370,21959026:21960130,21959031:21959914,21959035:21959747,21959040:21959845,21959045:21959233,21959050:21959268,21959052:21963048,21959053:21959310,21960936:21961578,21962468:21962673,21987804:21988354,21989948:21991706,21989952:21991631,21989956:21991894,21989960:21991795,21989965:21991984,21989968:21991213,21989972:21991001,21989973:21991285,21989974:21991485,21989975:21991556,21989976:21990965,21989977:21990706,21989978:21991396,21989979:21991072,21989980:21990282,21989981:21990509,21989982:21990738,21989983:21990226,21989984:21990315,21989985:21990799,21989986:21990398,21992833:21993984,21995874:21996737,22000333:22001063,22000334:22005540,22002452:22003162,22004599:22004849,22005792:22006162,22007309:22007507,22009333:22010161,22012084:22012471,22014793:22015373,22017236:2201764', 'assoc_mat': '21938966:carton:4230:21939598,21941366:carton:4230:21941670,21942267:carton:4230:21942408,21942958:carton:4230:21943093,21943749:carton:4230:21944079,21944563:carton:4230:21944762,21945209:carton:4230:21945383,21948069:carton:4230:21948356,21950039:carton:4230:21950614,21951757:carton:4230:21952610,21953974:carton:4230:21954544,21956170:carton:4230:21956466,21958148:carton:4230:21958370,21959026:carton:4230:21960130,21959031:carton:4230:21959914,21959035:carton:4230:21959747,21959040:carton:4230:21959845,21959045:carton:4230:21959233,21959050:carton:4230:21959268,21959052:carton:4230:21963048,21959053:carton:4230:21959310,21960936:carton:4230:21961578,21962468:carton:4230:21962673,21987804:carton:4230:21988354,21989948:carton:4230:21991706,21989952:carton:4230:21991631,21989956:carton:4230:21991894,21989960:carton:4230:21991795,21989965:carton:4230:21991984,21989968:carton:4230:21991213,21989972:carton:4230:21991001,21989973:carton:4230:21991285,21989974:carton:4230:21991485,21989975:carton:4230:21991556,2198'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001435475852499802, 'nb_photo': 990, 'list_port_cont': '21939595,21941669,21942394,21943080,21944085,21944763,21945382,21948357,21950622,21952608,21954537,21956465,21958364,21959231,21959259,21959322,21959748,21959834,21959902,21960123,21961577,21962661,21963052,21988342,21990218,21990277,21990317,21990406,21990518,21990705,21990734,21990802,21990959,21990999,21991068,21991259,21991389,21991476,21991549,21991620,21991701,21991796,21991886,21991986,21993983,21996728,22001059,22003147,22005530,22006157,22012468,22015363,22017636,22020486,22022653,22023696,22026045,22052952,22053001,22053214,22053232,22053251,22053321,22053377,22053426,22053455,22053899,22084677,22104460,22104826,22108101,22108375,22108474,22108617,22108911,22160336,22160633,22160924,22161246,22161540,22161677,22161775,22161884,22162101,22162421,22162458,22163384,22164131,22166244,22225564,22228575,22228884,22228942,22229056,22229097,22229134,22229176,22229260,22229406,22229490,22229509,22229553,22229652,22229656,22229827,22244553,22245610,22246245,22247485,22248762,22250466,22250774,22253470,2225375', 'assoc_port': '21938966:21939595,21941366:21941669,21942267:21942394,21942958:21943080,21943749:21944085,21944563:21944763,21945209:21945382,21948069:21948357,21950039:21950622,21951757:21952608,21953974:21954537,21956170:21956465,21958148:21958364,21959026:21960123,21959031:21959902,21959035:21959748,21959040:21959834,21959045:21959231,21959050:21959259,21959052:21963052,21959053:21959322,21960936:21961577,21962468:21962661,21987804:21988342,21989948:21991701,21989952:21991620,21989956:21991886,21989960:21991796,21989965:21991986,21989972:21990999,21989973:21991259,21989974:21991476,21989975:21991549,21989976:21990959,21989977:21990705,21989978:21991389,21989979:21991068,21989980:21990277,21989981:21990518,21989982:21990734,21989983:21990218,21989984:21990317,21989985:21990802,21989986:21990406,21992833:21993983,21995874:21996728,22000333:22001059,22000334:22005530,22002452:22003147,22005792:22006157,22012084:22012468,22014793:22015363,22017236:22017636,22019600:22020486,22022111:22022653,22023288:22023696,22024544:2202604', 'assoc_mat': '21938966:metal:4230:21939595,21941366:metal:4230:21941669,21942267:metal:4230:21942394,21942958:metal:4230:21943080,21943749:metal:4230:21944085,21944563:metal:4230:21944763,21945209:metal:4230:21945382,21948069:metal:4230:21948357,21950039:metal:4230:21950622,21951757:metal:4230:21952608,21953974:metal:4230:21954537,21956170:metal:4230:21956465,21958148:metal:4230:21958364,21959026:metal:4230:21960123,21959031:metal:4230:21959902,21959035:metal:4230:21959748,21959040:metal:4230:21959834,21959045:metal:4230:21959231,21959050:metal:4230:21959259,21959052:metal:4230:21963052,21959053:metal:4230:21959322,21960936:metal:4230:21961577,21962468:metal:4230:21962661,21987804:metal:4230:21988342,21989948:metal:4230:21991701,21989952:metal:4230:21991620,21989956:metal:4230:21991886,21989960:metal:4230:21991796,21989965:metal:4230:21991986,21989972:metal:4230:21990999,21989973:metal:4230:21991259,21989974:metal:4230:21991476,21989975:metal:4230:21991549,21989976:metal:4230:21990959,21989977:metal:4230:21990705,21989978:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2443286200194282, 'nb_photo': 187666, 'list_port_cont': '21939593,21941680,21942403,21943094,21944089,21944770,21945381,21948359,21950627,21952606,21954534,21956458,21958367,21959226,21959266,21959321,21959745,21959844,21959917,21960131,21961568,21962677,21963057,21988355,21990222,21990280,21990309,21990400,21990522,21990696,21990742,21990803,21990966,21991006,21991064,21991209,21991284,21991391,21991475,21991555,21991629,21991709,21991807,21991890,21991991,21993982,21996734,22001060,22003160,22004847,22005535,22006161,22007504,22010166,22012477,22015379,22017633,22020491,22022656,22023705,22026043,22052567,22052960,22053011,22053213,22053224,22053263,22053322,22053384,22053422,22053461,22053894,22084675,22104467,22104829,22108103,22108384,22108479,22108613,22108908,22160351,22160637,22160925,22161252,22161546,22161682,22161714,22161771,22161887,22162100,22162437,22162474,22162798,22163370,22164137,22166246,22225562,22228574,22228721,22228896,22228957,22229029,22229064,22229103,22229136,22229164,22229274,22229407,22229486,22229519,22229551,22229638,22229667,2222982', 'assoc_port': '21938966:21939593,21941366:21941680,21942267:21942403,21942958:21943094,21943749:21944089,21944563:21944770,21945209:21945381,21948069:21948359,21950039:21950627,21951757:21952606,21953974:21954534,21956170:21956458,21958148:21958367,21959026:21960131,21959031:21959917,21959035:21959745,21959040:21959844,21959045:21959226,21959050:21959266,21959052:21963057,21959053:21959321,21960936:21961568,21962468:21962677,21987804:21988355,21989948:21991709,21989952:21991629,21989956:21991890,21989960:21991807,21989965:21991991,21989968:21991209,21989972:21991006,21989973:21991284,21989974:21991475,21989975:21991555,21989976:21990966,21989977:21990696,21989978:21991391,21989979:21991064,21989980:21990280,21989981:21990522,21989982:21990742,21989983:21990222,21989984:21990309,21989985:21990803,21989986:21990400,21992833:21993982,21995874:21996734,22000333:22001060,22000334:22005535,22002452:22003160,22004599:22004847,22005792:22006161,22007309:22007504,22009333:22010166,22012084:22012477,22014793:22015379,22017236:2201763', 'assoc_mat': '21938966:papier:4230:21939593,21941366:papier:4230:21941680,21942267:papier:4230:21942403,21942958:papier:4230:21943094,21943749:papier:4230:21944089,21944563:papier:4230:21944770,21945209:papier:4230:21945381,21948069:papier:4230:21948359,21950039:papier:4230:21950627,21951757:papier:4230:21952606,21953974:papier:4230:21954534,21956170:papier:4230:21956458,21958148:papier:4230:21958367,21959026:papier:4230:21960131,21959031:papier:4230:21959917,21959035:papier:4230:21959745,21959040:papier:4230:21959844,21959045:papier:4230:21959226,21959050:papier:4230:21959266,21959052:papier:4230:21963057,21959053:papier:4230:21959321,21960936:papier:4230:21961568,21962468:papier:4230:21962677,21987804:papier:4230:21988355,21989948:papier:4230:21991709,21989952:papier:4230:21991629,21989956:papier:4230:21991890,21989960:papier:4230:21991807,21989965:papier:4230:21991991,21989968:papier:4230:21991209,21989972:papier:4230:21991006,21989973:papier:4230:21991284,21989974:papier:4230:21991475,21989975:papier:4230:21991555,2198'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007074442176229884, 'nb_photo': 1832, 'list_port_cont': '21939596,21941679,21942411,21943083,21944081,21944771,21945380,21948360,21950616,21952603,21954538,21956459,21958374,21959220,21959269,21959313,21959753,21960126,21961570,21962665,21988345,21990223,21990281,21990321,21990392,21990516,21990703,21990739,21990804,21990957,21991004,21991060,21991204,21991286,21991390,21991473,21991546,21991621,21991704,21991800,21991885,21991983,21993985,21996733,22001054,22003159,22004846,22005539,22006168,22007497,22010168,22012480,22015369,22017635,22020484,22022647,22023706,22026048,22053211,22053227,22053259,22053319,22053389,22053415,22053453,22053892,22084671,22104461,22104823,22108094,22108389,22108475,22108620,22108901,22160355,22160638,22160917,22161251,22161538,22161675,22161716,22161779,22161890,22162097,22162434,22162467,22162804,22163373,22164143,22166241,22225570,22228569,22228732,22228893,22228958,22229021,22229067,22229104,22229139,22229174,22229272,22229421,22229484,22229513,22229561,22229649,22229669,22229818,22244525,22244560,22245614,22245784,22246242,2224750', 'assoc_port': '21938966:21939596,21941366:21941679,21942267:21942411,21942958:21943083,21943749:21944081,21944563:21944771,21945209:21945380,21948069:21948360,21950039:21950616,21951757:21952603,21953974:21954538,21956170:21956459,21958148:21958374,21959026:21960126,21959035:21959753,21959045:21959220,21959050:21959269,21959053:21959313,21960936:21961570,21962468:21962665,21987804:21988345,21989948:21991704,21989952:21991621,21989956:21991885,21989960:21991800,21989965:21991983,21989968:21991204,21989972:21991004,21989973:21991286,21989974:21991473,21989975:21991546,21989976:21990957,21989977:21990703,21989978:21991390,21989979:21991060,21989980:21990281,21989981:21990516,21989982:21990739,21989983:21990223,21989984:21990321,21989985:21990804,21989986:21990392,21992833:21993985,21995874:21996733,22000333:22001054,22000334:22005539,22002452:22003159,22004599:22004846,22005792:22006168,22007309:22007497,22009333:22010168,22012084:22012480,22014793:22015369,22017236:22017635,22019600:22020484,22022111:22022647,22023288:2202370', 'assoc_mat': '21938966:pehd:4230:21939596,21941366:pehd:4230:21941679,21942267:pehd:4230:21942411,21942958:pehd:4230:21943083,21943749:pehd:4230:21944081,21944563:pehd:4230:21944771,21945209:pehd:4230:21945380,21948069:pehd:4230:21948360,21950039:pehd:4230:21950616,21951757:pehd:4230:21952603,21953974:pehd:4230:21954538,21956170:pehd:4230:21956459,21958148:pehd:4230:21958374,21959026:pehd:4230:21960126,21959035:pehd:4230:21959753,21959045:pehd:4230:21959220,21959050:pehd:4230:21959269,21959053:pehd:4230:21959313,21960936:pehd:4230:21961570,21962468:pehd:4230:21962665,21987804:pehd:4230:21988345,21989948:pehd:4230:21991704,21989952:pehd:4230:21991621,21989956:pehd:4230:21991885,21989960:pehd:4230:21991800,21989965:pehd:4230:21991983,21989968:pehd:4230:21991204,21989972:pehd:4230:21991004,21989973:pehd:4230:21991286,21989974:pehd:4230:21991473,21989975:pehd:4230:21991546,21989976:pehd:4230:21990957,21989977:pehd:4230:21990703,21989978:pehd:4230:21991390,21989979:pehd:4230:21991060,21989980:pehd:4230:21990281,21989981:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.018687761646608056, 'nb_photo': 12881, 'list_port_cont': '21939599,21941682,21942407,21943092,21944083,21944773,21945379,21948364,21950623,21952605,21954545,21956462,21958365,21959232,21959267,21959318,21959750,21959833,21959918,21960115,21961574,21962675,21963055,21988357,21990227,21990283,21990319,21990396,21990524,21990702,21990740,21990798,21990958,21990996,21991073,21991205,21991280,21991397,21991478,21991554,21991626,21991703,21991797,21991891,21991993,21993986,21996731,22001062,22003161,22004848,22005533,22006167,22007506,22010167,22012476,22015374,22017644,22020487,22022659,22023707,22026051,22052566,22052959,22053010,22053203,22053230,22053261,22053316,22053374,22053416,22053452,22053888,22084642,22104454,22104827,22108102,22108382,22108478,22108625,22108906,22160342,22160641,22160926,22161244,22161544,22161683,22161708,22161777,22161889,22162098,22162431,22162471,22162802,22163374,22164142,22166242,22225559,22228573,22228731,22228901,22228953,22229031,22229060,22229096,22229140,22229175,22229264,22229418,22229485,22229496,22229563,22229643,22229668,2222982', 'assoc_port': '21938966:21939599,21941366:21941682,21942267:21942407,21942958:21943092,21943749:21944083,21944563:21944773,21945209:21945379,21948069:21948364,21950039:21950623,21951757:21952605,21953974:21954545,21956170:21956462,21958148:21958365,21959026:21960115,21959031:21959918,21959035:21959750,21959040:21959833,21959045:21959232,21959050:21959267,21959052:21963055,21959053:21959318,21960936:21961574,21962468:21962675,21987804:21988357,21989948:21991703,21989952:21991626,21989956:21991891,21989960:21991797,21989965:21991993,21989968:21991205,21989972:21990996,21989973:21991280,21989974:21991478,21989975:21991554,21989976:21990958,21989977:21990702,21989978:21991397,21989979:21991073,21989980:21990283,21989981:21990524,21989982:21990740,21989983:21990227,21989984:21990319,21989985:21990798,21989986:21990396,21992833:21993986,21995874:21996731,22000333:22001062,22000334:22005533,22002452:22003161,22004599:22004848,22005792:22006167,22007309:22007506,22009333:22010167,22012084:22012476,22014793:22015374,22017236:2201764', 'assoc_mat': '21938966:pet_clair:4230:21939599,21941366:pet_clair:4230:21941682,21942267:pet_clair:4230:21942407,21942958:pet_clair:4230:21943092,21943749:pet_clair:4230:21944083,21944563:pet_clair:4230:21944773,21945209:pet_clair:4230:21945379,21948069:pet_clair:4230:21948364,21950039:pet_clair:4230:21950623,21951757:pet_clair:4230:21952605,21953974:pet_clair:4230:21954545,21956170:pet_clair:4230:21956462,21958148:pet_clair:4230:21958365,21959026:pet_clair:4230:21960115,21959031:pet_clair:4230:21959918,21959035:pet_clair:4230:21959750,21959040:pet_clair:4230:21959833,21959045:pet_clair:4230:21959232,21959050:pet_clair:4230:21959267,21959052:pet_clair:4230:21963055,21959053:pet_clair:4230:21959318,21960936:pet_clair:4230:21961574,21962468:pet_clair:4230:21962675,21987804:pet_clair:4230:21988357,21989948:pet_clair:4230:21991703,21989952:pet_clair:4230:21991626,21989956:pet_clair:4230:21991891,21989960:pet_clair:4230:21991797,21989965:pet_clair:4230:21991993,21989968:pet_clair:4230:21991205,21989972:pet_clair:4230:21990996,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003330816102153536, 'nb_photo': 543, 'list_port_cont': '21939590,21941671,21942404,21944088,21944766,21945370,21948362,21952599,21954541,21956460,21959227,21959260,21959319,21959754,21959836,21959910,21960124,21962671,21988347,21990285,21990314,21990387,21990796,21990961,21991069,21991215,21991281,21991398,21991557,21991623,21993988,21996729,22001061,22005534,22006166,22012474,22015380,22017630,22020489,22022658,22023703,22026046,22053212,22053267,22053317,22053383,22053424,22053450,22053897,22084659,22104459,22104820,22108096,22108387,22108622,22108909,22160357,22160631,22161254,22161549,22161681,22161717,22161891,22162103,22162436,22162470,22162793,22163383,22164140,22225572,22228564,22228902,22229020,22229093,22229128,22229172,22229276,22229482,22229503,22229560,22229645,22229665,22229826,22244523,22244569,22245616,22245782,22246231,22247495,22248756,22250474,22253493,22253762,22254977,22255317,22264788,22265038,22265186,22265259,22265280,22265838,22266230,22272155,22272461,22279385,22280048,22280425,22281521,22320595,22320804,22320843,22320902,22320972,2232100', 'assoc_port': '21938966:21939590,21941366:21941671,21942267:21942404,21943749:21944088,21944563:21944766,21945209:21945370,21948069:21948362,21951757:21952599,21953974:21954541,21956170:21956460,21959026:21960124,21959031:21959910,21959035:21959754,21959040:21959836,21959045:21959227,21959050:21959260,21959053:21959319,21962468:21962671,21987804:21988347,21989952:21991623,21989968:21991215,21989973:21991281,21989975:21991557,21989976:21990961,21989978:21991398,21989979:21991069,21989980:21990285,21989984:21990314,21989985:21990796,21989986:21990387,21992833:21993988,21995874:21996729,22000333:22001061,22000334:22005534,22005792:22006166,22012084:22012474,22014793:22015380,22017236:22017630,22019600:22020489,22022111:22022658,22023288:22023703,22024544:22026046,22051180:22053450,22051183:22053897,22051186:22053212,22051189:22053267,22051192:22053424,22051195:22053317,22051198:22053383,22083860:22084659,22104053:22108096,22104055:22108387,22104059:22108622,22104061:22108909,22104063:22104820,22104065:22104459,22155656:2216035', 'assoc_mat': '21938966:pet_fonce:4230:21939590,21941366:pet_fonce:4230:21941671,21942267:pet_fonce:4230:21942404,21943749:pet_fonce:4230:21944088,21944563:pet_fonce:4230:21944766,21945209:pet_fonce:4230:21945370,21948069:pet_fonce:4230:21948362,21951757:pet_fonce:4230:21952599,21953974:pet_fonce:4230:21954541,21956170:pet_fonce:4230:21956460,21959026:pet_fonce:4230:21960124,21959031:pet_fonce:4230:21959910,21959035:pet_fonce:4230:21959754,21959040:pet_fonce:4230:21959836,21959045:pet_fonce:4230:21959227,21959050:pet_fonce:4230:21959260,21959053:pet_fonce:4230:21959319,21962468:pet_fonce:4230:21962671,21987804:pet_fonce:4230:21988347,21989952:pet_fonce:4230:21991623,21989968:pet_fonce:4230:21991215,21989973:pet_fonce:4230:21991281,21989975:pet_fonce:4230:21991557,21989976:pet_fonce:4230:21990961,21989978:pet_fonce:4230:21991398,21989979:pet_fonce:4230:21991069,21989980:pet_fonce:4230:21990285,21989984:pet_fonce:4230:21990314,21989985:pet_fonce:4230:21990796,21989986:pet_fonce:4230:21990387,21992833:pet_fonce:4230:21993988,2'}), 'main_stat': {'nb_photos': 805}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-04', 0.6710570826584132),)]} 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': ((805,),), 'unwanted_material_monthly_percentage': ((0.6710570826584132,),), 'material_repartition': (('incineration', 805),), 'material_dict': {'incineration': 805}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 4, 1), 0.6935783491794749, 65), (datetime.date(2025, 4, 2), 0.6695286637340163, 71), (datetime.date(2025, 4, 3), 0.6368699922778897, 39), (datetime.date(2025, 4, 15), 0.5960811296220269, 22), (datetime.date(2025, 4, 16), 0.5646443540829197, 22), (datetime.date(2025, 4, 17), 0.4733879569611351, 39), (datetime.date(2025, 4, 18), 0.4907815670896094, 45), (datetime.date(2025, 4, 19), 0.6122177050863425, 37), (datetime.date(2025, 4, 20), 0.7462809544151038, 45), (datetime.date(2025, 4, 21), 0.7847942632473991, 59), (datetime.date(2025, 4, 22), 0.7521401272030738, 59), (datetime.date(2025, 4, 23), 0.7243727500396162, 63), (datetime.date(2025, 4, 24), 0.7044213722102305, 61), (datetime.date(2025, 4, 25), 0.6637618480344828, 44), (datetime.date(2025, 4, 28), 0.7505083562551756, 32), (datetime.date(2025, 4, 29), 0.6978132230477234, 47), (datetime.date(2025, 4, 30), 0.6249106571929627, 55)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 4, 1), 0.6935783491794749, 65), (datetime.date(2025, 4, 2), 0.6695286637340163, 71), (datetime.date(2025, 4, 3), 0.6368699922778897, 39), (datetime.date(2025, 4, 15), 0.5960811296220269, 22), (datetime.date(2025, 4, 16), 0.5646443540829197, 22), (datetime.date(2025, 4, 17), 0.4733879569611351, 39), (datetime.date(2025, 4, 18), 0.4907815670896094, 45), (datetime.date(2025, 4, 19), 0.6122177050863425, 37), (datetime.date(2025, 4, 20), 0.7462809544151038, 45), (datetime.date(2025, 4, 21), 0.7847942632473991, 59), (datetime.date(2025, 4, 22), 0.7521401272030738, 59), (datetime.date(2025, 4, 23), 0.7243727500396162, 63), (datetime.date(2025, 4, 24), 0.7044213722102305, 61), (datetime.date(2025, 4, 25), 0.6637618480344828, 44), (datetime.date(2025, 4, 28), 0.7505083562551756, 32), (datetime.date(2025, 4, 29), 0.6978132230477234, 47), (datetime.date(2025, 4, 30), 0.6249106571929627, 55))}, 'quality_array': [['-8.880778818412889', '01042025'], ['-8.807361893677484', '02042025'], ['-8.814937540887842', '03042025'], ['-9.08118861015823', '15042025'], ['-9.050852158402256', '16042025'], ['-9.18970239431016', '17042025'], ['-9.309278360920988', '18042025'], ['-9.23684502857409', '19042025'], ['-9.294858454145828', '20042025'], ['-8.75266213946362', '21042025'], ['-7.671937806531269', '22042025'], ['-7.571581512939442', '23042025'], ['-7.700699554977796', '24042025'], ['-7.956789091257496', '25042025'], ['-7.52053880865751', '28042025'], ['-7.562322179597124', '29042025'], ['-7.767226598325833', '30042025']], 'number_of_batch': ((319,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01710798330010659, 'nb_photo': 9026, 'list_port_cont': '21939601,21941681,21942409,21943095,21944084,21944767,21945369,21948363,21950619,21952609,21954540,21956454,21958369,21959228,21959257,21959317,21959736,21959842,21959904,21960120,21961564,21962676,21963045,21988349,21990216,21990270,21990307,21990404,21990523,21990694,21990729,21990794,21990968,21990992,21991061,21991203,21991276,21991394,21991480,21991548,21991628,21991712,21991804,21991877,21991987,21993976,21996736,22001052,22003163,22004853,22005531,22006171,22007491,22010170,22012475,22015375,22017637,22020479,22022646,22023697,22026053,22052569,22052953,22053004,22053207,22053223,22053239,22053309,22053379,22053418,22053448,22053896,22084673,22104450,22104828,22108105,22108378,22108463,22108623,22108902,22160356,22160635,22160927,22161249,22161542,22161674,22161703,22161769,22161883,22162102,22162433,22162473,22162803,22163375,22164138,22166240,22225558,22228570,22228733,22228869,22228950,22229017,22229063,22229089,22229131,22229177,22229266,22229420,22229473,22229515,22229554,22229640,22229653,2222983', 'assoc_port': '21938966:21939601,21941366:21941681,21942267:21942409,21942958:21943095,21943749:21944084,21944563:21944767,21945209:21945369,21948069:21948363,21950039:21950619,21951757:21952609,21953974:21954540,21956170:21956454,21958148:21958369,21959026:21960120,21959031:21959904,21959035:21959736,21959040:21959842,21959045:21959228,21959050:21959257,21959052:21963045,21959053:21959317,21960936:21961564,21962468:21962676,21987804:21988349,21989948:21991712,21989952:21991628,21989956:21991877,21989960:21991804,21989965:21991987,21989968:21991203,21989972:21990992,21989973:21991276,21989974:21991480,21989975:21991548,21989976:21990968,21989977:21990694,21989978:21991394,21989979:21991061,21989980:21990270,21989981:21990523,21989982:21990729,21989983:21990216,21989984:21990307,21989985:21990794,21989986:21990404,21992833:21993976,21995874:21996736,22000333:22001052,22000334:22005531,22002452:22003163,22004599:22004853,22005792:22006171,22007309:22007491,22009333:22010170,22012084:22012475,22014793:22015375,22017236:2201763', 'assoc_mat': '21938966:autre:4230:21939601,21941366:autre:4230:21941681,21942267:autre:4230:21942409,21942958:autre:4230:21943095,21943749:autre:4230:21944084,21944563:autre:4230:21944767,21945209:autre:4230:21945369,21948069:autre:4230:21948363,21950039:autre:4230:21950619,21951757:autre:4230:21952609,21953974:autre:4230:21954540,21956170:autre:4230:21956454,21958148:autre:4230:21958369,21959026:autre:4230:21960120,21959031:autre:4230:21959904,21959035:autre:4230:21959736,21959040:autre:4230:21959842,21959045:autre:4230:21959228,21959050:autre:4230:21959257,21959052:autre:4230:21963045,21959053:autre:4230:21959317,21960936:autre:4230:21961564,21962468:autre:4230:21962676,21987804:autre:4230:21988349,21989948:autre:4230:21991712,21989952:autre:4230:21991628,21989956:autre:4230:21991877,21989960:autre:4230:21991804,21989965:autre:4230:21991987,21989968:autre:4230:21991203,21989972:autre:4230:21990992,21989973:autre:4230:21991276,21989974:autre:4230:21991480,21989975:autre:4230:21991548,21989976:autre:4230:21990968,21989977:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.08129984111111323, 'nb_photo': 58837, 'list_port_cont': '21939598,21941670,21942408,21943093,21944079,21944762,21945383,21948356,21950614,21952610,21954544,21956466,21958370,21959233,21959268,21959310,21959747,21959845,21959914,21960130,21961578,21962673,21963048,21988354,21990226,21990282,21990315,21990398,21990509,21990706,21990738,21990799,21990965,21991001,21991072,21991213,21991285,21991396,21991485,21991556,21991631,21991706,21991795,21991894,21991984,21993984,21996737,22001063,22003162,22004849,22005540,22006162,22007507,22010161,22012471,22015373,22017643,22020477,22022655,22023701,22026054,22052557,22052961,22053003,22053201,22053220,22053255,22053314,22053381,22053425,22053439,22053890,22084672,22104462,22104824,22108100,22108385,22108473,22108626,22108912,22160352,22160636,22160928,22161247,22161536,22161676,22161710,22161765,22161877,22162104,22162435,22162475,22162799,22163379,22164136,22166236,22225569,22228571,22228728,22228872,22228954,22229023,22229052,22229101,22229129,22229173,22229269,22229419,22229480,22229511,22229557,22229650,22229660,2222983', 'assoc_port': '21938966:21939598,21941366:21941670,21942267:21942408,21942958:21943093,21943749:21944079,21944563:21944762,21945209:21945383,21948069:21948356,21950039:21950614,21951757:21952610,21953974:21954544,21956170:21956466,21958148:21958370,21959026:21960130,21959031:21959914,21959035:21959747,21959040:21959845,21959045:21959233,21959050:21959268,21959052:21963048,21959053:21959310,21960936:21961578,21962468:21962673,21987804:21988354,21989948:21991706,21989952:21991631,21989956:21991894,21989960:21991795,21989965:21991984,21989968:21991213,21989972:21991001,21989973:21991285,21989974:21991485,21989975:21991556,21989976:21990965,21989977:21990706,21989978:21991396,21989979:21991072,21989980:21990282,21989981:21990509,21989982:21990738,21989983:21990226,21989984:21990315,21989985:21990799,21989986:21990398,21992833:21993984,21995874:21996737,22000333:22001063,22000334:22005540,22002452:22003162,22004599:22004849,22005792:22006162,22007309:22007507,22009333:22010161,22012084:22012471,22014793:22015373,22017236:2201764', 'assoc_mat': '21938966:carton:4230:21939598,21941366:carton:4230:21941670,21942267:carton:4230:21942408,21942958:carton:4230:21943093,21943749:carton:4230:21944079,21944563:carton:4230:21944762,21945209:carton:4230:21945383,21948069:carton:4230:21948356,21950039:carton:4230:21950614,21951757:carton:4230:21952610,21953974:carton:4230:21954544,21956170:carton:4230:21956466,21958148:carton:4230:21958370,21959026:carton:4230:21960130,21959031:carton:4230:21959914,21959035:carton:4230:21959747,21959040:carton:4230:21959845,21959045:carton:4230:21959233,21959050:carton:4230:21959268,21959052:carton:4230:21963048,21959053:carton:4230:21959310,21960936:carton:4230:21961578,21962468:carton:4230:21962673,21987804:carton:4230:21988354,21989948:carton:4230:21991706,21989952:carton:4230:21991631,21989956:carton:4230:21991894,21989960:carton:4230:21991795,21989965:carton:4230:21991984,21989968:carton:4230:21991213,21989972:carton:4230:21991001,21989973:carton:4230:21991285,21989974:carton:4230:21991485,21989975:carton:4230:21991556,2198'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001435475852499802, 'nb_photo': 990, 'list_port_cont': '21939595,21941669,21942394,21943080,21944085,21944763,21945382,21948357,21950622,21952608,21954537,21956465,21958364,21959231,21959259,21959322,21959748,21959834,21959902,21960123,21961577,21962661,21963052,21988342,21990218,21990277,21990317,21990406,21990518,21990705,21990734,21990802,21990959,21990999,21991068,21991259,21991389,21991476,21991549,21991620,21991701,21991796,21991886,21991986,21993983,21996728,22001059,22003147,22005530,22006157,22012468,22015363,22017636,22020486,22022653,22023696,22026045,22052952,22053001,22053214,22053232,22053251,22053321,22053377,22053426,22053455,22053899,22084677,22104460,22104826,22108101,22108375,22108474,22108617,22108911,22160336,22160633,22160924,22161246,22161540,22161677,22161775,22161884,22162101,22162421,22162458,22163384,22164131,22166244,22225564,22228575,22228884,22228942,22229056,22229097,22229134,22229176,22229260,22229406,22229490,22229509,22229553,22229652,22229656,22229827,22244553,22245610,22246245,22247485,22248762,22250466,22250774,22253470,2225375', 'assoc_port': '21938966:21939595,21941366:21941669,21942267:21942394,21942958:21943080,21943749:21944085,21944563:21944763,21945209:21945382,21948069:21948357,21950039:21950622,21951757:21952608,21953974:21954537,21956170:21956465,21958148:21958364,21959026:21960123,21959031:21959902,21959035:21959748,21959040:21959834,21959045:21959231,21959050:21959259,21959052:21963052,21959053:21959322,21960936:21961577,21962468:21962661,21987804:21988342,21989948:21991701,21989952:21991620,21989956:21991886,21989960:21991796,21989965:21991986,21989972:21990999,21989973:21991259,21989974:21991476,21989975:21991549,21989976:21990959,21989977:21990705,21989978:21991389,21989979:21991068,21989980:21990277,21989981:21990518,21989982:21990734,21989983:21990218,21989984:21990317,21989985:21990802,21989986:21990406,21992833:21993983,21995874:21996728,22000333:22001059,22000334:22005530,22002452:22003147,22005792:22006157,22012084:22012468,22014793:22015363,22017236:22017636,22019600:22020486,22022111:22022653,22023288:22023696,22024544:2202604', 'assoc_mat': '21938966:metal:4230:21939595,21941366:metal:4230:21941669,21942267:metal:4230:21942394,21942958:metal:4230:21943080,21943749:metal:4230:21944085,21944563:metal:4230:21944763,21945209:metal:4230:21945382,21948069:metal:4230:21948357,21950039:metal:4230:21950622,21951757:metal:4230:21952608,21953974:metal:4230:21954537,21956170:metal:4230:21956465,21958148:metal:4230:21958364,21959026:metal:4230:21960123,21959031:metal:4230:21959902,21959035:metal:4230:21959748,21959040:metal:4230:21959834,21959045:metal:4230:21959231,21959050:metal:4230:21959259,21959052:metal:4230:21963052,21959053:metal:4230:21959322,21960936:metal:4230:21961577,21962468:metal:4230:21962661,21987804:metal:4230:21988342,21989948:metal:4230:21991701,21989952:metal:4230:21991620,21989956:metal:4230:21991886,21989960:metal:4230:21991796,21989965:metal:4230:21991986,21989972:metal:4230:21990999,21989973:metal:4230:21991259,21989974:metal:4230:21991476,21989975:metal:4230:21991549,21989976:metal:4230:21990959,21989977:metal:4230:21990705,21989978:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2443286200194282, 'nb_photo': 187666, 'list_port_cont': '21939593,21941680,21942403,21943094,21944089,21944770,21945381,21948359,21950627,21952606,21954534,21956458,21958367,21959226,21959266,21959321,21959745,21959844,21959917,21960131,21961568,21962677,21963057,21988355,21990222,21990280,21990309,21990400,21990522,21990696,21990742,21990803,21990966,21991006,21991064,21991209,21991284,21991391,21991475,21991555,21991629,21991709,21991807,21991890,21991991,21993982,21996734,22001060,22003160,22004847,22005535,22006161,22007504,22010166,22012477,22015379,22017633,22020491,22022656,22023705,22026043,22052567,22052960,22053011,22053213,22053224,22053263,22053322,22053384,22053422,22053461,22053894,22084675,22104467,22104829,22108103,22108384,22108479,22108613,22108908,22160351,22160637,22160925,22161252,22161546,22161682,22161714,22161771,22161887,22162100,22162437,22162474,22162798,22163370,22164137,22166246,22225562,22228574,22228721,22228896,22228957,22229029,22229064,22229103,22229136,22229164,22229274,22229407,22229486,22229519,22229551,22229638,22229667,2222982', 'assoc_port': '21938966:21939593,21941366:21941680,21942267:21942403,21942958:21943094,21943749:21944089,21944563:21944770,21945209:21945381,21948069:21948359,21950039:21950627,21951757:21952606,21953974:21954534,21956170:21956458,21958148:21958367,21959026:21960131,21959031:21959917,21959035:21959745,21959040:21959844,21959045:21959226,21959050:21959266,21959052:21963057,21959053:21959321,21960936:21961568,21962468:21962677,21987804:21988355,21989948:21991709,21989952:21991629,21989956:21991890,21989960:21991807,21989965:21991991,21989968:21991209,21989972:21991006,21989973:21991284,21989974:21991475,21989975:21991555,21989976:21990966,21989977:21990696,21989978:21991391,21989979:21991064,21989980:21990280,21989981:21990522,21989982:21990742,21989983:21990222,21989984:21990309,21989985:21990803,21989986:21990400,21992833:21993982,21995874:21996734,22000333:22001060,22000334:22005535,22002452:22003160,22004599:22004847,22005792:22006161,22007309:22007504,22009333:22010166,22012084:22012477,22014793:22015379,22017236:2201763', 'assoc_mat': '21938966:papier:4230:21939593,21941366:papier:4230:21941680,21942267:papier:4230:21942403,21942958:papier:4230:21943094,21943749:papier:4230:21944089,21944563:papier:4230:21944770,21945209:papier:4230:21945381,21948069:papier:4230:21948359,21950039:papier:4230:21950627,21951757:papier:4230:21952606,21953974:papier:4230:21954534,21956170:papier:4230:21956458,21958148:papier:4230:21958367,21959026:papier:4230:21960131,21959031:papier:4230:21959917,21959035:papier:4230:21959745,21959040:papier:4230:21959844,21959045:papier:4230:21959226,21959050:papier:4230:21959266,21959052:papier:4230:21963057,21959053:papier:4230:21959321,21960936:papier:4230:21961568,21962468:papier:4230:21962677,21987804:papier:4230:21988355,21989948:papier:4230:21991709,21989952:papier:4230:21991629,21989956:papier:4230:21991890,21989960:papier:4230:21991807,21989965:papier:4230:21991991,21989968:papier:4230:21991209,21989972:papier:4230:21991006,21989973:papier:4230:21991284,21989974:papier:4230:21991475,21989975:papier:4230:21991555,2198'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007074442176229884, 'nb_photo': 1832, 'list_port_cont': '21939596,21941679,21942411,21943083,21944081,21944771,21945380,21948360,21950616,21952603,21954538,21956459,21958374,21959220,21959269,21959313,21959753,21960126,21961570,21962665,21988345,21990223,21990281,21990321,21990392,21990516,21990703,21990739,21990804,21990957,21991004,21991060,21991204,21991286,21991390,21991473,21991546,21991621,21991704,21991800,21991885,21991983,21993985,21996733,22001054,22003159,22004846,22005539,22006168,22007497,22010168,22012480,22015369,22017635,22020484,22022647,22023706,22026048,22053211,22053227,22053259,22053319,22053389,22053415,22053453,22053892,22084671,22104461,22104823,22108094,22108389,22108475,22108620,22108901,22160355,22160638,22160917,22161251,22161538,22161675,22161716,22161779,22161890,22162097,22162434,22162467,22162804,22163373,22164143,22166241,22225570,22228569,22228732,22228893,22228958,22229021,22229067,22229104,22229139,22229174,22229272,22229421,22229484,22229513,22229561,22229649,22229669,22229818,22244525,22244560,22245614,22245784,22246242,2224750', 'assoc_port': '21938966:21939596,21941366:21941679,21942267:21942411,21942958:21943083,21943749:21944081,21944563:21944771,21945209:21945380,21948069:21948360,21950039:21950616,21951757:21952603,21953974:21954538,21956170:21956459,21958148:21958374,21959026:21960126,21959035:21959753,21959045:21959220,21959050:21959269,21959053:21959313,21960936:21961570,21962468:21962665,21987804:21988345,21989948:21991704,21989952:21991621,21989956:21991885,21989960:21991800,21989965:21991983,21989968:21991204,21989972:21991004,21989973:21991286,21989974:21991473,21989975:21991546,21989976:21990957,21989977:21990703,21989978:21991390,21989979:21991060,21989980:21990281,21989981:21990516,21989982:21990739,21989983:21990223,21989984:21990321,21989985:21990804,21989986:21990392,21992833:21993985,21995874:21996733,22000333:22001054,22000334:22005539,22002452:22003159,22004599:22004846,22005792:22006168,22007309:22007497,22009333:22010168,22012084:22012480,22014793:22015369,22017236:22017635,22019600:22020484,22022111:22022647,22023288:2202370', 'assoc_mat': '21938966:pehd:4230:21939596,21941366:pehd:4230:21941679,21942267:pehd:4230:21942411,21942958:pehd:4230:21943083,21943749:pehd:4230:21944081,21944563:pehd:4230:21944771,21945209:pehd:4230:21945380,21948069:pehd:4230:21948360,21950039:pehd:4230:21950616,21951757:pehd:4230:21952603,21953974:pehd:4230:21954538,21956170:pehd:4230:21956459,21958148:pehd:4230:21958374,21959026:pehd:4230:21960126,21959035:pehd:4230:21959753,21959045:pehd:4230:21959220,21959050:pehd:4230:21959269,21959053:pehd:4230:21959313,21960936:pehd:4230:21961570,21962468:pehd:4230:21962665,21987804:pehd:4230:21988345,21989948:pehd:4230:21991704,21989952:pehd:4230:21991621,21989956:pehd:4230:21991885,21989960:pehd:4230:21991800,21989965:pehd:4230:21991983,21989968:pehd:4230:21991204,21989972:pehd:4230:21991004,21989973:pehd:4230:21991286,21989974:pehd:4230:21991473,21989975:pehd:4230:21991546,21989976:pehd:4230:21990957,21989977:pehd:4230:21990703,21989978:pehd:4230:21991390,21989979:pehd:4230:21991060,21989980:pehd:4230:21990281,21989981:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.018687761646608056, 'nb_photo': 12881, 'list_port_cont': '21939599,21941682,21942407,21943092,21944083,21944773,21945379,21948364,21950623,21952605,21954545,21956462,21958365,21959232,21959267,21959318,21959750,21959833,21959918,21960115,21961574,21962675,21963055,21988357,21990227,21990283,21990319,21990396,21990524,21990702,21990740,21990798,21990958,21990996,21991073,21991205,21991280,21991397,21991478,21991554,21991626,21991703,21991797,21991891,21991993,21993986,21996731,22001062,22003161,22004848,22005533,22006167,22007506,22010167,22012476,22015374,22017644,22020487,22022659,22023707,22026051,22052566,22052959,22053010,22053203,22053230,22053261,22053316,22053374,22053416,22053452,22053888,22084642,22104454,22104827,22108102,22108382,22108478,22108625,22108906,22160342,22160641,22160926,22161244,22161544,22161683,22161708,22161777,22161889,22162098,22162431,22162471,22162802,22163374,22164142,22166242,22225559,22228573,22228731,22228901,22228953,22229031,22229060,22229096,22229140,22229175,22229264,22229418,22229485,22229496,22229563,22229643,22229668,2222982', 'assoc_port': '21938966:21939599,21941366:21941682,21942267:21942407,21942958:21943092,21943749:21944083,21944563:21944773,21945209:21945379,21948069:21948364,21950039:21950623,21951757:21952605,21953974:21954545,21956170:21956462,21958148:21958365,21959026:21960115,21959031:21959918,21959035:21959750,21959040:21959833,21959045:21959232,21959050:21959267,21959052:21963055,21959053:21959318,21960936:21961574,21962468:21962675,21987804:21988357,21989948:21991703,21989952:21991626,21989956:21991891,21989960:21991797,21989965:21991993,21989968:21991205,21989972:21990996,21989973:21991280,21989974:21991478,21989975:21991554,21989976:21990958,21989977:21990702,21989978:21991397,21989979:21991073,21989980:21990283,21989981:21990524,21989982:21990740,21989983:21990227,21989984:21990319,21989985:21990798,21989986:21990396,21992833:21993986,21995874:21996731,22000333:22001062,22000334:22005533,22002452:22003161,22004599:22004848,22005792:22006167,22007309:22007506,22009333:22010167,22012084:22012476,22014793:22015374,22017236:2201764', 'assoc_mat': '21938966:pet_clair:4230:21939599,21941366:pet_clair:4230:21941682,21942267:pet_clair:4230:21942407,21942958:pet_clair:4230:21943092,21943749:pet_clair:4230:21944083,21944563:pet_clair:4230:21944773,21945209:pet_clair:4230:21945379,21948069:pet_clair:4230:21948364,21950039:pet_clair:4230:21950623,21951757:pet_clair:4230:21952605,21953974:pet_clair:4230:21954545,21956170:pet_clair:4230:21956462,21958148:pet_clair:4230:21958365,21959026:pet_clair:4230:21960115,21959031:pet_clair:4230:21959918,21959035:pet_clair:4230:21959750,21959040:pet_clair:4230:21959833,21959045:pet_clair:4230:21959232,21959050:pet_clair:4230:21959267,21959052:pet_clair:4230:21963055,21959053:pet_clair:4230:21959318,21960936:pet_clair:4230:21961574,21962468:pet_clair:4230:21962675,21987804:pet_clair:4230:21988357,21989948:pet_clair:4230:21991703,21989952:pet_clair:4230:21991626,21989956:pet_clair:4230:21991891,21989960:pet_clair:4230:21991797,21989965:pet_clair:4230:21991993,21989968:pet_clair:4230:21991205,21989972:pet_clair:4230:21990996,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003330816102153536, 'nb_photo': 543, 'list_port_cont': '21939590,21941671,21942404,21944088,21944766,21945370,21948362,21952599,21954541,21956460,21959227,21959260,21959319,21959754,21959836,21959910,21960124,21962671,21988347,21990285,21990314,21990387,21990796,21990961,21991069,21991215,21991281,21991398,21991557,21991623,21993988,21996729,22001061,22005534,22006166,22012474,22015380,22017630,22020489,22022658,22023703,22026046,22053212,22053267,22053317,22053383,22053424,22053450,22053897,22084659,22104459,22104820,22108096,22108387,22108622,22108909,22160357,22160631,22161254,22161549,22161681,22161717,22161891,22162103,22162436,22162470,22162793,22163383,22164140,22225572,22228564,22228902,22229020,22229093,22229128,22229172,22229276,22229482,22229503,22229560,22229645,22229665,22229826,22244523,22244569,22245616,22245782,22246231,22247495,22248756,22250474,22253493,22253762,22254977,22255317,22264788,22265038,22265186,22265259,22265280,22265838,22266230,22272155,22272461,22279385,22280048,22280425,22281521,22320595,22320804,22320843,22320902,22320972,2232100', 'assoc_port': '21938966:21939590,21941366:21941671,21942267:21942404,21943749:21944088,21944563:21944766,21945209:21945370,21948069:21948362,21951757:21952599,21953974:21954541,21956170:21956460,21959026:21960124,21959031:21959910,21959035:21959754,21959040:21959836,21959045:21959227,21959050:21959260,21959053:21959319,21962468:21962671,21987804:21988347,21989952:21991623,21989968:21991215,21989973:21991281,21989975:21991557,21989976:21990961,21989978:21991398,21989979:21991069,21989980:21990285,21989984:21990314,21989985:21990796,21989986:21990387,21992833:21993988,21995874:21996729,22000333:22001061,22000334:22005534,22005792:22006166,22012084:22012474,22014793:22015380,22017236:22017630,22019600:22020489,22022111:22022658,22023288:22023703,22024544:22026046,22051180:22053450,22051183:22053897,22051186:22053212,22051189:22053267,22051192:22053424,22051195:22053317,22051198:22053383,22083860:22084659,22104053:22108096,22104055:22108387,22104059:22108622,22104061:22108909,22104063:22104820,22104065:22104459,22155656:2216035', 'assoc_mat': '21938966:pet_fonce:4230:21939590,21941366:pet_fonce:4230:21941671,21942267:pet_fonce:4230:21942404,21943749:pet_fonce:4230:21944088,21944563:pet_fonce:4230:21944766,21945209:pet_fonce:4230:21945370,21948069:pet_fonce:4230:21948362,21951757:pet_fonce:4230:21952599,21953974:pet_fonce:4230:21954541,21956170:pet_fonce:4230:21956460,21959026:pet_fonce:4230:21960124,21959031:pet_fonce:4230:21959910,21959035:pet_fonce:4230:21959754,21959040:pet_fonce:4230:21959836,21959045:pet_fonce:4230:21959227,21959050:pet_fonce:4230:21959260,21959053:pet_fonce:4230:21959319,21962468:pet_fonce:4230:21962671,21987804:pet_fonce:4230:21988347,21989952:pet_fonce:4230:21991623,21989968:pet_fonce:4230:21991215,21989973:pet_fonce:4230:21991281,21989975:pet_fonce:4230:21991557,21989976:pet_fonce:4230:21990961,21989978:pet_fonce:4230:21991398,21989979:pet_fonce:4230:21991069,21989980:pet_fonce:4230:21990285,21989984:pet_fonce:4230:21990314,21989985:pet_fonce:4230:21990796,21989986:pet_fonce:4230:21990387,21992833:pet_fonce:4230:21993988,2'}), 'main_stat': {'nb_photos': 805}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-04', 0.6710570826584132),)]} filepath : /data_2/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_04_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.71%', 9026], 'carton': ['carton', '8.13%', 58837], 'metal': ['metal', '0.14%', 990], 'papier': ['papier', '24.43%', 187666], 'pehd': ['pehd', '0.71%', 1832], 'pet_clair': ['pet_clair', '1.87%', 12881], 'pet_fonce': ['pet_fonce', '0.33%', 543]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_04_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/SCCU_cam7 2.71user 2.84system 0:06.45elapsed 86%CPU (0avgtext+0avgdata 193504maxresident)k 20496inputs+280outputs (247major+79900minor)pagefaults 0swaps