python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_2/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-01 _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 : (2, 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 : (2, 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 : 01 mtr_id : dashboard_places : SCCU_cam7 date : 2025-01 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-01%') and created_at like '%2025-01%'))); nb_day : (2, 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) = 01 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) = 01 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 '%012025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-01-01 : dt_date_just_month_year : 2025-01-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-01-01" AND ded.date <= "2025-01-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 (1506641,1509618,1513164,1516958,1517644,1520327,1522988,1525545,1526151,1528189,1530484,1531372,1533758,1537601,1541270,1543092,1544863,1546558,1547668,1549773,1552009,1554274,1556072,1558979,1561123,1562334,1565327,1568634,1571961,1575029,1577826) 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.015901388126300802, 'nb_photo': 22258, 'list_port_cont': '19360451,19360485,19360560,19360637,19360790,19360813,19360928,19360957,19361080,19361149,19361247,19361349,19361429,19361535,19361618,19361645,19361792,19361922,19362003,19362068,19362309,19362411,19362451,19362541,19378767,19378850,19379030,19379065,19379226,19379574,19379656,19379704,19379892,19380151,19380271,19380496,19380524,19380728,19380767,19380879,19380985,19381069,19381170,19381203,19381229,19381282,19381334,19381846,19399480,19399582,19399697,19399838,19399880,19399913,19400064,19400229,19400475,19400572,19400622,19400708,19400812,19400958,19401035,19401325,19401423,19401564,19401683,19401795,19401933,19402116,19402144,19402993,19406924,19407578,19407873,19408115,19408538,19409162,19409616,19409959,19410410,19410679,19411052,19411540,19412104,19412382,19413431,19414100,19417135,19417185,19417206,19417251,19417290,19417362,19417393,19417972,19423903,19423974,19424016,19424057,19424085,19424133,19424166,19424198,19424231,19424302,19424353,19424379,19424447,19424499,19424522,19424572,19424597,1942463', 'assoc_port': '19360357:19362411,19360359:19362451,19360361:19362068,19360364:19362003,19360366:19361922,19360369:19361792,19360370:19361535,19360372:19361618,19360374:19361645,19360377:19361247,19360378:19361429,19360380:19361349,19360382:19360957,19360384:19361149,19360386:19361080,19360388:19360928,19360390:19360813,19360392:19360790,19360394:19360451,19360397:19360560,19360399:19360637,19360400:19360485,19362213:19362309,19362491:19362541,19377817:19381229,19377818:19381282,19377819:19381334,19377823:19381203,19377825:19381170,19377828:19381069,19377831:19380728,19377834:19380767,19377837:19380879,19377840:19380496,19377843:19380524,19377846:19380271,19377849:19379704,19377852:19379892,19377855:19380151,19377858:19379656,19377861:19379574,19377864:19379226,19377867:19378767,19377870:19379030,19377873:19379065,19377876:19378850,19380759:19380985,19381692:19381846,19399344:19401933,19399347:19402116,19399350:19401795,19399353:19401683,19399356:19401564,19399359:19401035,19399362:19401325,19399365:19401423,19399368:1940095', 'assoc_mat': '19360357:autre:4230:19362411,19360359:autre:4230:19362451,19360361:autre:4230:19362068,19360364:autre:4230:19362003,19360366:autre:4230:19361922,19360369:autre:4230:19361792,19360370:autre:4230:19361535,19360372:autre:4230:19361618,19360374:autre:4230:19361645,19360377:autre:4230:19361247,19360378:autre:4230:19361429,19360380:autre:4230:19361349,19360382:autre:4230:19360957,19360384:autre:4230:19361149,19360386:autre:4230:19361080,19360388:autre:4230:19360928,19360390:autre:4230:19360813,19360392:autre:4230:19360790,19360394:autre:4230:19360451,19360397:autre:4230:19360560,19360399:autre:4230:19360637,19360400:autre:4230:19360485,19362213:autre:4230:19362309,19362491:autre:4230:19362541,19377817:autre:4230:19381229,19377818:autre:4230:19381282,19377819:autre:4230:19381334,19377823:autre:4230:19381203,19377825:autre:4230:19381170,19377828:autre:4230:19381069,19377831:autre:4230:19380728,19377834:autre:4230:19380767,19377837:autre:4230:19380879,19377840:autre:4230:19380496,19377843:autre:4230:19380524,19377846:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07039616708600642, 'nb_photo': 136468, 'list_port_cont': '19360459,19360495,19360570,19360641,19360789,19360825,19360931,19360966,19361070,19361155,19361250,19361358,19361431,19361542,19361612,19361651,19361798,19361926,19362005,19362085,19362300,19362405,19362446,19362537,19378782,19378851,19379032,19379059,19379235,19379581,19379653,19379717,19379891,19380156,19380286,19380492,19380528,19380735,19380777,19380878,19380991,19381070,19381158,19381204,19381241,19381274,19381335,19381845,19399470,19399573,19399695,19399832,19399877,19399910,19400071,19400236,19400474,19400588,19400627,19400720,19400814,19400966,19401040,19401314,19401439,19401580,19401689,19401794,19401935,19402108,19402154,19402986,19406923,19407563,19407877,19408111,19408547,19409164,19409606,19409961,19410411,19410690,19411049,19411543,19412108,19412395,19413442,19414102,19417150,19417182,19417218,19417245,19417291,19417359,19417395,19417981,19423916,19423985,19424024,19424062,19424094,19424137,19424169,19424205,19424237,19424308,19424342,19424392,19424461,19424487,19424534,19424571,19424599,1942462', 'assoc_port': '19360357:19362405,19360359:19362446,19360361:19362085,19360364:19362005,19360366:19361926,19360369:19361798,19360370:19361542,19360372:19361612,19360374:19361651,19360377:19361250,19360378:19361431,19360380:19361358,19360382:19360966,19360384:19361155,19360386:19361070,19360388:19360931,19360390:19360825,19360392:19360789,19360394:19360459,19360397:19360570,19360399:19360641,19360400:19360495,19362213:19362300,19362491:19362537,19377817:19381241,19377818:19381274,19377819:19381335,19377823:19381204,19377825:19381158,19377828:19381070,19377831:19380735,19377834:19380777,19377837:19380878,19377840:19380492,19377843:19380528,19377846:19380286,19377849:19379717,19377852:19379891,19377855:19380156,19377858:19379653,19377861:19379581,19377864:19379235,19377867:19378782,19377870:19379032,19377873:19379059,19377876:19378851,19380759:19380991,19381692:19381845,19399344:19401935,19399347:19402108,19399350:19401794,19399353:19401689,19399356:19401580,19399359:19401040,19399362:19401314,19399365:19401439,19399368:1940096', 'assoc_mat': '19360357:carton:4230:19362405,19360359:carton:4230:19362446,19360361:carton:4230:19362085,19360364:carton:4230:19362005,19360366:carton:4230:19361926,19360369:carton:4230:19361798,19360370:carton:4230:19361542,19360372:carton:4230:19361612,19360374:carton:4230:19361651,19360377:carton:4230:19361250,19360378:carton:4230:19361431,19360380:carton:4230:19361358,19360382:carton:4230:19360966,19360384:carton:4230:19361155,19360386:carton:4230:19361070,19360388:carton:4230:19360931,19360390:carton:4230:19360825,19360392:carton:4230:19360789,19360394:carton:4230:19360459,19360397:carton:4230:19360570,19360399:carton:4230:19360641,19360400:carton:4230:19360495,19362213:carton:4230:19362300,19362491:carton:4230:19362537,19377817:carton:4230:19381241,19377818:carton:4230:19381274,19377819:carton:4230:19381335,19377823:carton:4230:19381204,19377825:carton:4230:19381158,19377828:carton:4230:19381070,19377831:carton:4230:19380735,19377834:carton:4230:19380777,19377837:carton:4230:19380878,19377840:carton:4230:19380492,1937'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0015028216805139177, 'nb_photo': 2536, 'list_port_cont': '19360786,19361245,19361425,19361543,19361611,19361642,19361923,19362078,19362409,19379031,19379056,19379564,19379655,19379712,19379889,19380288,19380531,19380881,19381231,19381280,19399481,19399574,19399694,19399830,19399868,19399915,19400070,19400480,19400574,19400631,19400718,19400823,19400967,19401433,19402119,19402141,19402991,19406917,19407881,19408099,19408535,19409139,19409607,19409950,19410413,19410681,19411050,19411547,19412095,19412386,19413445,19414104,19417141,19417181,19417209,19417242,19417294,19417389,19423899,19423976,19424026,19424055,19424084,19424121,19424163,19424204,19424240,19424312,19424382,19424462,19424491,19424523,19424568,19424604,19424642,19424669,19424748,19424885,19426021,19442793,19442826,19442831,19442920,19443250,19443270,19443348,19443589,19443714,19443850,19443989,19444030,19444053,19444087,19444401,19444547,19444694,19445238,19445972,19447723,19447988,19448851,19449195,19449628,19450127,19450822,19451847,19452211,19452329,19452401,19453251,19454103,19454933,19455712,1945659', 'assoc_port': '19360357:19362409,19360361:19362078,19360366:19361923,19360370:19361543,19360372:19361611,19360374:19361642,19360377:19361245,19360378:19361425,19360392:19360786,19377817:19381231,19377818:19381280,19377837:19380881,19377843:19380531,19377846:19380288,19377849:19379712,19377852:19379889,19377858:19379655,19377861:19379564,19377870:19379031,19377873:19379056,19399347:19402119,19399365:19401433,19399368:19400967,19399371:19400823,19399374:19400718,19399377:19400480,19399380:19400574,19399383:19400631,19399389:19400070,19399392:19399915,19399395:19399694,19399398:19399830,19399401:19399868,19399404:19399574,19399406:19399481,19401817:19402141,19402851:19402991,19406788:19406917,19407783:19407881,19408045:19408099,19408454:19408535,19409040:19409139,19409543:19409607,19409882:19409950,19410304:19410413,19410616:19410681,19410954:19411050,19411480:19411547,19411986:19412095,19412358:19412386,19413257:19413445,19413960:19414104,19414837:19417294,19414840:19417209,19414842:19417242,19414845:19417141,19414848:1941718', 'assoc_mat': '19360357:metal:4230:19362409,19360361:metal:4230:19362078,19360366:metal:4230:19361923,19360370:metal:4230:19361543,19360372:metal:4230:19361611,19360374:metal:4230:19361642,19360377:metal:4230:19361245,19360378:metal:4230:19361425,19360392:metal:4230:19360786,19377817:metal:4230:19381231,19377818:metal:4230:19381280,19377837:metal:4230:19380881,19377843:metal:4230:19380531,19377846:metal:4230:19380288,19377849:metal:4230:19379712,19377852:metal:4230:19379889,19377858:metal:4230:19379655,19377861:metal:4230:19379564,19377870:metal:4230:19379031,19377873:metal:4230:19379056,19399347:metal:4230:19402119,19399365:metal:4230:19401433,19399368:metal:4230:19400967,19399371:metal:4230:19400823,19399374:metal:4230:19400718,19399377:metal:4230:19400480,19399380:metal:4230:19400574,19399383:metal:4230:19400631,19399389:metal:4230:19400070,19399392:metal:4230:19399915,19399395:metal:4230:19399694,19399398:metal:4230:19399830,19399401:metal:4230:19399868,19399404:metal:4230:19399574,19399406:metal:4230:19399481,19401817:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.21454960600971193, 'nb_photo': 477972, 'list_port_cont': '19360457,19360483,19360568,19360643,19360787,19360823,19360929,19360963,19361071,19361153,19361238,19361359,19361420,19361533,19361617,19361653,19361800,19361933,19361995,19362084,19362308,19362404,19362456,19362540,19378775,19378853,19379025,19379066,19379222,19379575,19379649,19379703,19379885,19380158,19380284,19380494,19380523,19380729,19380775,19380882,19380995,19381071,19381155,19381205,19381244,19381269,19381337,19381844,19399479,19399585,19399693,19399837,19399871,19399911,19400077,19400227,19400470,19400587,19400637,19400715,19400818,19400952,19401031,19401326,19401440,19401578,19401677,19401791,19401930,19402118,19402153,19402984,19406919,19407566,19407886,19408106,19408546,19409161,19409604,19409953,19410414,19410693,19411048,19411553,19412109,19412390,19413441,19414099,19417149,19417183,19417221,19417257,19417295,19417353,19417391,19417979,19423904,19423981,19424020,19424061,19424097,19424130,19424170,19424201,19424242,19424318,19424347,19424388,19424455,19424498,19424533,19424570,19424594,1942464', 'assoc_port': '19360357:19362404,19360359:19362456,19360361:19362084,19360364:19361995,19360366:19361933,19360369:19361800,19360370:19361533,19360372:19361617,19360374:19361653,19360377:19361238,19360378:19361420,19360380:19361359,19360382:19360963,19360384:19361153,19360386:19361071,19360388:19360929,19360390:19360823,19360392:19360787,19360394:19360457,19360397:19360568,19360399:19360643,19360400:19360483,19362213:19362308,19362491:19362540,19377817:19381244,19377818:19381269,19377819:19381337,19377823:19381205,19377825:19381155,19377828:19381071,19377831:19380729,19377834:19380775,19377837:19380882,19377840:19380494,19377843:19380523,19377846:19380284,19377849:19379703,19377852:19379885,19377855:19380158,19377858:19379649,19377861:19379575,19377864:19379222,19377867:19378775,19377870:19379025,19377873:19379066,19377876:19378853,19380759:19380995,19381692:19381844,19399344:19401930,19399347:19402118,19399350:19401791,19399353:19401677,19399356:19401578,19399359:19401031,19399362:19401326,19399365:19401440,19399368:1940095', 'assoc_mat': '19360357:papier:4230:19362404,19360359:papier:4230:19362456,19360361:papier:4230:19362084,19360364:papier:4230:19361995,19360366:papier:4230:19361933,19360369:papier:4230:19361800,19360370:papier:4230:19361533,19360372:papier:4230:19361617,19360374:papier:4230:19361653,19360377:papier:4230:19361238,19360378:papier:4230:19361420,19360380:papier:4230:19361359,19360382:papier:4230:19360963,19360384:papier:4230:19361153,19360386:papier:4230:19361071,19360388:papier:4230:19360929,19360390:papier:4230:19360823,19360392:papier:4230:19360787,19360394:papier:4230:19360457,19360397:papier:4230:19360568,19360399:papier:4230:19360643,19360400:papier:4230:19360483,19362213:papier:4230:19362308,19362491:papier:4230:19362540,19377817:papier:4230:19381244,19377818:papier:4230:19381269,19377819:papier:4230:19381337,19377823:papier:4230:19381205,19377825:papier:4230:19381155,19377828:papier:4230:19381071,19377831:papier:4230:19380729,19377834:papier:4230:19380775,19377837:papier:4230:19380882,19377840:papier:4230:19380494,1937'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003922854685352931, 'nb_photo': 2764, 'list_port_cont': '19361935,19362413,19362454,19379654,19379706,19380525,19380778,19381278,19399688,19399835,19400232,19400468,19400586,19400962,19401435,19408116,19409166,19409960,19410419,19410684,19411549,19412103,19414097,19417180,19417222,19417253,19417386,19417982,19424565,19424638,19424753,19424892,19442784,19442821,19442931,19443244,19443286,19443352,19443605,19443842,19443991,19444024,19444059,19444099,19445247,19445981,19447739,19448848,19449191,19449630,19450821,19451840,19452216,19452325,19452402,19453263,19454112,19454937,19455716,19456605,19457336,19458791,19459607,19460616,19461546,19462820,19463377,19465058,19465392,19465608,19466305,19466881,19467371,19467710,19468656,19469131,19470247,19473003,19474017,19474698,19476650,19477004,19478019,19479503,19480826,19484784,19486358,19492350,19492555,19493519,19493990,19495429,19495445,19495501,19496509,19497449,19497708,19498467,19498677,19499516,19500013,19501497,19501688,19502257,19502396,19502511,19502586,19502857,19502957,19503335,19503479,19503554,19503605,1950417', 'assoc_port': '19360357:19362413,19360359:19362454,19360366:19361935,19377818:19381278,19377834:19380778,19377843:19380525,19377849:19379706,19377858:19379654,19399365:19401435,19399368:19400962,19399377:19400468,19399380:19400586,19399386:19400232,19399395:19399688,19399398:19399835,19408045:19408116,19409040:19409166,19409882:19409960,19410304:19410419,19410616:19410684,19411480:19411549,19411986:19412103,19413960:19414097,19414840:19417222,19414842:19417253,19414848:19417180,19417315:19417386,19417870:19417982,19423877:19424892,19423878:19424753,19423881:19424638,19423882:19424565,19442653:19444099,19442655:19444059,19442658:19443842,19442660:19443991,19442662:19444024,19442670:19443352,19442672:19443605,19442674:19443244,19442676:19443286,19442678:19442931,19442680:19442784,19442682:19442821,19444867:19445247,19445826:19445981,19447499:19447739,19448565:19448848,19448962:19449191,19449491:19449630,19450261:19451840,19450660:19450821,19451969:19452325,19451971:19452402,19451973:19452216,19453133:19453263,19454022:1945411', 'assoc_mat': '19360357:pehd:4230:19362413,19360359:pehd:4230:19362454,19360366:pehd:4230:19361935,19377818:pehd:4230:19381278,19377834:pehd:4230:19380778,19377843:pehd:4230:19380525,19377849:pehd:4230:19379706,19377858:pehd:4230:19379654,19399365:pehd:4230:19401435,19399368:pehd:4230:19400962,19399377:pehd:4230:19400468,19399380:pehd:4230:19400586,19399386:pehd:4230:19400232,19399395:pehd:4230:19399688,19399398:pehd:4230:19399835,19408045:pehd:4230:19408116,19409040:pehd:4230:19409166,19409882:pehd:4230:19409960,19410304:pehd:4230:19410419,19410616:pehd:4230:19410684,19411480:pehd:4230:19411549,19411986:pehd:4230:19412103,19413960:pehd:4230:19414097,19414840:pehd:4230:19417222,19414842:pehd:4230:19417253,19414848:pehd:4230:19417180,19417315:pehd:4230:19417386,19417870:pehd:4230:19417982,19423877:pehd:4230:19424892,19423878:pehd:4230:19424753,19423881:pehd:4230:19424638,19423882:pehd:4230:19424565,19442653:pehd:4230:19444099,19442655:pehd:4230:19444059,19442658:pehd:4230:19443842,19442660:pehd:4230:19443991,19442662:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.008282687211801448, 'nb_photo': 25696, 'list_port_cont': '19360458,19360492,19360569,19360630,19360788,19360827,19360932,19360964,19361068,19361150,19361244,19361361,19361433,19361544,19361615,19361643,19361801,19361932,19362008,19362077,19362305,19362412,19362455,19362543,19378776,19378848,19379026,19379067,19379224,19379580,19379648,19379716,19379890,19380146,19380283,19380487,19380532,19380736,19380780,19380885,19380993,19381063,19381169,19381201,19381242,19381279,19381330,19381847,19399474,19399584,19399692,19399839,19399878,19399904,19400081,19400233,19400478,19400589,19400633,19400717,19400817,19400968,19401034,19401322,19401425,19401572,19401687,19401793,19401931,19402114,19402148,19402994,19406922,19407576,19407876,19408112,19408541,19409157,19409611,19409963,19410417,19410687,19411044,19411552,19412105,19412397,19413443,19414096,19417146,19417176,19417214,19417256,19417288,19417357,19417390,19417983,19423913,19423988,19424018,19424056,19424095,19424132,19424165,19424208,19424246,19424310,19424354,19424389,19424464,19424497,19424531,19424569,19424605,1942463', 'assoc_port': '19360357:19362412,19360359:19362455,19360361:19362077,19360364:19362008,19360366:19361932,19360369:19361801,19360370:19361544,19360372:19361615,19360374:19361643,19360377:19361244,19360378:19361433,19360380:19361361,19360382:19360964,19360384:19361150,19360386:19361068,19360388:19360932,19360390:19360827,19360392:19360788,19360394:19360458,19360397:19360569,19360399:19360630,19360400:19360492,19362213:19362305,19362491:19362543,19377817:19381242,19377818:19381279,19377819:19381330,19377823:19381201,19377825:19381169,19377828:19381063,19377831:19380736,19377834:19380780,19377837:19380885,19377840:19380487,19377843:19380532,19377846:19380283,19377849:19379716,19377852:19379890,19377855:19380146,19377858:19379648,19377861:19379580,19377864:19379224,19377867:19378776,19377870:19379026,19377873:19379067,19377876:19378848,19380759:19380993,19381692:19381847,19399344:19401931,19399347:19402114,19399350:19401793,19399353:19401687,19399356:19401572,19399359:19401034,19399362:19401322,19399365:19401425,19399368:1940096', 'assoc_mat': '19360357:pet_clair:4230:19362412,19360359:pet_clair:4230:19362455,19360361:pet_clair:4230:19362077,19360364:pet_clair:4230:19362008,19360366:pet_clair:4230:19361932,19360369:pet_clair:4230:19361801,19360370:pet_clair:4230:19361544,19360372:pet_clair:4230:19361615,19360374:pet_clair:4230:19361643,19360377:pet_clair:4230:19361244,19360378:pet_clair:4230:19361433,19360380:pet_clair:4230:19361361,19360382:pet_clair:4230:19360964,19360384:pet_clair:4230:19361150,19360386:pet_clair:4230:19361068,19360388:pet_clair:4230:19360932,19360390:pet_clair:4230:19360827,19360392:pet_clair:4230:19360788,19360394:pet_clair:4230:19360458,19360397:pet_clair:4230:19360569,19360399:pet_clair:4230:19360630,19360400:pet_clair:4230:19360492,19362213:pet_clair:4230:19362305,19362491:pet_clair:4230:19362543,19377817:pet_clair:4230:19381242,19377818:pet_clair:4230:19381279,19377819:pet_clair:4230:19381330,19377823:pet_clair:4230:19381201,19377825:pet_clair:4230:19381169,19377828:pet_clair:4230:19381063,19377831:pet_clair:4230:19380736,1'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024723806599921978, 'nb_photo': 900, 'list_port_cont': '19361435,19361616,19361646,19361787,19362004,19362307,19362545,19379652,19379714,19380282,19380488,19380530,19399469,19399578,19399696,19399833,19399867,19399916,19400078,19400476,19400584,19400961,19401576,19407577,19408102,19408545,19410406,19410678,19413436,19414103,19417977,19423914,19424092,19424131,19424245,19424316,19424755,19424894,19426034,19426189,19443247,19443357,19443603,19443730,19443849,19443995,19444029,19444056,19444102,19445249,19445988,19447728,19447991,19449198,19449638,19450139,19450818,19452395,19453266,19454113,19454936,19455711,19456604,19457331,19459608,19460613,19461538,19463363,19465059,19465394,19466308,19467366,19468652,19469137,19473005,19474022,19476644,19476998,19478026,19479493,19484786,19492349,19492560,19493521,19493998,19495420,19495451,19495499,19495566,19496502,19497445,19497707,19498469,19498675,19499512,19501498,19501690,19502256,19502334,19502597,19502961,19503338,19503480,19503564,19503597,19504435,19505296,19506717,19507159,19510450,19511640,19512633,19512827,1951293', 'assoc_port': '19360364:19362004,19360369:19361787,19360372:19361616,19360374:19361646,19360378:19361435,19362213:19362307,19362491:19362545,19377840:19380488,19377843:19380530,19377846:19380282,19377849:19379714,19377858:19379652,19399356:19401576,19399368:19400961,19399377:19400476,19399380:19400584,19399389:19400078,19399392:19399916,19399395:19399696,19399398:19399833,19399401:19399867,19399404:19399578,19399406:19399469,19407424:19407577,19408045:19408102,19408454:19408545,19410304:19410406,19410616:19410678,19413257:19413436,19413960:19414103,19417870:19417977,19423877:19424894,19423878:19424755,19423889:19424316,19423890:19424131,19423892:19424245,19423895:19424092,19423898:19423914,19425940:19426034,19426094:19426189,19442653:19444102,19442655:19444056,19442658:19443849,19442660:19443995,19442662:19444029,19442664:19443730,19442670:19443357,19442672:19443603,19442674:19443247,19444867:19445249,19445826:19445988,19447497:19447991,19447499:19447728,19448962:19449198,19449491:19449638,19450060:19450139,19450660:1945081', 'assoc_mat': '19360364:pet_fonce:4230:19362004,19360369:pet_fonce:4230:19361787,19360372:pet_fonce:4230:19361616,19360374:pet_fonce:4230:19361646,19360378:pet_fonce:4230:19361435,19362213:pet_fonce:4230:19362307,19362491:pet_fonce:4230:19362545,19377840:pet_fonce:4230:19380488,19377843:pet_fonce:4230:19380530,19377846:pet_fonce:4230:19380282,19377849:pet_fonce:4230:19379714,19377858:pet_fonce:4230:19379652,19399356:pet_fonce:4230:19401576,19399368:pet_fonce:4230:19400961,19399377:pet_fonce:4230:19400476,19399380:pet_fonce:4230:19400584,19399389:pet_fonce:4230:19400078,19399392:pet_fonce:4230:19399916,19399395:pet_fonce:4230:19399696,19399398:pet_fonce:4230:19399833,19399401:pet_fonce:4230:19399867,19399404:pet_fonce:4230:19399578,19399406:pet_fonce:4230:19399469,19407424:pet_fonce:4230:19407577,19408045:pet_fonce:4230:19408102,19408454:pet_fonce:4230:19408545,19410304:pet_fonce:4230:19410406,19410616:pet_fonce:4230:19410678,19413257:pet_fonce:4230:19413436,19413960:pet_fonce:4230:19414103,19417870:pet_fonce:4230:19417977,1'}) 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(1506641,1509618,1513164,1516958,1517644,1520327,1522988,1525545,1526151,1528189,1530484,1531372,1533758,1537601,1541270,1543092,1544863,1546558,1547668,1549773,1552009,1554274,1556072,1558979,1561123,1562334,1565327,1568634,1571961,1575029,1577826)); 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-01-01' and date <= '2025-01-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2111,),), 'unwanted_material_monthly_percentage': ((0.7318231023163485,),), 'material_repartition': (('incineration', 2103),), 'material_dict': {'incineration': 2103}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 1, 1), 0.9212784673350086, 84), (datetime.date(2025, 1, 2), 0.9050950162240791, 84), (datetime.date(2025, 1, 3), 0.8989099869928843, 80), (datetime.date(2025, 1, 4), 0.8875854346950851, 80), (datetime.date(2025, 1, 5), 0.9349149604272258, 76), (datetime.date(2025, 1, 6), 0.8460649028816316, 77), (datetime.date(2025, 1, 7), 0.690352128315495, 75), (datetime.date(2025, 1, 8), 0.6439744288975251, 73), (datetime.date(2025, 1, 9), 0.6255728747216748, 59), (datetime.date(2025, 1, 10), 0.6340190160073839, 78), (datetime.date(2025, 1, 11), 0.7085344780160738, 79), (datetime.date(2025, 1, 12), 0.7545117731032761, 73), (datetime.date(2025, 1, 13), 0.7286121381927588, 71), (datetime.date(2025, 1, 14), 0.7428311757958155, 64), (datetime.date(2025, 1, 15), 0.6701755006153496, 66), (datetime.date(2025, 1, 16), 0.6462317380645451, 48), (datetime.date(2025, 1, 17), 0.5489076371549022, 49), (datetime.date(2025, 1, 18), 0.6128170776895622, 78), (datetime.date(2025, 1, 19), 0.7005862618231382, 81), (datetime.date(2025, 1, 20), 0.7259692202075426, 77), (datetime.date(2025, 1, 21), 0.6574867764626305, 40), (datetime.date(2025, 1, 22), 0.6585159118679845, 42), (datetime.date(2025, 1, 23), 0.6721364945144759, 66), (datetime.date(2025, 1, 24), 0.6661104429435798, 66), (datetime.date(2025, 1, 25), 0.7370851555345519, 65), (datetime.date(2025, 1, 26), 0.8109461113320501, 55), (datetime.date(2025, 1, 27), 0.7680425696021573, 63), (datetime.date(2025, 1, 28), 0.666249966475808, 68), (datetime.date(2025, 1, 29), 0.6227987971773977, 70), (datetime.date(2025, 1, 30), 0.6488648193022177, 58), (datetime.date(2025, 1, 31), 0.6877369424068475, 58)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 1, 1), 0.9212784673350086, 84), (datetime.date(2025, 1, 2), 0.9050950162240791, 84), (datetime.date(2025, 1, 3), 0.8989099869928843, 80), (datetime.date(2025, 1, 4), 0.8875854346950851, 80), (datetime.date(2025, 1, 5), 0.9349149604272258, 76), (datetime.date(2025, 1, 6), 0.8460649028816316, 77), (datetime.date(2025, 1, 7), 0.690352128315495, 75), (datetime.date(2025, 1, 8), 0.6439744288975251, 73), (datetime.date(2025, 1, 9), 0.6255728747216748, 59), (datetime.date(2025, 1, 10), 0.6340190160073839, 78), (datetime.date(2025, 1, 11), 0.7085344780160738, 79), (datetime.date(2025, 1, 12), 0.7545117731032761, 73), (datetime.date(2025, 1, 13), 0.7286121381927588, 71), (datetime.date(2025, 1, 14), 0.7428311757958155, 64), (datetime.date(2025, 1, 15), 0.6701755006153496, 66), (datetime.date(2025, 1, 16), 0.6462317380645451, 48), (datetime.date(2025, 1, 17), 0.5489076371549022, 49), (datetime.date(2025, 1, 18), 0.6128170776895622, 78), (datetime.date(2025, 1, 19), 0.7005862618231382, 81), (datetime.date(2025, 1, 20), 0.7259692202075426, 77), (datetime.date(2025, 1, 21), 0.6574867764626305, 40), (datetime.date(2025, 1, 22), 0.6585159118679845, 42), (datetime.date(2025, 1, 23), 0.6721364945144759, 66), (datetime.date(2025, 1, 24), 0.6661104429435798, 66), (datetime.date(2025, 1, 25), 0.7370851555345519, 65), (datetime.date(2025, 1, 26), 0.8109461113320501, 55), (datetime.date(2025, 1, 27), 0.7680425696021573, 63), (datetime.date(2025, 1, 28), 0.666249966475808, 68), (datetime.date(2025, 1, 29), 0.6227987971773977, 70), (datetime.date(2025, 1, 30), 0.6488648193022177, 58), (datetime.date(2025, 1, 31), 0.6877369424068475, 58))}, 'quality_array': [['2001.4837591813182', '01012025'], ['1714.6418380917623', '02012025'], ['2250.1245152816', '03012025'], ['2131.7242888477867', '04012025'], ['1619.4054421258827', '05012025'], ['4375.092803230116', '06012025'], ['9797.488692285408', '07012025'], ['10185.120900727346', '08012025'], ['10699.361087719602', '09012025'], ['10759.863109905213', '10012025'], ['10571.436855064958', '11012025'], ['10034.479228551236', '12012025'], ['7968.945682846667', '13012025'], ['7742.726676439596', '14012025'], ['9680.14247044473', '15012025'], ['8977.571160166506', '16012025'], ['9816.315607618988', '17012025'], ['10571.356638750303', '18012025'], ['11188.946405519011', '19012025'], ['9672.072358441756', '20012025'], ['9548.38979615778', '21012025'], ['8560.172588379277', '22012025'], ['4112.5239296137215', '23012025'], ['-9.048199805880676', '24012025'], ['-9.038227671118303', '25012025'], ['-8.888749100933186', '26012025'], ['-8.584472274921994', '27012025'], ['-8.759952271087812', '28012025'], ['-9.019420601148397', '29012025'], ['-8.889841646740221', '30012025'], ['-9.037649190635033', '31012025']], 'number_of_batch': ((701,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015901388126300802, 'nb_photo': 22258, 'list_port_cont': '19360451,19360485,19360560,19360637,19360790,19360813,19360928,19360957,19361080,19361149,19361247,19361349,19361429,19361535,19361618,19361645,19361792,19361922,19362003,19362068,19362309,19362411,19362451,19362541,19378767,19378850,19379030,19379065,19379226,19379574,19379656,19379704,19379892,19380151,19380271,19380496,19380524,19380728,19380767,19380879,19380985,19381069,19381170,19381203,19381229,19381282,19381334,19381846,19399480,19399582,19399697,19399838,19399880,19399913,19400064,19400229,19400475,19400572,19400622,19400708,19400812,19400958,19401035,19401325,19401423,19401564,19401683,19401795,19401933,19402116,19402144,19402993,19406924,19407578,19407873,19408115,19408538,19409162,19409616,19409959,19410410,19410679,19411052,19411540,19412104,19412382,19413431,19414100,19417135,19417185,19417206,19417251,19417290,19417362,19417393,19417972,19423903,19423974,19424016,19424057,19424085,19424133,19424166,19424198,19424231,19424302,19424353,19424379,19424447,19424499,19424522,19424572,19424597,1942463', 'assoc_port': '19360357:19362411,19360359:19362451,19360361:19362068,19360364:19362003,19360366:19361922,19360369:19361792,19360370:19361535,19360372:19361618,19360374:19361645,19360377:19361247,19360378:19361429,19360380:19361349,19360382:19360957,19360384:19361149,19360386:19361080,19360388:19360928,19360390:19360813,19360392:19360790,19360394:19360451,19360397:19360560,19360399:19360637,19360400:19360485,19362213:19362309,19362491:19362541,19377817:19381229,19377818:19381282,19377819:19381334,19377823:19381203,19377825:19381170,19377828:19381069,19377831:19380728,19377834:19380767,19377837:19380879,19377840:19380496,19377843:19380524,19377846:19380271,19377849:19379704,19377852:19379892,19377855:19380151,19377858:19379656,19377861:19379574,19377864:19379226,19377867:19378767,19377870:19379030,19377873:19379065,19377876:19378850,19380759:19380985,19381692:19381846,19399344:19401933,19399347:19402116,19399350:19401795,19399353:19401683,19399356:19401564,19399359:19401035,19399362:19401325,19399365:19401423,19399368:1940095', 'assoc_mat': '19360357:autre:4230:19362411,19360359:autre:4230:19362451,19360361:autre:4230:19362068,19360364:autre:4230:19362003,19360366:autre:4230:19361922,19360369:autre:4230:19361792,19360370:autre:4230:19361535,19360372:autre:4230:19361618,19360374:autre:4230:19361645,19360377:autre:4230:19361247,19360378:autre:4230:19361429,19360380:autre:4230:19361349,19360382:autre:4230:19360957,19360384:autre:4230:19361149,19360386:autre:4230:19361080,19360388:autre:4230:19360928,19360390:autre:4230:19360813,19360392:autre:4230:19360790,19360394:autre:4230:19360451,19360397:autre:4230:19360560,19360399:autre:4230:19360637,19360400:autre:4230:19360485,19362213:autre:4230:19362309,19362491:autre:4230:19362541,19377817:autre:4230:19381229,19377818:autre:4230:19381282,19377819:autre:4230:19381334,19377823:autre:4230:19381203,19377825:autre:4230:19381170,19377828:autre:4230:19381069,19377831:autre:4230:19380728,19377834:autre:4230:19380767,19377837:autre:4230:19380879,19377840:autre:4230:19380496,19377843:autre:4230:19380524,19377846:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07039616708600642, 'nb_photo': 136468, 'list_port_cont': '19360459,19360495,19360570,19360641,19360789,19360825,19360931,19360966,19361070,19361155,19361250,19361358,19361431,19361542,19361612,19361651,19361798,19361926,19362005,19362085,19362300,19362405,19362446,19362537,19378782,19378851,19379032,19379059,19379235,19379581,19379653,19379717,19379891,19380156,19380286,19380492,19380528,19380735,19380777,19380878,19380991,19381070,19381158,19381204,19381241,19381274,19381335,19381845,19399470,19399573,19399695,19399832,19399877,19399910,19400071,19400236,19400474,19400588,19400627,19400720,19400814,19400966,19401040,19401314,19401439,19401580,19401689,19401794,19401935,19402108,19402154,19402986,19406923,19407563,19407877,19408111,19408547,19409164,19409606,19409961,19410411,19410690,19411049,19411543,19412108,19412395,19413442,19414102,19417150,19417182,19417218,19417245,19417291,19417359,19417395,19417981,19423916,19423985,19424024,19424062,19424094,19424137,19424169,19424205,19424237,19424308,19424342,19424392,19424461,19424487,19424534,19424571,19424599,1942462', 'assoc_port': '19360357:19362405,19360359:19362446,19360361:19362085,19360364:19362005,19360366:19361926,19360369:19361798,19360370:19361542,19360372:19361612,19360374:19361651,19360377:19361250,19360378:19361431,19360380:19361358,19360382:19360966,19360384:19361155,19360386:19361070,19360388:19360931,19360390:19360825,19360392:19360789,19360394:19360459,19360397:19360570,19360399:19360641,19360400:19360495,19362213:19362300,19362491:19362537,19377817:19381241,19377818:19381274,19377819:19381335,19377823:19381204,19377825:19381158,19377828:19381070,19377831:19380735,19377834:19380777,19377837:19380878,19377840:19380492,19377843:19380528,19377846:19380286,19377849:19379717,19377852:19379891,19377855:19380156,19377858:19379653,19377861:19379581,19377864:19379235,19377867:19378782,19377870:19379032,19377873:19379059,19377876:19378851,19380759:19380991,19381692:19381845,19399344:19401935,19399347:19402108,19399350:19401794,19399353:19401689,19399356:19401580,19399359:19401040,19399362:19401314,19399365:19401439,19399368:1940096', 'assoc_mat': '19360357:carton:4230:19362405,19360359:carton:4230:19362446,19360361:carton:4230:19362085,19360364:carton:4230:19362005,19360366:carton:4230:19361926,19360369:carton:4230:19361798,19360370:carton:4230:19361542,19360372:carton:4230:19361612,19360374:carton:4230:19361651,19360377:carton:4230:19361250,19360378:carton:4230:19361431,19360380:carton:4230:19361358,19360382:carton:4230:19360966,19360384:carton:4230:19361155,19360386:carton:4230:19361070,19360388:carton:4230:19360931,19360390:carton:4230:19360825,19360392:carton:4230:19360789,19360394:carton:4230:19360459,19360397:carton:4230:19360570,19360399:carton:4230:19360641,19360400:carton:4230:19360495,19362213:carton:4230:19362300,19362491:carton:4230:19362537,19377817:carton:4230:19381241,19377818:carton:4230:19381274,19377819:carton:4230:19381335,19377823:carton:4230:19381204,19377825:carton:4230:19381158,19377828:carton:4230:19381070,19377831:carton:4230:19380735,19377834:carton:4230:19380777,19377837:carton:4230:19380878,19377840:carton:4230:19380492,1937'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0015028216805139177, 'nb_photo': 2536, 'list_port_cont': '19360786,19361245,19361425,19361543,19361611,19361642,19361923,19362078,19362409,19379031,19379056,19379564,19379655,19379712,19379889,19380288,19380531,19380881,19381231,19381280,19399481,19399574,19399694,19399830,19399868,19399915,19400070,19400480,19400574,19400631,19400718,19400823,19400967,19401433,19402119,19402141,19402991,19406917,19407881,19408099,19408535,19409139,19409607,19409950,19410413,19410681,19411050,19411547,19412095,19412386,19413445,19414104,19417141,19417181,19417209,19417242,19417294,19417389,19423899,19423976,19424026,19424055,19424084,19424121,19424163,19424204,19424240,19424312,19424382,19424462,19424491,19424523,19424568,19424604,19424642,19424669,19424748,19424885,19426021,19442793,19442826,19442831,19442920,19443250,19443270,19443348,19443589,19443714,19443850,19443989,19444030,19444053,19444087,19444401,19444547,19444694,19445238,19445972,19447723,19447988,19448851,19449195,19449628,19450127,19450822,19451847,19452211,19452329,19452401,19453251,19454103,19454933,19455712,1945659', 'assoc_port': '19360357:19362409,19360361:19362078,19360366:19361923,19360370:19361543,19360372:19361611,19360374:19361642,19360377:19361245,19360378:19361425,19360392:19360786,19377817:19381231,19377818:19381280,19377837:19380881,19377843:19380531,19377846:19380288,19377849:19379712,19377852:19379889,19377858:19379655,19377861:19379564,19377870:19379031,19377873:19379056,19399347:19402119,19399365:19401433,19399368:19400967,19399371:19400823,19399374:19400718,19399377:19400480,19399380:19400574,19399383:19400631,19399389:19400070,19399392:19399915,19399395:19399694,19399398:19399830,19399401:19399868,19399404:19399574,19399406:19399481,19401817:19402141,19402851:19402991,19406788:19406917,19407783:19407881,19408045:19408099,19408454:19408535,19409040:19409139,19409543:19409607,19409882:19409950,19410304:19410413,19410616:19410681,19410954:19411050,19411480:19411547,19411986:19412095,19412358:19412386,19413257:19413445,19413960:19414104,19414837:19417294,19414840:19417209,19414842:19417242,19414845:19417141,19414848:1941718', 'assoc_mat': '19360357:metal:4230:19362409,19360361:metal:4230:19362078,19360366:metal:4230:19361923,19360370:metal:4230:19361543,19360372:metal:4230:19361611,19360374:metal:4230:19361642,19360377:metal:4230:19361245,19360378:metal:4230:19361425,19360392:metal:4230:19360786,19377817:metal:4230:19381231,19377818:metal:4230:19381280,19377837:metal:4230:19380881,19377843:metal:4230:19380531,19377846:metal:4230:19380288,19377849:metal:4230:19379712,19377852:metal:4230:19379889,19377858:metal:4230:19379655,19377861:metal:4230:19379564,19377870:metal:4230:19379031,19377873:metal:4230:19379056,19399347:metal:4230:19402119,19399365:metal:4230:19401433,19399368:metal:4230:19400967,19399371:metal:4230:19400823,19399374:metal:4230:19400718,19399377:metal:4230:19400480,19399380:metal:4230:19400574,19399383:metal:4230:19400631,19399389:metal:4230:19400070,19399392:metal:4230:19399915,19399395:metal:4230:19399694,19399398:metal:4230:19399830,19399401:metal:4230:19399868,19399404:metal:4230:19399574,19399406:metal:4230:19399481,19401817:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.21454960600971193, 'nb_photo': 477972, 'list_port_cont': '19360457,19360483,19360568,19360643,19360787,19360823,19360929,19360963,19361071,19361153,19361238,19361359,19361420,19361533,19361617,19361653,19361800,19361933,19361995,19362084,19362308,19362404,19362456,19362540,19378775,19378853,19379025,19379066,19379222,19379575,19379649,19379703,19379885,19380158,19380284,19380494,19380523,19380729,19380775,19380882,19380995,19381071,19381155,19381205,19381244,19381269,19381337,19381844,19399479,19399585,19399693,19399837,19399871,19399911,19400077,19400227,19400470,19400587,19400637,19400715,19400818,19400952,19401031,19401326,19401440,19401578,19401677,19401791,19401930,19402118,19402153,19402984,19406919,19407566,19407886,19408106,19408546,19409161,19409604,19409953,19410414,19410693,19411048,19411553,19412109,19412390,19413441,19414099,19417149,19417183,19417221,19417257,19417295,19417353,19417391,19417979,19423904,19423981,19424020,19424061,19424097,19424130,19424170,19424201,19424242,19424318,19424347,19424388,19424455,19424498,19424533,19424570,19424594,1942464', 'assoc_port': '19360357:19362404,19360359:19362456,19360361:19362084,19360364:19361995,19360366:19361933,19360369:19361800,19360370:19361533,19360372:19361617,19360374:19361653,19360377:19361238,19360378:19361420,19360380:19361359,19360382:19360963,19360384:19361153,19360386:19361071,19360388:19360929,19360390:19360823,19360392:19360787,19360394:19360457,19360397:19360568,19360399:19360643,19360400:19360483,19362213:19362308,19362491:19362540,19377817:19381244,19377818:19381269,19377819:19381337,19377823:19381205,19377825:19381155,19377828:19381071,19377831:19380729,19377834:19380775,19377837:19380882,19377840:19380494,19377843:19380523,19377846:19380284,19377849:19379703,19377852:19379885,19377855:19380158,19377858:19379649,19377861:19379575,19377864:19379222,19377867:19378775,19377870:19379025,19377873:19379066,19377876:19378853,19380759:19380995,19381692:19381844,19399344:19401930,19399347:19402118,19399350:19401791,19399353:19401677,19399356:19401578,19399359:19401031,19399362:19401326,19399365:19401440,19399368:1940095', 'assoc_mat': '19360357:papier:4230:19362404,19360359:papier:4230:19362456,19360361:papier:4230:19362084,19360364:papier:4230:19361995,19360366:papier:4230:19361933,19360369:papier:4230:19361800,19360370:papier:4230:19361533,19360372:papier:4230:19361617,19360374:papier:4230:19361653,19360377:papier:4230:19361238,19360378:papier:4230:19361420,19360380:papier:4230:19361359,19360382:papier:4230:19360963,19360384:papier:4230:19361153,19360386:papier:4230:19361071,19360388:papier:4230:19360929,19360390:papier:4230:19360823,19360392:papier:4230:19360787,19360394:papier:4230:19360457,19360397:papier:4230:19360568,19360399:papier:4230:19360643,19360400:papier:4230:19360483,19362213:papier:4230:19362308,19362491:papier:4230:19362540,19377817:papier:4230:19381244,19377818:papier:4230:19381269,19377819:papier:4230:19381337,19377823:papier:4230:19381205,19377825:papier:4230:19381155,19377828:papier:4230:19381071,19377831:papier:4230:19380729,19377834:papier:4230:19380775,19377837:papier:4230:19380882,19377840:papier:4230:19380494,1937'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003922854685352931, 'nb_photo': 2764, 'list_port_cont': '19361935,19362413,19362454,19379654,19379706,19380525,19380778,19381278,19399688,19399835,19400232,19400468,19400586,19400962,19401435,19408116,19409166,19409960,19410419,19410684,19411549,19412103,19414097,19417180,19417222,19417253,19417386,19417982,19424565,19424638,19424753,19424892,19442784,19442821,19442931,19443244,19443286,19443352,19443605,19443842,19443991,19444024,19444059,19444099,19445247,19445981,19447739,19448848,19449191,19449630,19450821,19451840,19452216,19452325,19452402,19453263,19454112,19454937,19455716,19456605,19457336,19458791,19459607,19460616,19461546,19462820,19463377,19465058,19465392,19465608,19466305,19466881,19467371,19467710,19468656,19469131,19470247,19473003,19474017,19474698,19476650,19477004,19478019,19479503,19480826,19484784,19486358,19492350,19492555,19493519,19493990,19495429,19495445,19495501,19496509,19497449,19497708,19498467,19498677,19499516,19500013,19501497,19501688,19502257,19502396,19502511,19502586,19502857,19502957,19503335,19503479,19503554,19503605,1950417', 'assoc_port': '19360357:19362413,19360359:19362454,19360366:19361935,19377818:19381278,19377834:19380778,19377843:19380525,19377849:19379706,19377858:19379654,19399365:19401435,19399368:19400962,19399377:19400468,19399380:19400586,19399386:19400232,19399395:19399688,19399398:19399835,19408045:19408116,19409040:19409166,19409882:19409960,19410304:19410419,19410616:19410684,19411480:19411549,19411986:19412103,19413960:19414097,19414840:19417222,19414842:19417253,19414848:19417180,19417315:19417386,19417870:19417982,19423877:19424892,19423878:19424753,19423881:19424638,19423882:19424565,19442653:19444099,19442655:19444059,19442658:19443842,19442660:19443991,19442662:19444024,19442670:19443352,19442672:19443605,19442674:19443244,19442676:19443286,19442678:19442931,19442680:19442784,19442682:19442821,19444867:19445247,19445826:19445981,19447499:19447739,19448565:19448848,19448962:19449191,19449491:19449630,19450261:19451840,19450660:19450821,19451969:19452325,19451971:19452402,19451973:19452216,19453133:19453263,19454022:1945411', 'assoc_mat': '19360357:pehd:4230:19362413,19360359:pehd:4230:19362454,19360366:pehd:4230:19361935,19377818:pehd:4230:19381278,19377834:pehd:4230:19380778,19377843:pehd:4230:19380525,19377849:pehd:4230:19379706,19377858:pehd:4230:19379654,19399365:pehd:4230:19401435,19399368:pehd:4230:19400962,19399377:pehd:4230:19400468,19399380:pehd:4230:19400586,19399386:pehd:4230:19400232,19399395:pehd:4230:19399688,19399398:pehd:4230:19399835,19408045:pehd:4230:19408116,19409040:pehd:4230:19409166,19409882:pehd:4230:19409960,19410304:pehd:4230:19410419,19410616:pehd:4230:19410684,19411480:pehd:4230:19411549,19411986:pehd:4230:19412103,19413960:pehd:4230:19414097,19414840:pehd:4230:19417222,19414842:pehd:4230:19417253,19414848:pehd:4230:19417180,19417315:pehd:4230:19417386,19417870:pehd:4230:19417982,19423877:pehd:4230:19424892,19423878:pehd:4230:19424753,19423881:pehd:4230:19424638,19423882:pehd:4230:19424565,19442653:pehd:4230:19444099,19442655:pehd:4230:19444059,19442658:pehd:4230:19443842,19442660:pehd:4230:19443991,19442662:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.008282687211801448, 'nb_photo': 25696, 'list_port_cont': '19360458,19360492,19360569,19360630,19360788,19360827,19360932,19360964,19361068,19361150,19361244,19361361,19361433,19361544,19361615,19361643,19361801,19361932,19362008,19362077,19362305,19362412,19362455,19362543,19378776,19378848,19379026,19379067,19379224,19379580,19379648,19379716,19379890,19380146,19380283,19380487,19380532,19380736,19380780,19380885,19380993,19381063,19381169,19381201,19381242,19381279,19381330,19381847,19399474,19399584,19399692,19399839,19399878,19399904,19400081,19400233,19400478,19400589,19400633,19400717,19400817,19400968,19401034,19401322,19401425,19401572,19401687,19401793,19401931,19402114,19402148,19402994,19406922,19407576,19407876,19408112,19408541,19409157,19409611,19409963,19410417,19410687,19411044,19411552,19412105,19412397,19413443,19414096,19417146,19417176,19417214,19417256,19417288,19417357,19417390,19417983,19423913,19423988,19424018,19424056,19424095,19424132,19424165,19424208,19424246,19424310,19424354,19424389,19424464,19424497,19424531,19424569,19424605,1942463', 'assoc_port': '19360357:19362412,19360359:19362455,19360361:19362077,19360364:19362008,19360366:19361932,19360369:19361801,19360370:19361544,19360372:19361615,19360374:19361643,19360377:19361244,19360378:19361433,19360380:19361361,19360382:19360964,19360384:19361150,19360386:19361068,19360388:19360932,19360390:19360827,19360392:19360788,19360394:19360458,19360397:19360569,19360399:19360630,19360400:19360492,19362213:19362305,19362491:19362543,19377817:19381242,19377818:19381279,19377819:19381330,19377823:19381201,19377825:19381169,19377828:19381063,19377831:19380736,19377834:19380780,19377837:19380885,19377840:19380487,19377843:19380532,19377846:19380283,19377849:19379716,19377852:19379890,19377855:19380146,19377858:19379648,19377861:19379580,19377864:19379224,19377867:19378776,19377870:19379026,19377873:19379067,19377876:19378848,19380759:19380993,19381692:19381847,19399344:19401931,19399347:19402114,19399350:19401793,19399353:19401687,19399356:19401572,19399359:19401034,19399362:19401322,19399365:19401425,19399368:1940096', 'assoc_mat': '19360357:pet_clair:4230:19362412,19360359:pet_clair:4230:19362455,19360361:pet_clair:4230:19362077,19360364:pet_clair:4230:19362008,19360366:pet_clair:4230:19361932,19360369:pet_clair:4230:19361801,19360370:pet_clair:4230:19361544,19360372:pet_clair:4230:19361615,19360374:pet_clair:4230:19361643,19360377:pet_clair:4230:19361244,19360378:pet_clair:4230:19361433,19360380:pet_clair:4230:19361361,19360382:pet_clair:4230:19360964,19360384:pet_clair:4230:19361150,19360386:pet_clair:4230:19361068,19360388:pet_clair:4230:19360932,19360390:pet_clair:4230:19360827,19360392:pet_clair:4230:19360788,19360394:pet_clair:4230:19360458,19360397:pet_clair:4230:19360569,19360399:pet_clair:4230:19360630,19360400:pet_clair:4230:19360492,19362213:pet_clair:4230:19362305,19362491:pet_clair:4230:19362543,19377817:pet_clair:4230:19381242,19377818:pet_clair:4230:19381279,19377819:pet_clair:4230:19381330,19377823:pet_clair:4230:19381201,19377825:pet_clair:4230:19381169,19377828:pet_clair:4230:19381063,19377831:pet_clair:4230:19380736,1'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024723806599921978, 'nb_photo': 900, 'list_port_cont': '19361435,19361616,19361646,19361787,19362004,19362307,19362545,19379652,19379714,19380282,19380488,19380530,19399469,19399578,19399696,19399833,19399867,19399916,19400078,19400476,19400584,19400961,19401576,19407577,19408102,19408545,19410406,19410678,19413436,19414103,19417977,19423914,19424092,19424131,19424245,19424316,19424755,19424894,19426034,19426189,19443247,19443357,19443603,19443730,19443849,19443995,19444029,19444056,19444102,19445249,19445988,19447728,19447991,19449198,19449638,19450139,19450818,19452395,19453266,19454113,19454936,19455711,19456604,19457331,19459608,19460613,19461538,19463363,19465059,19465394,19466308,19467366,19468652,19469137,19473005,19474022,19476644,19476998,19478026,19479493,19484786,19492349,19492560,19493521,19493998,19495420,19495451,19495499,19495566,19496502,19497445,19497707,19498469,19498675,19499512,19501498,19501690,19502256,19502334,19502597,19502961,19503338,19503480,19503564,19503597,19504435,19505296,19506717,19507159,19510450,19511640,19512633,19512827,1951293', 'assoc_port': '19360364:19362004,19360369:19361787,19360372:19361616,19360374:19361646,19360378:19361435,19362213:19362307,19362491:19362545,19377840:19380488,19377843:19380530,19377846:19380282,19377849:19379714,19377858:19379652,19399356:19401576,19399368:19400961,19399377:19400476,19399380:19400584,19399389:19400078,19399392:19399916,19399395:19399696,19399398:19399833,19399401:19399867,19399404:19399578,19399406:19399469,19407424:19407577,19408045:19408102,19408454:19408545,19410304:19410406,19410616:19410678,19413257:19413436,19413960:19414103,19417870:19417977,19423877:19424894,19423878:19424755,19423889:19424316,19423890:19424131,19423892:19424245,19423895:19424092,19423898:19423914,19425940:19426034,19426094:19426189,19442653:19444102,19442655:19444056,19442658:19443849,19442660:19443995,19442662:19444029,19442664:19443730,19442670:19443357,19442672:19443603,19442674:19443247,19444867:19445249,19445826:19445988,19447497:19447991,19447499:19447728,19448962:19449198,19449491:19449638,19450060:19450139,19450660:1945081', 'assoc_mat': '19360364:pet_fonce:4230:19362004,19360369:pet_fonce:4230:19361787,19360372:pet_fonce:4230:19361616,19360374:pet_fonce:4230:19361646,19360378:pet_fonce:4230:19361435,19362213:pet_fonce:4230:19362307,19362491:pet_fonce:4230:19362545,19377840:pet_fonce:4230:19380488,19377843:pet_fonce:4230:19380530,19377846:pet_fonce:4230:19380282,19377849:pet_fonce:4230:19379714,19377858:pet_fonce:4230:19379652,19399356:pet_fonce:4230:19401576,19399368:pet_fonce:4230:19400961,19399377:pet_fonce:4230:19400476,19399380:pet_fonce:4230:19400584,19399389:pet_fonce:4230:19400078,19399392:pet_fonce:4230:19399916,19399395:pet_fonce:4230:19399696,19399398:pet_fonce:4230:19399833,19399401:pet_fonce:4230:19399867,19399404:pet_fonce:4230:19399578,19399406:pet_fonce:4230:19399469,19407424:pet_fonce:4230:19407577,19408045:pet_fonce:4230:19408102,19408454:pet_fonce:4230:19408545,19410304:pet_fonce:4230:19410406,19410616:pet_fonce:4230:19410678,19413257:pet_fonce:4230:19413436,19413960:pet_fonce:4230:19414103,19417870:pet_fonce:4230:19417977,1'}), 'main_stat': {'nb_photos': 2111}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-01', 0.7318231023163485),)]} 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': ((2111,),), 'unwanted_material_monthly_percentage': ((0.7318231023163485,),), 'material_repartition': (('incineration', 2103),), 'material_dict': {'incineration': 2103}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 1, 1), 0.9212784673350086, 84), (datetime.date(2025, 1, 2), 0.9050950162240791, 84), (datetime.date(2025, 1, 3), 0.8989099869928843, 80), (datetime.date(2025, 1, 4), 0.8875854346950851, 80), (datetime.date(2025, 1, 5), 0.9349149604272258, 76), (datetime.date(2025, 1, 6), 0.8460649028816316, 77), (datetime.date(2025, 1, 7), 0.690352128315495, 75), (datetime.date(2025, 1, 8), 0.6439744288975251, 73), (datetime.date(2025, 1, 9), 0.6255728747216748, 59), (datetime.date(2025, 1, 10), 0.6340190160073839, 78), (datetime.date(2025, 1, 11), 0.7085344780160738, 79), (datetime.date(2025, 1, 12), 0.7545117731032761, 73), (datetime.date(2025, 1, 13), 0.7286121381927588, 71), (datetime.date(2025, 1, 14), 0.7428311757958155, 64), (datetime.date(2025, 1, 15), 0.6701755006153496, 66), (datetime.date(2025, 1, 16), 0.6462317380645451, 48), (datetime.date(2025, 1, 17), 0.5489076371549022, 49), (datetime.date(2025, 1, 18), 0.6128170776895622, 78), (datetime.date(2025, 1, 19), 0.7005862618231382, 81), (datetime.date(2025, 1, 20), 0.7259692202075426, 77), (datetime.date(2025, 1, 21), 0.6574867764626305, 40), (datetime.date(2025, 1, 22), 0.6585159118679845, 42), (datetime.date(2025, 1, 23), 0.6721364945144759, 66), (datetime.date(2025, 1, 24), 0.6661104429435798, 66), (datetime.date(2025, 1, 25), 0.7370851555345519, 65), (datetime.date(2025, 1, 26), 0.8109461113320501, 55), (datetime.date(2025, 1, 27), 0.7680425696021573, 63), (datetime.date(2025, 1, 28), 0.666249966475808, 68), (datetime.date(2025, 1, 29), 0.6227987971773977, 70), (datetime.date(2025, 1, 30), 0.6488648193022177, 58), (datetime.date(2025, 1, 31), 0.6877369424068475, 58)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 1, 1), 0.9212784673350086, 84), (datetime.date(2025, 1, 2), 0.9050950162240791, 84), (datetime.date(2025, 1, 3), 0.8989099869928843, 80), (datetime.date(2025, 1, 4), 0.8875854346950851, 80), (datetime.date(2025, 1, 5), 0.9349149604272258, 76), (datetime.date(2025, 1, 6), 0.8460649028816316, 77), (datetime.date(2025, 1, 7), 0.690352128315495, 75), (datetime.date(2025, 1, 8), 0.6439744288975251, 73), (datetime.date(2025, 1, 9), 0.6255728747216748, 59), (datetime.date(2025, 1, 10), 0.6340190160073839, 78), (datetime.date(2025, 1, 11), 0.7085344780160738, 79), (datetime.date(2025, 1, 12), 0.7545117731032761, 73), (datetime.date(2025, 1, 13), 0.7286121381927588, 71), (datetime.date(2025, 1, 14), 0.7428311757958155, 64), (datetime.date(2025, 1, 15), 0.6701755006153496, 66), (datetime.date(2025, 1, 16), 0.6462317380645451, 48), (datetime.date(2025, 1, 17), 0.5489076371549022, 49), (datetime.date(2025, 1, 18), 0.6128170776895622, 78), (datetime.date(2025, 1, 19), 0.7005862618231382, 81), (datetime.date(2025, 1, 20), 0.7259692202075426, 77), (datetime.date(2025, 1, 21), 0.6574867764626305, 40), (datetime.date(2025, 1, 22), 0.6585159118679845, 42), (datetime.date(2025, 1, 23), 0.6721364945144759, 66), (datetime.date(2025, 1, 24), 0.6661104429435798, 66), (datetime.date(2025, 1, 25), 0.7370851555345519, 65), (datetime.date(2025, 1, 26), 0.8109461113320501, 55), (datetime.date(2025, 1, 27), 0.7680425696021573, 63), (datetime.date(2025, 1, 28), 0.666249966475808, 68), (datetime.date(2025, 1, 29), 0.6227987971773977, 70), (datetime.date(2025, 1, 30), 0.6488648193022177, 58), (datetime.date(2025, 1, 31), 0.6877369424068475, 58))}, 'quality_array': [['2001.4837591813182', '01012025'], ['1714.6418380917623', '02012025'], ['2250.1245152816', '03012025'], ['2131.7242888477867', '04012025'], ['1619.4054421258827', '05012025'], ['4375.092803230116', '06012025'], ['9797.488692285408', '07012025'], ['10185.120900727346', '08012025'], ['10699.361087719602', '09012025'], ['10759.863109905213', '10012025'], ['10571.436855064958', '11012025'], ['10034.479228551236', '12012025'], ['7968.945682846667', '13012025'], ['7742.726676439596', '14012025'], ['9680.14247044473', '15012025'], ['8977.571160166506', '16012025'], ['9816.315607618988', '17012025'], ['10571.356638750303', '18012025'], ['11188.946405519011', '19012025'], ['9672.072358441756', '20012025'], ['9548.38979615778', '21012025'], ['8560.172588379277', '22012025'], ['4112.5239296137215', '23012025'], ['-9.048199805880676', '24012025'], ['-9.038227671118303', '25012025'], ['-8.888749100933186', '26012025'], ['-8.584472274921994', '27012025'], ['-8.759952271087812', '28012025'], ['-9.019420601148397', '29012025'], ['-8.889841646740221', '30012025'], ['-9.037649190635033', '31012025']], 'number_of_batch': ((701,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015901388126300802, 'nb_photo': 22258, 'list_port_cont': '19360451,19360485,19360560,19360637,19360790,19360813,19360928,19360957,19361080,19361149,19361247,19361349,19361429,19361535,19361618,19361645,19361792,19361922,19362003,19362068,19362309,19362411,19362451,19362541,19378767,19378850,19379030,19379065,19379226,19379574,19379656,19379704,19379892,19380151,19380271,19380496,19380524,19380728,19380767,19380879,19380985,19381069,19381170,19381203,19381229,19381282,19381334,19381846,19399480,19399582,19399697,19399838,19399880,19399913,19400064,19400229,19400475,19400572,19400622,19400708,19400812,19400958,19401035,19401325,19401423,19401564,19401683,19401795,19401933,19402116,19402144,19402993,19406924,19407578,19407873,19408115,19408538,19409162,19409616,19409959,19410410,19410679,19411052,19411540,19412104,19412382,19413431,19414100,19417135,19417185,19417206,19417251,19417290,19417362,19417393,19417972,19423903,19423974,19424016,19424057,19424085,19424133,19424166,19424198,19424231,19424302,19424353,19424379,19424447,19424499,19424522,19424572,19424597,1942463', 'assoc_port': '19360357:19362411,19360359:19362451,19360361:19362068,19360364:19362003,19360366:19361922,19360369:19361792,19360370:19361535,19360372:19361618,19360374:19361645,19360377:19361247,19360378:19361429,19360380:19361349,19360382:19360957,19360384:19361149,19360386:19361080,19360388:19360928,19360390:19360813,19360392:19360790,19360394:19360451,19360397:19360560,19360399:19360637,19360400:19360485,19362213:19362309,19362491:19362541,19377817:19381229,19377818:19381282,19377819:19381334,19377823:19381203,19377825:19381170,19377828:19381069,19377831:19380728,19377834:19380767,19377837:19380879,19377840:19380496,19377843:19380524,19377846:19380271,19377849:19379704,19377852:19379892,19377855:19380151,19377858:19379656,19377861:19379574,19377864:19379226,19377867:19378767,19377870:19379030,19377873:19379065,19377876:19378850,19380759:19380985,19381692:19381846,19399344:19401933,19399347:19402116,19399350:19401795,19399353:19401683,19399356:19401564,19399359:19401035,19399362:19401325,19399365:19401423,19399368:1940095', 'assoc_mat': '19360357:autre:4230:19362411,19360359:autre:4230:19362451,19360361:autre:4230:19362068,19360364:autre:4230:19362003,19360366:autre:4230:19361922,19360369:autre:4230:19361792,19360370:autre:4230:19361535,19360372:autre:4230:19361618,19360374:autre:4230:19361645,19360377:autre:4230:19361247,19360378:autre:4230:19361429,19360380:autre:4230:19361349,19360382:autre:4230:19360957,19360384:autre:4230:19361149,19360386:autre:4230:19361080,19360388:autre:4230:19360928,19360390:autre:4230:19360813,19360392:autre:4230:19360790,19360394:autre:4230:19360451,19360397:autre:4230:19360560,19360399:autre:4230:19360637,19360400:autre:4230:19360485,19362213:autre:4230:19362309,19362491:autre:4230:19362541,19377817:autre:4230:19381229,19377818:autre:4230:19381282,19377819:autre:4230:19381334,19377823:autre:4230:19381203,19377825:autre:4230:19381170,19377828:autre:4230:19381069,19377831:autre:4230:19380728,19377834:autre:4230:19380767,19377837:autre:4230:19380879,19377840:autre:4230:19380496,19377843:autre:4230:19380524,19377846:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07039616708600642, 'nb_photo': 136468, 'list_port_cont': '19360459,19360495,19360570,19360641,19360789,19360825,19360931,19360966,19361070,19361155,19361250,19361358,19361431,19361542,19361612,19361651,19361798,19361926,19362005,19362085,19362300,19362405,19362446,19362537,19378782,19378851,19379032,19379059,19379235,19379581,19379653,19379717,19379891,19380156,19380286,19380492,19380528,19380735,19380777,19380878,19380991,19381070,19381158,19381204,19381241,19381274,19381335,19381845,19399470,19399573,19399695,19399832,19399877,19399910,19400071,19400236,19400474,19400588,19400627,19400720,19400814,19400966,19401040,19401314,19401439,19401580,19401689,19401794,19401935,19402108,19402154,19402986,19406923,19407563,19407877,19408111,19408547,19409164,19409606,19409961,19410411,19410690,19411049,19411543,19412108,19412395,19413442,19414102,19417150,19417182,19417218,19417245,19417291,19417359,19417395,19417981,19423916,19423985,19424024,19424062,19424094,19424137,19424169,19424205,19424237,19424308,19424342,19424392,19424461,19424487,19424534,19424571,19424599,1942462', 'assoc_port': '19360357:19362405,19360359:19362446,19360361:19362085,19360364:19362005,19360366:19361926,19360369:19361798,19360370:19361542,19360372:19361612,19360374:19361651,19360377:19361250,19360378:19361431,19360380:19361358,19360382:19360966,19360384:19361155,19360386:19361070,19360388:19360931,19360390:19360825,19360392:19360789,19360394:19360459,19360397:19360570,19360399:19360641,19360400:19360495,19362213:19362300,19362491:19362537,19377817:19381241,19377818:19381274,19377819:19381335,19377823:19381204,19377825:19381158,19377828:19381070,19377831:19380735,19377834:19380777,19377837:19380878,19377840:19380492,19377843:19380528,19377846:19380286,19377849:19379717,19377852:19379891,19377855:19380156,19377858:19379653,19377861:19379581,19377864:19379235,19377867:19378782,19377870:19379032,19377873:19379059,19377876:19378851,19380759:19380991,19381692:19381845,19399344:19401935,19399347:19402108,19399350:19401794,19399353:19401689,19399356:19401580,19399359:19401040,19399362:19401314,19399365:19401439,19399368:1940096', 'assoc_mat': '19360357:carton:4230:19362405,19360359:carton:4230:19362446,19360361:carton:4230:19362085,19360364:carton:4230:19362005,19360366:carton:4230:19361926,19360369:carton:4230:19361798,19360370:carton:4230:19361542,19360372:carton:4230:19361612,19360374:carton:4230:19361651,19360377:carton:4230:19361250,19360378:carton:4230:19361431,19360380:carton:4230:19361358,19360382:carton:4230:19360966,19360384:carton:4230:19361155,19360386:carton:4230:19361070,19360388:carton:4230:19360931,19360390:carton:4230:19360825,19360392:carton:4230:19360789,19360394:carton:4230:19360459,19360397:carton:4230:19360570,19360399:carton:4230:19360641,19360400:carton:4230:19360495,19362213:carton:4230:19362300,19362491:carton:4230:19362537,19377817:carton:4230:19381241,19377818:carton:4230:19381274,19377819:carton:4230:19381335,19377823:carton:4230:19381204,19377825:carton:4230:19381158,19377828:carton:4230:19381070,19377831:carton:4230:19380735,19377834:carton:4230:19380777,19377837:carton:4230:19380878,19377840:carton:4230:19380492,1937'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0015028216805139177, 'nb_photo': 2536, 'list_port_cont': '19360786,19361245,19361425,19361543,19361611,19361642,19361923,19362078,19362409,19379031,19379056,19379564,19379655,19379712,19379889,19380288,19380531,19380881,19381231,19381280,19399481,19399574,19399694,19399830,19399868,19399915,19400070,19400480,19400574,19400631,19400718,19400823,19400967,19401433,19402119,19402141,19402991,19406917,19407881,19408099,19408535,19409139,19409607,19409950,19410413,19410681,19411050,19411547,19412095,19412386,19413445,19414104,19417141,19417181,19417209,19417242,19417294,19417389,19423899,19423976,19424026,19424055,19424084,19424121,19424163,19424204,19424240,19424312,19424382,19424462,19424491,19424523,19424568,19424604,19424642,19424669,19424748,19424885,19426021,19442793,19442826,19442831,19442920,19443250,19443270,19443348,19443589,19443714,19443850,19443989,19444030,19444053,19444087,19444401,19444547,19444694,19445238,19445972,19447723,19447988,19448851,19449195,19449628,19450127,19450822,19451847,19452211,19452329,19452401,19453251,19454103,19454933,19455712,1945659', 'assoc_port': '19360357:19362409,19360361:19362078,19360366:19361923,19360370:19361543,19360372:19361611,19360374:19361642,19360377:19361245,19360378:19361425,19360392:19360786,19377817:19381231,19377818:19381280,19377837:19380881,19377843:19380531,19377846:19380288,19377849:19379712,19377852:19379889,19377858:19379655,19377861:19379564,19377870:19379031,19377873:19379056,19399347:19402119,19399365:19401433,19399368:19400967,19399371:19400823,19399374:19400718,19399377:19400480,19399380:19400574,19399383:19400631,19399389:19400070,19399392:19399915,19399395:19399694,19399398:19399830,19399401:19399868,19399404:19399574,19399406:19399481,19401817:19402141,19402851:19402991,19406788:19406917,19407783:19407881,19408045:19408099,19408454:19408535,19409040:19409139,19409543:19409607,19409882:19409950,19410304:19410413,19410616:19410681,19410954:19411050,19411480:19411547,19411986:19412095,19412358:19412386,19413257:19413445,19413960:19414104,19414837:19417294,19414840:19417209,19414842:19417242,19414845:19417141,19414848:1941718', 'assoc_mat': '19360357:metal:4230:19362409,19360361:metal:4230:19362078,19360366:metal:4230:19361923,19360370:metal:4230:19361543,19360372:metal:4230:19361611,19360374:metal:4230:19361642,19360377:metal:4230:19361245,19360378:metal:4230:19361425,19360392:metal:4230:19360786,19377817:metal:4230:19381231,19377818:metal:4230:19381280,19377837:metal:4230:19380881,19377843:metal:4230:19380531,19377846:metal:4230:19380288,19377849:metal:4230:19379712,19377852:metal:4230:19379889,19377858:metal:4230:19379655,19377861:metal:4230:19379564,19377870:metal:4230:19379031,19377873:metal:4230:19379056,19399347:metal:4230:19402119,19399365:metal:4230:19401433,19399368:metal:4230:19400967,19399371:metal:4230:19400823,19399374:metal:4230:19400718,19399377:metal:4230:19400480,19399380:metal:4230:19400574,19399383:metal:4230:19400631,19399389:metal:4230:19400070,19399392:metal:4230:19399915,19399395:metal:4230:19399694,19399398:metal:4230:19399830,19399401:metal:4230:19399868,19399404:metal:4230:19399574,19399406:metal:4230:19399481,19401817:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.21454960600971193, 'nb_photo': 477972, 'list_port_cont': '19360457,19360483,19360568,19360643,19360787,19360823,19360929,19360963,19361071,19361153,19361238,19361359,19361420,19361533,19361617,19361653,19361800,19361933,19361995,19362084,19362308,19362404,19362456,19362540,19378775,19378853,19379025,19379066,19379222,19379575,19379649,19379703,19379885,19380158,19380284,19380494,19380523,19380729,19380775,19380882,19380995,19381071,19381155,19381205,19381244,19381269,19381337,19381844,19399479,19399585,19399693,19399837,19399871,19399911,19400077,19400227,19400470,19400587,19400637,19400715,19400818,19400952,19401031,19401326,19401440,19401578,19401677,19401791,19401930,19402118,19402153,19402984,19406919,19407566,19407886,19408106,19408546,19409161,19409604,19409953,19410414,19410693,19411048,19411553,19412109,19412390,19413441,19414099,19417149,19417183,19417221,19417257,19417295,19417353,19417391,19417979,19423904,19423981,19424020,19424061,19424097,19424130,19424170,19424201,19424242,19424318,19424347,19424388,19424455,19424498,19424533,19424570,19424594,1942464', 'assoc_port': '19360357:19362404,19360359:19362456,19360361:19362084,19360364:19361995,19360366:19361933,19360369:19361800,19360370:19361533,19360372:19361617,19360374:19361653,19360377:19361238,19360378:19361420,19360380:19361359,19360382:19360963,19360384:19361153,19360386:19361071,19360388:19360929,19360390:19360823,19360392:19360787,19360394:19360457,19360397:19360568,19360399:19360643,19360400:19360483,19362213:19362308,19362491:19362540,19377817:19381244,19377818:19381269,19377819:19381337,19377823:19381205,19377825:19381155,19377828:19381071,19377831:19380729,19377834:19380775,19377837:19380882,19377840:19380494,19377843:19380523,19377846:19380284,19377849:19379703,19377852:19379885,19377855:19380158,19377858:19379649,19377861:19379575,19377864:19379222,19377867:19378775,19377870:19379025,19377873:19379066,19377876:19378853,19380759:19380995,19381692:19381844,19399344:19401930,19399347:19402118,19399350:19401791,19399353:19401677,19399356:19401578,19399359:19401031,19399362:19401326,19399365:19401440,19399368:1940095', 'assoc_mat': '19360357:papier:4230:19362404,19360359:papier:4230:19362456,19360361:papier:4230:19362084,19360364:papier:4230:19361995,19360366:papier:4230:19361933,19360369:papier:4230:19361800,19360370:papier:4230:19361533,19360372:papier:4230:19361617,19360374:papier:4230:19361653,19360377:papier:4230:19361238,19360378:papier:4230:19361420,19360380:papier:4230:19361359,19360382:papier:4230:19360963,19360384:papier:4230:19361153,19360386:papier:4230:19361071,19360388:papier:4230:19360929,19360390:papier:4230:19360823,19360392:papier:4230:19360787,19360394:papier:4230:19360457,19360397:papier:4230:19360568,19360399:papier:4230:19360643,19360400:papier:4230:19360483,19362213:papier:4230:19362308,19362491:papier:4230:19362540,19377817:papier:4230:19381244,19377818:papier:4230:19381269,19377819:papier:4230:19381337,19377823:papier:4230:19381205,19377825:papier:4230:19381155,19377828:papier:4230:19381071,19377831:papier:4230:19380729,19377834:papier:4230:19380775,19377837:papier:4230:19380882,19377840:papier:4230:19380494,1937'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003922854685352931, 'nb_photo': 2764, 'list_port_cont': '19361935,19362413,19362454,19379654,19379706,19380525,19380778,19381278,19399688,19399835,19400232,19400468,19400586,19400962,19401435,19408116,19409166,19409960,19410419,19410684,19411549,19412103,19414097,19417180,19417222,19417253,19417386,19417982,19424565,19424638,19424753,19424892,19442784,19442821,19442931,19443244,19443286,19443352,19443605,19443842,19443991,19444024,19444059,19444099,19445247,19445981,19447739,19448848,19449191,19449630,19450821,19451840,19452216,19452325,19452402,19453263,19454112,19454937,19455716,19456605,19457336,19458791,19459607,19460616,19461546,19462820,19463377,19465058,19465392,19465608,19466305,19466881,19467371,19467710,19468656,19469131,19470247,19473003,19474017,19474698,19476650,19477004,19478019,19479503,19480826,19484784,19486358,19492350,19492555,19493519,19493990,19495429,19495445,19495501,19496509,19497449,19497708,19498467,19498677,19499516,19500013,19501497,19501688,19502257,19502396,19502511,19502586,19502857,19502957,19503335,19503479,19503554,19503605,1950417', 'assoc_port': '19360357:19362413,19360359:19362454,19360366:19361935,19377818:19381278,19377834:19380778,19377843:19380525,19377849:19379706,19377858:19379654,19399365:19401435,19399368:19400962,19399377:19400468,19399380:19400586,19399386:19400232,19399395:19399688,19399398:19399835,19408045:19408116,19409040:19409166,19409882:19409960,19410304:19410419,19410616:19410684,19411480:19411549,19411986:19412103,19413960:19414097,19414840:19417222,19414842:19417253,19414848:19417180,19417315:19417386,19417870:19417982,19423877:19424892,19423878:19424753,19423881:19424638,19423882:19424565,19442653:19444099,19442655:19444059,19442658:19443842,19442660:19443991,19442662:19444024,19442670:19443352,19442672:19443605,19442674:19443244,19442676:19443286,19442678:19442931,19442680:19442784,19442682:19442821,19444867:19445247,19445826:19445981,19447499:19447739,19448565:19448848,19448962:19449191,19449491:19449630,19450261:19451840,19450660:19450821,19451969:19452325,19451971:19452402,19451973:19452216,19453133:19453263,19454022:1945411', 'assoc_mat': '19360357:pehd:4230:19362413,19360359:pehd:4230:19362454,19360366:pehd:4230:19361935,19377818:pehd:4230:19381278,19377834:pehd:4230:19380778,19377843:pehd:4230:19380525,19377849:pehd:4230:19379706,19377858:pehd:4230:19379654,19399365:pehd:4230:19401435,19399368:pehd:4230:19400962,19399377:pehd:4230:19400468,19399380:pehd:4230:19400586,19399386:pehd:4230:19400232,19399395:pehd:4230:19399688,19399398:pehd:4230:19399835,19408045:pehd:4230:19408116,19409040:pehd:4230:19409166,19409882:pehd:4230:19409960,19410304:pehd:4230:19410419,19410616:pehd:4230:19410684,19411480:pehd:4230:19411549,19411986:pehd:4230:19412103,19413960:pehd:4230:19414097,19414840:pehd:4230:19417222,19414842:pehd:4230:19417253,19414848:pehd:4230:19417180,19417315:pehd:4230:19417386,19417870:pehd:4230:19417982,19423877:pehd:4230:19424892,19423878:pehd:4230:19424753,19423881:pehd:4230:19424638,19423882:pehd:4230:19424565,19442653:pehd:4230:19444099,19442655:pehd:4230:19444059,19442658:pehd:4230:19443842,19442660:pehd:4230:19443991,19442662:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.008282687211801448, 'nb_photo': 25696, 'list_port_cont': '19360458,19360492,19360569,19360630,19360788,19360827,19360932,19360964,19361068,19361150,19361244,19361361,19361433,19361544,19361615,19361643,19361801,19361932,19362008,19362077,19362305,19362412,19362455,19362543,19378776,19378848,19379026,19379067,19379224,19379580,19379648,19379716,19379890,19380146,19380283,19380487,19380532,19380736,19380780,19380885,19380993,19381063,19381169,19381201,19381242,19381279,19381330,19381847,19399474,19399584,19399692,19399839,19399878,19399904,19400081,19400233,19400478,19400589,19400633,19400717,19400817,19400968,19401034,19401322,19401425,19401572,19401687,19401793,19401931,19402114,19402148,19402994,19406922,19407576,19407876,19408112,19408541,19409157,19409611,19409963,19410417,19410687,19411044,19411552,19412105,19412397,19413443,19414096,19417146,19417176,19417214,19417256,19417288,19417357,19417390,19417983,19423913,19423988,19424018,19424056,19424095,19424132,19424165,19424208,19424246,19424310,19424354,19424389,19424464,19424497,19424531,19424569,19424605,1942463', 'assoc_port': '19360357:19362412,19360359:19362455,19360361:19362077,19360364:19362008,19360366:19361932,19360369:19361801,19360370:19361544,19360372:19361615,19360374:19361643,19360377:19361244,19360378:19361433,19360380:19361361,19360382:19360964,19360384:19361150,19360386:19361068,19360388:19360932,19360390:19360827,19360392:19360788,19360394:19360458,19360397:19360569,19360399:19360630,19360400:19360492,19362213:19362305,19362491:19362543,19377817:19381242,19377818:19381279,19377819:19381330,19377823:19381201,19377825:19381169,19377828:19381063,19377831:19380736,19377834:19380780,19377837:19380885,19377840:19380487,19377843:19380532,19377846:19380283,19377849:19379716,19377852:19379890,19377855:19380146,19377858:19379648,19377861:19379580,19377864:19379224,19377867:19378776,19377870:19379026,19377873:19379067,19377876:19378848,19380759:19380993,19381692:19381847,19399344:19401931,19399347:19402114,19399350:19401793,19399353:19401687,19399356:19401572,19399359:19401034,19399362:19401322,19399365:19401425,19399368:1940096', 'assoc_mat': '19360357:pet_clair:4230:19362412,19360359:pet_clair:4230:19362455,19360361:pet_clair:4230:19362077,19360364:pet_clair:4230:19362008,19360366:pet_clair:4230:19361932,19360369:pet_clair:4230:19361801,19360370:pet_clair:4230:19361544,19360372:pet_clair:4230:19361615,19360374:pet_clair:4230:19361643,19360377:pet_clair:4230:19361244,19360378:pet_clair:4230:19361433,19360380:pet_clair:4230:19361361,19360382:pet_clair:4230:19360964,19360384:pet_clair:4230:19361150,19360386:pet_clair:4230:19361068,19360388:pet_clair:4230:19360932,19360390:pet_clair:4230:19360827,19360392:pet_clair:4230:19360788,19360394:pet_clair:4230:19360458,19360397:pet_clair:4230:19360569,19360399:pet_clair:4230:19360630,19360400:pet_clair:4230:19360492,19362213:pet_clair:4230:19362305,19362491:pet_clair:4230:19362543,19377817:pet_clair:4230:19381242,19377818:pet_clair:4230:19381279,19377819:pet_clair:4230:19381330,19377823:pet_clair:4230:19381201,19377825:pet_clair:4230:19381169,19377828:pet_clair:4230:19381063,19377831:pet_clair:4230:19380736,1'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024723806599921978, 'nb_photo': 900, 'list_port_cont': '19361435,19361616,19361646,19361787,19362004,19362307,19362545,19379652,19379714,19380282,19380488,19380530,19399469,19399578,19399696,19399833,19399867,19399916,19400078,19400476,19400584,19400961,19401576,19407577,19408102,19408545,19410406,19410678,19413436,19414103,19417977,19423914,19424092,19424131,19424245,19424316,19424755,19424894,19426034,19426189,19443247,19443357,19443603,19443730,19443849,19443995,19444029,19444056,19444102,19445249,19445988,19447728,19447991,19449198,19449638,19450139,19450818,19452395,19453266,19454113,19454936,19455711,19456604,19457331,19459608,19460613,19461538,19463363,19465059,19465394,19466308,19467366,19468652,19469137,19473005,19474022,19476644,19476998,19478026,19479493,19484786,19492349,19492560,19493521,19493998,19495420,19495451,19495499,19495566,19496502,19497445,19497707,19498469,19498675,19499512,19501498,19501690,19502256,19502334,19502597,19502961,19503338,19503480,19503564,19503597,19504435,19505296,19506717,19507159,19510450,19511640,19512633,19512827,1951293', 'assoc_port': '19360364:19362004,19360369:19361787,19360372:19361616,19360374:19361646,19360378:19361435,19362213:19362307,19362491:19362545,19377840:19380488,19377843:19380530,19377846:19380282,19377849:19379714,19377858:19379652,19399356:19401576,19399368:19400961,19399377:19400476,19399380:19400584,19399389:19400078,19399392:19399916,19399395:19399696,19399398:19399833,19399401:19399867,19399404:19399578,19399406:19399469,19407424:19407577,19408045:19408102,19408454:19408545,19410304:19410406,19410616:19410678,19413257:19413436,19413960:19414103,19417870:19417977,19423877:19424894,19423878:19424755,19423889:19424316,19423890:19424131,19423892:19424245,19423895:19424092,19423898:19423914,19425940:19426034,19426094:19426189,19442653:19444102,19442655:19444056,19442658:19443849,19442660:19443995,19442662:19444029,19442664:19443730,19442670:19443357,19442672:19443603,19442674:19443247,19444867:19445249,19445826:19445988,19447497:19447991,19447499:19447728,19448962:19449198,19449491:19449638,19450060:19450139,19450660:1945081', 'assoc_mat': '19360364:pet_fonce:4230:19362004,19360369:pet_fonce:4230:19361787,19360372:pet_fonce:4230:19361616,19360374:pet_fonce:4230:19361646,19360378:pet_fonce:4230:19361435,19362213:pet_fonce:4230:19362307,19362491:pet_fonce:4230:19362545,19377840:pet_fonce:4230:19380488,19377843:pet_fonce:4230:19380530,19377846:pet_fonce:4230:19380282,19377849:pet_fonce:4230:19379714,19377858:pet_fonce:4230:19379652,19399356:pet_fonce:4230:19401576,19399368:pet_fonce:4230:19400961,19399377:pet_fonce:4230:19400476,19399380:pet_fonce:4230:19400584,19399389:pet_fonce:4230:19400078,19399392:pet_fonce:4230:19399916,19399395:pet_fonce:4230:19399696,19399398:pet_fonce:4230:19399833,19399401:pet_fonce:4230:19399867,19399404:pet_fonce:4230:19399578,19399406:pet_fonce:4230:19399469,19407424:pet_fonce:4230:19407577,19408045:pet_fonce:4230:19408102,19408454:pet_fonce:4230:19408545,19410304:pet_fonce:4230:19410406,19410616:pet_fonce:4230:19410678,19413257:pet_fonce:4230:19413436,19413960:pet_fonce:4230:19414103,19417870:pet_fonce:4230:19417977,1'}), 'main_stat': {'nb_photos': 2111}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-01', 0.7318231023163485),)]} filepath : /data_2/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_01_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.59%', 22258], 'carton': ['carton', '7.04%', 136468], 'metal': ['metal', '0.15%', 2536], 'papier': ['papier', '21.45%', 477972], 'pehd': ['pehd', '0.39%', 2764], 'pet_clair': ['pet_clair', '0.83%', 25696], 'pet_fonce': ['pet_fonce', '0.25%', 900]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_01_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/SCCU_cam7 3.10user 2.64system 6:32.52elapsed 1%CPU (0avgtext+0avgdata 194304maxresident)k 5448inputs+296outputs (39major+76367minor)pagefaults 0swaps