python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-06 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (6, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (6, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 06 mtr_id : dashboard_places : SCCU_cam6 date : 2025-06 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam6' and date like '%2025-06%') and created_at like '%2025-06%'))); nb_day : (6, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 202 and month(ded.date) = 06 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______incineration' and ded.dashboard_place_id = 202 and month(ded.date) = 06 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 202 and mp.name like '%062025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-06-01 : dt_date_just_month_year : 2025-06-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-06-01" AND ded.date <= "2025-06-30" apple3 {'incineration': {'mat': 'incineration', 'pht': 4230, 'datou_carac_id': 4234, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1862598,1866479,1870984,1873056,1876532,1884733,1887904,1893000,1896977,1900231,1903350,1907898,1909899,1910819,1913550,1915960,1918607,1921319,1924875,1926449,1926698,1930467,1930464,1931909,1935575,1937302,1940057,1940582,1944932) 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.012510235516854299, 'nb_photo': 18160, 'list_port_cont': '23520206,23520820,23520865,23521011,23521124,23521264,23521301,23521461,23521655,23521679,23521812,23521843,23521916,23521993,23522072,23522109,23522183,23522310,23522386,23522584,23522721,23524077,23524236,23524390,23540623,23542850,23544401,23550870,23553607,23553664,23556309,23558846,23561659,23565280,23570764,23571388,23571432,23571498,23571574,23571620,23571680,23571720,23571792,23571819,23571885,23571923,23571952,23572362,23601722,23602045,23602128,23602165,23602328,23602404,23602565,23602742,23602825,23602962,23602985,23603116,23603126,23603211,23603426,23603467,23603537,23603736,23603836,23603893,23606748,23607429,23620799,23620973,23645874,23645995,23646177,23647482,23647544,23647639,23647720,23647798,23647959,23648138,23648186,23648340,23648450,23648498,23648552,23648619,23648830,23648917,23648984,23649111,23649149,23649221,23651483,23652034,23688410,23688545,23688575,23688619,23688667,23688731,23688785,23688822,23689011,23689056,23689124,23689185,23689253,23749877,23749915,23750004,23750045,2375016', 'assoc_port': '23519890:23522386,23519892:23522183,23519894:23521993,23519896:23522310,23519898:23521916,23519900:23522072,23519902:23522109,23519904:23524236,23519907:23521679,23519909:23521812,23519912:23521843,23519915:23521655,23519917:23521461,23519920:23521301,23519922:23524077,23519925:23521264,23519928:23524390,23519930:23520865,23519933:23521011,23519936:23521124,23519938:23520820,23519941:23520206,23522490:23522584,23522697:23522721,23540201:23540623,23542485:23542850,23544148:23544401,23546744:23553607,23550376:23550870,23553289:23553664,23555921:23556309,23558413:23558846,23561138:23561659,23564933:23565280,23567564:23571952,23567566:23571885,23567569:23571792,23567582:23571923,23567584:23571819,23567587:23571720,23567590:23571620,23567604:23571680,23567620:23571574,23567623:23571388,23567625:23571498,23567629:23571432,23570230:23570764,23572185:23572362,23601604:23603736,23601605:23603836,23601606:23603893,23601608:23603467,23601609:23603426,23601610:23607429,23601611:23603211,23601612:23603537,23601613:2360298', 'assoc_mat': '23519890:autre:4230:23522386,23519892:autre:4230:23522183,23519894:autre:4230:23521993,23519896:autre:4230:23522310,23519898:autre:4230:23521916,23519900:autre:4230:23522072,23519902:autre:4230:23522109,23519904:autre:4230:23524236,23519907:autre:4230:23521679,23519909:autre:4230:23521812,23519912:autre:4230:23521843,23519915:autre:4230:23521655,23519917:autre:4230:23521461,23519920:autre:4230:23521301,23519922:autre:4230:23524077,23519925:autre:4230:23521264,23519928:autre:4230:23524390,23519930:autre:4230:23520865,23519933:autre:4230:23521011,23519936:autre:4230:23521124,23519938:autre:4230:23520820,23519941:autre:4230:23520206,23522490:autre:4230:23522584,23522697:autre:4230:23522721,23540201:autre:4230:23540623,23542485:autre:4230:23542850,23544148:autre:4230:23544401,23546744:autre:4230:23553607,23550376:autre:4230:23550870,23553289:autre:4230:23553664,23555921:autre:4230:23556309,23558413:autre:4230:23558846,23561138:autre:4230:23561659,23564933:autre:4230:23565280,23567564:autre:4230:23571952,23567566:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03219933899217814, 'nb_photo': 66816, 'list_port_cont': '23520200,23520835,23520872,23521012,23521126,23521261,23521302,23521459,23521658,23521690,23521816,23521844,23521925,23521997,23522073,23522121,23522191,23522323,23522388,23522574,23522713,23524092,23524240,23524392,23540620,23542843,23544397,23550866,23553622,23553669,23556300,23558848,23561665,23565284,23570772,23571403,23571438,23571487,23571582,23571622,23571681,23571713,23571790,23571827,23571895,23571921,23571969,23572364,23601732,23602054,23602118,23602166,23602322,23602403,23602572,23602740,23602824,23602955,23602997,23603117,23603145,23603215,23603433,23603480,23603549,23603737,23603846,23603909,23606759,23607434,23620811,23620988,23645885,23646013,23646183,23647484,23647562,23647638,23647719,23647789,23647967,23648141,23648191,23648339,23648459,23648510,23648557,23648626,23648834,23648927,23648999,23649113,23649158,23649216,23651494,23652023,23688399,23688541,23688578,23688634,23688648,23688733,23688776,23688837,23689019,23689062,23689133,23689186,23689257,23749887,23749914,23750000,23750043,2375016', 'assoc_port': '23519890:23522388,23519892:23522191,23519894:23521997,23519896:23522323,23519898:23521925,23519900:23522073,23519902:23522121,23519904:23524240,23519907:23521690,23519909:23521816,23519912:23521844,23519915:23521658,23519917:23521459,23519920:23521302,23519922:23524092,23519925:23521261,23519928:23524392,23519930:23520872,23519933:23521012,23519936:23521126,23519938:23520835,23519941:23520200,23522490:23522574,23522697:23522713,23540201:23540620,23542485:23542843,23544148:23544397,23546744:23553622,23550376:23550866,23553289:23553669,23555921:23556300,23558413:23558848,23561138:23561665,23564933:23565284,23567564:23571969,23567566:23571895,23567569:23571790,23567582:23571921,23567584:23571827,23567587:23571713,23567590:23571622,23567604:23571681,23567620:23571582,23567623:23571403,23567625:23571487,23567629:23571438,23570230:23570772,23572185:23572364,23601604:23603737,23601605:23603846,23601606:23603909,23601608:23603480,23601609:23603433,23601610:23607434,23601611:23603215,23601612:23603549,23601613:2360299', 'assoc_mat': '23519890:carton:4230:23522388,23519892:carton:4230:23522191,23519894:carton:4230:23521997,23519896:carton:4230:23522323,23519898:carton:4230:23521925,23519900:carton:4230:23522073,23519902:carton:4230:23522121,23519904:carton:4230:23524240,23519907:carton:4230:23521690,23519909:carton:4230:23521816,23519912:carton:4230:23521844,23519915:carton:4230:23521658,23519917:carton:4230:23521459,23519920:carton:4230:23521302,23519922:carton:4230:23524092,23519925:carton:4230:23521261,23519928:carton:4230:23524392,23519930:carton:4230:23520872,23519933:carton:4230:23521012,23519936:carton:4230:23521126,23519938:carton:4230:23520835,23519941:carton:4230:23520200,23522490:carton:4230:23522574,23522697:carton:4230:23522713,23540201:carton:4230:23540620,23542485:carton:4230:23542843,23544148:carton:4230:23544397,23546744:carton:4230:23553622,23550376:carton:4230:23550866,23553289:carton:4230:23553669,23555921:carton:4230:23556300,23558413:carton:4230:23558848,23561138:carton:4230:23561665,23564933:carton:4230:23565284,2356'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00082780081987957, 'nb_photo': 1437, 'list_port_cont': '23520191,23520833,23520873,23521018,23521122,23521258,23521464,23521644,23521680,23521813,23521853,23521912,23521995,23522085,23522105,23522185,23522317,23522392,23522586,23522715,23524239,23524393,23540615,23542833,23544387,23553624,23553655,23556301,23558851,23561674,23565275,23570771,23571397,23571439,23571484,23571621,23571670,23571722,23571830,23571879,23571915,23572371,23601728,23602113,23602154,23602577,23602750,23602823,23602960,23602981,23603122,23603134,23603208,23603419,23603551,23603852,23606749,23607433,23620989,23645882,23646185,23647489,23647640,23647717,23647791,23647972,23648194,23648328,23648507,23648562,23648831,23649001,23649110,23649152,23649225,23651495,23652032,23688400,23688544,23688586,23688632,23688663,23688720,23688773,23688832,23689005,23689058,23689120,23689251,23749879,23749919,23750002,23750037,23750171,23750262,23750294,23750690,23750790,23751365,23751637,23755728,23755754,23755880,23755908,23755943,23755997,23756069,23756094,23756171,23756217,23756225,23756315,23756361,2375666', 'assoc_port': '23519890:23522392,23519892:23522185,23519894:23521995,23519896:23522317,23519898:23521912,23519900:23522085,23519902:23522105,23519904:23524239,23519907:23521680,23519909:23521813,23519912:23521853,23519915:23521644,23519917:23521464,23519925:23521258,23519928:23524393,23519930:23520873,23519933:23521018,23519936:23521122,23519938:23520833,23519941:23520191,23522490:23522586,23522697:23522715,23540201:23540615,23542485:23542833,23544148:23544387,23546744:23553624,23553289:23553655,23555921:23556301,23558413:23558851,23561138:23561674,23564933:23565275,23567566:23571879,23567582:23571915,23567584:23571830,23567587:23571722,23567590:23571621,23567604:23571670,23567623:23571397,23567625:23571484,23567629:23571439,23570230:23570771,23572185:23572371,23601605:23603852,23601609:23603419,23601610:23607433,23601611:23603208,23601612:23603551,23601613:23602981,23601614:23602960,23601615:23603122,23601616:23602750,23601617:23603134,23601618:23602823,23601619:23602577,23601621:23602113,23601622:23606749,23601624:2360215', 'assoc_mat': '23519890:metal:4230:23522392,23519892:metal:4230:23522185,23519894:metal:4230:23521995,23519896:metal:4230:23522317,23519898:metal:4230:23521912,23519900:metal:4230:23522085,23519902:metal:4230:23522105,23519904:metal:4230:23524239,23519907:metal:4230:23521680,23519909:metal:4230:23521813,23519912:metal:4230:23521853,23519915:metal:4230:23521644,23519917:metal:4230:23521464,23519925:metal:4230:23521258,23519928:metal:4230:23524393,23519930:metal:4230:23520873,23519933:metal:4230:23521018,23519936:metal:4230:23521122,23519938:metal:4230:23520833,23519941:metal:4230:23520191,23522490:metal:4230:23522586,23522697:metal:4230:23522715,23540201:metal:4230:23540615,23542485:metal:4230:23542833,23544148:metal:4230:23544387,23546744:metal:4230:23553624,23553289:metal:4230:23553655,23555921:metal:4230:23556301,23558413:metal:4230:23558851,23561138:metal:4230:23561674,23564933:metal:4230:23565275,23567566:metal:4230:23571879,23567582:metal:4230:23571915,23567584:metal:4230:23571830,23567587:metal:4230:23571722,23567590:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1536923377021488, 'nb_photo': 406124, 'list_port_cont': '23520223,23520831,23520859,23521010,23521112,23521271,23521307,23521457,23521654,23521692,23521807,23521850,23521918,23521985,23522079,23522120,23522180,23522322,23522391,23522582,23522724,23524094,23524242,23524387,23540614,23542848,23544386,23550872,23553617,23553667,23556311,23558863,23561670,23565279,23570780,23571400,23571434,23571493,23571586,23571617,23571684,23571721,23571794,23571829,23571896,23571929,23571960,23572365,23601726,23602052,23602120,23602163,23602331,23602400,23602578,23602738,23602838,23602961,23602995,23603121,23603130,23603221,23603431,23603474,23603552,23603744,23603847,23603896,23606761,23607440,23620809,23620986,23645888,23646027,23646188,23647479,23647565,23647635,23647715,23647796,23647966,23648148,23648189,23648335,23648446,23648509,23648560,23648627,23648822,23648915,23648994,23649117,23649151,23649220,23651497,23652028,23688413,23688548,23688580,23688625,23688654,23688722,23688784,23688836,23689009,23689051,23689132,23689178,23689255,23749884,23749923,23750011,23750047,2375016', 'assoc_port': '23519890:23522391,23519892:23522180,23519894:23521985,23519896:23522322,23519898:23521918,23519900:23522079,23519902:23522120,23519904:23524242,23519907:23521692,23519909:23521807,23519912:23521850,23519915:23521654,23519917:23521457,23519920:23521307,23519922:23524094,23519925:23521271,23519928:23524387,23519930:23520859,23519933:23521010,23519936:23521112,23519938:23520831,23519941:23520223,23522490:23522582,23522697:23522724,23540201:23540614,23542485:23542848,23544148:23544386,23546744:23553617,23550376:23550872,23553289:23553667,23555921:23556311,23558413:23558863,23561138:23561670,23564933:23565279,23567564:23571960,23567566:23571896,23567569:23571794,23567582:23571929,23567584:23571829,23567587:23571721,23567590:23571617,23567604:23571684,23567620:23571586,23567623:23571400,23567625:23571493,23567629:23571434,23570230:23570780,23572185:23572365,23601604:23603744,23601605:23603847,23601606:23603896,23601608:23603474,23601609:23603431,23601610:23607440,23601611:23603221,23601612:23603552,23601613:2360299', 'assoc_mat': '23519890:papier:4230:23522391,23519892:papier:4230:23522180,23519894:papier:4230:23521985,23519896:papier:4230:23522322,23519898:papier:4230:23521918,23519900:papier:4230:23522079,23519902:papier:4230:23522120,23519904:papier:4230:23524242,23519907:papier:4230:23521692,23519909:papier:4230:23521807,23519912:papier:4230:23521850,23519915:papier:4230:23521654,23519917:papier:4230:23521457,23519920:papier:4230:23521307,23519922:papier:4230:23524094,23519925:papier:4230:23521271,23519928:papier:4230:23524387,23519930:papier:4230:23520859,23519933:papier:4230:23521010,23519936:papier:4230:23521112,23519938:papier:4230:23520831,23519941:papier:4230:23520223,23522490:papier:4230:23522582,23522697:papier:4230:23522724,23540201:papier:4230:23540614,23542485:papier:4230:23542848,23544148:papier:4230:23544386,23546744:papier:4230:23553617,23550376:papier:4230:23550872,23553289:papier:4230:23553667,23555921:papier:4230:23556311,23558413:papier:4230:23558863,23561138:papier:4230:23561670,23564933:papier:4230:23565279,2356'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002420780097311048, 'nb_photo': 1515, 'list_port_cont': '23520203,23520837,23520870,23521121,23521265,23521308,23521465,23521652,23521693,23521847,23521923,23522083,23522119,23522319,23522382,23522585,23522722,23524093,23524250,23524384,23540622,23542839,23544398,23550869,23553623,23553666,23556295,23558853,23570769,23571399,23571495,23571623,23571682,23571821,23571894,23571930,23571963,23572369,23602053,23602127,23602155,23602332,23602748,23602837,23602964,23602993,23603120,23603136,23603217,23603435,23603479,23603548,23603849,23603906,23607442,23620804,23620984,23646021,23646189,23647490,23647556,23647631,23647965,23648147,23648190,23648337,23648511,23648836,23648914,23649000,23649119,23649154,23649223,23651493,23688411,23688546,23688583,23688670,23688835,23689020,23689053,23689129,23689188,23689256,23749876,23749916,23750013,23750044,23750161,23750270,23750304,23750450,23750704,23750791,23751373,23751652,23755658,23755737,23755760,23755886,23755924,23755956,23755992,23756067,23756108,23756180,23756212,23756235,23756321,23756360,23756466,23756668,23756724,2375679', 'assoc_port': '23519890:23522382,23519896:23522319,23519898:23521923,23519900:23522083,23519902:23522119,23519904:23524250,23519907:23521693,23519912:23521847,23519915:23521652,23519917:23521465,23519920:23521308,23519922:23524093,23519925:23521265,23519928:23524384,23519930:23520870,23519936:23521121,23519938:23520837,23519941:23520203,23522490:23522585,23522697:23522722,23540201:23540622,23542485:23542839,23544148:23544398,23546744:23553623,23550376:23550869,23553289:23553666,23555921:23556295,23558413:23558853,23567564:23571963,23567566:23571894,23567582:23571930,23567584:23571821,23567590:23571623,23567604:23571682,23567623:23571399,23567625:23571495,23570230:23570769,23572185:23572369,23601605:23603849,23601606:23603906,23601608:23603479,23601609:23603435,23601610:23607442,23601611:23603217,23601612:23603548,23601613:23602993,23601614:23602964,23601615:23603120,23601616:23602748,23601617:23603136,23601618:23602837,23601621:23602127,23601623:23602332,23601624:23602155,23601626:23602053,23620511:23620984,23620513:2362080', 'assoc_mat': '23519890:pehd:4230:23522382,23519896:pehd:4230:23522319,23519898:pehd:4230:23521923,23519900:pehd:4230:23522083,23519902:pehd:4230:23522119,23519904:pehd:4230:23524250,23519907:pehd:4230:23521693,23519912:pehd:4230:23521847,23519915:pehd:4230:23521652,23519917:pehd:4230:23521465,23519920:pehd:4230:23521308,23519922:pehd:4230:23524093,23519925:pehd:4230:23521265,23519928:pehd:4230:23524384,23519930:pehd:4230:23520870,23519936:pehd:4230:23521121,23519938:pehd:4230:23520837,23519941:pehd:4230:23520203,23522490:pehd:4230:23522585,23522697:pehd:4230:23522722,23540201:pehd:4230:23540622,23542485:pehd:4230:23542839,23544148:pehd:4230:23544398,23546744:pehd:4230:23553623,23550376:pehd:4230:23550869,23553289:pehd:4230:23553666,23555921:pehd:4230:23556295,23558413:pehd:4230:23558853,23567564:pehd:4230:23571963,23567566:pehd:4230:23571894,23567582:pehd:4230:23571930,23567584:pehd:4230:23571821,23567590:pehd:4230:23571623,23567604:pehd:4230:23571682,23567623:pehd:4230:23571399,23567625:pehd:4230:23571495,23570230:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020107654707525135, 'nb_photo': 24843, 'list_port_cont': '23520218,23520830,23520862,23521015,23521123,23521270,23521305,23521462,23521656,23521689,23521815,23521842,23521915,23521989,23522084,23522114,23522187,23522321,23522395,23522577,23522723,23524088,23524234,23524389,23540624,23542840,23544394,23550871,23553613,23553668,23556302,23558855,23561668,23565278,23570778,23571393,23571436,23571490,23571583,23571619,23571677,23571717,23571793,23571825,23571888,23571922,23571965,23572372,23601734,23602055,23602126,23602160,23602333,23602407,23602573,23602751,23602829,23602963,23602979,23603119,23603135,23603219,23603425,23603470,23603546,23603743,23603851,23603904,23606757,23607438,23620805,23620987,23645887,23646019,23646184,23647481,23647563,23647637,23647723,23647799,23647958,23648143,23648180,23648338,23648456,23648501,23648558,23648624,23648823,23648923,23648995,23649115,23649159,23649217,23651489,23652022,23688408,23688542,23688581,23688630,23688646,23688724,23688772,23688826,23689022,23689060,23689135,23689183,23689249,23749888,23749927,23750010,23750050,2375015', 'assoc_port': '23519890:23522395,23519892:23522187,23519894:23521989,23519896:23522321,23519898:23521915,23519900:23522084,23519902:23522114,23519904:23524234,23519907:23521689,23519909:23521815,23519912:23521842,23519915:23521656,23519917:23521462,23519920:23521305,23519922:23524088,23519925:23521270,23519928:23524389,23519930:23520862,23519933:23521015,23519936:23521123,23519938:23520830,23519941:23520218,23522490:23522577,23522697:23522723,23540201:23540624,23542485:23542840,23544148:23544394,23546744:23553613,23550376:23550871,23553289:23553668,23555921:23556302,23558413:23558855,23561138:23561668,23564933:23565278,23567564:23571965,23567566:23571888,23567569:23571793,23567582:23571922,23567584:23571825,23567587:23571717,23567590:23571619,23567604:23571677,23567620:23571583,23567623:23571393,23567625:23571490,23567629:23571436,23570230:23570778,23572185:23572372,23601604:23603743,23601605:23603851,23601606:23603904,23601608:23603470,23601609:23603425,23601610:23607438,23601611:23603219,23601612:23603546,23601613:2360297', 'assoc_mat': '23519890:pet_clair:4230:23522395,23519892:pet_clair:4230:23522187,23519894:pet_clair:4230:23521989,23519896:pet_clair:4230:23522321,23519898:pet_clair:4230:23521915,23519900:pet_clair:4230:23522084,23519902:pet_clair:4230:23522114,23519904:pet_clair:4230:23524234,23519907:pet_clair:4230:23521689,23519909:pet_clair:4230:23521815,23519912:pet_clair:4230:23521842,23519915:pet_clair:4230:23521656,23519917:pet_clair:4230:23521462,23519920:pet_clair:4230:23521305,23519922:pet_clair:4230:23524088,23519925:pet_clair:4230:23521270,23519928:pet_clair:4230:23524389,23519930:pet_clair:4230:23520862,23519933:pet_clair:4230:23521015,23519936:pet_clair:4230:23521123,23519938:pet_clair:4230:23520830,23519941:pet_clair:4230:23520218,23522490:pet_clair:4230:23522577,23522697:pet_clair:4230:23522723,23540201:pet_clair:4230:23540624,23542485:pet_clair:4230:23542840,23544148:pet_clair:4230:23544394,23546744:pet_clair:4230:23553613,23550376:pet_clair:4230:23550871,23553289:pet_clair:4230:23553668,23555921:pet_clair:4230:23556302,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001970689888139395, 'nb_photo': 736, 'list_port_cont': '23520215,23520834,23521125,23521262,23521458,23521845,23521926,23521996,23522069,23522113,23522189,23522397,23524086,23524249,23524382,23553619,23553663,23571401,23571491,23571685,23571715,23571826,23572357,23602051,23602129,23602330,23602397,23602836,23602973,23603115,23603143,23603436,23603550,23603747,23603844,23647566,23647634,23647793,23647964,23648149,23648184,23648336,23648548,23652026,23688404,23688539,23688585,23688729,23688828,23689055,23749886,23749922,23750001,23750049,23750170,23750260,23750301,23750451,23750694,23750788,23751376,23751646,23755663,23755696,23755741,23755759,23755887,23755918,23755960,23755986,23756071,23756098,23756176,23756210,23756234,23756468,23756667,23756718,23756791,23756907,23757047,23757324,23792164,23792206,23792545,23792717,23793283,23793459,23793511,23793563,23793763,23794496,23794628,23798504,23823196,23823456,23823719,23823789,23823927,23824198,23824240,23824288,23824344,23825013,23829357,23842615,23845634,23848109,23851790,23853520,23855245,23857328,23859239,2386418', 'assoc_port': '23519890:23522397,23519892:23522189,23519894:23521996,23519898:23521926,23519900:23522069,23519902:23522113,23519904:23524249,23519912:23521845,23519917:23521458,23519922:23524086,23519925:23521262,23519928:23524382,23519936:23521125,23519938:23520834,23519941:23520215,23546744:23553619,23553289:23553663,23567584:23571826,23567587:23571715,23567604:23571685,23567623:23571401,23567625:23571491,23572185:23572357,23601604:23603747,23601605:23603844,23601609:23603436,23601612:23603550,23601613:23602973,23601615:23603115,23601617:23603143,23601618:23602836,23601620:23602397,23601621:23602129,23601623:23602330,23601626:23602051,23645627:23648336,23645628:23648548,23645630:23648184,23645631:23648149,23645632:23647793,23645633:23647964,23645635:23647634,23645638:23647566,23645639:23652026,23688174:23688585,23688175:23688729,23688176:23689055,23688182:23688404,23688183:23688828,23688186:23688539,23749586:23750788,23749589:23750694,23749591:23750260,23749593:23750451,23749595:23750170,23749597:23750301,23749600:2374988', 'assoc_mat': '23519890:pet_fonce:4230:23522397,23519892:pet_fonce:4230:23522189,23519894:pet_fonce:4230:23521996,23519898:pet_fonce:4230:23521926,23519900:pet_fonce:4230:23522069,23519902:pet_fonce:4230:23522113,23519904:pet_fonce:4230:23524249,23519912:pet_fonce:4230:23521845,23519917:pet_fonce:4230:23521458,23519922:pet_fonce:4230:23524086,23519925:pet_fonce:4230:23521262,23519928:pet_fonce:4230:23524382,23519936:pet_fonce:4230:23521125,23519938:pet_fonce:4230:23520834,23519941:pet_fonce:4230:23520215,23546744:pet_fonce:4230:23553619,23553289:pet_fonce:4230:23553663,23567584:pet_fonce:4230:23571826,23567587:pet_fonce:4230:23571715,23567604:pet_fonce:4230:23571685,23567623:pet_fonce:4230:23571401,23567625:pet_fonce:4230:23571491,23572185:pet_fonce:4230:23572357,23601604:pet_fonce:4230:23603747,23601605:pet_fonce:4230:23603844,23601609:pet_fonce:4230:23603436,23601612:pet_fonce:4230:23603550,23601613:pet_fonce:4230:23602973,23601615:pet_fonce:4230:23603115,23601617:pet_fonce:4230:23603143,23601618:pet_fonce:4230:23602836,2'}) select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(1862598,1866479,1870984,1873056,1876532,1884733,1887904,1893000,1896977,1900231,1903350,1907898,1909899,1910819,1913550,1915960,1918607,1921319,1924875,1926449,1926698,1930467,1930464,1931909,1935575,1937302,1940057,1940582,1944932)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2025-06-01' and date <= '2025-06-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2141,),), 'unwanted_material_monthly_percentage': ((0.7932704091007633,),), 'material_repartition': (('incineration', 2141),), 'material_dict': {'incineration': 2141}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 6, 1), 0.8026744478255345, 77), (datetime.date(2025, 6, 2), 0.8247319487013981, 88), (datetime.date(2025, 6, 3), 0.8060346491577184, 92), (datetime.date(2025, 6, 4), 0.8026487634331932, 90), (datetime.date(2025, 6, 5), 0.7998396613653869, 49), (datetime.date(2025, 6, 7), 0.6886774770183187, 40), (datetime.date(2025, 6, 8), 0.7537006787589525, 79), (datetime.date(2025, 6, 9), 0.8059158046132284, 82), (datetime.date(2025, 6, 10), 0.7797403962416957, 88), (datetime.date(2025, 6, 11), 0.7515220500426734, 84), (datetime.date(2025, 6, 12), 0.7699546815551611, 89), (datetime.date(2025, 6, 13), 0.7947387179823667, 84), (datetime.date(2025, 6, 14), 0.7608349439597035, 81), (datetime.date(2025, 6, 15), 0.7727156059487809, 66), (datetime.date(2025, 6, 16), 0.8896747319940842, 44), (datetime.date(2025, 6, 17), 0.8362864282305086, 83), (datetime.date(2025, 6, 18), 0.8171289510112109, 12), (datetime.date(2025, 6, 19), 0.7952569353922797, 25), (datetime.date(2025, 6, 20), 0.7820612478864118, 89), (datetime.date(2025, 6, 21), 0.7231713640743752, 87), (datetime.date(2025, 6, 22), 0.8072267655640867, 88), (datetime.date(2025, 6, 23), 0.792299971487162, 83), (datetime.date(2025, 6, 24), 0.7941602950035597, 79), (datetime.date(2025, 6, 25), 0.7728808245905531, 86), (datetime.date(2025, 6, 26), 0.7830220054699587, 80), (datetime.date(2025, 6, 27), 0.796591262985938, 34), (datetime.date(2025, 6, 28), 0.8180238411915842, 89), (datetime.date(2025, 6, 29), 0.8337087481776448, 84), (datetime.date(2025, 6, 30), 0.8608296316369833, 89)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 6, 1), 0.8026744478255345, 77), (datetime.date(2025, 6, 2), 0.8247319487013981, 88), (datetime.date(2025, 6, 3), 0.8060346491577184, 92), (datetime.date(2025, 6, 4), 0.8026487634331932, 90), (datetime.date(2025, 6, 5), 0.7998396613653869, 49), (datetime.date(2025, 6, 7), 0.6886774770183187, 40), (datetime.date(2025, 6, 8), 0.7537006787589525, 79), (datetime.date(2025, 6, 9), 0.8059158046132284, 82), (datetime.date(2025, 6, 10), 0.7797403962416957, 88), (datetime.date(2025, 6, 11), 0.7515220500426734, 84), (datetime.date(2025, 6, 12), 0.7699546815551611, 89), (datetime.date(2025, 6, 13), 0.7947387179823667, 84), (datetime.date(2025, 6, 14), 0.7608349439597035, 81), (datetime.date(2025, 6, 15), 0.7727156059487809, 66), (datetime.date(2025, 6, 16), 0.8896747319940842, 44), (datetime.date(2025, 6, 17), 0.8362864282305086, 83), (datetime.date(2025, 6, 18), 0.8171289510112109, 12), (datetime.date(2025, 6, 19), 0.7952569353922797, 25), (datetime.date(2025, 6, 20), 0.7820612478864118, 89), (datetime.date(2025, 6, 21), 0.7231713640743752, 87), (datetime.date(2025, 6, 22), 0.8072267655640867, 88), (datetime.date(2025, 6, 23), 0.792299971487162, 83), (datetime.date(2025, 6, 24), 0.7941602950035597, 79), (datetime.date(2025, 6, 25), 0.7728808245905531, 86), (datetime.date(2025, 6, 26), 0.7830220054699587, 80), (datetime.date(2025, 6, 27), 0.796591262985938, 34), (datetime.date(2025, 6, 28), 0.8180238411915842, 89), (datetime.date(2025, 6, 29), 0.8337087481776448, 84), (datetime.date(2025, 6, 30), 0.8608296316369833, 89))}, 'quality_array': [['-7.7495100788229365', '01062025'], ['-7.5064530459725', '02062025'], ['-7.520179897529099', '03062025'], ['-7.636595009546945', '04062025'], ['-7.684904263095518', '05062025'], ['-7.854888033486072', '07062025'], ['-7.890045994510897', '08062025'], ['-7.756612266486451', '09062025'], ['-7.789280388976858', '10062025'], ['-7.809982147987806', '11062025'], ['-7.768939729600901', '12062025'], ['-7.781254883208615', '13062025'], ['-7.748786569050353', '14062025'], ['-7.707418515675508', '15062025'], ['-6.564426425087858', '16062025'], ['-7.140775557158841', '17062025'], ['-7.455009423026756', '18062025'], ['-8.191167178117823', '19062025'], ['-8.108791122298221', '20062025'], ['-7.911398062267429', '21062025'], ['-7.803367019880508', '22062025'], ['-7.506825691607029', '23062025'], ['-7.61149045059047', '24062025'], ['-7.513471100784026', '25062025'], ['-7.776153631469716', '26062025'], ['-7.652177914365564', '27062025'], ['-7.092097112731721', '28062025'], ['-7.256409688717308', '29062025'], ['-6.826240891735539', '30062025']], 'number_of_batch': ((608,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012510235516854299, 'nb_photo': 18160, 'list_port_cont': '23520206,23520820,23520865,23521011,23521124,23521264,23521301,23521461,23521655,23521679,23521812,23521843,23521916,23521993,23522072,23522109,23522183,23522310,23522386,23522584,23522721,23524077,23524236,23524390,23540623,23542850,23544401,23550870,23553607,23553664,23556309,23558846,23561659,23565280,23570764,23571388,23571432,23571498,23571574,23571620,23571680,23571720,23571792,23571819,23571885,23571923,23571952,23572362,23601722,23602045,23602128,23602165,23602328,23602404,23602565,23602742,23602825,23602962,23602985,23603116,23603126,23603211,23603426,23603467,23603537,23603736,23603836,23603893,23606748,23607429,23620799,23620973,23645874,23645995,23646177,23647482,23647544,23647639,23647720,23647798,23647959,23648138,23648186,23648340,23648450,23648498,23648552,23648619,23648830,23648917,23648984,23649111,23649149,23649221,23651483,23652034,23688410,23688545,23688575,23688619,23688667,23688731,23688785,23688822,23689011,23689056,23689124,23689185,23689253,23749877,23749915,23750004,23750045,2375016', 'assoc_port': '23519890:23522386,23519892:23522183,23519894:23521993,23519896:23522310,23519898:23521916,23519900:23522072,23519902:23522109,23519904:23524236,23519907:23521679,23519909:23521812,23519912:23521843,23519915:23521655,23519917:23521461,23519920:23521301,23519922:23524077,23519925:23521264,23519928:23524390,23519930:23520865,23519933:23521011,23519936:23521124,23519938:23520820,23519941:23520206,23522490:23522584,23522697:23522721,23540201:23540623,23542485:23542850,23544148:23544401,23546744:23553607,23550376:23550870,23553289:23553664,23555921:23556309,23558413:23558846,23561138:23561659,23564933:23565280,23567564:23571952,23567566:23571885,23567569:23571792,23567582:23571923,23567584:23571819,23567587:23571720,23567590:23571620,23567604:23571680,23567620:23571574,23567623:23571388,23567625:23571498,23567629:23571432,23570230:23570764,23572185:23572362,23601604:23603736,23601605:23603836,23601606:23603893,23601608:23603467,23601609:23603426,23601610:23607429,23601611:23603211,23601612:23603537,23601613:2360298', 'assoc_mat': '23519890:autre:4230:23522386,23519892:autre:4230:23522183,23519894:autre:4230:23521993,23519896:autre:4230:23522310,23519898:autre:4230:23521916,23519900:autre:4230:23522072,23519902:autre:4230:23522109,23519904:autre:4230:23524236,23519907:autre:4230:23521679,23519909:autre:4230:23521812,23519912:autre:4230:23521843,23519915:autre:4230:23521655,23519917:autre:4230:23521461,23519920:autre:4230:23521301,23519922:autre:4230:23524077,23519925:autre:4230:23521264,23519928:autre:4230:23524390,23519930:autre:4230:23520865,23519933:autre:4230:23521011,23519936:autre:4230:23521124,23519938:autre:4230:23520820,23519941:autre:4230:23520206,23522490:autre:4230:23522584,23522697:autre:4230:23522721,23540201:autre:4230:23540623,23542485:autre:4230:23542850,23544148:autre:4230:23544401,23546744:autre:4230:23553607,23550376:autre:4230:23550870,23553289:autre:4230:23553664,23555921:autre:4230:23556309,23558413:autre:4230:23558846,23561138:autre:4230:23561659,23564933:autre:4230:23565280,23567564:autre:4230:23571952,23567566:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03219933899217814, 'nb_photo': 66816, 'list_port_cont': '23520200,23520835,23520872,23521012,23521126,23521261,23521302,23521459,23521658,23521690,23521816,23521844,23521925,23521997,23522073,23522121,23522191,23522323,23522388,23522574,23522713,23524092,23524240,23524392,23540620,23542843,23544397,23550866,23553622,23553669,23556300,23558848,23561665,23565284,23570772,23571403,23571438,23571487,23571582,23571622,23571681,23571713,23571790,23571827,23571895,23571921,23571969,23572364,23601732,23602054,23602118,23602166,23602322,23602403,23602572,23602740,23602824,23602955,23602997,23603117,23603145,23603215,23603433,23603480,23603549,23603737,23603846,23603909,23606759,23607434,23620811,23620988,23645885,23646013,23646183,23647484,23647562,23647638,23647719,23647789,23647967,23648141,23648191,23648339,23648459,23648510,23648557,23648626,23648834,23648927,23648999,23649113,23649158,23649216,23651494,23652023,23688399,23688541,23688578,23688634,23688648,23688733,23688776,23688837,23689019,23689062,23689133,23689186,23689257,23749887,23749914,23750000,23750043,2375016', 'assoc_port': '23519890:23522388,23519892:23522191,23519894:23521997,23519896:23522323,23519898:23521925,23519900:23522073,23519902:23522121,23519904:23524240,23519907:23521690,23519909:23521816,23519912:23521844,23519915:23521658,23519917:23521459,23519920:23521302,23519922:23524092,23519925:23521261,23519928:23524392,23519930:23520872,23519933:23521012,23519936:23521126,23519938:23520835,23519941:23520200,23522490:23522574,23522697:23522713,23540201:23540620,23542485:23542843,23544148:23544397,23546744:23553622,23550376:23550866,23553289:23553669,23555921:23556300,23558413:23558848,23561138:23561665,23564933:23565284,23567564:23571969,23567566:23571895,23567569:23571790,23567582:23571921,23567584:23571827,23567587:23571713,23567590:23571622,23567604:23571681,23567620:23571582,23567623:23571403,23567625:23571487,23567629:23571438,23570230:23570772,23572185:23572364,23601604:23603737,23601605:23603846,23601606:23603909,23601608:23603480,23601609:23603433,23601610:23607434,23601611:23603215,23601612:23603549,23601613:2360299', 'assoc_mat': '23519890:carton:4230:23522388,23519892:carton:4230:23522191,23519894:carton:4230:23521997,23519896:carton:4230:23522323,23519898:carton:4230:23521925,23519900:carton:4230:23522073,23519902:carton:4230:23522121,23519904:carton:4230:23524240,23519907:carton:4230:23521690,23519909:carton:4230:23521816,23519912:carton:4230:23521844,23519915:carton:4230:23521658,23519917:carton:4230:23521459,23519920:carton:4230:23521302,23519922:carton:4230:23524092,23519925:carton:4230:23521261,23519928:carton:4230:23524392,23519930:carton:4230:23520872,23519933:carton:4230:23521012,23519936:carton:4230:23521126,23519938:carton:4230:23520835,23519941:carton:4230:23520200,23522490:carton:4230:23522574,23522697:carton:4230:23522713,23540201:carton:4230:23540620,23542485:carton:4230:23542843,23544148:carton:4230:23544397,23546744:carton:4230:23553622,23550376:carton:4230:23550866,23553289:carton:4230:23553669,23555921:carton:4230:23556300,23558413:carton:4230:23558848,23561138:carton:4230:23561665,23564933:carton:4230:23565284,2356'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00082780081987957, 'nb_photo': 1437, 'list_port_cont': '23520191,23520833,23520873,23521018,23521122,23521258,23521464,23521644,23521680,23521813,23521853,23521912,23521995,23522085,23522105,23522185,23522317,23522392,23522586,23522715,23524239,23524393,23540615,23542833,23544387,23553624,23553655,23556301,23558851,23561674,23565275,23570771,23571397,23571439,23571484,23571621,23571670,23571722,23571830,23571879,23571915,23572371,23601728,23602113,23602154,23602577,23602750,23602823,23602960,23602981,23603122,23603134,23603208,23603419,23603551,23603852,23606749,23607433,23620989,23645882,23646185,23647489,23647640,23647717,23647791,23647972,23648194,23648328,23648507,23648562,23648831,23649001,23649110,23649152,23649225,23651495,23652032,23688400,23688544,23688586,23688632,23688663,23688720,23688773,23688832,23689005,23689058,23689120,23689251,23749879,23749919,23750002,23750037,23750171,23750262,23750294,23750690,23750790,23751365,23751637,23755728,23755754,23755880,23755908,23755943,23755997,23756069,23756094,23756171,23756217,23756225,23756315,23756361,2375666', 'assoc_port': '23519890:23522392,23519892:23522185,23519894:23521995,23519896:23522317,23519898:23521912,23519900:23522085,23519902:23522105,23519904:23524239,23519907:23521680,23519909:23521813,23519912:23521853,23519915:23521644,23519917:23521464,23519925:23521258,23519928:23524393,23519930:23520873,23519933:23521018,23519936:23521122,23519938:23520833,23519941:23520191,23522490:23522586,23522697:23522715,23540201:23540615,23542485:23542833,23544148:23544387,23546744:23553624,23553289:23553655,23555921:23556301,23558413:23558851,23561138:23561674,23564933:23565275,23567566:23571879,23567582:23571915,23567584:23571830,23567587:23571722,23567590:23571621,23567604:23571670,23567623:23571397,23567625:23571484,23567629:23571439,23570230:23570771,23572185:23572371,23601605:23603852,23601609:23603419,23601610:23607433,23601611:23603208,23601612:23603551,23601613:23602981,23601614:23602960,23601615:23603122,23601616:23602750,23601617:23603134,23601618:23602823,23601619:23602577,23601621:23602113,23601622:23606749,23601624:2360215', 'assoc_mat': '23519890:metal:4230:23522392,23519892:metal:4230:23522185,23519894:metal:4230:23521995,23519896:metal:4230:23522317,23519898:metal:4230:23521912,23519900:metal:4230:23522085,23519902:metal:4230:23522105,23519904:metal:4230:23524239,23519907:metal:4230:23521680,23519909:metal:4230:23521813,23519912:metal:4230:23521853,23519915:metal:4230:23521644,23519917:metal:4230:23521464,23519925:metal:4230:23521258,23519928:metal:4230:23524393,23519930:metal:4230:23520873,23519933:metal:4230:23521018,23519936:metal:4230:23521122,23519938:metal:4230:23520833,23519941:metal:4230:23520191,23522490:metal:4230:23522586,23522697:metal:4230:23522715,23540201:metal:4230:23540615,23542485:metal:4230:23542833,23544148:metal:4230:23544387,23546744:metal:4230:23553624,23553289:metal:4230:23553655,23555921:metal:4230:23556301,23558413:metal:4230:23558851,23561138:metal:4230:23561674,23564933:metal:4230:23565275,23567566:metal:4230:23571879,23567582:metal:4230:23571915,23567584:metal:4230:23571830,23567587:metal:4230:23571722,23567590:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1536923377021488, 'nb_photo': 406124, 'list_port_cont': '23520223,23520831,23520859,23521010,23521112,23521271,23521307,23521457,23521654,23521692,23521807,23521850,23521918,23521985,23522079,23522120,23522180,23522322,23522391,23522582,23522724,23524094,23524242,23524387,23540614,23542848,23544386,23550872,23553617,23553667,23556311,23558863,23561670,23565279,23570780,23571400,23571434,23571493,23571586,23571617,23571684,23571721,23571794,23571829,23571896,23571929,23571960,23572365,23601726,23602052,23602120,23602163,23602331,23602400,23602578,23602738,23602838,23602961,23602995,23603121,23603130,23603221,23603431,23603474,23603552,23603744,23603847,23603896,23606761,23607440,23620809,23620986,23645888,23646027,23646188,23647479,23647565,23647635,23647715,23647796,23647966,23648148,23648189,23648335,23648446,23648509,23648560,23648627,23648822,23648915,23648994,23649117,23649151,23649220,23651497,23652028,23688413,23688548,23688580,23688625,23688654,23688722,23688784,23688836,23689009,23689051,23689132,23689178,23689255,23749884,23749923,23750011,23750047,2375016', 'assoc_port': '23519890:23522391,23519892:23522180,23519894:23521985,23519896:23522322,23519898:23521918,23519900:23522079,23519902:23522120,23519904:23524242,23519907:23521692,23519909:23521807,23519912:23521850,23519915:23521654,23519917:23521457,23519920:23521307,23519922:23524094,23519925:23521271,23519928:23524387,23519930:23520859,23519933:23521010,23519936:23521112,23519938:23520831,23519941:23520223,23522490:23522582,23522697:23522724,23540201:23540614,23542485:23542848,23544148:23544386,23546744:23553617,23550376:23550872,23553289:23553667,23555921:23556311,23558413:23558863,23561138:23561670,23564933:23565279,23567564:23571960,23567566:23571896,23567569:23571794,23567582:23571929,23567584:23571829,23567587:23571721,23567590:23571617,23567604:23571684,23567620:23571586,23567623:23571400,23567625:23571493,23567629:23571434,23570230:23570780,23572185:23572365,23601604:23603744,23601605:23603847,23601606:23603896,23601608:23603474,23601609:23603431,23601610:23607440,23601611:23603221,23601612:23603552,23601613:2360299', 'assoc_mat': '23519890:papier:4230:23522391,23519892:papier:4230:23522180,23519894:papier:4230:23521985,23519896:papier:4230:23522322,23519898:papier:4230:23521918,23519900:papier:4230:23522079,23519902:papier:4230:23522120,23519904:papier:4230:23524242,23519907:papier:4230:23521692,23519909:papier:4230:23521807,23519912:papier:4230:23521850,23519915:papier:4230:23521654,23519917:papier:4230:23521457,23519920:papier:4230:23521307,23519922:papier:4230:23524094,23519925:papier:4230:23521271,23519928:papier:4230:23524387,23519930:papier:4230:23520859,23519933:papier:4230:23521010,23519936:papier:4230:23521112,23519938:papier:4230:23520831,23519941:papier:4230:23520223,23522490:papier:4230:23522582,23522697:papier:4230:23522724,23540201:papier:4230:23540614,23542485:papier:4230:23542848,23544148:papier:4230:23544386,23546744:papier:4230:23553617,23550376:papier:4230:23550872,23553289:papier:4230:23553667,23555921:papier:4230:23556311,23558413:papier:4230:23558863,23561138:papier:4230:23561670,23564933:papier:4230:23565279,2356'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002420780097311048, 'nb_photo': 1515, 'list_port_cont': '23520203,23520837,23520870,23521121,23521265,23521308,23521465,23521652,23521693,23521847,23521923,23522083,23522119,23522319,23522382,23522585,23522722,23524093,23524250,23524384,23540622,23542839,23544398,23550869,23553623,23553666,23556295,23558853,23570769,23571399,23571495,23571623,23571682,23571821,23571894,23571930,23571963,23572369,23602053,23602127,23602155,23602332,23602748,23602837,23602964,23602993,23603120,23603136,23603217,23603435,23603479,23603548,23603849,23603906,23607442,23620804,23620984,23646021,23646189,23647490,23647556,23647631,23647965,23648147,23648190,23648337,23648511,23648836,23648914,23649000,23649119,23649154,23649223,23651493,23688411,23688546,23688583,23688670,23688835,23689020,23689053,23689129,23689188,23689256,23749876,23749916,23750013,23750044,23750161,23750270,23750304,23750450,23750704,23750791,23751373,23751652,23755658,23755737,23755760,23755886,23755924,23755956,23755992,23756067,23756108,23756180,23756212,23756235,23756321,23756360,23756466,23756668,23756724,2375679', 'assoc_port': '23519890:23522382,23519896:23522319,23519898:23521923,23519900:23522083,23519902:23522119,23519904:23524250,23519907:23521693,23519912:23521847,23519915:23521652,23519917:23521465,23519920:23521308,23519922:23524093,23519925:23521265,23519928:23524384,23519930:23520870,23519936:23521121,23519938:23520837,23519941:23520203,23522490:23522585,23522697:23522722,23540201:23540622,23542485:23542839,23544148:23544398,23546744:23553623,23550376:23550869,23553289:23553666,23555921:23556295,23558413:23558853,23567564:23571963,23567566:23571894,23567582:23571930,23567584:23571821,23567590:23571623,23567604:23571682,23567623:23571399,23567625:23571495,23570230:23570769,23572185:23572369,23601605:23603849,23601606:23603906,23601608:23603479,23601609:23603435,23601610:23607442,23601611:23603217,23601612:23603548,23601613:23602993,23601614:23602964,23601615:23603120,23601616:23602748,23601617:23603136,23601618:23602837,23601621:23602127,23601623:23602332,23601624:23602155,23601626:23602053,23620511:23620984,23620513:2362080', 'assoc_mat': '23519890:pehd:4230:23522382,23519896:pehd:4230:23522319,23519898:pehd:4230:23521923,23519900:pehd:4230:23522083,23519902:pehd:4230:23522119,23519904:pehd:4230:23524250,23519907:pehd:4230:23521693,23519912:pehd:4230:23521847,23519915:pehd:4230:23521652,23519917:pehd:4230:23521465,23519920:pehd:4230:23521308,23519922:pehd:4230:23524093,23519925:pehd:4230:23521265,23519928:pehd:4230:23524384,23519930:pehd:4230:23520870,23519936:pehd:4230:23521121,23519938:pehd:4230:23520837,23519941:pehd:4230:23520203,23522490:pehd:4230:23522585,23522697:pehd:4230:23522722,23540201:pehd:4230:23540622,23542485:pehd:4230:23542839,23544148:pehd:4230:23544398,23546744:pehd:4230:23553623,23550376:pehd:4230:23550869,23553289:pehd:4230:23553666,23555921:pehd:4230:23556295,23558413:pehd:4230:23558853,23567564:pehd:4230:23571963,23567566:pehd:4230:23571894,23567582:pehd:4230:23571930,23567584:pehd:4230:23571821,23567590:pehd:4230:23571623,23567604:pehd:4230:23571682,23567623:pehd:4230:23571399,23567625:pehd:4230:23571495,23570230:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020107654707525135, 'nb_photo': 24843, 'list_port_cont': '23520218,23520830,23520862,23521015,23521123,23521270,23521305,23521462,23521656,23521689,23521815,23521842,23521915,23521989,23522084,23522114,23522187,23522321,23522395,23522577,23522723,23524088,23524234,23524389,23540624,23542840,23544394,23550871,23553613,23553668,23556302,23558855,23561668,23565278,23570778,23571393,23571436,23571490,23571583,23571619,23571677,23571717,23571793,23571825,23571888,23571922,23571965,23572372,23601734,23602055,23602126,23602160,23602333,23602407,23602573,23602751,23602829,23602963,23602979,23603119,23603135,23603219,23603425,23603470,23603546,23603743,23603851,23603904,23606757,23607438,23620805,23620987,23645887,23646019,23646184,23647481,23647563,23647637,23647723,23647799,23647958,23648143,23648180,23648338,23648456,23648501,23648558,23648624,23648823,23648923,23648995,23649115,23649159,23649217,23651489,23652022,23688408,23688542,23688581,23688630,23688646,23688724,23688772,23688826,23689022,23689060,23689135,23689183,23689249,23749888,23749927,23750010,23750050,2375015', 'assoc_port': '23519890:23522395,23519892:23522187,23519894:23521989,23519896:23522321,23519898:23521915,23519900:23522084,23519902:23522114,23519904:23524234,23519907:23521689,23519909:23521815,23519912:23521842,23519915:23521656,23519917:23521462,23519920:23521305,23519922:23524088,23519925:23521270,23519928:23524389,23519930:23520862,23519933:23521015,23519936:23521123,23519938:23520830,23519941:23520218,23522490:23522577,23522697:23522723,23540201:23540624,23542485:23542840,23544148:23544394,23546744:23553613,23550376:23550871,23553289:23553668,23555921:23556302,23558413:23558855,23561138:23561668,23564933:23565278,23567564:23571965,23567566:23571888,23567569:23571793,23567582:23571922,23567584:23571825,23567587:23571717,23567590:23571619,23567604:23571677,23567620:23571583,23567623:23571393,23567625:23571490,23567629:23571436,23570230:23570778,23572185:23572372,23601604:23603743,23601605:23603851,23601606:23603904,23601608:23603470,23601609:23603425,23601610:23607438,23601611:23603219,23601612:23603546,23601613:2360297', 'assoc_mat': '23519890:pet_clair:4230:23522395,23519892:pet_clair:4230:23522187,23519894:pet_clair:4230:23521989,23519896:pet_clair:4230:23522321,23519898:pet_clair:4230:23521915,23519900:pet_clair:4230:23522084,23519902:pet_clair:4230:23522114,23519904:pet_clair:4230:23524234,23519907:pet_clair:4230:23521689,23519909:pet_clair:4230:23521815,23519912:pet_clair:4230:23521842,23519915:pet_clair:4230:23521656,23519917:pet_clair:4230:23521462,23519920:pet_clair:4230:23521305,23519922:pet_clair:4230:23524088,23519925:pet_clair:4230:23521270,23519928:pet_clair:4230:23524389,23519930:pet_clair:4230:23520862,23519933:pet_clair:4230:23521015,23519936:pet_clair:4230:23521123,23519938:pet_clair:4230:23520830,23519941:pet_clair:4230:23520218,23522490:pet_clair:4230:23522577,23522697:pet_clair:4230:23522723,23540201:pet_clair:4230:23540624,23542485:pet_clair:4230:23542840,23544148:pet_clair:4230:23544394,23546744:pet_clair:4230:23553613,23550376:pet_clair:4230:23550871,23553289:pet_clair:4230:23553668,23555921:pet_clair:4230:23556302,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001970689888139395, 'nb_photo': 736, 'list_port_cont': '23520215,23520834,23521125,23521262,23521458,23521845,23521926,23521996,23522069,23522113,23522189,23522397,23524086,23524249,23524382,23553619,23553663,23571401,23571491,23571685,23571715,23571826,23572357,23602051,23602129,23602330,23602397,23602836,23602973,23603115,23603143,23603436,23603550,23603747,23603844,23647566,23647634,23647793,23647964,23648149,23648184,23648336,23648548,23652026,23688404,23688539,23688585,23688729,23688828,23689055,23749886,23749922,23750001,23750049,23750170,23750260,23750301,23750451,23750694,23750788,23751376,23751646,23755663,23755696,23755741,23755759,23755887,23755918,23755960,23755986,23756071,23756098,23756176,23756210,23756234,23756468,23756667,23756718,23756791,23756907,23757047,23757324,23792164,23792206,23792545,23792717,23793283,23793459,23793511,23793563,23793763,23794496,23794628,23798504,23823196,23823456,23823719,23823789,23823927,23824198,23824240,23824288,23824344,23825013,23829357,23842615,23845634,23848109,23851790,23853520,23855245,23857328,23859239,2386418', 'assoc_port': '23519890:23522397,23519892:23522189,23519894:23521996,23519898:23521926,23519900:23522069,23519902:23522113,23519904:23524249,23519912:23521845,23519917:23521458,23519922:23524086,23519925:23521262,23519928:23524382,23519936:23521125,23519938:23520834,23519941:23520215,23546744:23553619,23553289:23553663,23567584:23571826,23567587:23571715,23567604:23571685,23567623:23571401,23567625:23571491,23572185:23572357,23601604:23603747,23601605:23603844,23601609:23603436,23601612:23603550,23601613:23602973,23601615:23603115,23601617:23603143,23601618:23602836,23601620:23602397,23601621:23602129,23601623:23602330,23601626:23602051,23645627:23648336,23645628:23648548,23645630:23648184,23645631:23648149,23645632:23647793,23645633:23647964,23645635:23647634,23645638:23647566,23645639:23652026,23688174:23688585,23688175:23688729,23688176:23689055,23688182:23688404,23688183:23688828,23688186:23688539,23749586:23750788,23749589:23750694,23749591:23750260,23749593:23750451,23749595:23750170,23749597:23750301,23749600:2374988', 'assoc_mat': '23519890:pet_fonce:4230:23522397,23519892:pet_fonce:4230:23522189,23519894:pet_fonce:4230:23521996,23519898:pet_fonce:4230:23521926,23519900:pet_fonce:4230:23522069,23519902:pet_fonce:4230:23522113,23519904:pet_fonce:4230:23524249,23519912:pet_fonce:4230:23521845,23519917:pet_fonce:4230:23521458,23519922:pet_fonce:4230:23524086,23519925:pet_fonce:4230:23521262,23519928:pet_fonce:4230:23524382,23519936:pet_fonce:4230:23521125,23519938:pet_fonce:4230:23520834,23519941:pet_fonce:4230:23520215,23546744:pet_fonce:4230:23553619,23553289:pet_fonce:4230:23553663,23567584:pet_fonce:4230:23571826,23567587:pet_fonce:4230:23571715,23567604:pet_fonce:4230:23571685,23567623:pet_fonce:4230:23571401,23567625:pet_fonce:4230:23571491,23572185:pet_fonce:4230:23572357,23601604:pet_fonce:4230:23603747,23601605:pet_fonce:4230:23603844,23601609:pet_fonce:4230:23603436,23601612:pet_fonce:4230:23603550,23601613:pet_fonce:4230:23602973,23601615:pet_fonce:4230:23603115,23601617:pet_fonce:4230:23603143,23601618:pet_fonce:4230:23602836,2'}), 'main_stat': {'nb_photos': 2141}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-06', 0.7932704091007633),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((2141,),), 'unwanted_material_monthly_percentage': ((0.7932704091007633,),), 'material_repartition': (('incineration', 2141),), 'material_dict': {'incineration': 2141}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 6, 1), 0.8026744478255345, 77), (datetime.date(2025, 6, 2), 0.8247319487013981, 88), (datetime.date(2025, 6, 3), 0.8060346491577184, 92), (datetime.date(2025, 6, 4), 0.8026487634331932, 90), (datetime.date(2025, 6, 5), 0.7998396613653869, 49), (datetime.date(2025, 6, 7), 0.6886774770183187, 40), (datetime.date(2025, 6, 8), 0.7537006787589525, 79), (datetime.date(2025, 6, 9), 0.8059158046132284, 82), (datetime.date(2025, 6, 10), 0.7797403962416957, 88), (datetime.date(2025, 6, 11), 0.7515220500426734, 84), (datetime.date(2025, 6, 12), 0.7699546815551611, 89), (datetime.date(2025, 6, 13), 0.7947387179823667, 84), (datetime.date(2025, 6, 14), 0.7608349439597035, 81), (datetime.date(2025, 6, 15), 0.7727156059487809, 66), (datetime.date(2025, 6, 16), 0.8896747319940842, 44), (datetime.date(2025, 6, 17), 0.8362864282305086, 83), (datetime.date(2025, 6, 18), 0.8171289510112109, 12), (datetime.date(2025, 6, 19), 0.7952569353922797, 25), (datetime.date(2025, 6, 20), 0.7820612478864118, 89), (datetime.date(2025, 6, 21), 0.7231713640743752, 87), (datetime.date(2025, 6, 22), 0.8072267655640867, 88), (datetime.date(2025, 6, 23), 0.792299971487162, 83), (datetime.date(2025, 6, 24), 0.7941602950035597, 79), (datetime.date(2025, 6, 25), 0.7728808245905531, 86), (datetime.date(2025, 6, 26), 0.7830220054699587, 80), (datetime.date(2025, 6, 27), 0.796591262985938, 34), (datetime.date(2025, 6, 28), 0.8180238411915842, 89), (datetime.date(2025, 6, 29), 0.8337087481776448, 84), (datetime.date(2025, 6, 30), 0.8608296316369833, 89)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 6, 1), 0.8026744478255345, 77), (datetime.date(2025, 6, 2), 0.8247319487013981, 88), (datetime.date(2025, 6, 3), 0.8060346491577184, 92), (datetime.date(2025, 6, 4), 0.8026487634331932, 90), (datetime.date(2025, 6, 5), 0.7998396613653869, 49), (datetime.date(2025, 6, 7), 0.6886774770183187, 40), (datetime.date(2025, 6, 8), 0.7537006787589525, 79), (datetime.date(2025, 6, 9), 0.8059158046132284, 82), (datetime.date(2025, 6, 10), 0.7797403962416957, 88), (datetime.date(2025, 6, 11), 0.7515220500426734, 84), (datetime.date(2025, 6, 12), 0.7699546815551611, 89), (datetime.date(2025, 6, 13), 0.7947387179823667, 84), (datetime.date(2025, 6, 14), 0.7608349439597035, 81), (datetime.date(2025, 6, 15), 0.7727156059487809, 66), (datetime.date(2025, 6, 16), 0.8896747319940842, 44), (datetime.date(2025, 6, 17), 0.8362864282305086, 83), (datetime.date(2025, 6, 18), 0.8171289510112109, 12), (datetime.date(2025, 6, 19), 0.7952569353922797, 25), (datetime.date(2025, 6, 20), 0.7820612478864118, 89), (datetime.date(2025, 6, 21), 0.7231713640743752, 87), (datetime.date(2025, 6, 22), 0.8072267655640867, 88), (datetime.date(2025, 6, 23), 0.792299971487162, 83), (datetime.date(2025, 6, 24), 0.7941602950035597, 79), (datetime.date(2025, 6, 25), 0.7728808245905531, 86), (datetime.date(2025, 6, 26), 0.7830220054699587, 80), (datetime.date(2025, 6, 27), 0.796591262985938, 34), (datetime.date(2025, 6, 28), 0.8180238411915842, 89), (datetime.date(2025, 6, 29), 0.8337087481776448, 84), (datetime.date(2025, 6, 30), 0.8608296316369833, 89))}, 'quality_array': [['-7.7495100788229365', '01062025'], ['-7.5064530459725', '02062025'], ['-7.520179897529099', '03062025'], ['-7.636595009546945', '04062025'], ['-7.684904263095518', '05062025'], ['-7.854888033486072', '07062025'], ['-7.890045994510897', '08062025'], ['-7.756612266486451', '09062025'], ['-7.789280388976858', '10062025'], ['-7.809982147987806', '11062025'], ['-7.768939729600901', '12062025'], ['-7.781254883208615', '13062025'], ['-7.748786569050353', '14062025'], ['-7.707418515675508', '15062025'], ['-6.564426425087858', '16062025'], ['-7.140775557158841', '17062025'], ['-7.455009423026756', '18062025'], ['-8.191167178117823', '19062025'], ['-8.108791122298221', '20062025'], ['-7.911398062267429', '21062025'], ['-7.803367019880508', '22062025'], ['-7.506825691607029', '23062025'], ['-7.61149045059047', '24062025'], ['-7.513471100784026', '25062025'], ['-7.776153631469716', '26062025'], ['-7.652177914365564', '27062025'], ['-7.092097112731721', '28062025'], ['-7.256409688717308', '29062025'], ['-6.826240891735539', '30062025']], 'number_of_batch': ((608,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012510235516854299, 'nb_photo': 18160, 'list_port_cont': '23520206,23520820,23520865,23521011,23521124,23521264,23521301,23521461,23521655,23521679,23521812,23521843,23521916,23521993,23522072,23522109,23522183,23522310,23522386,23522584,23522721,23524077,23524236,23524390,23540623,23542850,23544401,23550870,23553607,23553664,23556309,23558846,23561659,23565280,23570764,23571388,23571432,23571498,23571574,23571620,23571680,23571720,23571792,23571819,23571885,23571923,23571952,23572362,23601722,23602045,23602128,23602165,23602328,23602404,23602565,23602742,23602825,23602962,23602985,23603116,23603126,23603211,23603426,23603467,23603537,23603736,23603836,23603893,23606748,23607429,23620799,23620973,23645874,23645995,23646177,23647482,23647544,23647639,23647720,23647798,23647959,23648138,23648186,23648340,23648450,23648498,23648552,23648619,23648830,23648917,23648984,23649111,23649149,23649221,23651483,23652034,23688410,23688545,23688575,23688619,23688667,23688731,23688785,23688822,23689011,23689056,23689124,23689185,23689253,23749877,23749915,23750004,23750045,2375016', 'assoc_port': '23519890:23522386,23519892:23522183,23519894:23521993,23519896:23522310,23519898:23521916,23519900:23522072,23519902:23522109,23519904:23524236,23519907:23521679,23519909:23521812,23519912:23521843,23519915:23521655,23519917:23521461,23519920:23521301,23519922:23524077,23519925:23521264,23519928:23524390,23519930:23520865,23519933:23521011,23519936:23521124,23519938:23520820,23519941:23520206,23522490:23522584,23522697:23522721,23540201:23540623,23542485:23542850,23544148:23544401,23546744:23553607,23550376:23550870,23553289:23553664,23555921:23556309,23558413:23558846,23561138:23561659,23564933:23565280,23567564:23571952,23567566:23571885,23567569:23571792,23567582:23571923,23567584:23571819,23567587:23571720,23567590:23571620,23567604:23571680,23567620:23571574,23567623:23571388,23567625:23571498,23567629:23571432,23570230:23570764,23572185:23572362,23601604:23603736,23601605:23603836,23601606:23603893,23601608:23603467,23601609:23603426,23601610:23607429,23601611:23603211,23601612:23603537,23601613:2360298', 'assoc_mat': '23519890:autre:4230:23522386,23519892:autre:4230:23522183,23519894:autre:4230:23521993,23519896:autre:4230:23522310,23519898:autre:4230:23521916,23519900:autre:4230:23522072,23519902:autre:4230:23522109,23519904:autre:4230:23524236,23519907:autre:4230:23521679,23519909:autre:4230:23521812,23519912:autre:4230:23521843,23519915:autre:4230:23521655,23519917:autre:4230:23521461,23519920:autre:4230:23521301,23519922:autre:4230:23524077,23519925:autre:4230:23521264,23519928:autre:4230:23524390,23519930:autre:4230:23520865,23519933:autre:4230:23521011,23519936:autre:4230:23521124,23519938:autre:4230:23520820,23519941:autre:4230:23520206,23522490:autre:4230:23522584,23522697:autre:4230:23522721,23540201:autre:4230:23540623,23542485:autre:4230:23542850,23544148:autre:4230:23544401,23546744:autre:4230:23553607,23550376:autre:4230:23550870,23553289:autre:4230:23553664,23555921:autre:4230:23556309,23558413:autre:4230:23558846,23561138:autre:4230:23561659,23564933:autre:4230:23565280,23567564:autre:4230:23571952,23567566:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03219933899217814, 'nb_photo': 66816, 'list_port_cont': '23520200,23520835,23520872,23521012,23521126,23521261,23521302,23521459,23521658,23521690,23521816,23521844,23521925,23521997,23522073,23522121,23522191,23522323,23522388,23522574,23522713,23524092,23524240,23524392,23540620,23542843,23544397,23550866,23553622,23553669,23556300,23558848,23561665,23565284,23570772,23571403,23571438,23571487,23571582,23571622,23571681,23571713,23571790,23571827,23571895,23571921,23571969,23572364,23601732,23602054,23602118,23602166,23602322,23602403,23602572,23602740,23602824,23602955,23602997,23603117,23603145,23603215,23603433,23603480,23603549,23603737,23603846,23603909,23606759,23607434,23620811,23620988,23645885,23646013,23646183,23647484,23647562,23647638,23647719,23647789,23647967,23648141,23648191,23648339,23648459,23648510,23648557,23648626,23648834,23648927,23648999,23649113,23649158,23649216,23651494,23652023,23688399,23688541,23688578,23688634,23688648,23688733,23688776,23688837,23689019,23689062,23689133,23689186,23689257,23749887,23749914,23750000,23750043,2375016', 'assoc_port': '23519890:23522388,23519892:23522191,23519894:23521997,23519896:23522323,23519898:23521925,23519900:23522073,23519902:23522121,23519904:23524240,23519907:23521690,23519909:23521816,23519912:23521844,23519915:23521658,23519917:23521459,23519920:23521302,23519922:23524092,23519925:23521261,23519928:23524392,23519930:23520872,23519933:23521012,23519936:23521126,23519938:23520835,23519941:23520200,23522490:23522574,23522697:23522713,23540201:23540620,23542485:23542843,23544148:23544397,23546744:23553622,23550376:23550866,23553289:23553669,23555921:23556300,23558413:23558848,23561138:23561665,23564933:23565284,23567564:23571969,23567566:23571895,23567569:23571790,23567582:23571921,23567584:23571827,23567587:23571713,23567590:23571622,23567604:23571681,23567620:23571582,23567623:23571403,23567625:23571487,23567629:23571438,23570230:23570772,23572185:23572364,23601604:23603737,23601605:23603846,23601606:23603909,23601608:23603480,23601609:23603433,23601610:23607434,23601611:23603215,23601612:23603549,23601613:2360299', 'assoc_mat': '23519890:carton:4230:23522388,23519892:carton:4230:23522191,23519894:carton:4230:23521997,23519896:carton:4230:23522323,23519898:carton:4230:23521925,23519900:carton:4230:23522073,23519902:carton:4230:23522121,23519904:carton:4230:23524240,23519907:carton:4230:23521690,23519909:carton:4230:23521816,23519912:carton:4230:23521844,23519915:carton:4230:23521658,23519917:carton:4230:23521459,23519920:carton:4230:23521302,23519922:carton:4230:23524092,23519925:carton:4230:23521261,23519928:carton:4230:23524392,23519930:carton:4230:23520872,23519933:carton:4230:23521012,23519936:carton:4230:23521126,23519938:carton:4230:23520835,23519941:carton:4230:23520200,23522490:carton:4230:23522574,23522697:carton:4230:23522713,23540201:carton:4230:23540620,23542485:carton:4230:23542843,23544148:carton:4230:23544397,23546744:carton:4230:23553622,23550376:carton:4230:23550866,23553289:carton:4230:23553669,23555921:carton:4230:23556300,23558413:carton:4230:23558848,23561138:carton:4230:23561665,23564933:carton:4230:23565284,2356'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00082780081987957, 'nb_photo': 1437, 'list_port_cont': '23520191,23520833,23520873,23521018,23521122,23521258,23521464,23521644,23521680,23521813,23521853,23521912,23521995,23522085,23522105,23522185,23522317,23522392,23522586,23522715,23524239,23524393,23540615,23542833,23544387,23553624,23553655,23556301,23558851,23561674,23565275,23570771,23571397,23571439,23571484,23571621,23571670,23571722,23571830,23571879,23571915,23572371,23601728,23602113,23602154,23602577,23602750,23602823,23602960,23602981,23603122,23603134,23603208,23603419,23603551,23603852,23606749,23607433,23620989,23645882,23646185,23647489,23647640,23647717,23647791,23647972,23648194,23648328,23648507,23648562,23648831,23649001,23649110,23649152,23649225,23651495,23652032,23688400,23688544,23688586,23688632,23688663,23688720,23688773,23688832,23689005,23689058,23689120,23689251,23749879,23749919,23750002,23750037,23750171,23750262,23750294,23750690,23750790,23751365,23751637,23755728,23755754,23755880,23755908,23755943,23755997,23756069,23756094,23756171,23756217,23756225,23756315,23756361,2375666', 'assoc_port': '23519890:23522392,23519892:23522185,23519894:23521995,23519896:23522317,23519898:23521912,23519900:23522085,23519902:23522105,23519904:23524239,23519907:23521680,23519909:23521813,23519912:23521853,23519915:23521644,23519917:23521464,23519925:23521258,23519928:23524393,23519930:23520873,23519933:23521018,23519936:23521122,23519938:23520833,23519941:23520191,23522490:23522586,23522697:23522715,23540201:23540615,23542485:23542833,23544148:23544387,23546744:23553624,23553289:23553655,23555921:23556301,23558413:23558851,23561138:23561674,23564933:23565275,23567566:23571879,23567582:23571915,23567584:23571830,23567587:23571722,23567590:23571621,23567604:23571670,23567623:23571397,23567625:23571484,23567629:23571439,23570230:23570771,23572185:23572371,23601605:23603852,23601609:23603419,23601610:23607433,23601611:23603208,23601612:23603551,23601613:23602981,23601614:23602960,23601615:23603122,23601616:23602750,23601617:23603134,23601618:23602823,23601619:23602577,23601621:23602113,23601622:23606749,23601624:2360215', 'assoc_mat': '23519890:metal:4230:23522392,23519892:metal:4230:23522185,23519894:metal:4230:23521995,23519896:metal:4230:23522317,23519898:metal:4230:23521912,23519900:metal:4230:23522085,23519902:metal:4230:23522105,23519904:metal:4230:23524239,23519907:metal:4230:23521680,23519909:metal:4230:23521813,23519912:metal:4230:23521853,23519915:metal:4230:23521644,23519917:metal:4230:23521464,23519925:metal:4230:23521258,23519928:metal:4230:23524393,23519930:metal:4230:23520873,23519933:metal:4230:23521018,23519936:metal:4230:23521122,23519938:metal:4230:23520833,23519941:metal:4230:23520191,23522490:metal:4230:23522586,23522697:metal:4230:23522715,23540201:metal:4230:23540615,23542485:metal:4230:23542833,23544148:metal:4230:23544387,23546744:metal:4230:23553624,23553289:metal:4230:23553655,23555921:metal:4230:23556301,23558413:metal:4230:23558851,23561138:metal:4230:23561674,23564933:metal:4230:23565275,23567566:metal:4230:23571879,23567582:metal:4230:23571915,23567584:metal:4230:23571830,23567587:metal:4230:23571722,23567590:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1536923377021488, 'nb_photo': 406124, 'list_port_cont': '23520223,23520831,23520859,23521010,23521112,23521271,23521307,23521457,23521654,23521692,23521807,23521850,23521918,23521985,23522079,23522120,23522180,23522322,23522391,23522582,23522724,23524094,23524242,23524387,23540614,23542848,23544386,23550872,23553617,23553667,23556311,23558863,23561670,23565279,23570780,23571400,23571434,23571493,23571586,23571617,23571684,23571721,23571794,23571829,23571896,23571929,23571960,23572365,23601726,23602052,23602120,23602163,23602331,23602400,23602578,23602738,23602838,23602961,23602995,23603121,23603130,23603221,23603431,23603474,23603552,23603744,23603847,23603896,23606761,23607440,23620809,23620986,23645888,23646027,23646188,23647479,23647565,23647635,23647715,23647796,23647966,23648148,23648189,23648335,23648446,23648509,23648560,23648627,23648822,23648915,23648994,23649117,23649151,23649220,23651497,23652028,23688413,23688548,23688580,23688625,23688654,23688722,23688784,23688836,23689009,23689051,23689132,23689178,23689255,23749884,23749923,23750011,23750047,2375016', 'assoc_port': '23519890:23522391,23519892:23522180,23519894:23521985,23519896:23522322,23519898:23521918,23519900:23522079,23519902:23522120,23519904:23524242,23519907:23521692,23519909:23521807,23519912:23521850,23519915:23521654,23519917:23521457,23519920:23521307,23519922:23524094,23519925:23521271,23519928:23524387,23519930:23520859,23519933:23521010,23519936:23521112,23519938:23520831,23519941:23520223,23522490:23522582,23522697:23522724,23540201:23540614,23542485:23542848,23544148:23544386,23546744:23553617,23550376:23550872,23553289:23553667,23555921:23556311,23558413:23558863,23561138:23561670,23564933:23565279,23567564:23571960,23567566:23571896,23567569:23571794,23567582:23571929,23567584:23571829,23567587:23571721,23567590:23571617,23567604:23571684,23567620:23571586,23567623:23571400,23567625:23571493,23567629:23571434,23570230:23570780,23572185:23572365,23601604:23603744,23601605:23603847,23601606:23603896,23601608:23603474,23601609:23603431,23601610:23607440,23601611:23603221,23601612:23603552,23601613:2360299', 'assoc_mat': '23519890:papier:4230:23522391,23519892:papier:4230:23522180,23519894:papier:4230:23521985,23519896:papier:4230:23522322,23519898:papier:4230:23521918,23519900:papier:4230:23522079,23519902:papier:4230:23522120,23519904:papier:4230:23524242,23519907:papier:4230:23521692,23519909:papier:4230:23521807,23519912:papier:4230:23521850,23519915:papier:4230:23521654,23519917:papier:4230:23521457,23519920:papier:4230:23521307,23519922:papier:4230:23524094,23519925:papier:4230:23521271,23519928:papier:4230:23524387,23519930:papier:4230:23520859,23519933:papier:4230:23521010,23519936:papier:4230:23521112,23519938:papier:4230:23520831,23519941:papier:4230:23520223,23522490:papier:4230:23522582,23522697:papier:4230:23522724,23540201:papier:4230:23540614,23542485:papier:4230:23542848,23544148:papier:4230:23544386,23546744:papier:4230:23553617,23550376:papier:4230:23550872,23553289:papier:4230:23553667,23555921:papier:4230:23556311,23558413:papier:4230:23558863,23561138:papier:4230:23561670,23564933:papier:4230:23565279,2356'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002420780097311048, 'nb_photo': 1515, 'list_port_cont': '23520203,23520837,23520870,23521121,23521265,23521308,23521465,23521652,23521693,23521847,23521923,23522083,23522119,23522319,23522382,23522585,23522722,23524093,23524250,23524384,23540622,23542839,23544398,23550869,23553623,23553666,23556295,23558853,23570769,23571399,23571495,23571623,23571682,23571821,23571894,23571930,23571963,23572369,23602053,23602127,23602155,23602332,23602748,23602837,23602964,23602993,23603120,23603136,23603217,23603435,23603479,23603548,23603849,23603906,23607442,23620804,23620984,23646021,23646189,23647490,23647556,23647631,23647965,23648147,23648190,23648337,23648511,23648836,23648914,23649000,23649119,23649154,23649223,23651493,23688411,23688546,23688583,23688670,23688835,23689020,23689053,23689129,23689188,23689256,23749876,23749916,23750013,23750044,23750161,23750270,23750304,23750450,23750704,23750791,23751373,23751652,23755658,23755737,23755760,23755886,23755924,23755956,23755992,23756067,23756108,23756180,23756212,23756235,23756321,23756360,23756466,23756668,23756724,2375679', 'assoc_port': '23519890:23522382,23519896:23522319,23519898:23521923,23519900:23522083,23519902:23522119,23519904:23524250,23519907:23521693,23519912:23521847,23519915:23521652,23519917:23521465,23519920:23521308,23519922:23524093,23519925:23521265,23519928:23524384,23519930:23520870,23519936:23521121,23519938:23520837,23519941:23520203,23522490:23522585,23522697:23522722,23540201:23540622,23542485:23542839,23544148:23544398,23546744:23553623,23550376:23550869,23553289:23553666,23555921:23556295,23558413:23558853,23567564:23571963,23567566:23571894,23567582:23571930,23567584:23571821,23567590:23571623,23567604:23571682,23567623:23571399,23567625:23571495,23570230:23570769,23572185:23572369,23601605:23603849,23601606:23603906,23601608:23603479,23601609:23603435,23601610:23607442,23601611:23603217,23601612:23603548,23601613:23602993,23601614:23602964,23601615:23603120,23601616:23602748,23601617:23603136,23601618:23602837,23601621:23602127,23601623:23602332,23601624:23602155,23601626:23602053,23620511:23620984,23620513:2362080', 'assoc_mat': '23519890:pehd:4230:23522382,23519896:pehd:4230:23522319,23519898:pehd:4230:23521923,23519900:pehd:4230:23522083,23519902:pehd:4230:23522119,23519904:pehd:4230:23524250,23519907:pehd:4230:23521693,23519912:pehd:4230:23521847,23519915:pehd:4230:23521652,23519917:pehd:4230:23521465,23519920:pehd:4230:23521308,23519922:pehd:4230:23524093,23519925:pehd:4230:23521265,23519928:pehd:4230:23524384,23519930:pehd:4230:23520870,23519936:pehd:4230:23521121,23519938:pehd:4230:23520837,23519941:pehd:4230:23520203,23522490:pehd:4230:23522585,23522697:pehd:4230:23522722,23540201:pehd:4230:23540622,23542485:pehd:4230:23542839,23544148:pehd:4230:23544398,23546744:pehd:4230:23553623,23550376:pehd:4230:23550869,23553289:pehd:4230:23553666,23555921:pehd:4230:23556295,23558413:pehd:4230:23558853,23567564:pehd:4230:23571963,23567566:pehd:4230:23571894,23567582:pehd:4230:23571930,23567584:pehd:4230:23571821,23567590:pehd:4230:23571623,23567604:pehd:4230:23571682,23567623:pehd:4230:23571399,23567625:pehd:4230:23571495,23570230:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020107654707525135, 'nb_photo': 24843, 'list_port_cont': '23520218,23520830,23520862,23521015,23521123,23521270,23521305,23521462,23521656,23521689,23521815,23521842,23521915,23521989,23522084,23522114,23522187,23522321,23522395,23522577,23522723,23524088,23524234,23524389,23540624,23542840,23544394,23550871,23553613,23553668,23556302,23558855,23561668,23565278,23570778,23571393,23571436,23571490,23571583,23571619,23571677,23571717,23571793,23571825,23571888,23571922,23571965,23572372,23601734,23602055,23602126,23602160,23602333,23602407,23602573,23602751,23602829,23602963,23602979,23603119,23603135,23603219,23603425,23603470,23603546,23603743,23603851,23603904,23606757,23607438,23620805,23620987,23645887,23646019,23646184,23647481,23647563,23647637,23647723,23647799,23647958,23648143,23648180,23648338,23648456,23648501,23648558,23648624,23648823,23648923,23648995,23649115,23649159,23649217,23651489,23652022,23688408,23688542,23688581,23688630,23688646,23688724,23688772,23688826,23689022,23689060,23689135,23689183,23689249,23749888,23749927,23750010,23750050,2375015', 'assoc_port': '23519890:23522395,23519892:23522187,23519894:23521989,23519896:23522321,23519898:23521915,23519900:23522084,23519902:23522114,23519904:23524234,23519907:23521689,23519909:23521815,23519912:23521842,23519915:23521656,23519917:23521462,23519920:23521305,23519922:23524088,23519925:23521270,23519928:23524389,23519930:23520862,23519933:23521015,23519936:23521123,23519938:23520830,23519941:23520218,23522490:23522577,23522697:23522723,23540201:23540624,23542485:23542840,23544148:23544394,23546744:23553613,23550376:23550871,23553289:23553668,23555921:23556302,23558413:23558855,23561138:23561668,23564933:23565278,23567564:23571965,23567566:23571888,23567569:23571793,23567582:23571922,23567584:23571825,23567587:23571717,23567590:23571619,23567604:23571677,23567620:23571583,23567623:23571393,23567625:23571490,23567629:23571436,23570230:23570778,23572185:23572372,23601604:23603743,23601605:23603851,23601606:23603904,23601608:23603470,23601609:23603425,23601610:23607438,23601611:23603219,23601612:23603546,23601613:2360297', 'assoc_mat': '23519890:pet_clair:4230:23522395,23519892:pet_clair:4230:23522187,23519894:pet_clair:4230:23521989,23519896:pet_clair:4230:23522321,23519898:pet_clair:4230:23521915,23519900:pet_clair:4230:23522084,23519902:pet_clair:4230:23522114,23519904:pet_clair:4230:23524234,23519907:pet_clair:4230:23521689,23519909:pet_clair:4230:23521815,23519912:pet_clair:4230:23521842,23519915:pet_clair:4230:23521656,23519917:pet_clair:4230:23521462,23519920:pet_clair:4230:23521305,23519922:pet_clair:4230:23524088,23519925:pet_clair:4230:23521270,23519928:pet_clair:4230:23524389,23519930:pet_clair:4230:23520862,23519933:pet_clair:4230:23521015,23519936:pet_clair:4230:23521123,23519938:pet_clair:4230:23520830,23519941:pet_clair:4230:23520218,23522490:pet_clair:4230:23522577,23522697:pet_clair:4230:23522723,23540201:pet_clair:4230:23540624,23542485:pet_clair:4230:23542840,23544148:pet_clair:4230:23544394,23546744:pet_clair:4230:23553613,23550376:pet_clair:4230:23550871,23553289:pet_clair:4230:23553668,23555921:pet_clair:4230:23556302,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001970689888139395, 'nb_photo': 736, 'list_port_cont': '23520215,23520834,23521125,23521262,23521458,23521845,23521926,23521996,23522069,23522113,23522189,23522397,23524086,23524249,23524382,23553619,23553663,23571401,23571491,23571685,23571715,23571826,23572357,23602051,23602129,23602330,23602397,23602836,23602973,23603115,23603143,23603436,23603550,23603747,23603844,23647566,23647634,23647793,23647964,23648149,23648184,23648336,23648548,23652026,23688404,23688539,23688585,23688729,23688828,23689055,23749886,23749922,23750001,23750049,23750170,23750260,23750301,23750451,23750694,23750788,23751376,23751646,23755663,23755696,23755741,23755759,23755887,23755918,23755960,23755986,23756071,23756098,23756176,23756210,23756234,23756468,23756667,23756718,23756791,23756907,23757047,23757324,23792164,23792206,23792545,23792717,23793283,23793459,23793511,23793563,23793763,23794496,23794628,23798504,23823196,23823456,23823719,23823789,23823927,23824198,23824240,23824288,23824344,23825013,23829357,23842615,23845634,23848109,23851790,23853520,23855245,23857328,23859239,2386418', 'assoc_port': '23519890:23522397,23519892:23522189,23519894:23521996,23519898:23521926,23519900:23522069,23519902:23522113,23519904:23524249,23519912:23521845,23519917:23521458,23519922:23524086,23519925:23521262,23519928:23524382,23519936:23521125,23519938:23520834,23519941:23520215,23546744:23553619,23553289:23553663,23567584:23571826,23567587:23571715,23567604:23571685,23567623:23571401,23567625:23571491,23572185:23572357,23601604:23603747,23601605:23603844,23601609:23603436,23601612:23603550,23601613:23602973,23601615:23603115,23601617:23603143,23601618:23602836,23601620:23602397,23601621:23602129,23601623:23602330,23601626:23602051,23645627:23648336,23645628:23648548,23645630:23648184,23645631:23648149,23645632:23647793,23645633:23647964,23645635:23647634,23645638:23647566,23645639:23652026,23688174:23688585,23688175:23688729,23688176:23689055,23688182:23688404,23688183:23688828,23688186:23688539,23749586:23750788,23749589:23750694,23749591:23750260,23749593:23750451,23749595:23750170,23749597:23750301,23749600:2374988', 'assoc_mat': '23519890:pet_fonce:4230:23522397,23519892:pet_fonce:4230:23522189,23519894:pet_fonce:4230:23521996,23519898:pet_fonce:4230:23521926,23519900:pet_fonce:4230:23522069,23519902:pet_fonce:4230:23522113,23519904:pet_fonce:4230:23524249,23519912:pet_fonce:4230:23521845,23519917:pet_fonce:4230:23521458,23519922:pet_fonce:4230:23524086,23519925:pet_fonce:4230:23521262,23519928:pet_fonce:4230:23524382,23519936:pet_fonce:4230:23521125,23519938:pet_fonce:4230:23520834,23519941:pet_fonce:4230:23520215,23546744:pet_fonce:4230:23553619,23553289:pet_fonce:4230:23553663,23567584:pet_fonce:4230:23571826,23567587:pet_fonce:4230:23571715,23567604:pet_fonce:4230:23571685,23567623:pet_fonce:4230:23571401,23567625:pet_fonce:4230:23571491,23572185:pet_fonce:4230:23572357,23601604:pet_fonce:4230:23603747,23601605:pet_fonce:4230:23603844,23601609:pet_fonce:4230:23603436,23601612:pet_fonce:4230:23603550,23601613:pet_fonce:4230:23602973,23601615:pet_fonce:4230:23603115,23601617:pet_fonce:4230:23603143,23601618:pet_fonce:4230:23602836,2'}), 'main_stat': {'nb_photos': 2141}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-06', 0.7932704091007633),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_06_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.25%', 18160], 'carton': ['carton', '3.22%', 66816], 'metal': ['metal', '0.08%', 1437], 'papier': ['papier', '15.37%', 406124], 'pehd': ['pehd', '0.24%', 1515], 'pet_clair': ['pet_clair', '2.01%', 24843], 'pet_fonce': ['pet_fonce', '0.2%', 736]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_06_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.55user 2.63system 0:17.18elapsed 30%CPU (0avgtext+0avgdata 194708maxresident)k 8inputs+288outputs (0major+67829minor)pagefaults 0swaps