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_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -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-07 _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, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 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=4849 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= 4849 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=4849 # 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, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 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=4849 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= 4849 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=4849 # 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 : 202 month : 07 mtr_id : dashboard_places : SCCU_cam6 date : 2025-07 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_cam6' and date like '%2025-07%') and created_at like '%2025-07%'))); nb_day : (1, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 202 and month(ded.date) = 07 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 = 202 and month(ded.date) = 07 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 = 202 and mp.name like '%072025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-07-01 : dt_date_just_month_year : 2025-07-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_cam6" 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-07-01" AND ded.date <= "2025-07-31" apple3 {'incineration': {'mat': 'incineration', 'pht': 4230, 'datou_carac_id': 4234, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1950656,1955073,1958635,1961688,1964066,1964416,1967786,1970358,1972641,1975906,1979420,1981921,1982249,1985696,1989629,1991366,1994338,1997040,1999280,1999629,2003002,2006386,2010055,2013844,2017698,2020297,2020939,2027411,2034539,2041275,2049321) 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.009181596510676193, 'nb_photo': 13741, 'list_port_cont': '24485163,24485418,24488660,24488739,24488824,24488883,24488921,24488959,24488997,24489026,24489108,24489136,24489174,24489221,24489243,24489278,24489347,24489407,24489443,24489470,24489552,24489633,24490374,24528081,24528187,24528382,24528540,24528604,24528613,24528846,24528966,24529035,24529146,24529154,24529439,24532524,24535769,24578578,24578621,24578756,24578832,24578930,24579002,24579035,24579170,24579204,24579273,24579345,24622931,24624480,24624615,24624668,24624777,24624827,24624931,24624975,24625140,24625253,24625317,24625371,24625449,24625950,24628074,24629180,24650125,24651139,24651166,24651262,24651372,24651385,24651441,24651491,24651576,24651669,24651680,24651804,24651860,24651877,24651935,24651971,24651984,24652048,24652080,24652117,24652149,24652207,24652800,24652997,24656828,24656943,24657204,24657452,24657935,24658280,24658310,24658511,24658538,24658684,24658724,24658771,24658798,24658844,24658871,24658945,24658973,24658992,24658999,24659081,24659170,24659195,24659302,24659405,24695513,2469564', 'assoc_port': '24485036:24489633,24485037:24490374,24485050:24489443,24485051:24489221,24485052:24489552,24485053:24489470,24485055:24489108,24485058:24485163,24485061:24489174,24485062:24489243,24485065:24489136,24485068:24489407,24485069:24488997,24485072:24489026,24485075:24489278,24485076:24488959,24485079:24488921,24485082:24488824,24485083:24488883,24485086:24488739,24485088:24488660,24485090:24485418,24488934:24489347,24527852:24529154,24527853:24529146,24527854:24529439,24527855:24529035,24527856:24528966,24527857:24528846,24527858:24528604,24527859:24528613,24527861:24528540,24527862:24528187,24527864:24528081,24527865:24528382,24532151:24532524,24535578:24535769,24578550:24579170,24578552:24579273,24578554:24579345,24578556:24579204,24578558:24578930,24578560:24579002,24578562:24578756,24578564:24579035,24578566:24578832,24578568:24578578,24578570:24578621,24622640:24625371,24622641:24625317,24622642:24625449,24622643:24625140,24622644:24625253,24622645:24624827,24622646:24624975,24622647:24624931,24622648:2462466', 'assoc_mat': '24485036:autre:4230:24489633,24485037:autre:4230:24490374,24485050:autre:4230:24489443,24485051:autre:4230:24489221,24485052:autre:4230:24489552,24485053:autre:4230:24489470,24485055:autre:4230:24489108,24485058:autre:4230:24485163,24485061:autre:4230:24489174,24485062:autre:4230:24489243,24485065:autre:4230:24489136,24485068:autre:4230:24489407,24485069:autre:4230:24488997,24485072:autre:4230:24489026,24485075:autre:4230:24489278,24485076:autre:4230:24488959,24485079:autre:4230:24488921,24485082:autre:4230:24488824,24485083:autre:4230:24488883,24485086:autre:4230:24488739,24485088:autre:4230:24488660,24485090:autre:4230:24485418,24488934:autre:4230:24489347,24527852:autre:4230:24529154,24527853:autre:4230:24529146,24527854:autre:4230:24529439,24527855:autre:4230:24529035,24527856:autre:4230:24528966,24527857:autre:4230:24528846,24527858:autre:4230:24528604,24527859:autre:4230:24528613,24527861:autre:4230:24528540,24527862:autre:4230:24528187,24527864:autre:4230:24528081,24527865:autre:4230:24528382,24532151:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02106182934526991, 'nb_photo': 45914, 'list_port_cont': '24485165,24485417,24488671,24488737,24488820,24488894,24488926,24488969,24489004,24489042,24489107,24489149,24489187,24489223,24489252,24489303,24489346,24489406,24489428,24489479,24489565,24489642,24490377,24528083,24528197,24528379,24528538,24528599,24528622,24528849,24528964,24529043,24529138,24529164,24529459,24532509,24535779,24578582,24578624,24578768,24578839,24578937,24579010,24579050,24579161,24579206,24579267,24579368,24622929,24624479,24624626,24624669,24624782,24624830,24624939,24624976,24625148,24625264,24625324,24625373,24625441,24625962,24628068,24629187,24650126,24651135,24651177,24651256,24651380,24651391,24651449,24651484,24651577,24651665,24651706,24651813,24651867,24651882,24651943,24651980,24651993,24652042,24652084,24652127,24652136,24652214,24652799,24652996,24656843,24656952,24657210,24657453,24657940,24658296,24658330,24658512,24658545,24658695,24658728,24658764,24658800,24658834,24658888,24658947,24658983,24659016,24659017,24659092,24659161,24659203,24659299,24659409,24695523,2469564', 'assoc_port': '24485036:24489642,24485037:24490377,24485050:24489428,24485051:24489223,24485052:24489565,24485053:24489479,24485055:24489107,24485058:24485165,24485061:24489187,24485062:24489252,24485065:24489149,24485068:24489406,24485069:24489004,24485072:24489042,24485075:24489303,24485076:24488969,24485079:24488926,24485082:24488820,24485083:24488894,24485086:24488737,24485088:24488671,24485090:24485417,24488934:24489346,24527852:24529164,24527853:24529138,24527854:24529459,24527855:24529043,24527856:24528964,24527857:24528849,24527858:24528599,24527859:24528622,24527861:24528538,24527862:24528197,24527864:24528083,24527865:24528379,24532151:24532509,24535578:24535779,24578550:24579161,24578552:24579267,24578554:24579368,24578556:24579206,24578558:24578937,24578560:24579010,24578562:24578768,24578564:24579050,24578566:24578839,24578568:24578582,24578570:24578624,24622640:24625373,24622641:24625324,24622642:24625441,24622643:24625148,24622644:24625264,24622645:24624830,24622646:24624976,24622647:24624939,24622648:2462466', 'assoc_mat': '24485036:carton:4230:24489642,24485037:carton:4230:24490377,24485050:carton:4230:24489428,24485051:carton:4230:24489223,24485052:carton:4230:24489565,24485053:carton:4230:24489479,24485055:carton:4230:24489107,24485058:carton:4230:24485165,24485061:carton:4230:24489187,24485062:carton:4230:24489252,24485065:carton:4230:24489149,24485068:carton:4230:24489406,24485069:carton:4230:24489004,24485072:carton:4230:24489042,24485075:carton:4230:24489303,24485076:carton:4230:24488969,24485079:carton:4230:24488926,24485082:carton:4230:24488820,24485083:carton:4230:24488894,24485086:carton:4230:24488737,24485088:carton:4230:24488671,24485090:carton:4230:24485417,24488934:carton:4230:24489346,24527852:carton:4230:24529164,24527853:carton:4230:24529138,24527854:carton:4230:24529459,24527855:carton:4230:24529043,24527856:carton:4230:24528964,24527857:carton:4230:24528849,24527858:carton:4230:24528599,24527859:carton:4230:24528622,24527861:carton:4230:24528538,24527862:carton:4230:24528197,24527864:carton:4230:24528083,2452'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0008759911615132322, 'nb_photo': 1318, 'list_port_cont': '24485412,24488813,24488892,24488916,24489030,24489143,24489249,24489286,24489333,24489394,24489432,24490367,24528189,24528395,24528533,24528603,24528959,24529144,24529156,24529451,24532515,24535770,24578571,24578608,24578831,24578935,24579048,24579200,24579265,24579369,24622917,24624490,24624610,24624656,24624779,24625141,24625256,24625309,24625372,24625426,24625958,24628069,24629183,24650137,24651130,24651179,24651261,24651371,24651395,24651440,24651489,24651670,24651690,24651812,24651857,24651871,24651977,24652056,24652141,24652202,24652805,24652993,24656840,24656950,24657457,24657928,24658274,24658842,24658981,24659082,24659159,24659201,24696053,24696216,24696262,24696486,24696519,24696657,24696723,24697052,24697225,24700086,24702241,24738745,24738959,24738989,24739159,24739172,24739234,24739375,24739412,24739449,24739515,24739559,24739600,24739670,24739715,24739793,24739867,24740012,24740255,24740376,24741341,24744292,24744885,24746115,24747111,24749589,24752336,24756016,24758449,24762462,24812461,2481252', 'assoc_port': '24485037:24490367,24485050:24489432,24485062:24489249,24485065:24489143,24485068:24489394,24485072:24489030,24485075:24489286,24485079:24488916,24485082:24488813,24485083:24488892,24485090:24485412,24488934:24489333,24527852:24529156,24527853:24529144,24527854:24529451,24527856:24528959,24527858:24528603,24527861:24528533,24527862:24528189,24527865:24528395,24532151:24532515,24535578:24535770,24578552:24579265,24578554:24579369,24578556:24579200,24578558:24578935,24578564:24579048,24578566:24578831,24578568:24578571,24578570:24578608,24622640:24625372,24622641:24625309,24622642:24625426,24622643:24625141,24622644:24625256,24622648:24624656,24622649:24624779,24622650:24629183,24622651:24624610,24622652:24624490,24622653:24622917,24625788:24625958,24627859:24628069,24650049:24652056,24650056:24651857,24650060:24651690,24650062:24650137,24650064:24651871,24650067:24651670,24650069:24652141,24650075:24652202,24650078:24651440,24650081:24651977,24650082:24651812,24650085:24651489,24650087:24651395,24650088:2465126', 'assoc_mat': '24485037:metal:4230:24490367,24485050:metal:4230:24489432,24485062:metal:4230:24489249,24485065:metal:4230:24489143,24485068:metal:4230:24489394,24485072:metal:4230:24489030,24485075:metal:4230:24489286,24485079:metal:4230:24488916,24485082:metal:4230:24488813,24485083:metal:4230:24488892,24485090:metal:4230:24485412,24488934:metal:4230:24489333,24527852:metal:4230:24529156,24527853:metal:4230:24529144,24527854:metal:4230:24529451,24527856:metal:4230:24528959,24527858:metal:4230:24528603,24527861:metal:4230:24528533,24527862:metal:4230:24528189,24527865:metal:4230:24528395,24532151:metal:4230:24532515,24535578:metal:4230:24535770,24578552:metal:4230:24579265,24578554:metal:4230:24579369,24578556:metal:4230:24579200,24578558:metal:4230:24578935,24578564:metal:4230:24579048,24578566:metal:4230:24578831,24578568:metal:4230:24578571,24578570:metal:4230:24578608,24622640:metal:4230:24625372,24622641:metal:4230:24625309,24622642:metal:4230:24625426,24622643:metal:4230:24625141,24622644:metal:4230:24625256,24622648:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1290268587873538, 'nb_photo': 297969, 'list_port_cont': '24485164,24485415,24488674,24488733,24488818,24488896,24488933,24488970,24488994,24489039,24489110,24489150,24489177,24489212,24489258,24489299,24489342,24489405,24489441,24489477,24489562,24489634,24490373,24528082,24528194,24528393,24528537,24528607,24528624,24528844,24528967,24529040,24529147,24529159,24529460,24532520,24535776,24578583,24578615,24578762,24578840,24578939,24579012,24579049,24579159,24579203,24579266,24579347,24622927,24624487,24624618,24624670,24624790,24624825,24624938,24624964,24625153,24625263,24625307,24625358,24625439,24625964,24628066,24629178,24650135,24651136,24651172,24651258,24651376,24651384,24651453,24651487,24651579,24651667,24651703,24651819,24651869,24651886,24651942,24651981,24651997,24652054,24652089,24652124,24652147,24652210,24652794,24652995,24656839,24656953,24657208,24657464,24657933,24658286,24658326,24658508,24658535,24658692,24658730,24658770,24658805,24658838,24658885,24658948,24658988,24659021,24659022,24659088,24659163,24659208,24659296,24659413,24695515,2469564', 'assoc_port': '24485036:24489634,24485037:24490373,24485050:24489441,24485051:24489212,24485052:24489562,24485053:24489477,24485055:24489110,24485058:24485164,24485061:24489177,24485062:24489258,24485065:24489150,24485068:24489405,24485069:24488994,24485072:24489039,24485075:24489299,24485076:24488970,24485079:24488933,24485082:24488818,24485083:24488896,24485086:24488733,24485088:24488674,24485090:24485415,24488934:24489342,24527852:24529159,24527853:24529147,24527854:24529460,24527855:24529040,24527856:24528967,24527857:24528844,24527858:24528607,24527859:24528624,24527861:24528537,24527862:24528194,24527864:24528082,24527865:24528393,24532151:24532520,24535578:24535776,24578550:24579159,24578552:24579266,24578554:24579347,24578556:24579203,24578558:24578939,24578560:24579012,24578562:24578762,24578564:24579049,24578566:24578840,24578568:24578583,24578570:24578615,24622640:24625358,24622641:24625307,24622642:24625439,24622643:24625153,24622644:24625263,24622645:24624825,24622646:24624964,24622647:24624938,24622648:2462467', 'assoc_mat': '24485036:papier:4230:24489634,24485037:papier:4230:24490373,24485050:papier:4230:24489441,24485051:papier:4230:24489212,24485052:papier:4230:24489562,24485053:papier:4230:24489477,24485055:papier:4230:24489110,24485058:papier:4230:24485164,24485061:papier:4230:24489177,24485062:papier:4230:24489258,24485065:papier:4230:24489150,24485068:papier:4230:24489405,24485069:papier:4230:24488994,24485072:papier:4230:24489039,24485075:papier:4230:24489299,24485076:papier:4230:24488970,24485079:papier:4230:24488933,24485082:papier:4230:24488818,24485083:papier:4230:24488896,24485086:papier:4230:24488733,24485088:papier:4230:24488674,24485090:papier:4230:24485415,24488934:papier:4230:24489342,24527852:papier:4230:24529159,24527853:papier:4230:24529147,24527854:papier:4230:24529460,24527855:papier:4230:24529040,24527856:papier:4230:24528967,24527857:papier:4230:24528844,24527858:papier:4230:24528607,24527859:papier:4230:24528624,24527861:papier:4230:24528537,24527862:papier:4230:24528194,24527864:papier:4230:24528082,2452'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022588931911694267, 'nb_photo': 928, 'list_port_cont': '24485416,24488925,24488971,24489043,24489147,24489294,24528601,24528841,24528975,24529143,24529443,24578588,24578766,24578836,24579279,24579363,24624622,24624671,24624820,24625150,24625261,24625325,24625368,24625447,24651132,24651171,24651254,24651367,24651399,24651451,24651493,24651568,24651658,24651809,24651883,24651941,24651973,24652135,24652148,24652204,24652806,24658294,24658548,24658733,24658985,24695894,24696057,24696227,24696274,24696662,24696735,24697159,24702245,24738749,24738834,24738965,24739161,24739388,24739419,24739454,24739554,24739596,24739677,24739721,24739797,24740020,24741524,24744293,24744518,24746109,24747118,24749602,24752340,24758451,24760697,24774181,24817759,24858157,24858802,24859236,24859618,24860307,24860593,24860646,24861016,24861051,24861104,24861210,24861326,24861444,24861466,24861670,24865072,24890377,24892100,24892229,24892301,24892346,24892389,24892427,24892465,24892509,24892551,24892588,24892613,24892675,24892868,24893032,24898056,24898419,24898890,24932714,24933553,2493375', 'assoc_port': '24485065:24489147,24485072:24489043,24485075:24489294,24485076:24488971,24485079:24488925,24485090:24485416,24527853:24529143,24527854:24529443,24527856:24528975,24527857:24528841,24527858:24528601,24578552:24579279,24578554:24579363,24578562:24578766,24578566:24578836,24578568:24578588,24622640:24625368,24622641:24625325,24622642:24625447,24622643:24625150,24622644:24625261,24622645:24624820,24622648:24624671,24622651:24624622,24650051:24651941,24650064:24651883,24650067:24651658,24650069:24652148,24650071:24651568,24650074:24652135,24650075:24652204,24650078:24651451,24650081:24651973,24650082:24651809,24650085:24651493,24650087:24651399,24650088:24651254,24650090:24651171,24650092:24651132,24650093:24651367,24652707:24652806,24656763:24658548,24656769:24658985,24656783:24658733,24656797:24658294,24695408:24697159,24695422:24696735,24695427:24696662,24695428:24696227,24695429:24696274,24695431:24696057,24695445:24695894,24702030:24702245,24736976:24740020,24736978:24739797,24736980:24739554,24736982:2473967', 'assoc_mat': '24485065:pehd:4230:24489147,24485072:pehd:4230:24489043,24485075:pehd:4230:24489294,24485076:pehd:4230:24488971,24485079:pehd:4230:24488925,24485090:pehd:4230:24485416,24527853:pehd:4230:24529143,24527854:pehd:4230:24529443,24527856:pehd:4230:24528975,24527857:pehd:4230:24528841,24527858:pehd:4230:24528601,24578552:pehd:4230:24579279,24578554:pehd:4230:24579363,24578562:pehd:4230:24578766,24578566:pehd:4230:24578836,24578568:pehd:4230:24578588,24622640:pehd:4230:24625368,24622641:pehd:4230:24625325,24622642:pehd:4230:24625447,24622643:pehd:4230:24625150,24622644:pehd:4230:24625261,24622645:pehd:4230:24624820,24622648:pehd:4230:24624671,24622651:pehd:4230:24624622,24650051:pehd:4230:24651941,24650064:pehd:4230:24651883,24650067:pehd:4230:24651658,24650069:pehd:4230:24652148,24650071:pehd:4230:24651568,24650074:pehd:4230:24652135,24650075:pehd:4230:24652204,24650078:pehd:4230:24651451,24650081:pehd:4230:24651973,24650082:pehd:4230:24651809,24650085:pehd:4230:24651493,24650087:pehd:4230:24651399,24650088:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.022090885106705264, 'nb_photo': 27292, 'list_port_cont': '24485157,24485420,24488665,24488729,24488822,24488895,24488928,24488961,24489003,24489041,24489115,24489145,24489184,24489216,24489244,24489295,24489340,24489400,24489437,24489469,24489553,24489638,24490379,24528077,24528196,24528391,24528543,24528595,24528611,24528843,24528974,24529031,24529137,24529167,24529458,24532518,24535775,24578586,24578617,24578786,24578833,24578928,24579011,24579043,24579166,24579207,24579275,24579365,24622923,24624491,24624613,24624663,24624785,24624821,24624932,24624972,24625149,24625265,24625315,24625374,24625446,24625959,24628072,24629186,24650136,24651140,24651178,24651257,24651382,24651394,24651454,24651488,24651578,24651664,24651700,24651810,24651861,24651881,24651930,24651966,24651987,24652051,24652091,24652125,24652142,24652212,24652803,24652990,24656827,24656951,24657199,24657461,24657934,24658300,24658306,24658516,24658537,24658689,24658729,24658766,24658803,24658835,24658883,24658949,24658984,24658995,24659012,24659091,24659169,24659196,24659293,24659410,24695528,2469564', 'assoc_port': '24485036:24489638,24485037:24490379,24485050:24489437,24485051:24489216,24485052:24489553,24485053:24489469,24485055:24489115,24485058:24485157,24485061:24489184,24485062:24489244,24485065:24489145,24485068:24489400,24485069:24489003,24485072:24489041,24485075:24489295,24485076:24488961,24485079:24488928,24485082:24488822,24485083:24488895,24485086:24488729,24485088:24488665,24485090:24485420,24488934:24489340,24527852:24529167,24527853:24529137,24527854:24529458,24527855:24529031,24527856:24528974,24527857:24528843,24527858:24528595,24527859:24528611,24527861:24528543,24527862:24528196,24527864:24528077,24527865:24528391,24532151:24532518,24535578:24535775,24578550:24579166,24578552:24579275,24578554:24579365,24578556:24579207,24578558:24578928,24578560:24579011,24578562:24578786,24578564:24579043,24578566:24578833,24578568:24578586,24578570:24578617,24622640:24625374,24622641:24625315,24622642:24625446,24622643:24625149,24622644:24625265,24622645:24624821,24622646:24624972,24622647:24624932,24622648:2462466', 'assoc_mat': '24485036:pet_clair:4230:24489638,24485037:pet_clair:4230:24490379,24485050:pet_clair:4230:24489437,24485051:pet_clair:4230:24489216,24485052:pet_clair:4230:24489553,24485053:pet_clair:4230:24489469,24485055:pet_clair:4230:24489115,24485058:pet_clair:4230:24485157,24485061:pet_clair:4230:24489184,24485062:pet_clair:4230:24489244,24485065:pet_clair:4230:24489145,24485068:pet_clair:4230:24489400,24485069:pet_clair:4230:24489003,24485072:pet_clair:4230:24489041,24485075:pet_clair:4230:24489295,24485076:pet_clair:4230:24488961,24485079:pet_clair:4230:24488928,24485082:pet_clair:4230:24488822,24485083:pet_clair:4230:24488895,24485086:pet_clair:4230:24488729,24485088:pet_clair:4230:24488665,24485090:pet_clair:4230:24485420,24488934:pet_clair:4230:24489340,24527852:pet_clair:4230:24529167,24527853:pet_clair:4230:24529137,24527854:pet_clair:4230:24529458,24527855:pet_clair:4230:24529031,24527856:pet_clair:4230:24528974,24527857:pet_clair:4230:24528843,24527858:pet_clair:4230:24528595,24527859:pet_clair:4230:24528611,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018554390726249126, 'nb_photo': 692, 'list_port_cont': '24488814,24488966,24489029,24489146,24489185,24489259,24489339,24489404,24489466,24489561,24490378,24528185,24528529,24528600,24528625,24528851,24529457,24578584,24578838,24579042,24579272,24622911,24624486,24624822,24624936,24625145,24625251,24625319,24625366,24625442,24629182,24651134,24651176,24651259,24651379,24651396,24651452,24651496,24651572,24651660,24651815,24651856,24651878,24651938,24651972,24651995,24652047,24652130,24652150,24652213,24652804,24652998,24656954,24657206,24659294,24696040,24696065,24696222,24696264,24696439,24696668,24696879,24697229,24737083,24739154,24739177,24739384,24739562,24739598,24739668,24739727,24739863,24740017,24741529,24744297,24744882,24746118,24747116,24749598,24752348,24756026,24758457,24760702,24774178,24812328,24817773,24858153,24858798,24859613,24859874,24860020,24860314,24861010,24861048,24861327,24861449,24861579,24861683,24865080,24890384,24891124,24891278,24891981,24892088,24892226,24892262,24892311,24892345,24892376,24892438,24892543,24892584,24892615,2489266', 'assoc_port': '24485037:24490378,24485052:24489561,24485053:24489466,24485061:24489185,24485062:24489259,24485065:24489146,24485068:24489404,24485072:24489029,24485076:24488966,24485082:24488814,24488934:24489339,24527854:24529457,24527857:24528851,24527858:24528600,24527859:24528625,24527861:24528529,24527862:24528185,24578552:24579272,24578564:24579042,24578566:24578838,24578568:24578584,24622640:24625366,24622641:24625319,24622642:24625442,24622643:24625145,24622644:24625251,24622645:24624822,24622647:24624936,24622650:24629182,24622652:24624486,24622653:24622911,24650049:24652047,24650051:24651938,24650056:24651856,24650057:24651995,24650064:24651878,24650067:24651660,24650069:24652150,24650071:24651572,24650074:24652130,24650075:24652213,24650078:24651452,24650081:24651972,24650082:24651815,24650085:24651496,24650087:24651396,24650088:24651259,24650090:24651176,24650092:24651134,24650093:24651379,24652707:24652804,24652930:24652998,24656760:24657206,24656799:24656954,24659240:24659294,24695412:24696879,24695417:2469722', 'assoc_mat': '24485037:pet_fonce:4230:24490378,24485052:pet_fonce:4230:24489561,24485053:pet_fonce:4230:24489466,24485061:pet_fonce:4230:24489185,24485062:pet_fonce:4230:24489259,24485065:pet_fonce:4230:24489146,24485068:pet_fonce:4230:24489404,24485072:pet_fonce:4230:24489029,24485076:pet_fonce:4230:24488966,24485082:pet_fonce:4230:24488814,24488934:pet_fonce:4230:24489339,24527854:pet_fonce:4230:24529457,24527857:pet_fonce:4230:24528851,24527858:pet_fonce:4230:24528600,24527859:pet_fonce:4230:24528625,24527861:pet_fonce:4230:24528529,24527862:pet_fonce:4230:24528185,24578552:pet_fonce:4230:24579272,24578564:pet_fonce:4230:24579042,24578566:pet_fonce:4230:24578838,24578568:pet_fonce:4230:24578584,24622640:pet_fonce:4230:24625366,24622641:pet_fonce:4230:24625319,24622642:pet_fonce:4230:24625442,24622643:pet_fonce:4230:24625145,24622644:pet_fonce:4230:24625251,24622645:pet_fonce:4230:24624822,24622647:pet_fonce:4230:24624936,24622650:pet_fonce:4230:24629182,24622652:pet_fonce:4230:24624486,24622653:pet_fonce:4230:24622911,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(1950656,1955073,1958635,1961688,1964066,1964416,1967786,1970358,1972641,1975906,1979420,1981921,1982249,1985696,1989629,1991366,1994338,1997040,1999280,1999629,2003002,2006386,2010055,2013844,2017698,2020297,2020939,2027411,2034539,2041275,2049321)); 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=202 and date >='2025-07-01' and date <= '2025-07-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2330,),), 'unwanted_material_monthly_percentage': ((0.8295730889874583,),), 'material_repartition': (('incineration', 2330),), 'material_dict': {'incineration': 2330}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 7, 1), 0.8617837796596023, 83), (datetime.date(2025, 7, 2), 0.850816574618458, 49), (datetime.date(2025, 7, 3), 0.8387598720094017, 39), (datetime.date(2025, 7, 4), 0.8475461769220981, 61), (datetime.date(2025, 7, 5), 0.7870220534331659, 88), (datetime.date(2025, 7, 6), 0.8454664364139345, 86), (datetime.date(2025, 7, 7), 0.8385985969113773, 88), (datetime.date(2025, 7, 8), 0.8546688888042224, 95), (datetime.date(2025, 7, 9), 0.8457530684087399, 64), (datetime.date(2025, 7, 10), 0.8157554788384099, 50), (datetime.date(2025, 7, 11), 0.8133564251818424, 88), (datetime.date(2025, 7, 12), 0.7993388930091709, 81), (datetime.date(2025, 7, 13), 0.8296604348256547, 84), (datetime.date(2025, 7, 14), 0.8740011866099884, 75), (datetime.date(2025, 7, 15), 0.8350646868384015, 54), (datetime.date(2025, 7, 16), 0.8486622521949654, 36), (datetime.date(2025, 7, 17), 0.8131007353780881, 86), (datetime.date(2025, 7, 18), 0.8176314366501725, 61), (datetime.date(2025, 7, 19), 0.7530876310392668, 84), (datetime.date(2025, 7, 20), 0.796369377961058, 73), (datetime.date(2025, 7, 21), 0.8141609846790592, 80), (datetime.date(2025, 7, 22), 0.7976014877189722, 76), (datetime.date(2025, 7, 23), 0.8174303433996465, 85), (datetime.date(2025, 7, 24), 0.8229143360761951, 81), (datetime.date(2025, 7, 25), 0.8154535783664866, 83), (datetime.date(2025, 7, 26), 0.7975845923455142, 79), (datetime.date(2025, 7, 27), 0.8759212959477795, 77), (datetime.date(2025, 7, 28), 0.8936622390395179, 87), (datetime.date(2025, 7, 29), 0.8614784839953555, 86), (datetime.date(2025, 7, 30), 0.8497533000985666, 79), (datetime.date(2025, 7, 31), 0.8129164183141008, 92)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 7, 1), 0.8617837796596023, 83), (datetime.date(2025, 7, 2), 0.850816574618458, 49), (datetime.date(2025, 7, 3), 0.8387598720094017, 39), (datetime.date(2025, 7, 4), 0.8475461769220981, 61), (datetime.date(2025, 7, 5), 0.7870220534331659, 88), (datetime.date(2025, 7, 6), 0.8454664364139345, 86), (datetime.date(2025, 7, 7), 0.8385985969113773, 88), (datetime.date(2025, 7, 8), 0.8546688888042224, 95), (datetime.date(2025, 7, 9), 0.8457530684087399, 64), (datetime.date(2025, 7, 10), 0.8157554788384099, 50), (datetime.date(2025, 7, 11), 0.8133564251818424, 88), (datetime.date(2025, 7, 12), 0.7993388930091709, 81), (datetime.date(2025, 7, 13), 0.8296604348256547, 84), (datetime.date(2025, 7, 14), 0.8740011866099884, 75), (datetime.date(2025, 7, 15), 0.8350646868384015, 54), (datetime.date(2025, 7, 16), 0.8486622521949654, 36), (datetime.date(2025, 7, 17), 0.8131007353780881, 86), (datetime.date(2025, 7, 18), 0.8176314366501725, 61), (datetime.date(2025, 7, 19), 0.7530876310392668, 84), (datetime.date(2025, 7, 20), 0.796369377961058, 73), (datetime.date(2025, 7, 21), 0.8141609846790592, 80), (datetime.date(2025, 7, 22), 0.7976014877189722, 76), (datetime.date(2025, 7, 23), 0.8174303433996465, 85), (datetime.date(2025, 7, 24), 0.8229143360761951, 81), (datetime.date(2025, 7, 25), 0.8154535783664866, 83), (datetime.date(2025, 7, 26), 0.7975845923455142, 79), (datetime.date(2025, 7, 27), 0.8759212959477795, 77), (datetime.date(2025, 7, 28), 0.8936622390395179, 87), (datetime.date(2025, 7, 29), 0.8614784839953555, 86), (datetime.date(2025, 7, 30), 0.8497533000985666, 79), (datetime.date(2025, 7, 31), 0.8129164183141008, 92))}, 'quality_array': [['-6.4799305513991285', '01072025'], ['-6.999757374489088', '02072025'], ['-6.793443881142246', '03072025'], ['-6.540016607021323', '04072025'], ['-6.5499074253786995', '05072025'], ['-6.794035756829002', '06072025'], ['-6.652934874900338', '07072025'], ['-6.493498853781173', '08072025'], ['-6.424185959386435', '09072025'], ['-6.809106115136159', '10072025'], ['-6.649277351693132', '11072025'], ['-6.5610714171629425', '12072025'], ['-6.697783734257634', '13072025'], ['-6.691934858344514', '14072025'], ['-5.1512776178125375', '15072025'], ['-6.231939874771875', '16072025'], ['-6.82147519987909', '17072025'], ['-7.285996079755057', '18072025'], ['-6.988920670985546', '19072025'], ['-6.921691483830134', '20072025'], ['-6.243896137914432', '21072025'], ['-6.5330852158824735', '22072025'], ['-6.543949714756784', '23072025'], ['-6.860388852294578', '24072025'], ['-7.033762634718339', '25072025'], ['-6.932553072751547', '26072025'], ['-6.708224076132307', '27072025'], ['-6.685990554130721', '28072025'], ['-6.662418912222709', '29072025'], ['-6.7355513166111995', '30072025'], ['-6.509727829731283', '31072025']], 'number_of_batch': ((669,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.009181596510676193, 'nb_photo': 13741, 'list_port_cont': '24485163,24485418,24488660,24488739,24488824,24488883,24488921,24488959,24488997,24489026,24489108,24489136,24489174,24489221,24489243,24489278,24489347,24489407,24489443,24489470,24489552,24489633,24490374,24528081,24528187,24528382,24528540,24528604,24528613,24528846,24528966,24529035,24529146,24529154,24529439,24532524,24535769,24578578,24578621,24578756,24578832,24578930,24579002,24579035,24579170,24579204,24579273,24579345,24622931,24624480,24624615,24624668,24624777,24624827,24624931,24624975,24625140,24625253,24625317,24625371,24625449,24625950,24628074,24629180,24650125,24651139,24651166,24651262,24651372,24651385,24651441,24651491,24651576,24651669,24651680,24651804,24651860,24651877,24651935,24651971,24651984,24652048,24652080,24652117,24652149,24652207,24652800,24652997,24656828,24656943,24657204,24657452,24657935,24658280,24658310,24658511,24658538,24658684,24658724,24658771,24658798,24658844,24658871,24658945,24658973,24658992,24658999,24659081,24659170,24659195,24659302,24659405,24695513,2469564', 'assoc_port': '24485036:24489633,24485037:24490374,24485050:24489443,24485051:24489221,24485052:24489552,24485053:24489470,24485055:24489108,24485058:24485163,24485061:24489174,24485062:24489243,24485065:24489136,24485068:24489407,24485069:24488997,24485072:24489026,24485075:24489278,24485076:24488959,24485079:24488921,24485082:24488824,24485083:24488883,24485086:24488739,24485088:24488660,24485090:24485418,24488934:24489347,24527852:24529154,24527853:24529146,24527854:24529439,24527855:24529035,24527856:24528966,24527857:24528846,24527858:24528604,24527859:24528613,24527861:24528540,24527862:24528187,24527864:24528081,24527865:24528382,24532151:24532524,24535578:24535769,24578550:24579170,24578552:24579273,24578554:24579345,24578556:24579204,24578558:24578930,24578560:24579002,24578562:24578756,24578564:24579035,24578566:24578832,24578568:24578578,24578570:24578621,24622640:24625371,24622641:24625317,24622642:24625449,24622643:24625140,24622644:24625253,24622645:24624827,24622646:24624975,24622647:24624931,24622648:2462466', 'assoc_mat': '24485036:autre:4230:24489633,24485037:autre:4230:24490374,24485050:autre:4230:24489443,24485051:autre:4230:24489221,24485052:autre:4230:24489552,24485053:autre:4230:24489470,24485055:autre:4230:24489108,24485058:autre:4230:24485163,24485061:autre:4230:24489174,24485062:autre:4230:24489243,24485065:autre:4230:24489136,24485068:autre:4230:24489407,24485069:autre:4230:24488997,24485072:autre:4230:24489026,24485075:autre:4230:24489278,24485076:autre:4230:24488959,24485079:autre:4230:24488921,24485082:autre:4230:24488824,24485083:autre:4230:24488883,24485086:autre:4230:24488739,24485088:autre:4230:24488660,24485090:autre:4230:24485418,24488934:autre:4230:24489347,24527852:autre:4230:24529154,24527853:autre:4230:24529146,24527854:autre:4230:24529439,24527855:autre:4230:24529035,24527856:autre:4230:24528966,24527857:autre:4230:24528846,24527858:autre:4230:24528604,24527859:autre:4230:24528613,24527861:autre:4230:24528540,24527862:autre:4230:24528187,24527864:autre:4230:24528081,24527865:autre:4230:24528382,24532151:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02106182934526991, 'nb_photo': 45914, 'list_port_cont': '24485165,24485417,24488671,24488737,24488820,24488894,24488926,24488969,24489004,24489042,24489107,24489149,24489187,24489223,24489252,24489303,24489346,24489406,24489428,24489479,24489565,24489642,24490377,24528083,24528197,24528379,24528538,24528599,24528622,24528849,24528964,24529043,24529138,24529164,24529459,24532509,24535779,24578582,24578624,24578768,24578839,24578937,24579010,24579050,24579161,24579206,24579267,24579368,24622929,24624479,24624626,24624669,24624782,24624830,24624939,24624976,24625148,24625264,24625324,24625373,24625441,24625962,24628068,24629187,24650126,24651135,24651177,24651256,24651380,24651391,24651449,24651484,24651577,24651665,24651706,24651813,24651867,24651882,24651943,24651980,24651993,24652042,24652084,24652127,24652136,24652214,24652799,24652996,24656843,24656952,24657210,24657453,24657940,24658296,24658330,24658512,24658545,24658695,24658728,24658764,24658800,24658834,24658888,24658947,24658983,24659016,24659017,24659092,24659161,24659203,24659299,24659409,24695523,2469564', 'assoc_port': '24485036:24489642,24485037:24490377,24485050:24489428,24485051:24489223,24485052:24489565,24485053:24489479,24485055:24489107,24485058:24485165,24485061:24489187,24485062:24489252,24485065:24489149,24485068:24489406,24485069:24489004,24485072:24489042,24485075:24489303,24485076:24488969,24485079:24488926,24485082:24488820,24485083:24488894,24485086:24488737,24485088:24488671,24485090:24485417,24488934:24489346,24527852:24529164,24527853:24529138,24527854:24529459,24527855:24529043,24527856:24528964,24527857:24528849,24527858:24528599,24527859:24528622,24527861:24528538,24527862:24528197,24527864:24528083,24527865:24528379,24532151:24532509,24535578:24535779,24578550:24579161,24578552:24579267,24578554:24579368,24578556:24579206,24578558:24578937,24578560:24579010,24578562:24578768,24578564:24579050,24578566:24578839,24578568:24578582,24578570:24578624,24622640:24625373,24622641:24625324,24622642:24625441,24622643:24625148,24622644:24625264,24622645:24624830,24622646:24624976,24622647:24624939,24622648:2462466', 'assoc_mat': '24485036:carton:4230:24489642,24485037:carton:4230:24490377,24485050:carton:4230:24489428,24485051:carton:4230:24489223,24485052:carton:4230:24489565,24485053:carton:4230:24489479,24485055:carton:4230:24489107,24485058:carton:4230:24485165,24485061:carton:4230:24489187,24485062:carton:4230:24489252,24485065:carton:4230:24489149,24485068:carton:4230:24489406,24485069:carton:4230:24489004,24485072:carton:4230:24489042,24485075:carton:4230:24489303,24485076:carton:4230:24488969,24485079:carton:4230:24488926,24485082:carton:4230:24488820,24485083:carton:4230:24488894,24485086:carton:4230:24488737,24485088:carton:4230:24488671,24485090:carton:4230:24485417,24488934:carton:4230:24489346,24527852:carton:4230:24529164,24527853:carton:4230:24529138,24527854:carton:4230:24529459,24527855:carton:4230:24529043,24527856:carton:4230:24528964,24527857:carton:4230:24528849,24527858:carton:4230:24528599,24527859:carton:4230:24528622,24527861:carton:4230:24528538,24527862:carton:4230:24528197,24527864:carton:4230:24528083,2452'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0008759911615132322, 'nb_photo': 1318, 'list_port_cont': '24485412,24488813,24488892,24488916,24489030,24489143,24489249,24489286,24489333,24489394,24489432,24490367,24528189,24528395,24528533,24528603,24528959,24529144,24529156,24529451,24532515,24535770,24578571,24578608,24578831,24578935,24579048,24579200,24579265,24579369,24622917,24624490,24624610,24624656,24624779,24625141,24625256,24625309,24625372,24625426,24625958,24628069,24629183,24650137,24651130,24651179,24651261,24651371,24651395,24651440,24651489,24651670,24651690,24651812,24651857,24651871,24651977,24652056,24652141,24652202,24652805,24652993,24656840,24656950,24657457,24657928,24658274,24658842,24658981,24659082,24659159,24659201,24696053,24696216,24696262,24696486,24696519,24696657,24696723,24697052,24697225,24700086,24702241,24738745,24738959,24738989,24739159,24739172,24739234,24739375,24739412,24739449,24739515,24739559,24739600,24739670,24739715,24739793,24739867,24740012,24740255,24740376,24741341,24744292,24744885,24746115,24747111,24749589,24752336,24756016,24758449,24762462,24812461,2481252', 'assoc_port': '24485037:24490367,24485050:24489432,24485062:24489249,24485065:24489143,24485068:24489394,24485072:24489030,24485075:24489286,24485079:24488916,24485082:24488813,24485083:24488892,24485090:24485412,24488934:24489333,24527852:24529156,24527853:24529144,24527854:24529451,24527856:24528959,24527858:24528603,24527861:24528533,24527862:24528189,24527865:24528395,24532151:24532515,24535578:24535770,24578552:24579265,24578554:24579369,24578556:24579200,24578558:24578935,24578564:24579048,24578566:24578831,24578568:24578571,24578570:24578608,24622640:24625372,24622641:24625309,24622642:24625426,24622643:24625141,24622644:24625256,24622648:24624656,24622649:24624779,24622650:24629183,24622651:24624610,24622652:24624490,24622653:24622917,24625788:24625958,24627859:24628069,24650049:24652056,24650056:24651857,24650060:24651690,24650062:24650137,24650064:24651871,24650067:24651670,24650069:24652141,24650075:24652202,24650078:24651440,24650081:24651977,24650082:24651812,24650085:24651489,24650087:24651395,24650088:2465126', 'assoc_mat': '24485037:metal:4230:24490367,24485050:metal:4230:24489432,24485062:metal:4230:24489249,24485065:metal:4230:24489143,24485068:metal:4230:24489394,24485072:metal:4230:24489030,24485075:metal:4230:24489286,24485079:metal:4230:24488916,24485082:metal:4230:24488813,24485083:metal:4230:24488892,24485090:metal:4230:24485412,24488934:metal:4230:24489333,24527852:metal:4230:24529156,24527853:metal:4230:24529144,24527854:metal:4230:24529451,24527856:metal:4230:24528959,24527858:metal:4230:24528603,24527861:metal:4230:24528533,24527862:metal:4230:24528189,24527865:metal:4230:24528395,24532151:metal:4230:24532515,24535578:metal:4230:24535770,24578552:metal:4230:24579265,24578554:metal:4230:24579369,24578556:metal:4230:24579200,24578558:metal:4230:24578935,24578564:metal:4230:24579048,24578566:metal:4230:24578831,24578568:metal:4230:24578571,24578570:metal:4230:24578608,24622640:metal:4230:24625372,24622641:metal:4230:24625309,24622642:metal:4230:24625426,24622643:metal:4230:24625141,24622644:metal:4230:24625256,24622648:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1290268587873538, 'nb_photo': 297969, 'list_port_cont': '24485164,24485415,24488674,24488733,24488818,24488896,24488933,24488970,24488994,24489039,24489110,24489150,24489177,24489212,24489258,24489299,24489342,24489405,24489441,24489477,24489562,24489634,24490373,24528082,24528194,24528393,24528537,24528607,24528624,24528844,24528967,24529040,24529147,24529159,24529460,24532520,24535776,24578583,24578615,24578762,24578840,24578939,24579012,24579049,24579159,24579203,24579266,24579347,24622927,24624487,24624618,24624670,24624790,24624825,24624938,24624964,24625153,24625263,24625307,24625358,24625439,24625964,24628066,24629178,24650135,24651136,24651172,24651258,24651376,24651384,24651453,24651487,24651579,24651667,24651703,24651819,24651869,24651886,24651942,24651981,24651997,24652054,24652089,24652124,24652147,24652210,24652794,24652995,24656839,24656953,24657208,24657464,24657933,24658286,24658326,24658508,24658535,24658692,24658730,24658770,24658805,24658838,24658885,24658948,24658988,24659021,24659022,24659088,24659163,24659208,24659296,24659413,24695515,2469564', 'assoc_port': '24485036:24489634,24485037:24490373,24485050:24489441,24485051:24489212,24485052:24489562,24485053:24489477,24485055:24489110,24485058:24485164,24485061:24489177,24485062:24489258,24485065:24489150,24485068:24489405,24485069:24488994,24485072:24489039,24485075:24489299,24485076:24488970,24485079:24488933,24485082:24488818,24485083:24488896,24485086:24488733,24485088:24488674,24485090:24485415,24488934:24489342,24527852:24529159,24527853:24529147,24527854:24529460,24527855:24529040,24527856:24528967,24527857:24528844,24527858:24528607,24527859:24528624,24527861:24528537,24527862:24528194,24527864:24528082,24527865:24528393,24532151:24532520,24535578:24535776,24578550:24579159,24578552:24579266,24578554:24579347,24578556:24579203,24578558:24578939,24578560:24579012,24578562:24578762,24578564:24579049,24578566:24578840,24578568:24578583,24578570:24578615,24622640:24625358,24622641:24625307,24622642:24625439,24622643:24625153,24622644:24625263,24622645:24624825,24622646:24624964,24622647:24624938,24622648:2462467', 'assoc_mat': '24485036:papier:4230:24489634,24485037:papier:4230:24490373,24485050:papier:4230:24489441,24485051:papier:4230:24489212,24485052:papier:4230:24489562,24485053:papier:4230:24489477,24485055:papier:4230:24489110,24485058:papier:4230:24485164,24485061:papier:4230:24489177,24485062:papier:4230:24489258,24485065:papier:4230:24489150,24485068:papier:4230:24489405,24485069:papier:4230:24488994,24485072:papier:4230:24489039,24485075:papier:4230:24489299,24485076:papier:4230:24488970,24485079:papier:4230:24488933,24485082:papier:4230:24488818,24485083:papier:4230:24488896,24485086:papier:4230:24488733,24485088:papier:4230:24488674,24485090:papier:4230:24485415,24488934:papier:4230:24489342,24527852:papier:4230:24529159,24527853:papier:4230:24529147,24527854:papier:4230:24529460,24527855:papier:4230:24529040,24527856:papier:4230:24528967,24527857:papier:4230:24528844,24527858:papier:4230:24528607,24527859:papier:4230:24528624,24527861:papier:4230:24528537,24527862:papier:4230:24528194,24527864:papier:4230:24528082,2452'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022588931911694267, 'nb_photo': 928, 'list_port_cont': '24485416,24488925,24488971,24489043,24489147,24489294,24528601,24528841,24528975,24529143,24529443,24578588,24578766,24578836,24579279,24579363,24624622,24624671,24624820,24625150,24625261,24625325,24625368,24625447,24651132,24651171,24651254,24651367,24651399,24651451,24651493,24651568,24651658,24651809,24651883,24651941,24651973,24652135,24652148,24652204,24652806,24658294,24658548,24658733,24658985,24695894,24696057,24696227,24696274,24696662,24696735,24697159,24702245,24738749,24738834,24738965,24739161,24739388,24739419,24739454,24739554,24739596,24739677,24739721,24739797,24740020,24741524,24744293,24744518,24746109,24747118,24749602,24752340,24758451,24760697,24774181,24817759,24858157,24858802,24859236,24859618,24860307,24860593,24860646,24861016,24861051,24861104,24861210,24861326,24861444,24861466,24861670,24865072,24890377,24892100,24892229,24892301,24892346,24892389,24892427,24892465,24892509,24892551,24892588,24892613,24892675,24892868,24893032,24898056,24898419,24898890,24932714,24933553,2493375', 'assoc_port': '24485065:24489147,24485072:24489043,24485075:24489294,24485076:24488971,24485079:24488925,24485090:24485416,24527853:24529143,24527854:24529443,24527856:24528975,24527857:24528841,24527858:24528601,24578552:24579279,24578554:24579363,24578562:24578766,24578566:24578836,24578568:24578588,24622640:24625368,24622641:24625325,24622642:24625447,24622643:24625150,24622644:24625261,24622645:24624820,24622648:24624671,24622651:24624622,24650051:24651941,24650064:24651883,24650067:24651658,24650069:24652148,24650071:24651568,24650074:24652135,24650075:24652204,24650078:24651451,24650081:24651973,24650082:24651809,24650085:24651493,24650087:24651399,24650088:24651254,24650090:24651171,24650092:24651132,24650093:24651367,24652707:24652806,24656763:24658548,24656769:24658985,24656783:24658733,24656797:24658294,24695408:24697159,24695422:24696735,24695427:24696662,24695428:24696227,24695429:24696274,24695431:24696057,24695445:24695894,24702030:24702245,24736976:24740020,24736978:24739797,24736980:24739554,24736982:2473967', 'assoc_mat': '24485065:pehd:4230:24489147,24485072:pehd:4230:24489043,24485075:pehd:4230:24489294,24485076:pehd:4230:24488971,24485079:pehd:4230:24488925,24485090:pehd:4230:24485416,24527853:pehd:4230:24529143,24527854:pehd:4230:24529443,24527856:pehd:4230:24528975,24527857:pehd:4230:24528841,24527858:pehd:4230:24528601,24578552:pehd:4230:24579279,24578554:pehd:4230:24579363,24578562:pehd:4230:24578766,24578566:pehd:4230:24578836,24578568:pehd:4230:24578588,24622640:pehd:4230:24625368,24622641:pehd:4230:24625325,24622642:pehd:4230:24625447,24622643:pehd:4230:24625150,24622644:pehd:4230:24625261,24622645:pehd:4230:24624820,24622648:pehd:4230:24624671,24622651:pehd:4230:24624622,24650051:pehd:4230:24651941,24650064:pehd:4230:24651883,24650067:pehd:4230:24651658,24650069:pehd:4230:24652148,24650071:pehd:4230:24651568,24650074:pehd:4230:24652135,24650075:pehd:4230:24652204,24650078:pehd:4230:24651451,24650081:pehd:4230:24651973,24650082:pehd:4230:24651809,24650085:pehd:4230:24651493,24650087:pehd:4230:24651399,24650088:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.022090885106705264, 'nb_photo': 27292, 'list_port_cont': '24485157,24485420,24488665,24488729,24488822,24488895,24488928,24488961,24489003,24489041,24489115,24489145,24489184,24489216,24489244,24489295,24489340,24489400,24489437,24489469,24489553,24489638,24490379,24528077,24528196,24528391,24528543,24528595,24528611,24528843,24528974,24529031,24529137,24529167,24529458,24532518,24535775,24578586,24578617,24578786,24578833,24578928,24579011,24579043,24579166,24579207,24579275,24579365,24622923,24624491,24624613,24624663,24624785,24624821,24624932,24624972,24625149,24625265,24625315,24625374,24625446,24625959,24628072,24629186,24650136,24651140,24651178,24651257,24651382,24651394,24651454,24651488,24651578,24651664,24651700,24651810,24651861,24651881,24651930,24651966,24651987,24652051,24652091,24652125,24652142,24652212,24652803,24652990,24656827,24656951,24657199,24657461,24657934,24658300,24658306,24658516,24658537,24658689,24658729,24658766,24658803,24658835,24658883,24658949,24658984,24658995,24659012,24659091,24659169,24659196,24659293,24659410,24695528,2469564', 'assoc_port': '24485036:24489638,24485037:24490379,24485050:24489437,24485051:24489216,24485052:24489553,24485053:24489469,24485055:24489115,24485058:24485157,24485061:24489184,24485062:24489244,24485065:24489145,24485068:24489400,24485069:24489003,24485072:24489041,24485075:24489295,24485076:24488961,24485079:24488928,24485082:24488822,24485083:24488895,24485086:24488729,24485088:24488665,24485090:24485420,24488934:24489340,24527852:24529167,24527853:24529137,24527854:24529458,24527855:24529031,24527856:24528974,24527857:24528843,24527858:24528595,24527859:24528611,24527861:24528543,24527862:24528196,24527864:24528077,24527865:24528391,24532151:24532518,24535578:24535775,24578550:24579166,24578552:24579275,24578554:24579365,24578556:24579207,24578558:24578928,24578560:24579011,24578562:24578786,24578564:24579043,24578566:24578833,24578568:24578586,24578570:24578617,24622640:24625374,24622641:24625315,24622642:24625446,24622643:24625149,24622644:24625265,24622645:24624821,24622646:24624972,24622647:24624932,24622648:2462466', 'assoc_mat': '24485036:pet_clair:4230:24489638,24485037:pet_clair:4230:24490379,24485050:pet_clair:4230:24489437,24485051:pet_clair:4230:24489216,24485052:pet_clair:4230:24489553,24485053:pet_clair:4230:24489469,24485055:pet_clair:4230:24489115,24485058:pet_clair:4230:24485157,24485061:pet_clair:4230:24489184,24485062:pet_clair:4230:24489244,24485065:pet_clair:4230:24489145,24485068:pet_clair:4230:24489400,24485069:pet_clair:4230:24489003,24485072:pet_clair:4230:24489041,24485075:pet_clair:4230:24489295,24485076:pet_clair:4230:24488961,24485079:pet_clair:4230:24488928,24485082:pet_clair:4230:24488822,24485083:pet_clair:4230:24488895,24485086:pet_clair:4230:24488729,24485088:pet_clair:4230:24488665,24485090:pet_clair:4230:24485420,24488934:pet_clair:4230:24489340,24527852:pet_clair:4230:24529167,24527853:pet_clair:4230:24529137,24527854:pet_clair:4230:24529458,24527855:pet_clair:4230:24529031,24527856:pet_clair:4230:24528974,24527857:pet_clair:4230:24528843,24527858:pet_clair:4230:24528595,24527859:pet_clair:4230:24528611,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018554390726249126, 'nb_photo': 692, 'list_port_cont': '24488814,24488966,24489029,24489146,24489185,24489259,24489339,24489404,24489466,24489561,24490378,24528185,24528529,24528600,24528625,24528851,24529457,24578584,24578838,24579042,24579272,24622911,24624486,24624822,24624936,24625145,24625251,24625319,24625366,24625442,24629182,24651134,24651176,24651259,24651379,24651396,24651452,24651496,24651572,24651660,24651815,24651856,24651878,24651938,24651972,24651995,24652047,24652130,24652150,24652213,24652804,24652998,24656954,24657206,24659294,24696040,24696065,24696222,24696264,24696439,24696668,24696879,24697229,24737083,24739154,24739177,24739384,24739562,24739598,24739668,24739727,24739863,24740017,24741529,24744297,24744882,24746118,24747116,24749598,24752348,24756026,24758457,24760702,24774178,24812328,24817773,24858153,24858798,24859613,24859874,24860020,24860314,24861010,24861048,24861327,24861449,24861579,24861683,24865080,24890384,24891124,24891278,24891981,24892088,24892226,24892262,24892311,24892345,24892376,24892438,24892543,24892584,24892615,2489266', 'assoc_port': '24485037:24490378,24485052:24489561,24485053:24489466,24485061:24489185,24485062:24489259,24485065:24489146,24485068:24489404,24485072:24489029,24485076:24488966,24485082:24488814,24488934:24489339,24527854:24529457,24527857:24528851,24527858:24528600,24527859:24528625,24527861:24528529,24527862:24528185,24578552:24579272,24578564:24579042,24578566:24578838,24578568:24578584,24622640:24625366,24622641:24625319,24622642:24625442,24622643:24625145,24622644:24625251,24622645:24624822,24622647:24624936,24622650:24629182,24622652:24624486,24622653:24622911,24650049:24652047,24650051:24651938,24650056:24651856,24650057:24651995,24650064:24651878,24650067:24651660,24650069:24652150,24650071:24651572,24650074:24652130,24650075:24652213,24650078:24651452,24650081:24651972,24650082:24651815,24650085:24651496,24650087:24651396,24650088:24651259,24650090:24651176,24650092:24651134,24650093:24651379,24652707:24652804,24652930:24652998,24656760:24657206,24656799:24656954,24659240:24659294,24695412:24696879,24695417:2469722', 'assoc_mat': '24485037:pet_fonce:4230:24490378,24485052:pet_fonce:4230:24489561,24485053:pet_fonce:4230:24489466,24485061:pet_fonce:4230:24489185,24485062:pet_fonce:4230:24489259,24485065:pet_fonce:4230:24489146,24485068:pet_fonce:4230:24489404,24485072:pet_fonce:4230:24489029,24485076:pet_fonce:4230:24488966,24485082:pet_fonce:4230:24488814,24488934:pet_fonce:4230:24489339,24527854:pet_fonce:4230:24529457,24527857:pet_fonce:4230:24528851,24527858:pet_fonce:4230:24528600,24527859:pet_fonce:4230:24528625,24527861:pet_fonce:4230:24528529,24527862:pet_fonce:4230:24528185,24578552:pet_fonce:4230:24579272,24578564:pet_fonce:4230:24579042,24578566:pet_fonce:4230:24578838,24578568:pet_fonce:4230:24578584,24622640:pet_fonce:4230:24625366,24622641:pet_fonce:4230:24625319,24622642:pet_fonce:4230:24625442,24622643:pet_fonce:4230:24625145,24622644:pet_fonce:4230:24625251,24622645:pet_fonce:4230:24624822,24622647:pet_fonce:4230:24624936,24622650:pet_fonce:4230:24629182,24622652:pet_fonce:4230:24624486,24622653:pet_fonce:4230:24622911,2'}), 'main_stat': {'nb_photos': 2330}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-07', 0.8295730889874583),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 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=4849 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= 4849 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=4849 # 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': ((2330,),), 'unwanted_material_monthly_percentage': ((0.8295730889874583,),), 'material_repartition': (('incineration', 2330),), 'material_dict': {'incineration': 2330}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 7, 1), 0.8617837796596023, 83), (datetime.date(2025, 7, 2), 0.850816574618458, 49), (datetime.date(2025, 7, 3), 0.8387598720094017, 39), (datetime.date(2025, 7, 4), 0.8475461769220981, 61), (datetime.date(2025, 7, 5), 0.7870220534331659, 88), (datetime.date(2025, 7, 6), 0.8454664364139345, 86), (datetime.date(2025, 7, 7), 0.8385985969113773, 88), (datetime.date(2025, 7, 8), 0.8546688888042224, 95), (datetime.date(2025, 7, 9), 0.8457530684087399, 64), (datetime.date(2025, 7, 10), 0.8157554788384099, 50), (datetime.date(2025, 7, 11), 0.8133564251818424, 88), (datetime.date(2025, 7, 12), 0.7993388930091709, 81), (datetime.date(2025, 7, 13), 0.8296604348256547, 84), (datetime.date(2025, 7, 14), 0.8740011866099884, 75), (datetime.date(2025, 7, 15), 0.8350646868384015, 54), (datetime.date(2025, 7, 16), 0.8486622521949654, 36), (datetime.date(2025, 7, 17), 0.8131007353780881, 86), (datetime.date(2025, 7, 18), 0.8176314366501725, 61), (datetime.date(2025, 7, 19), 0.7530876310392668, 84), (datetime.date(2025, 7, 20), 0.796369377961058, 73), (datetime.date(2025, 7, 21), 0.8141609846790592, 80), (datetime.date(2025, 7, 22), 0.7976014877189722, 76), (datetime.date(2025, 7, 23), 0.8174303433996465, 85), (datetime.date(2025, 7, 24), 0.8229143360761951, 81), (datetime.date(2025, 7, 25), 0.8154535783664866, 83), (datetime.date(2025, 7, 26), 0.7975845923455142, 79), (datetime.date(2025, 7, 27), 0.8759212959477795, 77), (datetime.date(2025, 7, 28), 0.8936622390395179, 87), (datetime.date(2025, 7, 29), 0.8614784839953555, 86), (datetime.date(2025, 7, 30), 0.8497533000985666, 79), (datetime.date(2025, 7, 31), 0.8129164183141008, 92)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 7, 1), 0.8617837796596023, 83), (datetime.date(2025, 7, 2), 0.850816574618458, 49), (datetime.date(2025, 7, 3), 0.8387598720094017, 39), (datetime.date(2025, 7, 4), 0.8475461769220981, 61), (datetime.date(2025, 7, 5), 0.7870220534331659, 88), (datetime.date(2025, 7, 6), 0.8454664364139345, 86), (datetime.date(2025, 7, 7), 0.8385985969113773, 88), (datetime.date(2025, 7, 8), 0.8546688888042224, 95), (datetime.date(2025, 7, 9), 0.8457530684087399, 64), (datetime.date(2025, 7, 10), 0.8157554788384099, 50), (datetime.date(2025, 7, 11), 0.8133564251818424, 88), (datetime.date(2025, 7, 12), 0.7993388930091709, 81), (datetime.date(2025, 7, 13), 0.8296604348256547, 84), (datetime.date(2025, 7, 14), 0.8740011866099884, 75), (datetime.date(2025, 7, 15), 0.8350646868384015, 54), (datetime.date(2025, 7, 16), 0.8486622521949654, 36), (datetime.date(2025, 7, 17), 0.8131007353780881, 86), (datetime.date(2025, 7, 18), 0.8176314366501725, 61), (datetime.date(2025, 7, 19), 0.7530876310392668, 84), (datetime.date(2025, 7, 20), 0.796369377961058, 73), (datetime.date(2025, 7, 21), 0.8141609846790592, 80), (datetime.date(2025, 7, 22), 0.7976014877189722, 76), (datetime.date(2025, 7, 23), 0.8174303433996465, 85), (datetime.date(2025, 7, 24), 0.8229143360761951, 81), (datetime.date(2025, 7, 25), 0.8154535783664866, 83), (datetime.date(2025, 7, 26), 0.7975845923455142, 79), (datetime.date(2025, 7, 27), 0.8759212959477795, 77), (datetime.date(2025, 7, 28), 0.8936622390395179, 87), (datetime.date(2025, 7, 29), 0.8614784839953555, 86), (datetime.date(2025, 7, 30), 0.8497533000985666, 79), (datetime.date(2025, 7, 31), 0.8129164183141008, 92))}, 'quality_array': [['-6.4799305513991285', '01072025'], ['-6.999757374489088', '02072025'], ['-6.793443881142246', '03072025'], ['-6.540016607021323', '04072025'], ['-6.5499074253786995', '05072025'], ['-6.794035756829002', '06072025'], ['-6.652934874900338', '07072025'], ['-6.493498853781173', '08072025'], ['-6.424185959386435', '09072025'], ['-6.809106115136159', '10072025'], ['-6.649277351693132', '11072025'], ['-6.5610714171629425', '12072025'], ['-6.697783734257634', '13072025'], ['-6.691934858344514', '14072025'], ['-5.1512776178125375', '15072025'], ['-6.231939874771875', '16072025'], ['-6.82147519987909', '17072025'], ['-7.285996079755057', '18072025'], ['-6.988920670985546', '19072025'], ['-6.921691483830134', '20072025'], ['-6.243896137914432', '21072025'], ['-6.5330852158824735', '22072025'], ['-6.543949714756784', '23072025'], ['-6.860388852294578', '24072025'], ['-7.033762634718339', '25072025'], ['-6.932553072751547', '26072025'], ['-6.708224076132307', '27072025'], ['-6.685990554130721', '28072025'], ['-6.662418912222709', '29072025'], ['-6.7355513166111995', '30072025'], ['-6.509727829731283', '31072025']], 'number_of_batch': ((669,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.009181596510676193, 'nb_photo': 13741, 'list_port_cont': '24485163,24485418,24488660,24488739,24488824,24488883,24488921,24488959,24488997,24489026,24489108,24489136,24489174,24489221,24489243,24489278,24489347,24489407,24489443,24489470,24489552,24489633,24490374,24528081,24528187,24528382,24528540,24528604,24528613,24528846,24528966,24529035,24529146,24529154,24529439,24532524,24535769,24578578,24578621,24578756,24578832,24578930,24579002,24579035,24579170,24579204,24579273,24579345,24622931,24624480,24624615,24624668,24624777,24624827,24624931,24624975,24625140,24625253,24625317,24625371,24625449,24625950,24628074,24629180,24650125,24651139,24651166,24651262,24651372,24651385,24651441,24651491,24651576,24651669,24651680,24651804,24651860,24651877,24651935,24651971,24651984,24652048,24652080,24652117,24652149,24652207,24652800,24652997,24656828,24656943,24657204,24657452,24657935,24658280,24658310,24658511,24658538,24658684,24658724,24658771,24658798,24658844,24658871,24658945,24658973,24658992,24658999,24659081,24659170,24659195,24659302,24659405,24695513,2469564', 'assoc_port': '24485036:24489633,24485037:24490374,24485050:24489443,24485051:24489221,24485052:24489552,24485053:24489470,24485055:24489108,24485058:24485163,24485061:24489174,24485062:24489243,24485065:24489136,24485068:24489407,24485069:24488997,24485072:24489026,24485075:24489278,24485076:24488959,24485079:24488921,24485082:24488824,24485083:24488883,24485086:24488739,24485088:24488660,24485090:24485418,24488934:24489347,24527852:24529154,24527853:24529146,24527854:24529439,24527855:24529035,24527856:24528966,24527857:24528846,24527858:24528604,24527859:24528613,24527861:24528540,24527862:24528187,24527864:24528081,24527865:24528382,24532151:24532524,24535578:24535769,24578550:24579170,24578552:24579273,24578554:24579345,24578556:24579204,24578558:24578930,24578560:24579002,24578562:24578756,24578564:24579035,24578566:24578832,24578568:24578578,24578570:24578621,24622640:24625371,24622641:24625317,24622642:24625449,24622643:24625140,24622644:24625253,24622645:24624827,24622646:24624975,24622647:24624931,24622648:2462466', 'assoc_mat': '24485036:autre:4230:24489633,24485037:autre:4230:24490374,24485050:autre:4230:24489443,24485051:autre:4230:24489221,24485052:autre:4230:24489552,24485053:autre:4230:24489470,24485055:autre:4230:24489108,24485058:autre:4230:24485163,24485061:autre:4230:24489174,24485062:autre:4230:24489243,24485065:autre:4230:24489136,24485068:autre:4230:24489407,24485069:autre:4230:24488997,24485072:autre:4230:24489026,24485075:autre:4230:24489278,24485076:autre:4230:24488959,24485079:autre:4230:24488921,24485082:autre:4230:24488824,24485083:autre:4230:24488883,24485086:autre:4230:24488739,24485088:autre:4230:24488660,24485090:autre:4230:24485418,24488934:autre:4230:24489347,24527852:autre:4230:24529154,24527853:autre:4230:24529146,24527854:autre:4230:24529439,24527855:autre:4230:24529035,24527856:autre:4230:24528966,24527857:autre:4230:24528846,24527858:autre:4230:24528604,24527859:autre:4230:24528613,24527861:autre:4230:24528540,24527862:autre:4230:24528187,24527864:autre:4230:24528081,24527865:autre:4230:24528382,24532151:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02106182934526991, 'nb_photo': 45914, 'list_port_cont': '24485165,24485417,24488671,24488737,24488820,24488894,24488926,24488969,24489004,24489042,24489107,24489149,24489187,24489223,24489252,24489303,24489346,24489406,24489428,24489479,24489565,24489642,24490377,24528083,24528197,24528379,24528538,24528599,24528622,24528849,24528964,24529043,24529138,24529164,24529459,24532509,24535779,24578582,24578624,24578768,24578839,24578937,24579010,24579050,24579161,24579206,24579267,24579368,24622929,24624479,24624626,24624669,24624782,24624830,24624939,24624976,24625148,24625264,24625324,24625373,24625441,24625962,24628068,24629187,24650126,24651135,24651177,24651256,24651380,24651391,24651449,24651484,24651577,24651665,24651706,24651813,24651867,24651882,24651943,24651980,24651993,24652042,24652084,24652127,24652136,24652214,24652799,24652996,24656843,24656952,24657210,24657453,24657940,24658296,24658330,24658512,24658545,24658695,24658728,24658764,24658800,24658834,24658888,24658947,24658983,24659016,24659017,24659092,24659161,24659203,24659299,24659409,24695523,2469564', 'assoc_port': '24485036:24489642,24485037:24490377,24485050:24489428,24485051:24489223,24485052:24489565,24485053:24489479,24485055:24489107,24485058:24485165,24485061:24489187,24485062:24489252,24485065:24489149,24485068:24489406,24485069:24489004,24485072:24489042,24485075:24489303,24485076:24488969,24485079:24488926,24485082:24488820,24485083:24488894,24485086:24488737,24485088:24488671,24485090:24485417,24488934:24489346,24527852:24529164,24527853:24529138,24527854:24529459,24527855:24529043,24527856:24528964,24527857:24528849,24527858:24528599,24527859:24528622,24527861:24528538,24527862:24528197,24527864:24528083,24527865:24528379,24532151:24532509,24535578:24535779,24578550:24579161,24578552:24579267,24578554:24579368,24578556:24579206,24578558:24578937,24578560:24579010,24578562:24578768,24578564:24579050,24578566:24578839,24578568:24578582,24578570:24578624,24622640:24625373,24622641:24625324,24622642:24625441,24622643:24625148,24622644:24625264,24622645:24624830,24622646:24624976,24622647:24624939,24622648:2462466', 'assoc_mat': '24485036:carton:4230:24489642,24485037:carton:4230:24490377,24485050:carton:4230:24489428,24485051:carton:4230:24489223,24485052:carton:4230:24489565,24485053:carton:4230:24489479,24485055:carton:4230:24489107,24485058:carton:4230:24485165,24485061:carton:4230:24489187,24485062:carton:4230:24489252,24485065:carton:4230:24489149,24485068:carton:4230:24489406,24485069:carton:4230:24489004,24485072:carton:4230:24489042,24485075:carton:4230:24489303,24485076:carton:4230:24488969,24485079:carton:4230:24488926,24485082:carton:4230:24488820,24485083:carton:4230:24488894,24485086:carton:4230:24488737,24485088:carton:4230:24488671,24485090:carton:4230:24485417,24488934:carton:4230:24489346,24527852:carton:4230:24529164,24527853:carton:4230:24529138,24527854:carton:4230:24529459,24527855:carton:4230:24529043,24527856:carton:4230:24528964,24527857:carton:4230:24528849,24527858:carton:4230:24528599,24527859:carton:4230:24528622,24527861:carton:4230:24528538,24527862:carton:4230:24528197,24527864:carton:4230:24528083,2452'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0008759911615132322, 'nb_photo': 1318, 'list_port_cont': '24485412,24488813,24488892,24488916,24489030,24489143,24489249,24489286,24489333,24489394,24489432,24490367,24528189,24528395,24528533,24528603,24528959,24529144,24529156,24529451,24532515,24535770,24578571,24578608,24578831,24578935,24579048,24579200,24579265,24579369,24622917,24624490,24624610,24624656,24624779,24625141,24625256,24625309,24625372,24625426,24625958,24628069,24629183,24650137,24651130,24651179,24651261,24651371,24651395,24651440,24651489,24651670,24651690,24651812,24651857,24651871,24651977,24652056,24652141,24652202,24652805,24652993,24656840,24656950,24657457,24657928,24658274,24658842,24658981,24659082,24659159,24659201,24696053,24696216,24696262,24696486,24696519,24696657,24696723,24697052,24697225,24700086,24702241,24738745,24738959,24738989,24739159,24739172,24739234,24739375,24739412,24739449,24739515,24739559,24739600,24739670,24739715,24739793,24739867,24740012,24740255,24740376,24741341,24744292,24744885,24746115,24747111,24749589,24752336,24756016,24758449,24762462,24812461,2481252', 'assoc_port': '24485037:24490367,24485050:24489432,24485062:24489249,24485065:24489143,24485068:24489394,24485072:24489030,24485075:24489286,24485079:24488916,24485082:24488813,24485083:24488892,24485090:24485412,24488934:24489333,24527852:24529156,24527853:24529144,24527854:24529451,24527856:24528959,24527858:24528603,24527861:24528533,24527862:24528189,24527865:24528395,24532151:24532515,24535578:24535770,24578552:24579265,24578554:24579369,24578556:24579200,24578558:24578935,24578564:24579048,24578566:24578831,24578568:24578571,24578570:24578608,24622640:24625372,24622641:24625309,24622642:24625426,24622643:24625141,24622644:24625256,24622648:24624656,24622649:24624779,24622650:24629183,24622651:24624610,24622652:24624490,24622653:24622917,24625788:24625958,24627859:24628069,24650049:24652056,24650056:24651857,24650060:24651690,24650062:24650137,24650064:24651871,24650067:24651670,24650069:24652141,24650075:24652202,24650078:24651440,24650081:24651977,24650082:24651812,24650085:24651489,24650087:24651395,24650088:2465126', 'assoc_mat': '24485037:metal:4230:24490367,24485050:metal:4230:24489432,24485062:metal:4230:24489249,24485065:metal:4230:24489143,24485068:metal:4230:24489394,24485072:metal:4230:24489030,24485075:metal:4230:24489286,24485079:metal:4230:24488916,24485082:metal:4230:24488813,24485083:metal:4230:24488892,24485090:metal:4230:24485412,24488934:metal:4230:24489333,24527852:metal:4230:24529156,24527853:metal:4230:24529144,24527854:metal:4230:24529451,24527856:metal:4230:24528959,24527858:metal:4230:24528603,24527861:metal:4230:24528533,24527862:metal:4230:24528189,24527865:metal:4230:24528395,24532151:metal:4230:24532515,24535578:metal:4230:24535770,24578552:metal:4230:24579265,24578554:metal:4230:24579369,24578556:metal:4230:24579200,24578558:metal:4230:24578935,24578564:metal:4230:24579048,24578566:metal:4230:24578831,24578568:metal:4230:24578571,24578570:metal:4230:24578608,24622640:metal:4230:24625372,24622641:metal:4230:24625309,24622642:metal:4230:24625426,24622643:metal:4230:24625141,24622644:metal:4230:24625256,24622648:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1290268587873538, 'nb_photo': 297969, 'list_port_cont': '24485164,24485415,24488674,24488733,24488818,24488896,24488933,24488970,24488994,24489039,24489110,24489150,24489177,24489212,24489258,24489299,24489342,24489405,24489441,24489477,24489562,24489634,24490373,24528082,24528194,24528393,24528537,24528607,24528624,24528844,24528967,24529040,24529147,24529159,24529460,24532520,24535776,24578583,24578615,24578762,24578840,24578939,24579012,24579049,24579159,24579203,24579266,24579347,24622927,24624487,24624618,24624670,24624790,24624825,24624938,24624964,24625153,24625263,24625307,24625358,24625439,24625964,24628066,24629178,24650135,24651136,24651172,24651258,24651376,24651384,24651453,24651487,24651579,24651667,24651703,24651819,24651869,24651886,24651942,24651981,24651997,24652054,24652089,24652124,24652147,24652210,24652794,24652995,24656839,24656953,24657208,24657464,24657933,24658286,24658326,24658508,24658535,24658692,24658730,24658770,24658805,24658838,24658885,24658948,24658988,24659021,24659022,24659088,24659163,24659208,24659296,24659413,24695515,2469564', 'assoc_port': '24485036:24489634,24485037:24490373,24485050:24489441,24485051:24489212,24485052:24489562,24485053:24489477,24485055:24489110,24485058:24485164,24485061:24489177,24485062:24489258,24485065:24489150,24485068:24489405,24485069:24488994,24485072:24489039,24485075:24489299,24485076:24488970,24485079:24488933,24485082:24488818,24485083:24488896,24485086:24488733,24485088:24488674,24485090:24485415,24488934:24489342,24527852:24529159,24527853:24529147,24527854:24529460,24527855:24529040,24527856:24528967,24527857:24528844,24527858:24528607,24527859:24528624,24527861:24528537,24527862:24528194,24527864:24528082,24527865:24528393,24532151:24532520,24535578:24535776,24578550:24579159,24578552:24579266,24578554:24579347,24578556:24579203,24578558:24578939,24578560:24579012,24578562:24578762,24578564:24579049,24578566:24578840,24578568:24578583,24578570:24578615,24622640:24625358,24622641:24625307,24622642:24625439,24622643:24625153,24622644:24625263,24622645:24624825,24622646:24624964,24622647:24624938,24622648:2462467', 'assoc_mat': '24485036:papier:4230:24489634,24485037:papier:4230:24490373,24485050:papier:4230:24489441,24485051:papier:4230:24489212,24485052:papier:4230:24489562,24485053:papier:4230:24489477,24485055:papier:4230:24489110,24485058:papier:4230:24485164,24485061:papier:4230:24489177,24485062:papier:4230:24489258,24485065:papier:4230:24489150,24485068:papier:4230:24489405,24485069:papier:4230:24488994,24485072:papier:4230:24489039,24485075:papier:4230:24489299,24485076:papier:4230:24488970,24485079:papier:4230:24488933,24485082:papier:4230:24488818,24485083:papier:4230:24488896,24485086:papier:4230:24488733,24485088:papier:4230:24488674,24485090:papier:4230:24485415,24488934:papier:4230:24489342,24527852:papier:4230:24529159,24527853:papier:4230:24529147,24527854:papier:4230:24529460,24527855:papier:4230:24529040,24527856:papier:4230:24528967,24527857:papier:4230:24528844,24527858:papier:4230:24528607,24527859:papier:4230:24528624,24527861:papier:4230:24528537,24527862:papier:4230:24528194,24527864:papier:4230:24528082,2452'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022588931911694267, 'nb_photo': 928, 'list_port_cont': '24485416,24488925,24488971,24489043,24489147,24489294,24528601,24528841,24528975,24529143,24529443,24578588,24578766,24578836,24579279,24579363,24624622,24624671,24624820,24625150,24625261,24625325,24625368,24625447,24651132,24651171,24651254,24651367,24651399,24651451,24651493,24651568,24651658,24651809,24651883,24651941,24651973,24652135,24652148,24652204,24652806,24658294,24658548,24658733,24658985,24695894,24696057,24696227,24696274,24696662,24696735,24697159,24702245,24738749,24738834,24738965,24739161,24739388,24739419,24739454,24739554,24739596,24739677,24739721,24739797,24740020,24741524,24744293,24744518,24746109,24747118,24749602,24752340,24758451,24760697,24774181,24817759,24858157,24858802,24859236,24859618,24860307,24860593,24860646,24861016,24861051,24861104,24861210,24861326,24861444,24861466,24861670,24865072,24890377,24892100,24892229,24892301,24892346,24892389,24892427,24892465,24892509,24892551,24892588,24892613,24892675,24892868,24893032,24898056,24898419,24898890,24932714,24933553,2493375', 'assoc_port': '24485065:24489147,24485072:24489043,24485075:24489294,24485076:24488971,24485079:24488925,24485090:24485416,24527853:24529143,24527854:24529443,24527856:24528975,24527857:24528841,24527858:24528601,24578552:24579279,24578554:24579363,24578562:24578766,24578566:24578836,24578568:24578588,24622640:24625368,24622641:24625325,24622642:24625447,24622643:24625150,24622644:24625261,24622645:24624820,24622648:24624671,24622651:24624622,24650051:24651941,24650064:24651883,24650067:24651658,24650069:24652148,24650071:24651568,24650074:24652135,24650075:24652204,24650078:24651451,24650081:24651973,24650082:24651809,24650085:24651493,24650087:24651399,24650088:24651254,24650090:24651171,24650092:24651132,24650093:24651367,24652707:24652806,24656763:24658548,24656769:24658985,24656783:24658733,24656797:24658294,24695408:24697159,24695422:24696735,24695427:24696662,24695428:24696227,24695429:24696274,24695431:24696057,24695445:24695894,24702030:24702245,24736976:24740020,24736978:24739797,24736980:24739554,24736982:2473967', 'assoc_mat': '24485065:pehd:4230:24489147,24485072:pehd:4230:24489043,24485075:pehd:4230:24489294,24485076:pehd:4230:24488971,24485079:pehd:4230:24488925,24485090:pehd:4230:24485416,24527853:pehd:4230:24529143,24527854:pehd:4230:24529443,24527856:pehd:4230:24528975,24527857:pehd:4230:24528841,24527858:pehd:4230:24528601,24578552:pehd:4230:24579279,24578554:pehd:4230:24579363,24578562:pehd:4230:24578766,24578566:pehd:4230:24578836,24578568:pehd:4230:24578588,24622640:pehd:4230:24625368,24622641:pehd:4230:24625325,24622642:pehd:4230:24625447,24622643:pehd:4230:24625150,24622644:pehd:4230:24625261,24622645:pehd:4230:24624820,24622648:pehd:4230:24624671,24622651:pehd:4230:24624622,24650051:pehd:4230:24651941,24650064:pehd:4230:24651883,24650067:pehd:4230:24651658,24650069:pehd:4230:24652148,24650071:pehd:4230:24651568,24650074:pehd:4230:24652135,24650075:pehd:4230:24652204,24650078:pehd:4230:24651451,24650081:pehd:4230:24651973,24650082:pehd:4230:24651809,24650085:pehd:4230:24651493,24650087:pehd:4230:24651399,24650088:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.022090885106705264, 'nb_photo': 27292, 'list_port_cont': '24485157,24485420,24488665,24488729,24488822,24488895,24488928,24488961,24489003,24489041,24489115,24489145,24489184,24489216,24489244,24489295,24489340,24489400,24489437,24489469,24489553,24489638,24490379,24528077,24528196,24528391,24528543,24528595,24528611,24528843,24528974,24529031,24529137,24529167,24529458,24532518,24535775,24578586,24578617,24578786,24578833,24578928,24579011,24579043,24579166,24579207,24579275,24579365,24622923,24624491,24624613,24624663,24624785,24624821,24624932,24624972,24625149,24625265,24625315,24625374,24625446,24625959,24628072,24629186,24650136,24651140,24651178,24651257,24651382,24651394,24651454,24651488,24651578,24651664,24651700,24651810,24651861,24651881,24651930,24651966,24651987,24652051,24652091,24652125,24652142,24652212,24652803,24652990,24656827,24656951,24657199,24657461,24657934,24658300,24658306,24658516,24658537,24658689,24658729,24658766,24658803,24658835,24658883,24658949,24658984,24658995,24659012,24659091,24659169,24659196,24659293,24659410,24695528,2469564', 'assoc_port': '24485036:24489638,24485037:24490379,24485050:24489437,24485051:24489216,24485052:24489553,24485053:24489469,24485055:24489115,24485058:24485157,24485061:24489184,24485062:24489244,24485065:24489145,24485068:24489400,24485069:24489003,24485072:24489041,24485075:24489295,24485076:24488961,24485079:24488928,24485082:24488822,24485083:24488895,24485086:24488729,24485088:24488665,24485090:24485420,24488934:24489340,24527852:24529167,24527853:24529137,24527854:24529458,24527855:24529031,24527856:24528974,24527857:24528843,24527858:24528595,24527859:24528611,24527861:24528543,24527862:24528196,24527864:24528077,24527865:24528391,24532151:24532518,24535578:24535775,24578550:24579166,24578552:24579275,24578554:24579365,24578556:24579207,24578558:24578928,24578560:24579011,24578562:24578786,24578564:24579043,24578566:24578833,24578568:24578586,24578570:24578617,24622640:24625374,24622641:24625315,24622642:24625446,24622643:24625149,24622644:24625265,24622645:24624821,24622646:24624972,24622647:24624932,24622648:2462466', 'assoc_mat': '24485036:pet_clair:4230:24489638,24485037:pet_clair:4230:24490379,24485050:pet_clair:4230:24489437,24485051:pet_clair:4230:24489216,24485052:pet_clair:4230:24489553,24485053:pet_clair:4230:24489469,24485055:pet_clair:4230:24489115,24485058:pet_clair:4230:24485157,24485061:pet_clair:4230:24489184,24485062:pet_clair:4230:24489244,24485065:pet_clair:4230:24489145,24485068:pet_clair:4230:24489400,24485069:pet_clair:4230:24489003,24485072:pet_clair:4230:24489041,24485075:pet_clair:4230:24489295,24485076:pet_clair:4230:24488961,24485079:pet_clair:4230:24488928,24485082:pet_clair:4230:24488822,24485083:pet_clair:4230:24488895,24485086:pet_clair:4230:24488729,24485088:pet_clair:4230:24488665,24485090:pet_clair:4230:24485420,24488934:pet_clair:4230:24489340,24527852:pet_clair:4230:24529167,24527853:pet_clair:4230:24529137,24527854:pet_clair:4230:24529458,24527855:pet_clair:4230:24529031,24527856:pet_clair:4230:24528974,24527857:pet_clair:4230:24528843,24527858:pet_clair:4230:24528595,24527859:pet_clair:4230:24528611,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018554390726249126, 'nb_photo': 692, 'list_port_cont': '24488814,24488966,24489029,24489146,24489185,24489259,24489339,24489404,24489466,24489561,24490378,24528185,24528529,24528600,24528625,24528851,24529457,24578584,24578838,24579042,24579272,24622911,24624486,24624822,24624936,24625145,24625251,24625319,24625366,24625442,24629182,24651134,24651176,24651259,24651379,24651396,24651452,24651496,24651572,24651660,24651815,24651856,24651878,24651938,24651972,24651995,24652047,24652130,24652150,24652213,24652804,24652998,24656954,24657206,24659294,24696040,24696065,24696222,24696264,24696439,24696668,24696879,24697229,24737083,24739154,24739177,24739384,24739562,24739598,24739668,24739727,24739863,24740017,24741529,24744297,24744882,24746118,24747116,24749598,24752348,24756026,24758457,24760702,24774178,24812328,24817773,24858153,24858798,24859613,24859874,24860020,24860314,24861010,24861048,24861327,24861449,24861579,24861683,24865080,24890384,24891124,24891278,24891981,24892088,24892226,24892262,24892311,24892345,24892376,24892438,24892543,24892584,24892615,2489266', 'assoc_port': '24485037:24490378,24485052:24489561,24485053:24489466,24485061:24489185,24485062:24489259,24485065:24489146,24485068:24489404,24485072:24489029,24485076:24488966,24485082:24488814,24488934:24489339,24527854:24529457,24527857:24528851,24527858:24528600,24527859:24528625,24527861:24528529,24527862:24528185,24578552:24579272,24578564:24579042,24578566:24578838,24578568:24578584,24622640:24625366,24622641:24625319,24622642:24625442,24622643:24625145,24622644:24625251,24622645:24624822,24622647:24624936,24622650:24629182,24622652:24624486,24622653:24622911,24650049:24652047,24650051:24651938,24650056:24651856,24650057:24651995,24650064:24651878,24650067:24651660,24650069:24652150,24650071:24651572,24650074:24652130,24650075:24652213,24650078:24651452,24650081:24651972,24650082:24651815,24650085:24651496,24650087:24651396,24650088:24651259,24650090:24651176,24650092:24651134,24650093:24651379,24652707:24652804,24652930:24652998,24656760:24657206,24656799:24656954,24659240:24659294,24695412:24696879,24695417:2469722', 'assoc_mat': '24485037:pet_fonce:4230:24490378,24485052:pet_fonce:4230:24489561,24485053:pet_fonce:4230:24489466,24485061:pet_fonce:4230:24489185,24485062:pet_fonce:4230:24489259,24485065:pet_fonce:4230:24489146,24485068:pet_fonce:4230:24489404,24485072:pet_fonce:4230:24489029,24485076:pet_fonce:4230:24488966,24485082:pet_fonce:4230:24488814,24488934:pet_fonce:4230:24489339,24527854:pet_fonce:4230:24529457,24527857:pet_fonce:4230:24528851,24527858:pet_fonce:4230:24528600,24527859:pet_fonce:4230:24528625,24527861:pet_fonce:4230:24528529,24527862:pet_fonce:4230:24528185,24578552:pet_fonce:4230:24579272,24578564:pet_fonce:4230:24579042,24578566:pet_fonce:4230:24578838,24578568:pet_fonce:4230:24578584,24622640:pet_fonce:4230:24625366,24622641:pet_fonce:4230:24625319,24622642:pet_fonce:4230:24625442,24622643:pet_fonce:4230:24625145,24622644:pet_fonce:4230:24625251,24622645:pet_fonce:4230:24624822,24622647:pet_fonce:4230:24624936,24622650:pet_fonce:4230:24629182,24622652:pet_fonce:4230:24624486,24622653:pet_fonce:4230:24622911,2'}), 'main_stat': {'nb_photos': 2330}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-07', 0.8295730889874583),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_07_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', '0.92%', 13741], 'carton': ['carton', '2.11%', 45914], 'metal': ['metal', '0.09%', 1318], 'papier': ['papier', '12.9%', 297969], 'pehd': ['pehd', '0.23%', 928], 'pet_clair': ['pet_clair', '2.21%', 27292], 'pet_fonce': ['pet_fonce', '0.19%', 692]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_07_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.50user 3.09system 0:07.98elapsed 70%CPU (0avgtext+0avgdata 176160maxresident)k 8inputs+280outputs (11major+44910minor)pagefaults 0swaps