python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-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_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (1, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 07 mtr_id : dashboard_places : SCCU_cam7 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_cam7' 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 = 204 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 = 204 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 = 204 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_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-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 (1950655,1955072,1958634,1961689,1964068,1964415,1967785,1970357,1972640,1975904,1979421,1981919,1982248,1985695,1989631,1991369,1994340,1997041,1999282,1999628,2003003,2006385,2010054,2013842,2017697,2020299,2020609) 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.012597026408727998, 'nb_photo': 14128, 'list_port_cont': '24485504,24485665,24485770,24485912,24486005,24486387,24486567,24486705,24487008,24487017,24487082,24487294,24487504,24487634,24487740,24487905,24488032,24488088,24488275,24488619,24488776,24489044,24490636,24503580,24505980,24508598,24511494,24521770,24525198,24528768,24530366,24530460,24530582,24530788,24532765,24533651,24535904,24578635,24578694,24578709,24578755,24578872,24578977,24579087,24579127,24579237,24579310,24579348,24622843,24622904,24623062,24623100,24623163,24623257,24623334,24623373,24623410,24623476,24623782,24623845,24623881,24623987,24626112,24627975,24644346,24645083,24645896,24646664,24647358,24648147,24648931,24649553,24650350,24650783,24650952,24651301,24651611,24651734,24652294,24652337,24652365,24652410,24652493,24652554,24652599,24652827,24652887,24653018,24656868,24656901,24656980,24657084,24657268,24657317,24657341,24657388,24657405,24657488,24657522,24657609,24657636,24657862,24657953,24657982,24658067,24658105,24658175,24658363,24658625,24658650,24659255,24659446,24696338,2469756', 'assoc_port': '24485057:24488619,24485060:24488776,24485064:24488275,24485067:24488088,24485071:24488032,24485074:24487905,24485078:24487740,24485081:24487504,24485085:24487634,24485089:24487008,24485092:24487082,24485094:24487294,24485096:24487017,24485098:24486705,24485100:24486567,24485102:24490636,24485104:24486387,24485106:24486005,24485108:24485770,24485110:24485912,24485112:24485504,24485115:24485665,24488879:24489044,24503237:24503580,24505869:24505980,24508472:24508598,24511365:24511494,24515720:24533651,24520780:24521770,24524357:24525198,24527806:24530460,24527808:24530788,24527810:24530366,24527812:24530582,24527814:24528768,24532194:24532765,24535579:24535904,24578549:24579237,24578551:24579348,24578553:24579310,24578555:24579127,24578557:24579087,24578559:24578755,24578561:24578694,24578563:24578977,24578565:24578709,24578567:24578872,24578569:24578635,24622679:24623782,24622681:24623881,24622695:24623987,24622709:24623845,24622711:24623334,24622713:24623257,24622715:24623410,24622717:24623062,24622719:2462347', 'assoc_mat': '24485057:autre:4230:24488619,24485060:autre:4230:24488776,24485064:autre:4230:24488275,24485067:autre:4230:24488088,24485071:autre:4230:24488032,24485074:autre:4230:24487905,24485078:autre:4230:24487740,24485081:autre:4230:24487504,24485085:autre:4230:24487634,24485089:autre:4230:24487008,24485092:autre:4230:24487082,24485094:autre:4230:24487294,24485096:autre:4230:24487017,24485098:autre:4230:24486705,24485100:autre:4230:24486567,24485102:autre:4230:24490636,24485104:autre:4230:24486387,24485106:autre:4230:24486005,24485108:autre:4230:24485770,24485110:autre:4230:24485912,24485112:autre:4230:24485504,24485115:autre:4230:24485665,24488879:autre:4230:24489044,24503237:autre:4230:24503580,24505869:autre:4230:24505980,24508472:autre:4230:24508598,24511365:autre:4230:24511494,24515720:autre:4230:24533651,24520780:autre:4230:24521770,24524357:autre:4230:24525198,24527806:autre:4230:24530460,24527808:autre:4230:24530788,24527810:autre:4230:24530366,24527812:autre:4230:24530582,24527814:autre:4230:24528768,24532194:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03822149618811542, 'nb_photo': 78493, 'list_port_cont': '24485508,24485653,24485762,24485909,24486003,24486388,24486582,24486712,24487006,24487025,24487076,24487307,24487505,24487633,24487746,24487896,24488035,24488096,24488277,24488614,24488785,24489053,24490651,24503573,24505977,24508597,24511506,24521768,24525202,24528769,24530368,24530455,24530585,24530778,24532755,24533641,24535897,24578637,24578696,24578715,24578781,24578874,24578974,24579092,24579128,24579242,24579315,24579366,24622836,24622906,24623059,24623102,24623148,24623255,24623344,24623381,24623417,24623479,24623794,24623850,24623884,24623997,24626120,24627984,24644348,24645096,24645900,24646681,24647370,24648151,24648940,24649555,24650359,24650772,24650958,24651294,24651610,24651743,24652279,24652332,24652378,24652419,24652506,24652563,24652602,24652836,24652894,24653032,24656878,24656906,24656977,24657095,24657282,24657319,24657345,24657390,24657425,24657499,24657537,24657601,24657638,24657864,24657957,24657983,24658083,24658110,24658179,24658362,24658620,24658653,24659262,24659443,24696350,2469756', 'assoc_port': '24485057:24488614,24485060:24488785,24485064:24488277,24485067:24488096,24485071:24488035,24485074:24487896,24485078:24487746,24485081:24487505,24485085:24487633,24485089:24487006,24485092:24487076,24485094:24487307,24485096:24487025,24485098:24486712,24485100:24486582,24485102:24490651,24485104:24486388,24485106:24486003,24485108:24485762,24485110:24485909,24485112:24485508,24485115:24485653,24488879:24489053,24503237:24503573,24505869:24505977,24508472:24508597,24511365:24511506,24515720:24533641,24520780:24521768,24524357:24525202,24527806:24530455,24527808:24530778,24527810:24530368,24527812:24530585,24527814:24528769,24532194:24532755,24535579:24535897,24578549:24579242,24578551:24579366,24578553:24579315,24578555:24579128,24578557:24579092,24578559:24578781,24578561:24578696,24578563:24578974,24578565:24578715,24578567:24578874,24578569:24578637,24622679:24623794,24622681:24623884,24622695:24623997,24622709:24623850,24622711:24623344,24622713:24623255,24622715:24623417,24622717:24623059,24622719:2462347', 'assoc_mat': '24485057:carton:4230:24488614,24485060:carton:4230:24488785,24485064:carton:4230:24488277,24485067:carton:4230:24488096,24485071:carton:4230:24488035,24485074:carton:4230:24487896,24485078:carton:4230:24487746,24485081:carton:4230:24487505,24485085:carton:4230:24487633,24485089:carton:4230:24487006,24485092:carton:4230:24487076,24485094:carton:4230:24487307,24485096:carton:4230:24487025,24485098:carton:4230:24486712,24485100:carton:4230:24486582,24485102:carton:4230:24490651,24485104:carton:4230:24486388,24485106:carton:4230:24486003,24485108:carton:4230:24485762,24485110:carton:4230:24485909,24485112:carton:4230:24485508,24485115:carton:4230:24485653,24488879:carton:4230:24489053,24503237:carton:4230:24503573,24505869:carton:4230:24505977,24508472:carton:4230:24508597,24511365:carton:4230:24511506,24515720:carton:4230:24533641,24520780:carton:4230:24521768,24524357:carton:4230:24525202,24527806:carton:4230:24530455,24527808:carton:4230:24530778,24527810:carton:4230:24530368,24527812:carton:4230:24530585,2452'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010984659259666856, 'nb_photo': 1654, 'list_port_cont': '24485509,24485651,24485758,24485906,24486007,24486382,24486574,24486720,24487007,24487009,24487080,24487297,24487499,24487619,24487735,24487906,24488021,24488098,24488272,24488599,24488786,24489057,24490637,24503574,24505967,24508586,24521755,24525207,24528755,24530360,24530450,24530576,24532768,24533644,24535896,24578639,24578708,24578771,24578871,24578961,24579098,24579135,24579238,24579314,24579335,24622834,24622928,24623049,24623094,24623152,24623266,24623370,24623411,24623468,24623796,24623848,24623882,24623998,24626127,24645094,24645876,24646675,24647369,24648142,24648941,24649549,24650358,24650773,24650945,24651295,24652328,24652368,24652402,24652499,24652567,24652595,24652843,24652886,24653021,24656865,24656914,24656983,24657308,24657354,24657386,24657422,24657489,24657608,24657639,24657859,24657954,24658082,24658112,24658176,24658369,24658612,24659263,24659439,24696343,24697556,24697759,24697989,24698125,24698177,24698534,24698784,24698867,24699148,24699286,24699436,24699507,24699566,24699855,2469993', 'assoc_port': '24485057:24488599,24485060:24488786,24485064:24488272,24485067:24488098,24485071:24488021,24485074:24487906,24485078:24487735,24485081:24487499,24485085:24487619,24485089:24487007,24485092:24487080,24485094:24487297,24485096:24487009,24485098:24486720,24485100:24486574,24485102:24490637,24485104:24486382,24485106:24486007,24485108:24485758,24485110:24485906,24485112:24485509,24485115:24485651,24488879:24489057,24503237:24503574,24505869:24505967,24508472:24508586,24515720:24533644,24520780:24521755,24524357:24525207,24527806:24530450,24527810:24530360,24527812:24530576,24527814:24528755,24532194:24532768,24535579:24535896,24578549:24579238,24578551:24579335,24578553:24579314,24578555:24579135,24578557:24579098,24578559:24578771,24578563:24578961,24578565:24578708,24578567:24578871,24578569:24578639,24622679:24623796,24622681:24623882,24622695:24623998,24622709:24623848,24622713:24623266,24622715:24623411,24622717:24623049,24622719:24623468,24622721:24623370,24622722:24622928,24622724:24623152,24622725:2462283', 'assoc_mat': '24485057:metal:4230:24488599,24485060:metal:4230:24488786,24485064:metal:4230:24488272,24485067:metal:4230:24488098,24485071:metal:4230:24488021,24485074:metal:4230:24487906,24485078:metal:4230:24487735,24485081:metal:4230:24487499,24485085:metal:4230:24487619,24485089:metal:4230:24487007,24485092:metal:4230:24487080,24485094:metal:4230:24487297,24485096:metal:4230:24487009,24485098:metal:4230:24486720,24485100:metal:4230:24486574,24485102:metal:4230:24490637,24485104:metal:4230:24486382,24485106:metal:4230:24486007,24485108:metal:4230:24485758,24485110:metal:4230:24485906,24485112:metal:4230:24485509,24485115:metal:4230:24485651,24488879:metal:4230:24489057,24503237:metal:4230:24503574,24505869:metal:4230:24505967,24508472:metal:4230:24508586,24515720:metal:4230:24533644,24520780:metal:4230:24521755,24524357:metal:4230:24525207,24527806:metal:4230:24530450,24527810:metal:4230:24530360,24527812:metal:4230:24530576,24527814:metal:4230:24528755,24532194:metal:4230:24532768,24535579:metal:4230:24535896,24578549:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.13379624884514216, 'nb_photo': 261326, 'list_port_cont': '24485500,24485663,24485767,24485914,24486008,24486386,24486584,24486719,24487000,24487015,24487084,24487303,24487507,24487635,24487743,24487904,24488028,24488092,24488270,24488620,24488782,24489055,24490650,24503578,24505981,24508589,24511504,24521762,24525208,24528772,24530374,24530452,24530590,24530790,24532770,24533654,24535899,24578631,24578698,24578716,24578769,24578877,24578976,24579091,24579133,24579230,24579308,24579364,24622839,24622924,24623063,24623101,24623160,24623262,24623340,24623380,24623419,24623475,24623788,24623847,24623888,24623995,24626124,24627987,24644341,24645100,24645898,24646671,24647360,24648144,24648937,24649557,24650349,24650771,24650959,24651302,24651617,24651737,24652290,24652334,24652381,24652412,24652508,24652558,24652604,24652839,24652896,24653034,24656876,24656912,24656992,24657100,24657280,24657309,24657348,24657389,24657403,24657494,24657532,24657607,24657642,24657855,24657955,24657993,24658077,24658106,24658192,24658370,24658623,24658652,24659252,24659449,24696349,2469754', 'assoc_port': '24485057:24488620,24485060:24488782,24485064:24488270,24485067:24488092,24485071:24488028,24485074:24487904,24485078:24487743,24485081:24487507,24485085:24487635,24485089:24487000,24485092:24487084,24485094:24487303,24485096:24487015,24485098:24486719,24485100:24486584,24485102:24490650,24485104:24486386,24485106:24486008,24485108:24485767,24485110:24485914,24485112:24485500,24485115:24485663,24488879:24489055,24503237:24503578,24505869:24505981,24508472:24508589,24511365:24511504,24515720:24533654,24520780:24521762,24524357:24525208,24527806:24530452,24527808:24530790,24527810:24530374,24527812:24530590,24527814:24528772,24532194:24532770,24535579:24535899,24578549:24579230,24578551:24579364,24578553:24579308,24578555:24579133,24578557:24579091,24578559:24578769,24578561:24578698,24578563:24578976,24578565:24578716,24578567:24578877,24578569:24578631,24622679:24623788,24622681:24623888,24622695:24623995,24622709:24623847,24622711:24623340,24622713:24623262,24622715:24623419,24622717:24623063,24622719:2462347', 'assoc_mat': '24485057:papier:4230:24488620,24485060:papier:4230:24488782,24485064:papier:4230:24488270,24485067:papier:4230:24488092,24485071:papier:4230:24488028,24485074:papier:4230:24487904,24485078:papier:4230:24487743,24485081:papier:4230:24487507,24485085:papier:4230:24487635,24485089:papier:4230:24487000,24485092:papier:4230:24487084,24485094:papier:4230:24487303,24485096:papier:4230:24487015,24485098:papier:4230:24486719,24485100:papier:4230:24486584,24485102:papier:4230:24490650,24485104:papier:4230:24486386,24485106:papier:4230:24486008,24485108:papier:4230:24485767,24485110:papier:4230:24485914,24485112:papier:4230:24485500,24485115:papier:4230:24485663,24488879:papier:4230:24489055,24503237:papier:4230:24503578,24505869:papier:4230:24505981,24508472:papier:4230:24508589,24511365:papier:4230:24511504,24515720:papier:4230:24533654,24520780:papier:4230:24521762,24524357:papier:4230:24525208,24527806:papier:4230:24530452,24527808:papier:4230:24530790,24527810:papier:4230:24530374,24527812:papier:4230:24530590,2452'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0019405773133772562, 'nb_photo': 845, 'list_port_cont': '24485502,24486581,24486717,24487018,24487071,24487508,24488605,24488773,24503575,24525204,24528763,24530371,24530792,24535907,24578641,24578706,24578866,24578975,24579229,24579306,24622842,24623057,24623261,24623467,24623795,24623852,24623885,24623994,24644349,24645097,24645890,24646673,24647365,24648932,24651304,24652284,24652323,24652382,24652406,24652564,24653031,24657343,24657380,24657491,24657605,24657643,24657866,24657950,24658081,24658186,24658614,24658651,24697892,24698176,24698880,24699152,24699443,24699495,24699576,24700218,24700472,24703448,24706182,24737138,24737324,24737362,24737637,24737688,24737717,24737975,24738142,24738210,24738234,24738291,24738397,24738465,24738563,24738862,24739262,24740460,24770930,24771061,24771171,24771434,24771507,24771736,24771922,24771970,24772033,24772118,24777176,24821982,24825535,24856969,24857333,24857646,24857769,24858061,24858534,24859325,24859835,24860166,24860787,24860869,24860896,24861139,24861347,24865708,24885618,24886137,24886828,24887370,24888047,2488858', 'assoc_port': '24485057:24488605,24485060:24488773,24485081:24487508,24485092:24487071,24485096:24487018,24485098:24486717,24485100:24486581,24485112:24485502,24503237:24503575,24524357:24525204,24527808:24530792,24527810:24530371,24527814:24528763,24535579:24535907,24578549:24579229,24578553:24579306,24578563:24578975,24578565:24578706,24578567:24578866,24578569:24578641,24622679:24623795,24622681:24623885,24622695:24623994,24622709:24623852,24622713:24623261,24622717:24623057,24622719:24623467,24622725:24622842,24644273:24644349,24644889:24645097,24645694:24645890,24646497:24646673,24647189:24647365,24648771:24648932,24650048:24651304,24650063:24652382,24650070:24652564,24650073:24652284,24650077:24652323,24650084:24652406,24652932:24653031,24656773:24658081,24656777:24658651,24656780:24658614,24656787:24657950,24656791:24657866,24656794:24658186,24656798:24657643,24656805:24657491,24656807:24657380,24656811:24657343,24656813:24657605,24695373:24703448,24695386:24700472,24695388:24700218,24695391:24699576,24695396:2469949', 'assoc_mat': '24485057:pehd:4230:24488605,24485060:pehd:4230:24488773,24485081:pehd:4230:24487508,24485092:pehd:4230:24487071,24485096:pehd:4230:24487018,24485098:pehd:4230:24486717,24485100:pehd:4230:24486581,24485112:pehd:4230:24485502,24503237:pehd:4230:24503575,24524357:pehd:4230:24525204,24527808:pehd:4230:24530792,24527810:pehd:4230:24530371,24527814:pehd:4230:24528763,24535579:pehd:4230:24535907,24578549:pehd:4230:24579229,24578553:pehd:4230:24579306,24578563:pehd:4230:24578975,24578565:pehd:4230:24578706,24578567:pehd:4230:24578866,24578569:pehd:4230:24578641,24622679:pehd:4230:24623795,24622681:pehd:4230:24623885,24622695:pehd:4230:24623994,24622709:pehd:4230:24623852,24622713:pehd:4230:24623261,24622717:pehd:4230:24623057,24622719:pehd:4230:24623467,24622725:pehd:4230:24622842,24644273:pehd:4230:24644349,24644889:pehd:4230:24645097,24645694:pehd:4230:24645890,24646497:pehd:4230:24646673,24647189:pehd:4230:24647365,24648771:pehd:4230:24648932,24650048:pehd:4230:24651304,24650063:pehd:4230:24652382,24650070:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015401600686769277, 'nb_photo': 16503, 'list_port_cont': '24485496,24485664,24485768,24485911,24486012,24486385,24486585,24486715,24487002,24487019,24487079,24487308,24487506,24487625,24487750,24487903,24488030,24488094,24488266,24488621,24488787,24489061,24490649,24503576,24505969,24508602,24511500,24521763,24525209,24528761,24530370,24530457,24530586,24530761,24532761,24533645,24535903,24578638,24578689,24578703,24578763,24578878,24578972,24579095,24579131,24579239,24579311,24579362,24622847,24622932,24623061,24623089,24623157,24623258,24623333,24623375,24623418,24623474,24623791,24623855,24623895,24623996,24626113,24627977,24644343,24645089,24645902,24646682,24647357,24648153,24648939,24649546,24650355,24650781,24650951,24651306,24651607,24651741,24652286,24652333,24652379,24652411,24652507,24652568,24652593,24652838,24652884,24653029,24656879,24656917,24656988,24657089,24657276,24657312,24657353,24657391,24657414,24657490,24657534,24657599,24657645,24657863,24657951,24657986,24658075,24658116,24658185,24658367,24658611,24658655,24659257,24659447,24696353,2469755', 'assoc_port': '24485057:24488621,24485060:24488787,24485064:24488266,24485067:24488094,24485071:24488030,24485074:24487903,24485078:24487750,24485081:24487506,24485085:24487625,24485089:24487002,24485092:24487079,24485094:24487308,24485096:24487019,24485098:24486715,24485100:24486585,24485102:24490649,24485104:24486385,24485106:24486012,24485108:24485768,24485110:24485911,24485112:24485496,24485115:24485664,24488879:24489061,24503237:24503576,24505869:24505969,24508472:24508602,24511365:24511500,24515720:24533645,24520780:24521763,24524357:24525209,24527806:24530457,24527808:24530761,24527810:24530370,24527812:24530586,24527814:24528761,24532194:24532761,24535579:24535903,24578549:24579239,24578551:24579362,24578553:24579311,24578555:24579131,24578557:24579095,24578559:24578763,24578561:24578689,24578563:24578972,24578565:24578703,24578567:24578878,24578569:24578638,24622679:24623791,24622681:24623895,24622695:24623996,24622709:24623855,24622711:24623333,24622713:24623258,24622715:24623418,24622717:24623061,24622719:2462347', 'assoc_mat': '24485057:pet_clair:4230:24488621,24485060:pet_clair:4230:24488787,24485064:pet_clair:4230:24488266,24485067:pet_clair:4230:24488094,24485071:pet_clair:4230:24488030,24485074:pet_clair:4230:24487903,24485078:pet_clair:4230:24487750,24485081:pet_clair:4230:24487506,24485085:pet_clair:4230:24487625,24485089:pet_clair:4230:24487002,24485092:pet_clair:4230:24487079,24485094:pet_clair:4230:24487308,24485096:pet_clair:4230:24487019,24485098:pet_clair:4230:24486715,24485100:pet_clair:4230:24486585,24485102:pet_clair:4230:24490649,24485104:pet_clair:4230:24486385,24485106:pet_clair:4230:24486012,24485108:pet_clair:4230:24485768,24485110:pet_clair:4230:24485911,24485112:pet_clair:4230:24485496,24485115:pet_clair:4230:24485664,24488879:pet_clair:4230:24489061,24503237:pet_clair:4230:24503576,24505869:pet_clair:4230:24505969,24508472:pet_clair:4230:24508602,24511365:pet_clair:4230:24511500,24515720:pet_clair:4230:24533645,24520780:pet_clair:4230:24521763,24524357:pet_clair:4230:24525209,24527806:pet_clair:4230:24530457,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021226305323105753, 'nb_photo': 547, 'list_port_cont': '24485902,24486381,24486577,24486710,24487081,24487751,24488031,24490643,24530365,24530786,24578642,24578875,24578959,24579124,24579240,24622840,24622922,24623065,24623091,24623161,24623265,24623379,24623416,24623469,24623890,24624000,24626122,24627986,24644342,24645884,24646660,24647366,24648150,24649558,24650353,24650778,24650953,24651305,24651620,24651742,24652291,24652327,24652380,24652408,24652566,24652605,24652837,24653023,24657379,24657498,24657989,24658372,24697894,24697987,24698878,24699133,24699430,24700216,24700255,24700467,24738146,24738215,24738222,24738283,24738406,24738462,24738560,24739243,24740462,24770266,24771059,24771168,24771289,24771440,24771511,24771744,24771961,24772038,24772112,24777184,24821944,24821948,24856967,24857335,24857859,24858065,24858545,24859834,24860152,24860173,24860788,24860862,24861147,24861349,24862838,24865711,24885623,24886133,24887365,24888059,24888597,24889289,24890513,24891419,24891460,24891495,24891612,24891734,24891779,24892908,24893071,24894022,24894161,2489435', 'assoc_port': '24485071:24488031,24485078:24487751,24485092:24487081,24485098:24486710,24485100:24486577,24485102:24490643,24485104:24486381,24485110:24485902,24527808:24530786,24527810:24530365,24578549:24579240,24578555:24579124,24578563:24578959,24578567:24578875,24578569:24578642,24622681:24623890,24622695:24624000,24622713:24623265,24622715:24623416,24622717:24623065,24622719:24623469,24622721:24623379,24622722:24622922,24622724:24623161,24622725:24622840,24622726:24623091,24625790:24626122,24627860:24627986,24644273:24644342,24645694:24645884,24646497:24646660,24647189:24647366,24647987:24648150,24649379:24649558,24650042:24650353,24650044:24650778,24650046:24650953,24650048:24651305,24650052:24651620,24650055:24651742,24650063:24652380,24650066:24652605,24650070:24652566,24650073:24652291,24650077:24652327,24650084:24652408,24652705:24652837,24652932:24653023,24656770:24658372,24656801:24657989,24656805:24657498,24656807:24657379,24695383:24700255,24695386:24700467,24695388:24700216,24695399:24699430,24695401:2469887', 'assoc_mat': '24485071:pet_fonce:4230:24488031,24485078:pet_fonce:4230:24487751,24485092:pet_fonce:4230:24487081,24485098:pet_fonce:4230:24486710,24485100:pet_fonce:4230:24486577,24485102:pet_fonce:4230:24490643,24485104:pet_fonce:4230:24486381,24485110:pet_fonce:4230:24485902,24527808:pet_fonce:4230:24530786,24527810:pet_fonce:4230:24530365,24578549:pet_fonce:4230:24579240,24578555:pet_fonce:4230:24579124,24578563:pet_fonce:4230:24578959,24578567:pet_fonce:4230:24578875,24578569:pet_fonce:4230:24578642,24622681:pet_fonce:4230:24623890,24622695:pet_fonce:4230:24624000,24622713:pet_fonce:4230:24623265,24622715:pet_fonce:4230:24623416,24622717:pet_fonce:4230:24623065,24622719:pet_fonce:4230:24623469,24622721:pet_fonce:4230:24623379,24622722:pet_fonce:4230:24622922,24622724:pet_fonce:4230:24623161,24622725:pet_fonce:4230:24622840,24622726:pet_fonce:4230:24623091,24625790:pet_fonce:4230:24626122,24627860:pet_fonce:4230:24627986,24644273:pet_fonce:4230:24644342,24645694:pet_fonce:4230:24645884,24646497:pet_fonce:4230:24646660,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(1950655,1955072,1958634,1961689,1964068,1964415,1967785,1970357,1972640,1975904,1979421,1981919,1982248,1985695,1989631,1991369,1994340,1997041,1999282,1999628,2003003,2006385,2010054,2013842,2017697,2020299,2020609)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2025-07-01' and date <= '2025-07-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1673,),), 'unwanted_material_monthly_percentage': ((0.8064509072650274,),), 'material_repartition': (('incineration', 1672),), 'material_dict': {'incineration': 1672}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 7, 1), 0.8330926458285152, 75), (datetime.date(2025, 7, 2), 0.8478553739050155, 36), (datetime.date(2025, 7, 3), 0.8307036328191859, 29), (datetime.date(2025, 7, 4), 0.8620119339320356, 51), (datetime.date(2025, 7, 5), 0.8212693747070223, 79), (datetime.date(2025, 7, 6), 0.8530575117414375, 71), (datetime.date(2025, 7, 7), 0.815195857596316, 72), (datetime.date(2025, 7, 8), 0.7888054613556619, 81), (datetime.date(2025, 7, 9), 0.8207127034296815, 53), (datetime.date(2025, 7, 10), 0.7921214581035552, 39), (datetime.date(2025, 7, 11), 0.828056440303599, 71), (datetime.date(2025, 7, 12), 0.7578551373398715, 75), (datetime.date(2025, 7, 13), 0.811659850814711, 74), (datetime.date(2025, 7, 14), 0.8430980604574009, 65), (datetime.date(2025, 7, 15), 0.7262374565764469, 52), (datetime.date(2025, 7, 16), 0.74745765597167, 28), (datetime.date(2025, 7, 17), 0.7759670304790609, 78), (datetime.date(2025, 7, 18), 0.7901741562548125, 48), (datetime.date(2025, 7, 19), 0.7697804675951871, 78), (datetime.date(2025, 7, 20), 0.8225773582671195, 59), (datetime.date(2025, 7, 21), 0.8113494073763412, 70), (datetime.date(2025, 7, 22), 0.7785791609939686, 71), (datetime.date(2025, 7, 23), 0.8061941094691351, 80), (datetime.date(2025, 7, 24), 0.8028271729928489, 67), (datetime.date(2025, 7, 25), 0.8115550860647816, 66), (datetime.date(2025, 7, 26), 0.77661910063718, 69), (datetime.date(2025, 7, 27), 0.8720643003670528, 35)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 7, 1), 0.8330926458285152, 75), (datetime.date(2025, 7, 2), 0.8478553739050155, 36), (datetime.date(2025, 7, 3), 0.8307036328191859, 29), (datetime.date(2025, 7, 4), 0.8620119339320356, 51), (datetime.date(2025, 7, 5), 0.8212693747070223, 79), (datetime.date(2025, 7, 6), 0.8530575117414375, 71), (datetime.date(2025, 7, 7), 0.815195857596316, 72), (datetime.date(2025, 7, 8), 0.7888054613556619, 81), (datetime.date(2025, 7, 9), 0.8207127034296815, 53), (datetime.date(2025, 7, 10), 0.7921214581035552, 39), (datetime.date(2025, 7, 11), 0.828056440303599, 71), (datetime.date(2025, 7, 12), 0.7578551373398715, 75), (datetime.date(2025, 7, 13), 0.811659850814711, 74), (datetime.date(2025, 7, 14), 0.8430980604574009, 65), (datetime.date(2025, 7, 15), 0.7262374565764469, 52), (datetime.date(2025, 7, 16), 0.74745765597167, 28), (datetime.date(2025, 7, 17), 0.7759670304790609, 78), (datetime.date(2025, 7, 18), 0.7901741562548125, 48), (datetime.date(2025, 7, 19), 0.7697804675951871, 78), (datetime.date(2025, 7, 20), 0.8225773582671195, 59), (datetime.date(2025, 7, 21), 0.8113494073763412, 70), (datetime.date(2025, 7, 22), 0.7785791609939686, 71), (datetime.date(2025, 7, 23), 0.8061941094691351, 80), (datetime.date(2025, 7, 24), 0.8028271729928489, 67), (datetime.date(2025, 7, 25), 0.8115550860647816, 66), (datetime.date(2025, 7, 26), 0.77661910063718, 69), (datetime.date(2025, 7, 27), 0.8720643003670528, 35))}, 'quality_array': [['-7.827054415814331', '01072025'], ['-8.315925385433458', '02072025'], ['-8.105389968950366', '03072025'], ['-7.673395755494485', '04072025'], ['-7.731523746178086', '05072025'], ['-8.071480926193178', '06072025'], ['-8.063069961756275', '07072025'], ['-8.043657858968308', '08072025'], ['-7.909680611076746', '09072025'], ['-7.932310113754524', '10072025'], ['-7.780761199509596', '11072025'], ['-7.694835583899124', '12072025'], ['-7.93758043972864', '13072025'], ['-8.107616933813215', '14072025'], ['-7.158709436128257', '15072025'], ['-7.529719760108628', '16072025'], ['-7.729801154404691', '17072025'], ['-8.020575406602463', '18072025'], ['-7.843978720314126', '19072025'], ['-7.9219439747393015', '20072025'], ['-7.541355434534321', '21072025'], ['-7.6740720101439335', '22072025'], ['-7.6955678517340615', '23072025'], ['-7.824570397762929', '24072025'], ['-7.900931645310839', '25072025'], ['-7.817554727400465', '26072025'], ['-7.771940667222259', '27072025']], 'number_of_batch': ((560,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012597026408727998, 'nb_photo': 14128, 'list_port_cont': '24485504,24485665,24485770,24485912,24486005,24486387,24486567,24486705,24487008,24487017,24487082,24487294,24487504,24487634,24487740,24487905,24488032,24488088,24488275,24488619,24488776,24489044,24490636,24503580,24505980,24508598,24511494,24521770,24525198,24528768,24530366,24530460,24530582,24530788,24532765,24533651,24535904,24578635,24578694,24578709,24578755,24578872,24578977,24579087,24579127,24579237,24579310,24579348,24622843,24622904,24623062,24623100,24623163,24623257,24623334,24623373,24623410,24623476,24623782,24623845,24623881,24623987,24626112,24627975,24644346,24645083,24645896,24646664,24647358,24648147,24648931,24649553,24650350,24650783,24650952,24651301,24651611,24651734,24652294,24652337,24652365,24652410,24652493,24652554,24652599,24652827,24652887,24653018,24656868,24656901,24656980,24657084,24657268,24657317,24657341,24657388,24657405,24657488,24657522,24657609,24657636,24657862,24657953,24657982,24658067,24658105,24658175,24658363,24658625,24658650,24659255,24659446,24696338,2469756', 'assoc_port': '24485057:24488619,24485060:24488776,24485064:24488275,24485067:24488088,24485071:24488032,24485074:24487905,24485078:24487740,24485081:24487504,24485085:24487634,24485089:24487008,24485092:24487082,24485094:24487294,24485096:24487017,24485098:24486705,24485100:24486567,24485102:24490636,24485104:24486387,24485106:24486005,24485108:24485770,24485110:24485912,24485112:24485504,24485115:24485665,24488879:24489044,24503237:24503580,24505869:24505980,24508472:24508598,24511365:24511494,24515720:24533651,24520780:24521770,24524357:24525198,24527806:24530460,24527808:24530788,24527810:24530366,24527812:24530582,24527814:24528768,24532194:24532765,24535579:24535904,24578549:24579237,24578551:24579348,24578553:24579310,24578555:24579127,24578557:24579087,24578559:24578755,24578561:24578694,24578563:24578977,24578565:24578709,24578567:24578872,24578569:24578635,24622679:24623782,24622681:24623881,24622695:24623987,24622709:24623845,24622711:24623334,24622713:24623257,24622715:24623410,24622717:24623062,24622719:2462347', 'assoc_mat': '24485057:autre:4230:24488619,24485060:autre:4230:24488776,24485064:autre:4230:24488275,24485067:autre:4230:24488088,24485071:autre:4230:24488032,24485074:autre:4230:24487905,24485078:autre:4230:24487740,24485081:autre:4230:24487504,24485085:autre:4230:24487634,24485089:autre:4230:24487008,24485092:autre:4230:24487082,24485094:autre:4230:24487294,24485096:autre:4230:24487017,24485098:autre:4230:24486705,24485100:autre:4230:24486567,24485102:autre:4230:24490636,24485104:autre:4230:24486387,24485106:autre:4230:24486005,24485108:autre:4230:24485770,24485110:autre:4230:24485912,24485112:autre:4230:24485504,24485115:autre:4230:24485665,24488879:autre:4230:24489044,24503237:autre:4230:24503580,24505869:autre:4230:24505980,24508472:autre:4230:24508598,24511365:autre:4230:24511494,24515720:autre:4230:24533651,24520780:autre:4230:24521770,24524357:autre:4230:24525198,24527806:autre:4230:24530460,24527808:autre:4230:24530788,24527810:autre:4230:24530366,24527812:autre:4230:24530582,24527814:autre:4230:24528768,24532194:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03822149618811542, 'nb_photo': 78493, 'list_port_cont': '24485508,24485653,24485762,24485909,24486003,24486388,24486582,24486712,24487006,24487025,24487076,24487307,24487505,24487633,24487746,24487896,24488035,24488096,24488277,24488614,24488785,24489053,24490651,24503573,24505977,24508597,24511506,24521768,24525202,24528769,24530368,24530455,24530585,24530778,24532755,24533641,24535897,24578637,24578696,24578715,24578781,24578874,24578974,24579092,24579128,24579242,24579315,24579366,24622836,24622906,24623059,24623102,24623148,24623255,24623344,24623381,24623417,24623479,24623794,24623850,24623884,24623997,24626120,24627984,24644348,24645096,24645900,24646681,24647370,24648151,24648940,24649555,24650359,24650772,24650958,24651294,24651610,24651743,24652279,24652332,24652378,24652419,24652506,24652563,24652602,24652836,24652894,24653032,24656878,24656906,24656977,24657095,24657282,24657319,24657345,24657390,24657425,24657499,24657537,24657601,24657638,24657864,24657957,24657983,24658083,24658110,24658179,24658362,24658620,24658653,24659262,24659443,24696350,2469756', 'assoc_port': '24485057:24488614,24485060:24488785,24485064:24488277,24485067:24488096,24485071:24488035,24485074:24487896,24485078:24487746,24485081:24487505,24485085:24487633,24485089:24487006,24485092:24487076,24485094:24487307,24485096:24487025,24485098:24486712,24485100:24486582,24485102:24490651,24485104:24486388,24485106:24486003,24485108:24485762,24485110:24485909,24485112:24485508,24485115:24485653,24488879:24489053,24503237:24503573,24505869:24505977,24508472:24508597,24511365:24511506,24515720:24533641,24520780:24521768,24524357:24525202,24527806:24530455,24527808:24530778,24527810:24530368,24527812:24530585,24527814:24528769,24532194:24532755,24535579:24535897,24578549:24579242,24578551:24579366,24578553:24579315,24578555:24579128,24578557:24579092,24578559:24578781,24578561:24578696,24578563:24578974,24578565:24578715,24578567:24578874,24578569:24578637,24622679:24623794,24622681:24623884,24622695:24623997,24622709:24623850,24622711:24623344,24622713:24623255,24622715:24623417,24622717:24623059,24622719:2462347', 'assoc_mat': '24485057:carton:4230:24488614,24485060:carton:4230:24488785,24485064:carton:4230:24488277,24485067:carton:4230:24488096,24485071:carton:4230:24488035,24485074:carton:4230:24487896,24485078:carton:4230:24487746,24485081:carton:4230:24487505,24485085:carton:4230:24487633,24485089:carton:4230:24487006,24485092:carton:4230:24487076,24485094:carton:4230:24487307,24485096:carton:4230:24487025,24485098:carton:4230:24486712,24485100:carton:4230:24486582,24485102:carton:4230:24490651,24485104:carton:4230:24486388,24485106:carton:4230:24486003,24485108:carton:4230:24485762,24485110:carton:4230:24485909,24485112:carton:4230:24485508,24485115:carton:4230:24485653,24488879:carton:4230:24489053,24503237:carton:4230:24503573,24505869:carton:4230:24505977,24508472:carton:4230:24508597,24511365:carton:4230:24511506,24515720:carton:4230:24533641,24520780:carton:4230:24521768,24524357:carton:4230:24525202,24527806:carton:4230:24530455,24527808:carton:4230:24530778,24527810:carton:4230:24530368,24527812:carton:4230:24530585,2452'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010984659259666856, 'nb_photo': 1654, 'list_port_cont': '24485509,24485651,24485758,24485906,24486007,24486382,24486574,24486720,24487007,24487009,24487080,24487297,24487499,24487619,24487735,24487906,24488021,24488098,24488272,24488599,24488786,24489057,24490637,24503574,24505967,24508586,24521755,24525207,24528755,24530360,24530450,24530576,24532768,24533644,24535896,24578639,24578708,24578771,24578871,24578961,24579098,24579135,24579238,24579314,24579335,24622834,24622928,24623049,24623094,24623152,24623266,24623370,24623411,24623468,24623796,24623848,24623882,24623998,24626127,24645094,24645876,24646675,24647369,24648142,24648941,24649549,24650358,24650773,24650945,24651295,24652328,24652368,24652402,24652499,24652567,24652595,24652843,24652886,24653021,24656865,24656914,24656983,24657308,24657354,24657386,24657422,24657489,24657608,24657639,24657859,24657954,24658082,24658112,24658176,24658369,24658612,24659263,24659439,24696343,24697556,24697759,24697989,24698125,24698177,24698534,24698784,24698867,24699148,24699286,24699436,24699507,24699566,24699855,2469993', 'assoc_port': '24485057:24488599,24485060:24488786,24485064:24488272,24485067:24488098,24485071:24488021,24485074:24487906,24485078:24487735,24485081:24487499,24485085:24487619,24485089:24487007,24485092:24487080,24485094:24487297,24485096:24487009,24485098:24486720,24485100:24486574,24485102:24490637,24485104:24486382,24485106:24486007,24485108:24485758,24485110:24485906,24485112:24485509,24485115:24485651,24488879:24489057,24503237:24503574,24505869:24505967,24508472:24508586,24515720:24533644,24520780:24521755,24524357:24525207,24527806:24530450,24527810:24530360,24527812:24530576,24527814:24528755,24532194:24532768,24535579:24535896,24578549:24579238,24578551:24579335,24578553:24579314,24578555:24579135,24578557:24579098,24578559:24578771,24578563:24578961,24578565:24578708,24578567:24578871,24578569:24578639,24622679:24623796,24622681:24623882,24622695:24623998,24622709:24623848,24622713:24623266,24622715:24623411,24622717:24623049,24622719:24623468,24622721:24623370,24622722:24622928,24622724:24623152,24622725:2462283', 'assoc_mat': '24485057:metal:4230:24488599,24485060:metal:4230:24488786,24485064:metal:4230:24488272,24485067:metal:4230:24488098,24485071:metal:4230:24488021,24485074:metal:4230:24487906,24485078:metal:4230:24487735,24485081:metal:4230:24487499,24485085:metal:4230:24487619,24485089:metal:4230:24487007,24485092:metal:4230:24487080,24485094:metal:4230:24487297,24485096:metal:4230:24487009,24485098:metal:4230:24486720,24485100:metal:4230:24486574,24485102:metal:4230:24490637,24485104:metal:4230:24486382,24485106:metal:4230:24486007,24485108:metal:4230:24485758,24485110:metal:4230:24485906,24485112:metal:4230:24485509,24485115:metal:4230:24485651,24488879:metal:4230:24489057,24503237:metal:4230:24503574,24505869:metal:4230:24505967,24508472:metal:4230:24508586,24515720:metal:4230:24533644,24520780:metal:4230:24521755,24524357:metal:4230:24525207,24527806:metal:4230:24530450,24527810:metal:4230:24530360,24527812:metal:4230:24530576,24527814:metal:4230:24528755,24532194:metal:4230:24532768,24535579:metal:4230:24535896,24578549:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.13379624884514216, 'nb_photo': 261326, 'list_port_cont': '24485500,24485663,24485767,24485914,24486008,24486386,24486584,24486719,24487000,24487015,24487084,24487303,24487507,24487635,24487743,24487904,24488028,24488092,24488270,24488620,24488782,24489055,24490650,24503578,24505981,24508589,24511504,24521762,24525208,24528772,24530374,24530452,24530590,24530790,24532770,24533654,24535899,24578631,24578698,24578716,24578769,24578877,24578976,24579091,24579133,24579230,24579308,24579364,24622839,24622924,24623063,24623101,24623160,24623262,24623340,24623380,24623419,24623475,24623788,24623847,24623888,24623995,24626124,24627987,24644341,24645100,24645898,24646671,24647360,24648144,24648937,24649557,24650349,24650771,24650959,24651302,24651617,24651737,24652290,24652334,24652381,24652412,24652508,24652558,24652604,24652839,24652896,24653034,24656876,24656912,24656992,24657100,24657280,24657309,24657348,24657389,24657403,24657494,24657532,24657607,24657642,24657855,24657955,24657993,24658077,24658106,24658192,24658370,24658623,24658652,24659252,24659449,24696349,2469754', 'assoc_port': '24485057:24488620,24485060:24488782,24485064:24488270,24485067:24488092,24485071:24488028,24485074:24487904,24485078:24487743,24485081:24487507,24485085:24487635,24485089:24487000,24485092:24487084,24485094:24487303,24485096:24487015,24485098:24486719,24485100:24486584,24485102:24490650,24485104:24486386,24485106:24486008,24485108:24485767,24485110:24485914,24485112:24485500,24485115:24485663,24488879:24489055,24503237:24503578,24505869:24505981,24508472:24508589,24511365:24511504,24515720:24533654,24520780:24521762,24524357:24525208,24527806:24530452,24527808:24530790,24527810:24530374,24527812:24530590,24527814:24528772,24532194:24532770,24535579:24535899,24578549:24579230,24578551:24579364,24578553:24579308,24578555:24579133,24578557:24579091,24578559:24578769,24578561:24578698,24578563:24578976,24578565:24578716,24578567:24578877,24578569:24578631,24622679:24623788,24622681:24623888,24622695:24623995,24622709:24623847,24622711:24623340,24622713:24623262,24622715:24623419,24622717:24623063,24622719:2462347', 'assoc_mat': '24485057:papier:4230:24488620,24485060:papier:4230:24488782,24485064:papier:4230:24488270,24485067:papier:4230:24488092,24485071:papier:4230:24488028,24485074:papier:4230:24487904,24485078:papier:4230:24487743,24485081:papier:4230:24487507,24485085:papier:4230:24487635,24485089:papier:4230:24487000,24485092:papier:4230:24487084,24485094:papier:4230:24487303,24485096:papier:4230:24487015,24485098:papier:4230:24486719,24485100:papier:4230:24486584,24485102:papier:4230:24490650,24485104:papier:4230:24486386,24485106:papier:4230:24486008,24485108:papier:4230:24485767,24485110:papier:4230:24485914,24485112:papier:4230:24485500,24485115:papier:4230:24485663,24488879:papier:4230:24489055,24503237:papier:4230:24503578,24505869:papier:4230:24505981,24508472:papier:4230:24508589,24511365:papier:4230:24511504,24515720:papier:4230:24533654,24520780:papier:4230:24521762,24524357:papier:4230:24525208,24527806:papier:4230:24530452,24527808:papier:4230:24530790,24527810:papier:4230:24530374,24527812:papier:4230:24530590,2452'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0019405773133772562, 'nb_photo': 845, 'list_port_cont': '24485502,24486581,24486717,24487018,24487071,24487508,24488605,24488773,24503575,24525204,24528763,24530371,24530792,24535907,24578641,24578706,24578866,24578975,24579229,24579306,24622842,24623057,24623261,24623467,24623795,24623852,24623885,24623994,24644349,24645097,24645890,24646673,24647365,24648932,24651304,24652284,24652323,24652382,24652406,24652564,24653031,24657343,24657380,24657491,24657605,24657643,24657866,24657950,24658081,24658186,24658614,24658651,24697892,24698176,24698880,24699152,24699443,24699495,24699576,24700218,24700472,24703448,24706182,24737138,24737324,24737362,24737637,24737688,24737717,24737975,24738142,24738210,24738234,24738291,24738397,24738465,24738563,24738862,24739262,24740460,24770930,24771061,24771171,24771434,24771507,24771736,24771922,24771970,24772033,24772118,24777176,24821982,24825535,24856969,24857333,24857646,24857769,24858061,24858534,24859325,24859835,24860166,24860787,24860869,24860896,24861139,24861347,24865708,24885618,24886137,24886828,24887370,24888047,2488858', 'assoc_port': '24485057:24488605,24485060:24488773,24485081:24487508,24485092:24487071,24485096:24487018,24485098:24486717,24485100:24486581,24485112:24485502,24503237:24503575,24524357:24525204,24527808:24530792,24527810:24530371,24527814:24528763,24535579:24535907,24578549:24579229,24578553:24579306,24578563:24578975,24578565:24578706,24578567:24578866,24578569:24578641,24622679:24623795,24622681:24623885,24622695:24623994,24622709:24623852,24622713:24623261,24622717:24623057,24622719:24623467,24622725:24622842,24644273:24644349,24644889:24645097,24645694:24645890,24646497:24646673,24647189:24647365,24648771:24648932,24650048:24651304,24650063:24652382,24650070:24652564,24650073:24652284,24650077:24652323,24650084:24652406,24652932:24653031,24656773:24658081,24656777:24658651,24656780:24658614,24656787:24657950,24656791:24657866,24656794:24658186,24656798:24657643,24656805:24657491,24656807:24657380,24656811:24657343,24656813:24657605,24695373:24703448,24695386:24700472,24695388:24700218,24695391:24699576,24695396:2469949', 'assoc_mat': '24485057:pehd:4230:24488605,24485060:pehd:4230:24488773,24485081:pehd:4230:24487508,24485092:pehd:4230:24487071,24485096:pehd:4230:24487018,24485098:pehd:4230:24486717,24485100:pehd:4230:24486581,24485112:pehd:4230:24485502,24503237:pehd:4230:24503575,24524357:pehd:4230:24525204,24527808:pehd:4230:24530792,24527810:pehd:4230:24530371,24527814:pehd:4230:24528763,24535579:pehd:4230:24535907,24578549:pehd:4230:24579229,24578553:pehd:4230:24579306,24578563:pehd:4230:24578975,24578565:pehd:4230:24578706,24578567:pehd:4230:24578866,24578569:pehd:4230:24578641,24622679:pehd:4230:24623795,24622681:pehd:4230:24623885,24622695:pehd:4230:24623994,24622709:pehd:4230:24623852,24622713:pehd:4230:24623261,24622717:pehd:4230:24623057,24622719:pehd:4230:24623467,24622725:pehd:4230:24622842,24644273:pehd:4230:24644349,24644889:pehd:4230:24645097,24645694:pehd:4230:24645890,24646497:pehd:4230:24646673,24647189:pehd:4230:24647365,24648771:pehd:4230:24648932,24650048:pehd:4230:24651304,24650063:pehd:4230:24652382,24650070:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015401600686769277, 'nb_photo': 16503, 'list_port_cont': '24485496,24485664,24485768,24485911,24486012,24486385,24486585,24486715,24487002,24487019,24487079,24487308,24487506,24487625,24487750,24487903,24488030,24488094,24488266,24488621,24488787,24489061,24490649,24503576,24505969,24508602,24511500,24521763,24525209,24528761,24530370,24530457,24530586,24530761,24532761,24533645,24535903,24578638,24578689,24578703,24578763,24578878,24578972,24579095,24579131,24579239,24579311,24579362,24622847,24622932,24623061,24623089,24623157,24623258,24623333,24623375,24623418,24623474,24623791,24623855,24623895,24623996,24626113,24627977,24644343,24645089,24645902,24646682,24647357,24648153,24648939,24649546,24650355,24650781,24650951,24651306,24651607,24651741,24652286,24652333,24652379,24652411,24652507,24652568,24652593,24652838,24652884,24653029,24656879,24656917,24656988,24657089,24657276,24657312,24657353,24657391,24657414,24657490,24657534,24657599,24657645,24657863,24657951,24657986,24658075,24658116,24658185,24658367,24658611,24658655,24659257,24659447,24696353,2469755', 'assoc_port': '24485057:24488621,24485060:24488787,24485064:24488266,24485067:24488094,24485071:24488030,24485074:24487903,24485078:24487750,24485081:24487506,24485085:24487625,24485089:24487002,24485092:24487079,24485094:24487308,24485096:24487019,24485098:24486715,24485100:24486585,24485102:24490649,24485104:24486385,24485106:24486012,24485108:24485768,24485110:24485911,24485112:24485496,24485115:24485664,24488879:24489061,24503237:24503576,24505869:24505969,24508472:24508602,24511365:24511500,24515720:24533645,24520780:24521763,24524357:24525209,24527806:24530457,24527808:24530761,24527810:24530370,24527812:24530586,24527814:24528761,24532194:24532761,24535579:24535903,24578549:24579239,24578551:24579362,24578553:24579311,24578555:24579131,24578557:24579095,24578559:24578763,24578561:24578689,24578563:24578972,24578565:24578703,24578567:24578878,24578569:24578638,24622679:24623791,24622681:24623895,24622695:24623996,24622709:24623855,24622711:24623333,24622713:24623258,24622715:24623418,24622717:24623061,24622719:2462347', 'assoc_mat': '24485057:pet_clair:4230:24488621,24485060:pet_clair:4230:24488787,24485064:pet_clair:4230:24488266,24485067:pet_clair:4230:24488094,24485071:pet_clair:4230:24488030,24485074:pet_clair:4230:24487903,24485078:pet_clair:4230:24487750,24485081:pet_clair:4230:24487506,24485085:pet_clair:4230:24487625,24485089:pet_clair:4230:24487002,24485092:pet_clair:4230:24487079,24485094:pet_clair:4230:24487308,24485096:pet_clair:4230:24487019,24485098:pet_clair:4230:24486715,24485100:pet_clair:4230:24486585,24485102:pet_clair:4230:24490649,24485104:pet_clair:4230:24486385,24485106:pet_clair:4230:24486012,24485108:pet_clair:4230:24485768,24485110:pet_clair:4230:24485911,24485112:pet_clair:4230:24485496,24485115:pet_clair:4230:24485664,24488879:pet_clair:4230:24489061,24503237:pet_clair:4230:24503576,24505869:pet_clair:4230:24505969,24508472:pet_clair:4230:24508602,24511365:pet_clair:4230:24511500,24515720:pet_clair:4230:24533645,24520780:pet_clair:4230:24521763,24524357:pet_clair:4230:24525209,24527806:pet_clair:4230:24530457,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021226305323105753, 'nb_photo': 547, 'list_port_cont': '24485902,24486381,24486577,24486710,24487081,24487751,24488031,24490643,24530365,24530786,24578642,24578875,24578959,24579124,24579240,24622840,24622922,24623065,24623091,24623161,24623265,24623379,24623416,24623469,24623890,24624000,24626122,24627986,24644342,24645884,24646660,24647366,24648150,24649558,24650353,24650778,24650953,24651305,24651620,24651742,24652291,24652327,24652380,24652408,24652566,24652605,24652837,24653023,24657379,24657498,24657989,24658372,24697894,24697987,24698878,24699133,24699430,24700216,24700255,24700467,24738146,24738215,24738222,24738283,24738406,24738462,24738560,24739243,24740462,24770266,24771059,24771168,24771289,24771440,24771511,24771744,24771961,24772038,24772112,24777184,24821944,24821948,24856967,24857335,24857859,24858065,24858545,24859834,24860152,24860173,24860788,24860862,24861147,24861349,24862838,24865711,24885623,24886133,24887365,24888059,24888597,24889289,24890513,24891419,24891460,24891495,24891612,24891734,24891779,24892908,24893071,24894022,24894161,2489435', 'assoc_port': '24485071:24488031,24485078:24487751,24485092:24487081,24485098:24486710,24485100:24486577,24485102:24490643,24485104:24486381,24485110:24485902,24527808:24530786,24527810:24530365,24578549:24579240,24578555:24579124,24578563:24578959,24578567:24578875,24578569:24578642,24622681:24623890,24622695:24624000,24622713:24623265,24622715:24623416,24622717:24623065,24622719:24623469,24622721:24623379,24622722:24622922,24622724:24623161,24622725:24622840,24622726:24623091,24625790:24626122,24627860:24627986,24644273:24644342,24645694:24645884,24646497:24646660,24647189:24647366,24647987:24648150,24649379:24649558,24650042:24650353,24650044:24650778,24650046:24650953,24650048:24651305,24650052:24651620,24650055:24651742,24650063:24652380,24650066:24652605,24650070:24652566,24650073:24652291,24650077:24652327,24650084:24652408,24652705:24652837,24652932:24653023,24656770:24658372,24656801:24657989,24656805:24657498,24656807:24657379,24695383:24700255,24695386:24700467,24695388:24700216,24695399:24699430,24695401:2469887', 'assoc_mat': '24485071:pet_fonce:4230:24488031,24485078:pet_fonce:4230:24487751,24485092:pet_fonce:4230:24487081,24485098:pet_fonce:4230:24486710,24485100:pet_fonce:4230:24486577,24485102:pet_fonce:4230:24490643,24485104:pet_fonce:4230:24486381,24485110:pet_fonce:4230:24485902,24527808:pet_fonce:4230:24530786,24527810:pet_fonce:4230:24530365,24578549:pet_fonce:4230:24579240,24578555:pet_fonce:4230:24579124,24578563:pet_fonce:4230:24578959,24578567:pet_fonce:4230:24578875,24578569:pet_fonce:4230:24578642,24622681:pet_fonce:4230:24623890,24622695:pet_fonce:4230:24624000,24622713:pet_fonce:4230:24623265,24622715:pet_fonce:4230:24623416,24622717:pet_fonce:4230:24623065,24622719:pet_fonce:4230:24623469,24622721:pet_fonce:4230:24623379,24622722:pet_fonce:4230:24622922,24622724:pet_fonce:4230:24623161,24622725:pet_fonce:4230:24622840,24622726:pet_fonce:4230:24623091,24625790:pet_fonce:4230:24626122,24627860:pet_fonce:4230:24627986,24644273:pet_fonce:4230:24644342,24645694:pet_fonce:4230:24645884,24646497:pet_fonce:4230:24646660,2'}), 'main_stat': {'nb_photos': 1673}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-07', 0.8064509072650274),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1673,),), 'unwanted_material_monthly_percentage': ((0.8064509072650274,),), 'material_repartition': (('incineration', 1672),), 'material_dict': {'incineration': 1672}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 7, 1), 0.8330926458285152, 75), (datetime.date(2025, 7, 2), 0.8478553739050155, 36), (datetime.date(2025, 7, 3), 0.8307036328191859, 29), (datetime.date(2025, 7, 4), 0.8620119339320356, 51), (datetime.date(2025, 7, 5), 0.8212693747070223, 79), (datetime.date(2025, 7, 6), 0.8530575117414375, 71), (datetime.date(2025, 7, 7), 0.815195857596316, 72), (datetime.date(2025, 7, 8), 0.7888054613556619, 81), (datetime.date(2025, 7, 9), 0.8207127034296815, 53), (datetime.date(2025, 7, 10), 0.7921214581035552, 39), (datetime.date(2025, 7, 11), 0.828056440303599, 71), (datetime.date(2025, 7, 12), 0.7578551373398715, 75), (datetime.date(2025, 7, 13), 0.811659850814711, 74), (datetime.date(2025, 7, 14), 0.8430980604574009, 65), (datetime.date(2025, 7, 15), 0.7262374565764469, 52), (datetime.date(2025, 7, 16), 0.74745765597167, 28), (datetime.date(2025, 7, 17), 0.7759670304790609, 78), (datetime.date(2025, 7, 18), 0.7901741562548125, 48), (datetime.date(2025, 7, 19), 0.7697804675951871, 78), (datetime.date(2025, 7, 20), 0.8225773582671195, 59), (datetime.date(2025, 7, 21), 0.8113494073763412, 70), (datetime.date(2025, 7, 22), 0.7785791609939686, 71), (datetime.date(2025, 7, 23), 0.8061941094691351, 80), (datetime.date(2025, 7, 24), 0.8028271729928489, 67), (datetime.date(2025, 7, 25), 0.8115550860647816, 66), (datetime.date(2025, 7, 26), 0.77661910063718, 69), (datetime.date(2025, 7, 27), 0.8720643003670528, 35)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 7, 1), 0.8330926458285152, 75), (datetime.date(2025, 7, 2), 0.8478553739050155, 36), (datetime.date(2025, 7, 3), 0.8307036328191859, 29), (datetime.date(2025, 7, 4), 0.8620119339320356, 51), (datetime.date(2025, 7, 5), 0.8212693747070223, 79), (datetime.date(2025, 7, 6), 0.8530575117414375, 71), (datetime.date(2025, 7, 7), 0.815195857596316, 72), (datetime.date(2025, 7, 8), 0.7888054613556619, 81), (datetime.date(2025, 7, 9), 0.8207127034296815, 53), (datetime.date(2025, 7, 10), 0.7921214581035552, 39), (datetime.date(2025, 7, 11), 0.828056440303599, 71), (datetime.date(2025, 7, 12), 0.7578551373398715, 75), (datetime.date(2025, 7, 13), 0.811659850814711, 74), (datetime.date(2025, 7, 14), 0.8430980604574009, 65), (datetime.date(2025, 7, 15), 0.7262374565764469, 52), (datetime.date(2025, 7, 16), 0.74745765597167, 28), (datetime.date(2025, 7, 17), 0.7759670304790609, 78), (datetime.date(2025, 7, 18), 0.7901741562548125, 48), (datetime.date(2025, 7, 19), 0.7697804675951871, 78), (datetime.date(2025, 7, 20), 0.8225773582671195, 59), (datetime.date(2025, 7, 21), 0.8113494073763412, 70), (datetime.date(2025, 7, 22), 0.7785791609939686, 71), (datetime.date(2025, 7, 23), 0.8061941094691351, 80), (datetime.date(2025, 7, 24), 0.8028271729928489, 67), (datetime.date(2025, 7, 25), 0.8115550860647816, 66), (datetime.date(2025, 7, 26), 0.77661910063718, 69), (datetime.date(2025, 7, 27), 0.8720643003670528, 35))}, 'quality_array': [['-7.827054415814331', '01072025'], ['-8.315925385433458', '02072025'], ['-8.105389968950366', '03072025'], ['-7.673395755494485', '04072025'], ['-7.731523746178086', '05072025'], ['-8.071480926193178', '06072025'], ['-8.063069961756275', '07072025'], ['-8.043657858968308', '08072025'], ['-7.909680611076746', '09072025'], ['-7.932310113754524', '10072025'], ['-7.780761199509596', '11072025'], ['-7.694835583899124', '12072025'], ['-7.93758043972864', '13072025'], ['-8.107616933813215', '14072025'], ['-7.158709436128257', '15072025'], ['-7.529719760108628', '16072025'], ['-7.729801154404691', '17072025'], ['-8.020575406602463', '18072025'], ['-7.843978720314126', '19072025'], ['-7.9219439747393015', '20072025'], ['-7.541355434534321', '21072025'], ['-7.6740720101439335', '22072025'], ['-7.6955678517340615', '23072025'], ['-7.824570397762929', '24072025'], ['-7.900931645310839', '25072025'], ['-7.817554727400465', '26072025'], ['-7.771940667222259', '27072025']], 'number_of_batch': ((560,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012597026408727998, 'nb_photo': 14128, 'list_port_cont': '24485504,24485665,24485770,24485912,24486005,24486387,24486567,24486705,24487008,24487017,24487082,24487294,24487504,24487634,24487740,24487905,24488032,24488088,24488275,24488619,24488776,24489044,24490636,24503580,24505980,24508598,24511494,24521770,24525198,24528768,24530366,24530460,24530582,24530788,24532765,24533651,24535904,24578635,24578694,24578709,24578755,24578872,24578977,24579087,24579127,24579237,24579310,24579348,24622843,24622904,24623062,24623100,24623163,24623257,24623334,24623373,24623410,24623476,24623782,24623845,24623881,24623987,24626112,24627975,24644346,24645083,24645896,24646664,24647358,24648147,24648931,24649553,24650350,24650783,24650952,24651301,24651611,24651734,24652294,24652337,24652365,24652410,24652493,24652554,24652599,24652827,24652887,24653018,24656868,24656901,24656980,24657084,24657268,24657317,24657341,24657388,24657405,24657488,24657522,24657609,24657636,24657862,24657953,24657982,24658067,24658105,24658175,24658363,24658625,24658650,24659255,24659446,24696338,2469756', 'assoc_port': '24485057:24488619,24485060:24488776,24485064:24488275,24485067:24488088,24485071:24488032,24485074:24487905,24485078:24487740,24485081:24487504,24485085:24487634,24485089:24487008,24485092:24487082,24485094:24487294,24485096:24487017,24485098:24486705,24485100:24486567,24485102:24490636,24485104:24486387,24485106:24486005,24485108:24485770,24485110:24485912,24485112:24485504,24485115:24485665,24488879:24489044,24503237:24503580,24505869:24505980,24508472:24508598,24511365:24511494,24515720:24533651,24520780:24521770,24524357:24525198,24527806:24530460,24527808:24530788,24527810:24530366,24527812:24530582,24527814:24528768,24532194:24532765,24535579:24535904,24578549:24579237,24578551:24579348,24578553:24579310,24578555:24579127,24578557:24579087,24578559:24578755,24578561:24578694,24578563:24578977,24578565:24578709,24578567:24578872,24578569:24578635,24622679:24623782,24622681:24623881,24622695:24623987,24622709:24623845,24622711:24623334,24622713:24623257,24622715:24623410,24622717:24623062,24622719:2462347', 'assoc_mat': '24485057:autre:4230:24488619,24485060:autre:4230:24488776,24485064:autre:4230:24488275,24485067:autre:4230:24488088,24485071:autre:4230:24488032,24485074:autre:4230:24487905,24485078:autre:4230:24487740,24485081:autre:4230:24487504,24485085:autre:4230:24487634,24485089:autre:4230:24487008,24485092:autre:4230:24487082,24485094:autre:4230:24487294,24485096:autre:4230:24487017,24485098:autre:4230:24486705,24485100:autre:4230:24486567,24485102:autre:4230:24490636,24485104:autre:4230:24486387,24485106:autre:4230:24486005,24485108:autre:4230:24485770,24485110:autre:4230:24485912,24485112:autre:4230:24485504,24485115:autre:4230:24485665,24488879:autre:4230:24489044,24503237:autre:4230:24503580,24505869:autre:4230:24505980,24508472:autre:4230:24508598,24511365:autre:4230:24511494,24515720:autre:4230:24533651,24520780:autre:4230:24521770,24524357:autre:4230:24525198,24527806:autre:4230:24530460,24527808:autre:4230:24530788,24527810:autre:4230:24530366,24527812:autre:4230:24530582,24527814:autre:4230:24528768,24532194:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03822149618811542, 'nb_photo': 78493, 'list_port_cont': '24485508,24485653,24485762,24485909,24486003,24486388,24486582,24486712,24487006,24487025,24487076,24487307,24487505,24487633,24487746,24487896,24488035,24488096,24488277,24488614,24488785,24489053,24490651,24503573,24505977,24508597,24511506,24521768,24525202,24528769,24530368,24530455,24530585,24530778,24532755,24533641,24535897,24578637,24578696,24578715,24578781,24578874,24578974,24579092,24579128,24579242,24579315,24579366,24622836,24622906,24623059,24623102,24623148,24623255,24623344,24623381,24623417,24623479,24623794,24623850,24623884,24623997,24626120,24627984,24644348,24645096,24645900,24646681,24647370,24648151,24648940,24649555,24650359,24650772,24650958,24651294,24651610,24651743,24652279,24652332,24652378,24652419,24652506,24652563,24652602,24652836,24652894,24653032,24656878,24656906,24656977,24657095,24657282,24657319,24657345,24657390,24657425,24657499,24657537,24657601,24657638,24657864,24657957,24657983,24658083,24658110,24658179,24658362,24658620,24658653,24659262,24659443,24696350,2469756', 'assoc_port': '24485057:24488614,24485060:24488785,24485064:24488277,24485067:24488096,24485071:24488035,24485074:24487896,24485078:24487746,24485081:24487505,24485085:24487633,24485089:24487006,24485092:24487076,24485094:24487307,24485096:24487025,24485098:24486712,24485100:24486582,24485102:24490651,24485104:24486388,24485106:24486003,24485108:24485762,24485110:24485909,24485112:24485508,24485115:24485653,24488879:24489053,24503237:24503573,24505869:24505977,24508472:24508597,24511365:24511506,24515720:24533641,24520780:24521768,24524357:24525202,24527806:24530455,24527808:24530778,24527810:24530368,24527812:24530585,24527814:24528769,24532194:24532755,24535579:24535897,24578549:24579242,24578551:24579366,24578553:24579315,24578555:24579128,24578557:24579092,24578559:24578781,24578561:24578696,24578563:24578974,24578565:24578715,24578567:24578874,24578569:24578637,24622679:24623794,24622681:24623884,24622695:24623997,24622709:24623850,24622711:24623344,24622713:24623255,24622715:24623417,24622717:24623059,24622719:2462347', 'assoc_mat': '24485057:carton:4230:24488614,24485060:carton:4230:24488785,24485064:carton:4230:24488277,24485067:carton:4230:24488096,24485071:carton:4230:24488035,24485074:carton:4230:24487896,24485078:carton:4230:24487746,24485081:carton:4230:24487505,24485085:carton:4230:24487633,24485089:carton:4230:24487006,24485092:carton:4230:24487076,24485094:carton:4230:24487307,24485096:carton:4230:24487025,24485098:carton:4230:24486712,24485100:carton:4230:24486582,24485102:carton:4230:24490651,24485104:carton:4230:24486388,24485106:carton:4230:24486003,24485108:carton:4230:24485762,24485110:carton:4230:24485909,24485112:carton:4230:24485508,24485115:carton:4230:24485653,24488879:carton:4230:24489053,24503237:carton:4230:24503573,24505869:carton:4230:24505977,24508472:carton:4230:24508597,24511365:carton:4230:24511506,24515720:carton:4230:24533641,24520780:carton:4230:24521768,24524357:carton:4230:24525202,24527806:carton:4230:24530455,24527808:carton:4230:24530778,24527810:carton:4230:24530368,24527812:carton:4230:24530585,2452'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010984659259666856, 'nb_photo': 1654, 'list_port_cont': '24485509,24485651,24485758,24485906,24486007,24486382,24486574,24486720,24487007,24487009,24487080,24487297,24487499,24487619,24487735,24487906,24488021,24488098,24488272,24488599,24488786,24489057,24490637,24503574,24505967,24508586,24521755,24525207,24528755,24530360,24530450,24530576,24532768,24533644,24535896,24578639,24578708,24578771,24578871,24578961,24579098,24579135,24579238,24579314,24579335,24622834,24622928,24623049,24623094,24623152,24623266,24623370,24623411,24623468,24623796,24623848,24623882,24623998,24626127,24645094,24645876,24646675,24647369,24648142,24648941,24649549,24650358,24650773,24650945,24651295,24652328,24652368,24652402,24652499,24652567,24652595,24652843,24652886,24653021,24656865,24656914,24656983,24657308,24657354,24657386,24657422,24657489,24657608,24657639,24657859,24657954,24658082,24658112,24658176,24658369,24658612,24659263,24659439,24696343,24697556,24697759,24697989,24698125,24698177,24698534,24698784,24698867,24699148,24699286,24699436,24699507,24699566,24699855,2469993', 'assoc_port': '24485057:24488599,24485060:24488786,24485064:24488272,24485067:24488098,24485071:24488021,24485074:24487906,24485078:24487735,24485081:24487499,24485085:24487619,24485089:24487007,24485092:24487080,24485094:24487297,24485096:24487009,24485098:24486720,24485100:24486574,24485102:24490637,24485104:24486382,24485106:24486007,24485108:24485758,24485110:24485906,24485112:24485509,24485115:24485651,24488879:24489057,24503237:24503574,24505869:24505967,24508472:24508586,24515720:24533644,24520780:24521755,24524357:24525207,24527806:24530450,24527810:24530360,24527812:24530576,24527814:24528755,24532194:24532768,24535579:24535896,24578549:24579238,24578551:24579335,24578553:24579314,24578555:24579135,24578557:24579098,24578559:24578771,24578563:24578961,24578565:24578708,24578567:24578871,24578569:24578639,24622679:24623796,24622681:24623882,24622695:24623998,24622709:24623848,24622713:24623266,24622715:24623411,24622717:24623049,24622719:24623468,24622721:24623370,24622722:24622928,24622724:24623152,24622725:2462283', 'assoc_mat': '24485057:metal:4230:24488599,24485060:metal:4230:24488786,24485064:metal:4230:24488272,24485067:metal:4230:24488098,24485071:metal:4230:24488021,24485074:metal:4230:24487906,24485078:metal:4230:24487735,24485081:metal:4230:24487499,24485085:metal:4230:24487619,24485089:metal:4230:24487007,24485092:metal:4230:24487080,24485094:metal:4230:24487297,24485096:metal:4230:24487009,24485098:metal:4230:24486720,24485100:metal:4230:24486574,24485102:metal:4230:24490637,24485104:metal:4230:24486382,24485106:metal:4230:24486007,24485108:metal:4230:24485758,24485110:metal:4230:24485906,24485112:metal:4230:24485509,24485115:metal:4230:24485651,24488879:metal:4230:24489057,24503237:metal:4230:24503574,24505869:metal:4230:24505967,24508472:metal:4230:24508586,24515720:metal:4230:24533644,24520780:metal:4230:24521755,24524357:metal:4230:24525207,24527806:metal:4230:24530450,24527810:metal:4230:24530360,24527812:metal:4230:24530576,24527814:metal:4230:24528755,24532194:metal:4230:24532768,24535579:metal:4230:24535896,24578549:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.13379624884514216, 'nb_photo': 261326, 'list_port_cont': '24485500,24485663,24485767,24485914,24486008,24486386,24486584,24486719,24487000,24487015,24487084,24487303,24487507,24487635,24487743,24487904,24488028,24488092,24488270,24488620,24488782,24489055,24490650,24503578,24505981,24508589,24511504,24521762,24525208,24528772,24530374,24530452,24530590,24530790,24532770,24533654,24535899,24578631,24578698,24578716,24578769,24578877,24578976,24579091,24579133,24579230,24579308,24579364,24622839,24622924,24623063,24623101,24623160,24623262,24623340,24623380,24623419,24623475,24623788,24623847,24623888,24623995,24626124,24627987,24644341,24645100,24645898,24646671,24647360,24648144,24648937,24649557,24650349,24650771,24650959,24651302,24651617,24651737,24652290,24652334,24652381,24652412,24652508,24652558,24652604,24652839,24652896,24653034,24656876,24656912,24656992,24657100,24657280,24657309,24657348,24657389,24657403,24657494,24657532,24657607,24657642,24657855,24657955,24657993,24658077,24658106,24658192,24658370,24658623,24658652,24659252,24659449,24696349,2469754', 'assoc_port': '24485057:24488620,24485060:24488782,24485064:24488270,24485067:24488092,24485071:24488028,24485074:24487904,24485078:24487743,24485081:24487507,24485085:24487635,24485089:24487000,24485092:24487084,24485094:24487303,24485096:24487015,24485098:24486719,24485100:24486584,24485102:24490650,24485104:24486386,24485106:24486008,24485108:24485767,24485110:24485914,24485112:24485500,24485115:24485663,24488879:24489055,24503237:24503578,24505869:24505981,24508472:24508589,24511365:24511504,24515720:24533654,24520780:24521762,24524357:24525208,24527806:24530452,24527808:24530790,24527810:24530374,24527812:24530590,24527814:24528772,24532194:24532770,24535579:24535899,24578549:24579230,24578551:24579364,24578553:24579308,24578555:24579133,24578557:24579091,24578559:24578769,24578561:24578698,24578563:24578976,24578565:24578716,24578567:24578877,24578569:24578631,24622679:24623788,24622681:24623888,24622695:24623995,24622709:24623847,24622711:24623340,24622713:24623262,24622715:24623419,24622717:24623063,24622719:2462347', 'assoc_mat': '24485057:papier:4230:24488620,24485060:papier:4230:24488782,24485064:papier:4230:24488270,24485067:papier:4230:24488092,24485071:papier:4230:24488028,24485074:papier:4230:24487904,24485078:papier:4230:24487743,24485081:papier:4230:24487507,24485085:papier:4230:24487635,24485089:papier:4230:24487000,24485092:papier:4230:24487084,24485094:papier:4230:24487303,24485096:papier:4230:24487015,24485098:papier:4230:24486719,24485100:papier:4230:24486584,24485102:papier:4230:24490650,24485104:papier:4230:24486386,24485106:papier:4230:24486008,24485108:papier:4230:24485767,24485110:papier:4230:24485914,24485112:papier:4230:24485500,24485115:papier:4230:24485663,24488879:papier:4230:24489055,24503237:papier:4230:24503578,24505869:papier:4230:24505981,24508472:papier:4230:24508589,24511365:papier:4230:24511504,24515720:papier:4230:24533654,24520780:papier:4230:24521762,24524357:papier:4230:24525208,24527806:papier:4230:24530452,24527808:papier:4230:24530790,24527810:papier:4230:24530374,24527812:papier:4230:24530590,2452'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0019405773133772562, 'nb_photo': 845, 'list_port_cont': '24485502,24486581,24486717,24487018,24487071,24487508,24488605,24488773,24503575,24525204,24528763,24530371,24530792,24535907,24578641,24578706,24578866,24578975,24579229,24579306,24622842,24623057,24623261,24623467,24623795,24623852,24623885,24623994,24644349,24645097,24645890,24646673,24647365,24648932,24651304,24652284,24652323,24652382,24652406,24652564,24653031,24657343,24657380,24657491,24657605,24657643,24657866,24657950,24658081,24658186,24658614,24658651,24697892,24698176,24698880,24699152,24699443,24699495,24699576,24700218,24700472,24703448,24706182,24737138,24737324,24737362,24737637,24737688,24737717,24737975,24738142,24738210,24738234,24738291,24738397,24738465,24738563,24738862,24739262,24740460,24770930,24771061,24771171,24771434,24771507,24771736,24771922,24771970,24772033,24772118,24777176,24821982,24825535,24856969,24857333,24857646,24857769,24858061,24858534,24859325,24859835,24860166,24860787,24860869,24860896,24861139,24861347,24865708,24885618,24886137,24886828,24887370,24888047,2488858', 'assoc_port': '24485057:24488605,24485060:24488773,24485081:24487508,24485092:24487071,24485096:24487018,24485098:24486717,24485100:24486581,24485112:24485502,24503237:24503575,24524357:24525204,24527808:24530792,24527810:24530371,24527814:24528763,24535579:24535907,24578549:24579229,24578553:24579306,24578563:24578975,24578565:24578706,24578567:24578866,24578569:24578641,24622679:24623795,24622681:24623885,24622695:24623994,24622709:24623852,24622713:24623261,24622717:24623057,24622719:24623467,24622725:24622842,24644273:24644349,24644889:24645097,24645694:24645890,24646497:24646673,24647189:24647365,24648771:24648932,24650048:24651304,24650063:24652382,24650070:24652564,24650073:24652284,24650077:24652323,24650084:24652406,24652932:24653031,24656773:24658081,24656777:24658651,24656780:24658614,24656787:24657950,24656791:24657866,24656794:24658186,24656798:24657643,24656805:24657491,24656807:24657380,24656811:24657343,24656813:24657605,24695373:24703448,24695386:24700472,24695388:24700218,24695391:24699576,24695396:2469949', 'assoc_mat': '24485057:pehd:4230:24488605,24485060:pehd:4230:24488773,24485081:pehd:4230:24487508,24485092:pehd:4230:24487071,24485096:pehd:4230:24487018,24485098:pehd:4230:24486717,24485100:pehd:4230:24486581,24485112:pehd:4230:24485502,24503237:pehd:4230:24503575,24524357:pehd:4230:24525204,24527808:pehd:4230:24530792,24527810:pehd:4230:24530371,24527814:pehd:4230:24528763,24535579:pehd:4230:24535907,24578549:pehd:4230:24579229,24578553:pehd:4230:24579306,24578563:pehd:4230:24578975,24578565:pehd:4230:24578706,24578567:pehd:4230:24578866,24578569:pehd:4230:24578641,24622679:pehd:4230:24623795,24622681:pehd:4230:24623885,24622695:pehd:4230:24623994,24622709:pehd:4230:24623852,24622713:pehd:4230:24623261,24622717:pehd:4230:24623057,24622719:pehd:4230:24623467,24622725:pehd:4230:24622842,24644273:pehd:4230:24644349,24644889:pehd:4230:24645097,24645694:pehd:4230:24645890,24646497:pehd:4230:24646673,24647189:pehd:4230:24647365,24648771:pehd:4230:24648932,24650048:pehd:4230:24651304,24650063:pehd:4230:24652382,24650070:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015401600686769277, 'nb_photo': 16503, 'list_port_cont': '24485496,24485664,24485768,24485911,24486012,24486385,24486585,24486715,24487002,24487019,24487079,24487308,24487506,24487625,24487750,24487903,24488030,24488094,24488266,24488621,24488787,24489061,24490649,24503576,24505969,24508602,24511500,24521763,24525209,24528761,24530370,24530457,24530586,24530761,24532761,24533645,24535903,24578638,24578689,24578703,24578763,24578878,24578972,24579095,24579131,24579239,24579311,24579362,24622847,24622932,24623061,24623089,24623157,24623258,24623333,24623375,24623418,24623474,24623791,24623855,24623895,24623996,24626113,24627977,24644343,24645089,24645902,24646682,24647357,24648153,24648939,24649546,24650355,24650781,24650951,24651306,24651607,24651741,24652286,24652333,24652379,24652411,24652507,24652568,24652593,24652838,24652884,24653029,24656879,24656917,24656988,24657089,24657276,24657312,24657353,24657391,24657414,24657490,24657534,24657599,24657645,24657863,24657951,24657986,24658075,24658116,24658185,24658367,24658611,24658655,24659257,24659447,24696353,2469755', 'assoc_port': '24485057:24488621,24485060:24488787,24485064:24488266,24485067:24488094,24485071:24488030,24485074:24487903,24485078:24487750,24485081:24487506,24485085:24487625,24485089:24487002,24485092:24487079,24485094:24487308,24485096:24487019,24485098:24486715,24485100:24486585,24485102:24490649,24485104:24486385,24485106:24486012,24485108:24485768,24485110:24485911,24485112:24485496,24485115:24485664,24488879:24489061,24503237:24503576,24505869:24505969,24508472:24508602,24511365:24511500,24515720:24533645,24520780:24521763,24524357:24525209,24527806:24530457,24527808:24530761,24527810:24530370,24527812:24530586,24527814:24528761,24532194:24532761,24535579:24535903,24578549:24579239,24578551:24579362,24578553:24579311,24578555:24579131,24578557:24579095,24578559:24578763,24578561:24578689,24578563:24578972,24578565:24578703,24578567:24578878,24578569:24578638,24622679:24623791,24622681:24623895,24622695:24623996,24622709:24623855,24622711:24623333,24622713:24623258,24622715:24623418,24622717:24623061,24622719:2462347', 'assoc_mat': '24485057:pet_clair:4230:24488621,24485060:pet_clair:4230:24488787,24485064:pet_clair:4230:24488266,24485067:pet_clair:4230:24488094,24485071:pet_clair:4230:24488030,24485074:pet_clair:4230:24487903,24485078:pet_clair:4230:24487750,24485081:pet_clair:4230:24487506,24485085:pet_clair:4230:24487625,24485089:pet_clair:4230:24487002,24485092:pet_clair:4230:24487079,24485094:pet_clair:4230:24487308,24485096:pet_clair:4230:24487019,24485098:pet_clair:4230:24486715,24485100:pet_clair:4230:24486585,24485102:pet_clair:4230:24490649,24485104:pet_clair:4230:24486385,24485106:pet_clair:4230:24486012,24485108:pet_clair:4230:24485768,24485110:pet_clair:4230:24485911,24485112:pet_clair:4230:24485496,24485115:pet_clair:4230:24485664,24488879:pet_clair:4230:24489061,24503237:pet_clair:4230:24503576,24505869:pet_clair:4230:24505969,24508472:pet_clair:4230:24508602,24511365:pet_clair:4230:24511500,24515720:pet_clair:4230:24533645,24520780:pet_clair:4230:24521763,24524357:pet_clair:4230:24525209,24527806:pet_clair:4230:24530457,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021226305323105753, 'nb_photo': 547, 'list_port_cont': '24485902,24486381,24486577,24486710,24487081,24487751,24488031,24490643,24530365,24530786,24578642,24578875,24578959,24579124,24579240,24622840,24622922,24623065,24623091,24623161,24623265,24623379,24623416,24623469,24623890,24624000,24626122,24627986,24644342,24645884,24646660,24647366,24648150,24649558,24650353,24650778,24650953,24651305,24651620,24651742,24652291,24652327,24652380,24652408,24652566,24652605,24652837,24653023,24657379,24657498,24657989,24658372,24697894,24697987,24698878,24699133,24699430,24700216,24700255,24700467,24738146,24738215,24738222,24738283,24738406,24738462,24738560,24739243,24740462,24770266,24771059,24771168,24771289,24771440,24771511,24771744,24771961,24772038,24772112,24777184,24821944,24821948,24856967,24857335,24857859,24858065,24858545,24859834,24860152,24860173,24860788,24860862,24861147,24861349,24862838,24865711,24885623,24886133,24887365,24888059,24888597,24889289,24890513,24891419,24891460,24891495,24891612,24891734,24891779,24892908,24893071,24894022,24894161,2489435', 'assoc_port': '24485071:24488031,24485078:24487751,24485092:24487081,24485098:24486710,24485100:24486577,24485102:24490643,24485104:24486381,24485110:24485902,24527808:24530786,24527810:24530365,24578549:24579240,24578555:24579124,24578563:24578959,24578567:24578875,24578569:24578642,24622681:24623890,24622695:24624000,24622713:24623265,24622715:24623416,24622717:24623065,24622719:24623469,24622721:24623379,24622722:24622922,24622724:24623161,24622725:24622840,24622726:24623091,24625790:24626122,24627860:24627986,24644273:24644342,24645694:24645884,24646497:24646660,24647189:24647366,24647987:24648150,24649379:24649558,24650042:24650353,24650044:24650778,24650046:24650953,24650048:24651305,24650052:24651620,24650055:24651742,24650063:24652380,24650066:24652605,24650070:24652566,24650073:24652291,24650077:24652327,24650084:24652408,24652705:24652837,24652932:24653023,24656770:24658372,24656801:24657989,24656805:24657498,24656807:24657379,24695383:24700255,24695386:24700467,24695388:24700216,24695399:24699430,24695401:2469887', 'assoc_mat': '24485071:pet_fonce:4230:24488031,24485078:pet_fonce:4230:24487751,24485092:pet_fonce:4230:24487081,24485098:pet_fonce:4230:24486710,24485100:pet_fonce:4230:24486577,24485102:pet_fonce:4230:24490643,24485104:pet_fonce:4230:24486381,24485110:pet_fonce:4230:24485902,24527808:pet_fonce:4230:24530786,24527810:pet_fonce:4230:24530365,24578549:pet_fonce:4230:24579240,24578555:pet_fonce:4230:24579124,24578563:pet_fonce:4230:24578959,24578567:pet_fonce:4230:24578875,24578569:pet_fonce:4230:24578642,24622681:pet_fonce:4230:24623890,24622695:pet_fonce:4230:24624000,24622713:pet_fonce:4230:24623265,24622715:pet_fonce:4230:24623416,24622717:pet_fonce:4230:24623065,24622719:pet_fonce:4230:24623469,24622721:pet_fonce:4230:24623379,24622722:pet_fonce:4230:24622922,24622724:pet_fonce:4230:24623161,24622725:pet_fonce:4230:24622840,24622726:pet_fonce:4230:24623091,24625790:pet_fonce:4230:24626122,24627860:pet_fonce:4230:24627986,24644273:pet_fonce:4230:24644342,24645694:pet_fonce:4230:24645884,24646497:pet_fonce:4230:24646660,2'}), 'main_stat': {'nb_photos': 1673}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-07', 0.8064509072650274),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_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', '1.26%', 14128], 'carton': ['carton', '3.82%', 78493], 'metal': ['metal', '0.11%', 1654], 'papier': ['papier', '13.38%', 261326], 'pehd': ['pehd', '0.19%', 845], 'pet_clair': ['pet_clair', '1.54%', 16503], 'pet_fonce': ['pet_fonce', '0.21%', 547]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_07_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.69user 1.73system 0:07.01elapsed 63%CPU (0avgtext+0avgdata 175628maxresident)k 2432inputs+280outputs (31major+44500minor)pagefaults 0swaps