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_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-07 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (1, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (1, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # 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 : 203 month : 07 mtr_id : dashboard_places : SCCU_cam8 date : 2025-07 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam8' and date like '%2025-07%') and created_at like '%2025-07%'))); nb_day : (1, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 203 and month(ded.date) = 07 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______incineration' and ded.dashboard_place_id = 203 and month(ded.date) = 07 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 203 and mp.name like '%072025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-07-01 : dt_date_just_month_year : 2025-07-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam8" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-07-01" AND ded.date <= "2025-07-31" apple3 {'incineration': {'mat': 'incineration', 'pht': 4230, 'datou_carac_id': 4234, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1950669,1955076,1958637,1961691,1964067,1964414,1967787,1970359,1972642,1975903,1979422,1981920,1982250,1985694,1989630,1991367,1994339,1997042,1999281,1999627,2003007,2006384,2010053,2013843,2017699,2020301,2020937,2027413,2034537,2041277,2049325) 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.013502926306493633, 'nb_photo': 17671, 'list_port_cont': '24485626,24485808,24485935,24486123,24486213,24486302,24486484,24486621,24486901,24486961,24487173,24487447,24487564,24487853,24487951,24488124,24488189,24488367,24488441,24488608,24488856,24490438,24490839,24529282,24529637,24529670,24529796,24529887,24530130,24530231,24530296,24530303,24530480,24530617,24530744,24532915,24536147,24579560,24579596,24579628,24579657,24579702,24579739,24579765,24579815,24579839,24579884,24579921,24614250,24617149,24619056,24620958,24623659,24623754,24623976,24624146,24624218,24624252,24624342,24624379,24624691,24626166,24626608,24628152,24650182,24650245,24650284,24650322,24650382,24650470,24650505,24650545,24650587,24650629,24650673,24650721,24650748,24650845,24650871,24650911,24650985,24651041,24651077,24651199,24651343,24651504,24652757,24652951,24657014,24657062,24657119,24657159,24657232,24657553,24657676,24657705,24657750,24657774,24657809,24657901,24658036,24658141,24658201,24658257,24658402,24658435,24658468,24658589,24658853,24659125,24659335,24659510,24696781,2469729', 'assoc_port': '24485056:24488856,24485059:24488441,24485063:24488608,24485066:24488189,24485070:24488367,24485073:24488124,24485077:24487853,24485080:24487951,24485084:24487447,24485087:24487564,24485091:24486901,24485093:24490839,24485095:24487173,24485097:24486961,24485099:24486484,24485101:24486621,24485103:24486213,24485105:24486123,24485107:24486302,24485109:24485935,24485111:24485626,24485114:24485808,24490318:24490438,24527805:24530130,24527807:24530744,24527809:24530231,24527811:24530480,24527813:24529887,24527815:24530617,24527816:24529796,24527817:24530303,24527818:24529637,24527841:24529670,24527850:24529282,24527851:24530296,24532153:24532915,24535609:24536147,24579506:24579839,24579507:24579921,24579508:24579765,24579509:24579884,24579510:24579657,24579511:24579739,24579512:24579596,24579513:24579628,24579514:24579702,24579515:24579815,24579516:24579560,24613934:24614250,24616412:24617149,24618676:24619056,24620683:24620958,24622678:24624379,24622680:24624691,24622694:24624146,24622708:24624342,24622710:2462397', 'assoc_mat': '24485056:autre:4230:24488856,24485059:autre:4230:24488441,24485063:autre:4230:24488608,24485066:autre:4230:24488189,24485070:autre:4230:24488367,24485073:autre:4230:24488124,24485077:autre:4230:24487853,24485080:autre:4230:24487951,24485084:autre:4230:24487447,24485087:autre:4230:24487564,24485091:autre:4230:24486901,24485093:autre:4230:24490839,24485095:autre:4230:24487173,24485097:autre:4230:24486961,24485099:autre:4230:24486484,24485101:autre:4230:24486621,24485103:autre:4230:24486213,24485105:autre:4230:24486123,24485107:autre:4230:24486302,24485109:autre:4230:24485935,24485111:autre:4230:24485626,24485114:autre:4230:24485808,24490318:autre:4230:24490438,24527805:autre:4230:24530130,24527807:autre:4230:24530744,24527809:autre:4230:24530231,24527811:autre:4230:24530480,24527813:autre:4230:24529887,24527815:autre:4230:24530617,24527816:autre:4230:24529796,24527817:autre:4230:24530303,24527818:autre:4230:24529637,24527841:autre:4230:24529670,24527850:autre:4230:24529282,24527851:autre:4230:24530296,24532153:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.042146350027552584, 'nb_photo': 84188, 'list_port_cont': '24485617,24485809,24485943,24486143,24486219,24486297,24486497,24486612,24486894,24486963,24487170,24487453,24487558,24487867,24487963,24488136,24488206,24488375,24488443,24488588,24488857,24490450,24490836,24529287,24529629,24529676,24529802,24529893,24530134,24530239,24530283,24530308,24530469,24530627,24530741,24532929,24536144,24579554,24579597,24579631,24579669,24579697,24579736,24579777,24579803,24579850,24579888,24579913,24614249,24617153,24619059,24620957,24623660,24623759,24623970,24624158,24624212,24624248,24624341,24624378,24624697,24626171,24626612,24628167,24650191,24650243,24650280,24650324,24650395,24650480,24650513,24650555,24650588,24650637,24650683,24650711,24650757,24650838,24650878,24650910,24650997,24651043,24651088,24651205,24651338,24651508,24652759,24652949,24657028,24657058,24657111,24657173,24657245,24657551,24657678,24657716,24657751,24657783,24657802,24657902,24658047,24658151,24658206,24658250,24658401,24658439,24658471,24658581,24658852,24659130,24659339,24659508,24696791,2469730', 'assoc_port': '24485056:24488857,24485059:24488443,24485063:24488588,24485066:24488206,24485070:24488375,24485073:24488136,24485077:24487867,24485080:24487963,24485084:24487453,24485087:24487558,24485091:24486894,24485093:24490836,24485095:24487170,24485097:24486963,24485099:24486497,24485101:24486612,24485103:24486219,24485105:24486143,24485107:24486297,24485109:24485943,24485111:24485617,24485114:24485809,24490318:24490450,24527805:24530134,24527807:24530741,24527809:24530239,24527811:24530469,24527813:24529893,24527815:24530627,24527816:24529802,24527817:24530283,24527818:24529629,24527841:24529676,24527850:24529287,24527851:24530308,24532153:24532929,24535609:24536144,24579506:24579850,24579507:24579913,24579508:24579777,24579509:24579888,24579510:24579669,24579511:24579736,24579512:24579597,24579513:24579631,24579514:24579697,24579515:24579803,24579516:24579554,24613934:24614249,24616412:24617153,24618676:24619059,24620683:24620957,24622678:24624378,24622680:24624697,24622694:24624158,24622708:24624341,24622710:2462397', 'assoc_mat': '24485056:carton:4230:24488857,24485059:carton:4230:24488443,24485063:carton:4230:24488588,24485066:carton:4230:24488206,24485070:carton:4230:24488375,24485073:carton:4230:24488136,24485077:carton:4230:24487867,24485080:carton:4230:24487963,24485084:carton:4230:24487453,24485087:carton:4230:24487558,24485091:carton:4230:24486894,24485093:carton:4230:24490836,24485095:carton:4230:24487170,24485097:carton:4230:24486963,24485099:carton:4230:24486497,24485101:carton:4230:24486612,24485103:carton:4230:24486219,24485105:carton:4230:24486143,24485107:carton:4230:24486297,24485109:carton:4230:24485943,24485111:carton:4230:24485617,24485114:carton:4230:24485809,24490318:carton:4230:24490450,24527805:carton:4230:24530134,24527807:carton:4230:24530741,24527809:carton:4230:24530239,24527811:carton:4230:24530469,24527813:carton:4230:24529893,24527815:carton:4230:24530627,24527816:carton:4230:24529802,24527817:carton:4230:24530283,24527818:carton:4230:24529629,24527841:carton:4230:24529676,24527850:carton:4230:24529287,2452'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0009380997866097974, 'nb_photo': 1648, 'list_port_cont': '24485625,24485792,24485951,24486125,24486217,24486304,24486494,24486613,24486951,24487179,24487868,24488130,24488203,24488370,24488448,24488590,24488854,24490448,24490841,24529274,24529628,24529672,24529811,24529870,24530132,24530238,24530270,24530294,24530464,24530622,24530745,24532913,24536135,24579561,24579582,24579664,24579705,24579763,24579813,24579849,24579878,24579924,24614243,24617150,24619060,24620956,24623757,24624150,24624219,24624336,24624370,24624701,24626155,24626609,24628154,24650194,24650272,24650381,24650553,24650595,24650634,24650669,24650713,24650751,24650832,24650867,24650909,24651001,24651035,24651089,24651215,24651337,24651507,24652767,24652942,24657020,24657063,24657117,24657168,24657246,24657550,24657675,24657715,24657752,24657789,24657815,24657885,24658030,24658139,24658193,24658256,24658409,24658430,24658480,24658578,24658859,24659127,24659324,24659516,24696793,24697449,24697594,24697829,24697998,24698355,24698435,24698597,24698713,24698748,24699046,24699183,24699391,24699680,2469973', 'assoc_port': '24485056:24488854,24485059:24488448,24485063:24488590,24485066:24488203,24485070:24488370,24485073:24488130,24485077:24487868,24485093:24490841,24485095:24487179,24485097:24486951,24485099:24486494,24485101:24486613,24485103:24486217,24485105:24486125,24485107:24486304,24485109:24485951,24485111:24485625,24485114:24485792,24490318:24490448,24527805:24530132,24527807:24530745,24527809:24530238,24527811:24530464,24527813:24529870,24527815:24530622,24527816:24529811,24527817:24530270,24527818:24529628,24527841:24529672,24527850:24529274,24527851:24530294,24532153:24532913,24535609:24536135,24579506:24579849,24579507:24579924,24579508:24579763,24579509:24579878,24579510:24579664,24579512:24579582,24579514:24579705,24579515:24579813,24579516:24579561,24613934:24614243,24616412:24617150,24618676:24619060,24620683:24620956,24622678:24624370,24622680:24624701,24622694:24624150,24622708:24624336,24622714:24624219,24622716:24626609,24622718:24623757,24625789:24626155,24627861:24628154,24650041:24651337,24650043:2465150', 'assoc_mat': '24485056:metal:4230:24488854,24485059:metal:4230:24488448,24485063:metal:4230:24488590,24485066:metal:4230:24488203,24485070:metal:4230:24488370,24485073:metal:4230:24488130,24485077:metal:4230:24487868,24485093:metal:4230:24490841,24485095:metal:4230:24487179,24485097:metal:4230:24486951,24485099:metal:4230:24486494,24485101:metal:4230:24486613,24485103:metal:4230:24486217,24485105:metal:4230:24486125,24485107:metal:4230:24486304,24485109:metal:4230:24485951,24485111:metal:4230:24485625,24485114:metal:4230:24485792,24490318:metal:4230:24490448,24527805:metal:4230:24530132,24527807:metal:4230:24530745,24527809:metal:4230:24530238,24527811:metal:4230:24530464,24527813:metal:4230:24529870,24527815:metal:4230:24530622,24527816:metal:4230:24529811,24527817:metal:4230:24530270,24527818:metal:4230:24529628,24527841:metal:4230:24529672,24527850:metal:4230:24529274,24527851:metal:4230:24530294,24532153:metal:4230:24532913,24535609:metal:4230:24536135,24579506:metal:4230:24579849,24579507:metal:4230:24579924,24579508:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16332368438695918, 'nb_photo': 355343, 'list_port_cont': '24485628,24485807,24485948,24486144,24486226,24486294,24486489,24486619,24486899,24486959,24487178,24487448,24487567,24487863,24487964,24488123,24488205,24488374,24488447,24488594,24488851,24490452,24490842,24529288,24529639,24529669,24529810,24529882,24530143,24530233,24530288,24530295,24530478,24530626,24530738,24532928,24536146,24579559,24579586,24579634,24579671,24579707,24579734,24579780,24579812,24579846,24579880,24579918,24614242,24617148,24619072,24620961,24623653,24623760,24623975,24624156,24624209,24624246,24624328,24624372,24624700,24626168,24626611,24628156,24650183,24650235,24650288,24650316,24650396,24650477,24650518,24650552,24650594,24650633,24650681,24650717,24650765,24650844,24650877,24650919,24651002,24651048,24651094,24651214,24651344,24651499,24652764,24652943,24657029,24657052,24657109,24657170,24657243,24657545,24657681,24657711,24657744,24657786,24657803,24657894,24658044,24658156,24658208,24658263,24658399,24658442,24658473,24658588,24658855,24659124,24659332,24659517,24696788,2469731', 'assoc_port': '24485056:24488851,24485059:24488447,24485063:24488594,24485066:24488205,24485070:24488374,24485073:24488123,24485077:24487863,24485080:24487964,24485084:24487448,24485087:24487567,24485091:24486899,24485093:24490842,24485095:24487178,24485097:24486959,24485099:24486489,24485101:24486619,24485103:24486226,24485105:24486144,24485107:24486294,24485109:24485948,24485111:24485628,24485114:24485807,24490318:24490452,24527805:24530143,24527807:24530738,24527809:24530233,24527811:24530478,24527813:24529882,24527815:24530626,24527816:24529810,24527817:24530295,24527818:24529639,24527841:24529669,24527850:24529288,24527851:24530288,24532153:24532928,24535609:24536146,24579506:24579846,24579507:24579918,24579508:24579780,24579509:24579880,24579510:24579671,24579511:24579734,24579512:24579586,24579513:24579634,24579514:24579707,24579515:24579812,24579516:24579559,24613934:24614242,24616412:24617148,24618676:24619072,24620683:24620961,24622678:24624372,24622680:24624700,24622694:24624156,24622708:24624328,24622710:2462397', 'assoc_mat': '24485056:papier:4230:24488851,24485059:papier:4230:24488447,24485063:papier:4230:24488594,24485066:papier:4230:24488205,24485070:papier:4230:24488374,24485073:papier:4230:24488123,24485077:papier:4230:24487863,24485080:papier:4230:24487964,24485084:papier:4230:24487448,24485087:papier:4230:24487567,24485091:papier:4230:24486899,24485093:papier:4230:24490842,24485095:papier:4230:24487178,24485097:papier:4230:24486959,24485099:papier:4230:24486489,24485101:papier:4230:24486619,24485103:papier:4230:24486226,24485105:papier:4230:24486144,24485107:papier:4230:24486294,24485109:papier:4230:24485948,24485111:papier:4230:24485628,24485114:papier:4230:24485807,24490318:papier:4230:24490452,24527805:papier:4230:24530143,24527807:papier:4230:24530738,24527809:papier:4230:24530233,24527811:papier:4230:24530478,24527813:papier:4230:24529882,24527815:papier:4230:24530626,24527816:papier:4230:24529810,24527817:papier:4230:24530295,24527818:papier:4230:24529639,24527841:papier:4230:24529669,24527850:papier:4230:24529288,2452'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0038254685251989623, 'nb_photo': 1443, 'list_port_cont': '24485619,24485806,24485946,24486131,24486222,24486305,24486491,24486618,24486904,24486956,24487171,24487449,24487568,24487864,24487966,24488129,24488376,24490449,24490840,24529290,24529633,24529673,24529809,24529880,24530139,24530232,24530298,24530299,24530466,24530618,24530737,24532930,24536136,24579552,24579595,24579619,24579665,24579704,24579740,24579775,24579807,24579851,24579877,24579916,24614237,24623969,24624154,24624216,24624333,24624702,24626176,24626603,24650192,24650244,24650281,24650323,24650388,24650517,24650557,24650624,24650676,24650709,24650762,24650916,24650990,24651212,24651336,24651511,24652762,24657012,24657059,24657114,24657165,24657238,24657554,24657671,24657709,24657745,24657782,24657807,24658046,24658155,24658200,24658858,24659121,24697833,24698366,24698614,24698702,24698741,24698933,24699195,24699403,24699633,24699736,24702391,24704220,24737486,24737516,24737555,24737592,24737773,24737807,24737881,24737928,24738034,24738090,24738117,24738521,24738595,24738669,24738793,24738882,2473907', 'assoc_port': '24485070:24488376,24485073:24488129,24485077:24487864,24485080:24487966,24485084:24487449,24485087:24487568,24485091:24486904,24485093:24490840,24485095:24487171,24485097:24486956,24485099:24486491,24485101:24486618,24485103:24486222,24485105:24486131,24485107:24486305,24485109:24485946,24485111:24485619,24485114:24485806,24490318:24490449,24527805:24530139,24527807:24530737,24527809:24530232,24527811:24530466,24527813:24529880,24527815:24530618,24527816:24529809,24527817:24530299,24527818:24529633,24527841:24529673,24527850:24529290,24527851:24530298,24532153:24532930,24535609:24536136,24579506:24579851,24579507:24579916,24579508:24579775,24579509:24579877,24579510:24579665,24579511:24579740,24579512:24579595,24579513:24579619,24579514:24579704,24579515:24579807,24579516:24579552,24613934:24614237,24622680:24624702,24622694:24624154,24622708:24624333,24622710:24623969,24622714:24624216,24622716:24626603,24625789:24626176,24650041:24651336,24650043:24651511,24650054:24650916,24650058:24650990,24650061:2465070', 'assoc_mat': '24485070:pehd:4230:24488376,24485073:pehd:4230:24488129,24485077:pehd:4230:24487864,24485080:pehd:4230:24487966,24485084:pehd:4230:24487449,24485087:pehd:4230:24487568,24485091:pehd:4230:24486904,24485093:pehd:4230:24490840,24485095:pehd:4230:24487171,24485097:pehd:4230:24486956,24485099:pehd:4230:24486491,24485101:pehd:4230:24486618,24485103:pehd:4230:24486222,24485105:pehd:4230:24486131,24485107:pehd:4230:24486305,24485109:pehd:4230:24485946,24485111:pehd:4230:24485619,24485114:pehd:4230:24485806,24490318:pehd:4230:24490449,24527805:pehd:4230:24530139,24527807:pehd:4230:24530737,24527809:pehd:4230:24530232,24527811:pehd:4230:24530466,24527813:pehd:4230:24529880,24527815:pehd:4230:24530618,24527816:pehd:4230:24529809,24527817:pehd:4230:24530299,24527818:pehd:4230:24529633,24527841:pehd:4230:24529673,24527850:pehd:4230:24529290,24527851:pehd:4230:24530298,24532153:pehd:4230:24532930,24535609:pehd:4230:24536136,24579506:pehd:4230:24579851,24579507:pehd:4230:24579916,24579508:pehd:4230:24579775,24579509:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014094189222324405, 'nb_photo': 29211, 'list_port_cont': '24485620,24485796,24485947,24486141,24486221,24486301,24486493,24486614,24486900,24486950,24487177,24487461,24487571,24487869,24487967,24488134,24488207,24488364,24488442,24488612,24488858,24490453,24490843,24529279,24529632,24529677,24529800,24529891,24530133,24530237,24530304,24530305,24530477,24530624,24530746,24532923,24536145,24579555,24579598,24579620,24579666,24579706,24579733,24579770,24579808,24579845,24579873,24579919,24614238,24617140,24619070,24620959,24623663,24623755,24623972,24624159,24624215,24624258,24624340,24624373,24624706,24626172,24626601,24628165,24650189,24650246,24650279,24650320,24650390,24650466,24650516,24650556,24650589,24650628,24650679,24650714,24650755,24650833,24650875,24650917,24650989,24651045,24651090,24651211,24651339,24651513,24652769,24652952,24657026,24657051,24657104,24657167,24657239,24657549,24657673,24657712,24657753,24657780,24657804,24657897,24658038,24658154,24658210,24658252,24658407,24658444,24658481,24658576,24658854,24659131,24659336,24659511,24696789,2469730', 'assoc_port': '24485056:24488858,24485059:24488442,24485063:24488612,24485066:24488207,24485070:24488364,24485073:24488134,24485077:24487869,24485080:24487967,24485084:24487461,24485087:24487571,24485091:24486900,24485093:24490843,24485095:24487177,24485097:24486950,24485099:24486493,24485101:24486614,24485103:24486221,24485105:24486141,24485107:24486301,24485109:24485947,24485111:24485620,24485114:24485796,24490318:24490453,24527805:24530133,24527807:24530746,24527809:24530237,24527811:24530477,24527813:24529891,24527815:24530624,24527816:24529800,24527817:24530305,24527818:24529632,24527841:24529677,24527850:24529279,24527851:24530304,24532153:24532923,24535609:24536145,24579506:24579845,24579507:24579919,24579508:24579770,24579509:24579873,24579510:24579666,24579511:24579733,24579512:24579598,24579513:24579620,24579514:24579706,24579515:24579808,24579516:24579555,24613934:24614238,24616412:24617140,24618676:24619070,24620683:24620959,24622678:24624373,24622680:24624706,24622694:24624159,24622708:24624340,24622710:2462397', 'assoc_mat': '24485056:pet_clair:4230:24488858,24485059:pet_clair:4230:24488442,24485063:pet_clair:4230:24488612,24485066:pet_clair:4230:24488207,24485070:pet_clair:4230:24488364,24485073:pet_clair:4230:24488134,24485077:pet_clair:4230:24487869,24485080:pet_clair:4230:24487967,24485084:pet_clair:4230:24487461,24485087:pet_clair:4230:24487571,24485091:pet_clair:4230:24486900,24485093:pet_clair:4230:24490843,24485095:pet_clair:4230:24487177,24485097:pet_clair:4230:24486950,24485099:pet_clair:4230:24486493,24485101:pet_clair:4230:24486614,24485103:pet_clair:4230:24486221,24485105:pet_clair:4230:24486141,24485107:pet_clair:4230:24486301,24485109:pet_clair:4230:24485947,24485111:pet_clair:4230:24485620,24485114:pet_clair:4230:24485796,24490318:pet_clair:4230:24490453,24527805:pet_clair:4230:24530133,24527807:pet_clair:4230:24530746,24527809:pet_clair:4230:24530237,24527811:pet_clair:4230:24530477,24527813:pet_clair:4230:24529891,24527815:pet_clair:4230:24530624,24527816:pet_clair:4230:24529800,24527817:pet_clair:4230:24530305,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021948311179941834, 'nb_photo': 841, 'list_port_cont': '24485624,24485952,24486299,24486488,24486902,24486957,24487168,24487452,24487566,24487857,24487954,24488137,24488199,24488371,24488445,24490832,24529671,24530309,24530621,24532927,24579556,24579630,24579741,24579810,24579882,24579920,24614241,24619063,24624250,24624337,24624377,24650195,24650248,24650287,24650315,24650394,24650509,24650554,24650630,24650837,24650880,24650991,24651512,24652763,24657115,24657171,24657244,24657540,24657892,24658147,24658205,24658406,24658433,24658479,24658856,24659132,24697307,24697590,24697826,24697999,24698358,24698445,24698616,24698710,24698928,24699397,24699686,24700108,24702388,24737487,24737520,24737561,24737764,24737856,24737884,24738023,24738038,24738082,24738125,24738515,24738596,24738665,24738790,24738885,24739040,24739077,24739116,24739313,24740417,24744439,24745005,24746165,24749855,24752749,24756064,24758590,24761248,24769218,24769401,24769677,24769916,24817804,24856434,24856467,24856525,24856567,24856634,24856670,24857029,24857464,24857502,24857917,24858269,2485831', 'assoc_port': '24485059:24488445,24485066:24488199,24485070:24488371,24485073:24488137,24485077:24487857,24485080:24487954,24485084:24487452,24485087:24487566,24485091:24486902,24485093:24490832,24485095:24487168,24485097:24486957,24485099:24486488,24485107:24486299,24485109:24485952,24485111:24485624,24527815:24530621,24527841:24529671,24527851:24530309,24532153:24532927,24579507:24579920,24579509:24579882,24579511:24579741,24579513:24579630,24579515:24579810,24579516:24579556,24613934:24614241,24618676:24619063,24622678:24624377,24622708:24624337,24622712:24624250,24650043:24651512,24650045:24650880,24650058:24650991,24650076:24650837,24650079:24650554,24650089:24650248,24650091:24650315,24650094:24650287,24650095:24650630,24650096:24650195,24650097:24650509,24650098:24650394,24652706:24652763,24656768:24658856,24656772:24659132,24656775:24658406,24656779:24658479,24656786:24658205,24656793:24658433,24656796:24657892,24656802:24658147,24656814:24657540,24656816:24657115,24656822:24657171,24656824:24657244,24695377:2469968', 'assoc_mat': '24485059:pet_fonce:4230:24488445,24485066:pet_fonce:4230:24488199,24485070:pet_fonce:4230:24488371,24485073:pet_fonce:4230:24488137,24485077:pet_fonce:4230:24487857,24485080:pet_fonce:4230:24487954,24485084:pet_fonce:4230:24487452,24485087:pet_fonce:4230:24487566,24485091:pet_fonce:4230:24486902,24485093:pet_fonce:4230:24490832,24485095:pet_fonce:4230:24487168,24485097:pet_fonce:4230:24486957,24485099:pet_fonce:4230:24486488,24485107:pet_fonce:4230:24486299,24485109:pet_fonce:4230:24485952,24485111:pet_fonce:4230:24485624,24527815:pet_fonce:4230:24530621,24527841:pet_fonce:4230:24529671,24527851:pet_fonce:4230:24530309,24532153:pet_fonce:4230:24532927,24579507:pet_fonce:4230:24579920,24579509:pet_fonce:4230:24579882,24579511:pet_fonce:4230:24579741,24579513:pet_fonce:4230:24579630,24579515:pet_fonce:4230:24579810,24579516:pet_fonce:4230:24579556,24613934:pet_fonce:4230:24614241,24618676:pet_fonce:4230:24619063,24622678:pet_fonce:4230:24624377,24622708:pet_fonce:4230:24624337,24622712:pet_fonce:4230:24624250,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(1950669,1955076,1958637,1961691,1964067,1964414,1967787,1970359,1972642,1975903,1979422,1981920,1982250,1985694,1989630,1991367,1994339,1997042,1999281,1999627,2003007,2006384,2010053,2013843,2017699,2020301,2020937,2027413,2034537,2041277,2049325)); 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=203 and date >='2025-07-01' and date <= '2025-07-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2155,),), 'unwanted_material_monthly_percentage': ((0.7715736588761196,),), 'material_repartition': (('incineration', 2155),), 'material_dict': {'incineration': 2155}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 7, 1), 0.7912228232343024, 83), (datetime.date(2025, 7, 2), 0.6896873851075702, 41), (datetime.date(2025, 7, 3), 0.6818392215245094, 34), (datetime.date(2025, 7, 4), 0.7786588774270982, 45), (datetime.date(2025, 7, 5), 0.8016838830602628, 83), (datetime.date(2025, 7, 6), 0.8110703139311308, 84), (datetime.date(2025, 7, 7), 0.7831379733461118, 74), (datetime.date(2025, 7, 8), 0.753629090300987, 82), (datetime.date(2025, 7, 9), 0.8009400838265346, 65), (datetime.date(2025, 7, 10), 0.6652047896383109, 48), (datetime.date(2025, 7, 11), 0.7137237854724252, 70), (datetime.date(2025, 7, 12), 0.7349288383143121, 82), (datetime.date(2025, 7, 13), 0.7778483834720371, 72), (datetime.date(2025, 7, 14), 0.8481735102347672, 77), (datetime.date(2025, 7, 15), 0.7774730322439117, 54), (datetime.date(2025, 7, 16), 0.7830483330549004, 39), (datetime.date(2025, 7, 17), 0.7833070125250177, 87), (datetime.date(2025, 7, 18), 0.7891701751933212, 55), (datetime.date(2025, 7, 19), 0.7596449149788799, 77), (datetime.date(2025, 7, 20), 0.8048066073130057, 76), (datetime.date(2025, 7, 21), 0.7770081326407581, 81), (datetime.date(2025, 7, 22), 0.7077421180163587, 75), (datetime.date(2025, 7, 23), 0.7564003080651085, 71), (datetime.date(2025, 7, 24), 0.7523245077553709, 79), (datetime.date(2025, 7, 25), 0.7218784012119719, 82), (datetime.date(2025, 7, 26), 0.7146116424070499, 67), (datetime.date(2025, 7, 27), 0.7630213967372275, 75), (datetime.date(2025, 7, 28), 0.8295767130404801, 69), (datetime.date(2025, 7, 29), 0.8321284594954335, 81), (datetime.date(2025, 7, 30), 0.8332592562695748, 70), (datetime.date(2025, 7, 31), 0.7817682733038958, 77)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 7, 1), 0.7912228232343024, 83), (datetime.date(2025, 7, 2), 0.6896873851075702, 41), (datetime.date(2025, 7, 3), 0.6818392215245094, 34), (datetime.date(2025, 7, 4), 0.7786588774270982, 45), (datetime.date(2025, 7, 5), 0.8016838830602628, 83), (datetime.date(2025, 7, 6), 0.8110703139311308, 84), (datetime.date(2025, 7, 7), 0.7831379733461118, 74), (datetime.date(2025, 7, 8), 0.753629090300987, 82), (datetime.date(2025, 7, 9), 0.8009400838265346, 65), (datetime.date(2025, 7, 10), 0.6652047896383109, 48), (datetime.date(2025, 7, 11), 0.7137237854724252, 70), (datetime.date(2025, 7, 12), 0.7349288383143121, 82), (datetime.date(2025, 7, 13), 0.7778483834720371, 72), (datetime.date(2025, 7, 14), 0.8481735102347672, 77), (datetime.date(2025, 7, 15), 0.7774730322439117, 54), (datetime.date(2025, 7, 16), 0.7830483330549004, 39), (datetime.date(2025, 7, 17), 0.7833070125250177, 87), (datetime.date(2025, 7, 18), 0.7891701751933212, 55), (datetime.date(2025, 7, 19), 0.7596449149788799, 77), (datetime.date(2025, 7, 20), 0.8048066073130057, 76), (datetime.date(2025, 7, 21), 0.7770081326407581, 81), (datetime.date(2025, 7, 22), 0.7077421180163587, 75), (datetime.date(2025, 7, 23), 0.7564003080651085, 71), (datetime.date(2025, 7, 24), 0.7523245077553709, 79), (datetime.date(2025, 7, 25), 0.7218784012119719, 82), (datetime.date(2025, 7, 26), 0.7146116424070499, 67), (datetime.date(2025, 7, 27), 0.7630213967372275, 75), (datetime.date(2025, 7, 28), 0.8295767130404801, 69), (datetime.date(2025, 7, 29), 0.8321284594954335, 81), (datetime.date(2025, 7, 30), 0.8332592562695748, 70), (datetime.date(2025, 7, 31), 0.7817682733038958, 77))}, 'quality_array': [['-8.291343821638542', '01072025'], ['-8.361873280075779', '02072025'], ['-8.281884914652679', '03072025'], ['-8.079178171788051', '04072025'], ['-8.116309951511877', '05072025'], ['-8.22581151040472', '06072025'], ['-7.943572053107086', '07072025'], ['-7.851680968107506', '08072025'], ['-7.9676464214014215', '09072025'], ['-8.144262714790463', '10072025'], ['-8.35047249550421', '11072025'], ['-8.361261448163772', '12072025'], ['-8.403046407801106', '13072025'], ['-7.952826591656781', '14072025'], ['-6.840935958233493', '15072025'], ['-7.447732642854183', '16072025'], ['-7.7884731187655065', '17072025'], ['-8.213453246636048', '18072025'], ['-7.994855437249302', '19072025'], ['-8.146236429431905', '20072025'], ['-7.531606856415653', '21072025'], ['-7.800332990831904', '22072025'], ['-8.06572508755478', '23072025'], ['-7.938016293750944', '24072025'], ['-8.098304412892041', '25072025'], ['-7.99923805019047', '26072025'], ['-8.127996310777126', '27072025'], ['-8.171166219004515', '28072025'], ['-8.071706011711255', '29072025'], ['-8.028443509808966', '30072025'], ['-7.852861609893568', '31072025']], 'number_of_batch': ((667,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013502926306493633, 'nb_photo': 17671, 'list_port_cont': '24485626,24485808,24485935,24486123,24486213,24486302,24486484,24486621,24486901,24486961,24487173,24487447,24487564,24487853,24487951,24488124,24488189,24488367,24488441,24488608,24488856,24490438,24490839,24529282,24529637,24529670,24529796,24529887,24530130,24530231,24530296,24530303,24530480,24530617,24530744,24532915,24536147,24579560,24579596,24579628,24579657,24579702,24579739,24579765,24579815,24579839,24579884,24579921,24614250,24617149,24619056,24620958,24623659,24623754,24623976,24624146,24624218,24624252,24624342,24624379,24624691,24626166,24626608,24628152,24650182,24650245,24650284,24650322,24650382,24650470,24650505,24650545,24650587,24650629,24650673,24650721,24650748,24650845,24650871,24650911,24650985,24651041,24651077,24651199,24651343,24651504,24652757,24652951,24657014,24657062,24657119,24657159,24657232,24657553,24657676,24657705,24657750,24657774,24657809,24657901,24658036,24658141,24658201,24658257,24658402,24658435,24658468,24658589,24658853,24659125,24659335,24659510,24696781,2469729', 'assoc_port': '24485056:24488856,24485059:24488441,24485063:24488608,24485066:24488189,24485070:24488367,24485073:24488124,24485077:24487853,24485080:24487951,24485084:24487447,24485087:24487564,24485091:24486901,24485093:24490839,24485095:24487173,24485097:24486961,24485099:24486484,24485101:24486621,24485103:24486213,24485105:24486123,24485107:24486302,24485109:24485935,24485111:24485626,24485114:24485808,24490318:24490438,24527805:24530130,24527807:24530744,24527809:24530231,24527811:24530480,24527813:24529887,24527815:24530617,24527816:24529796,24527817:24530303,24527818:24529637,24527841:24529670,24527850:24529282,24527851:24530296,24532153:24532915,24535609:24536147,24579506:24579839,24579507:24579921,24579508:24579765,24579509:24579884,24579510:24579657,24579511:24579739,24579512:24579596,24579513:24579628,24579514:24579702,24579515:24579815,24579516:24579560,24613934:24614250,24616412:24617149,24618676:24619056,24620683:24620958,24622678:24624379,24622680:24624691,24622694:24624146,24622708:24624342,24622710:2462397', 'assoc_mat': '24485056:autre:4230:24488856,24485059:autre:4230:24488441,24485063:autre:4230:24488608,24485066:autre:4230:24488189,24485070:autre:4230:24488367,24485073:autre:4230:24488124,24485077:autre:4230:24487853,24485080:autre:4230:24487951,24485084:autre:4230:24487447,24485087:autre:4230:24487564,24485091:autre:4230:24486901,24485093:autre:4230:24490839,24485095:autre:4230:24487173,24485097:autre:4230:24486961,24485099:autre:4230:24486484,24485101:autre:4230:24486621,24485103:autre:4230:24486213,24485105:autre:4230:24486123,24485107:autre:4230:24486302,24485109:autre:4230:24485935,24485111:autre:4230:24485626,24485114:autre:4230:24485808,24490318:autre:4230:24490438,24527805:autre:4230:24530130,24527807:autre:4230:24530744,24527809:autre:4230:24530231,24527811:autre:4230:24530480,24527813:autre:4230:24529887,24527815:autre:4230:24530617,24527816:autre:4230:24529796,24527817:autre:4230:24530303,24527818:autre:4230:24529637,24527841:autre:4230:24529670,24527850:autre:4230:24529282,24527851:autre:4230:24530296,24532153:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.042146350027552584, 'nb_photo': 84188, 'list_port_cont': '24485617,24485809,24485943,24486143,24486219,24486297,24486497,24486612,24486894,24486963,24487170,24487453,24487558,24487867,24487963,24488136,24488206,24488375,24488443,24488588,24488857,24490450,24490836,24529287,24529629,24529676,24529802,24529893,24530134,24530239,24530283,24530308,24530469,24530627,24530741,24532929,24536144,24579554,24579597,24579631,24579669,24579697,24579736,24579777,24579803,24579850,24579888,24579913,24614249,24617153,24619059,24620957,24623660,24623759,24623970,24624158,24624212,24624248,24624341,24624378,24624697,24626171,24626612,24628167,24650191,24650243,24650280,24650324,24650395,24650480,24650513,24650555,24650588,24650637,24650683,24650711,24650757,24650838,24650878,24650910,24650997,24651043,24651088,24651205,24651338,24651508,24652759,24652949,24657028,24657058,24657111,24657173,24657245,24657551,24657678,24657716,24657751,24657783,24657802,24657902,24658047,24658151,24658206,24658250,24658401,24658439,24658471,24658581,24658852,24659130,24659339,24659508,24696791,2469730', 'assoc_port': '24485056:24488857,24485059:24488443,24485063:24488588,24485066:24488206,24485070:24488375,24485073:24488136,24485077:24487867,24485080:24487963,24485084:24487453,24485087:24487558,24485091:24486894,24485093:24490836,24485095:24487170,24485097:24486963,24485099:24486497,24485101:24486612,24485103:24486219,24485105:24486143,24485107:24486297,24485109:24485943,24485111:24485617,24485114:24485809,24490318:24490450,24527805:24530134,24527807:24530741,24527809:24530239,24527811:24530469,24527813:24529893,24527815:24530627,24527816:24529802,24527817:24530283,24527818:24529629,24527841:24529676,24527850:24529287,24527851:24530308,24532153:24532929,24535609:24536144,24579506:24579850,24579507:24579913,24579508:24579777,24579509:24579888,24579510:24579669,24579511:24579736,24579512:24579597,24579513:24579631,24579514:24579697,24579515:24579803,24579516:24579554,24613934:24614249,24616412:24617153,24618676:24619059,24620683:24620957,24622678:24624378,24622680:24624697,24622694:24624158,24622708:24624341,24622710:2462397', 'assoc_mat': '24485056:carton:4230:24488857,24485059:carton:4230:24488443,24485063:carton:4230:24488588,24485066:carton:4230:24488206,24485070:carton:4230:24488375,24485073:carton:4230:24488136,24485077:carton:4230:24487867,24485080:carton:4230:24487963,24485084:carton:4230:24487453,24485087:carton:4230:24487558,24485091:carton:4230:24486894,24485093:carton:4230:24490836,24485095:carton:4230:24487170,24485097:carton:4230:24486963,24485099:carton:4230:24486497,24485101:carton:4230:24486612,24485103:carton:4230:24486219,24485105:carton:4230:24486143,24485107:carton:4230:24486297,24485109:carton:4230:24485943,24485111:carton:4230:24485617,24485114:carton:4230:24485809,24490318:carton:4230:24490450,24527805:carton:4230:24530134,24527807:carton:4230:24530741,24527809:carton:4230:24530239,24527811:carton:4230:24530469,24527813:carton:4230:24529893,24527815:carton:4230:24530627,24527816:carton:4230:24529802,24527817:carton:4230:24530283,24527818:carton:4230:24529629,24527841:carton:4230:24529676,24527850:carton:4230:24529287,2452'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0009380997866097974, 'nb_photo': 1648, 'list_port_cont': '24485625,24485792,24485951,24486125,24486217,24486304,24486494,24486613,24486951,24487179,24487868,24488130,24488203,24488370,24488448,24488590,24488854,24490448,24490841,24529274,24529628,24529672,24529811,24529870,24530132,24530238,24530270,24530294,24530464,24530622,24530745,24532913,24536135,24579561,24579582,24579664,24579705,24579763,24579813,24579849,24579878,24579924,24614243,24617150,24619060,24620956,24623757,24624150,24624219,24624336,24624370,24624701,24626155,24626609,24628154,24650194,24650272,24650381,24650553,24650595,24650634,24650669,24650713,24650751,24650832,24650867,24650909,24651001,24651035,24651089,24651215,24651337,24651507,24652767,24652942,24657020,24657063,24657117,24657168,24657246,24657550,24657675,24657715,24657752,24657789,24657815,24657885,24658030,24658139,24658193,24658256,24658409,24658430,24658480,24658578,24658859,24659127,24659324,24659516,24696793,24697449,24697594,24697829,24697998,24698355,24698435,24698597,24698713,24698748,24699046,24699183,24699391,24699680,2469973', 'assoc_port': '24485056:24488854,24485059:24488448,24485063:24488590,24485066:24488203,24485070:24488370,24485073:24488130,24485077:24487868,24485093:24490841,24485095:24487179,24485097:24486951,24485099:24486494,24485101:24486613,24485103:24486217,24485105:24486125,24485107:24486304,24485109:24485951,24485111:24485625,24485114:24485792,24490318:24490448,24527805:24530132,24527807:24530745,24527809:24530238,24527811:24530464,24527813:24529870,24527815:24530622,24527816:24529811,24527817:24530270,24527818:24529628,24527841:24529672,24527850:24529274,24527851:24530294,24532153:24532913,24535609:24536135,24579506:24579849,24579507:24579924,24579508:24579763,24579509:24579878,24579510:24579664,24579512:24579582,24579514:24579705,24579515:24579813,24579516:24579561,24613934:24614243,24616412:24617150,24618676:24619060,24620683:24620956,24622678:24624370,24622680:24624701,24622694:24624150,24622708:24624336,24622714:24624219,24622716:24626609,24622718:24623757,24625789:24626155,24627861:24628154,24650041:24651337,24650043:2465150', 'assoc_mat': '24485056:metal:4230:24488854,24485059:metal:4230:24488448,24485063:metal:4230:24488590,24485066:metal:4230:24488203,24485070:metal:4230:24488370,24485073:metal:4230:24488130,24485077:metal:4230:24487868,24485093:metal:4230:24490841,24485095:metal:4230:24487179,24485097:metal:4230:24486951,24485099:metal:4230:24486494,24485101:metal:4230:24486613,24485103:metal:4230:24486217,24485105:metal:4230:24486125,24485107:metal:4230:24486304,24485109:metal:4230:24485951,24485111:metal:4230:24485625,24485114:metal:4230:24485792,24490318:metal:4230:24490448,24527805:metal:4230:24530132,24527807:metal:4230:24530745,24527809:metal:4230:24530238,24527811:metal:4230:24530464,24527813:metal:4230:24529870,24527815:metal:4230:24530622,24527816:metal:4230:24529811,24527817:metal:4230:24530270,24527818:metal:4230:24529628,24527841:metal:4230:24529672,24527850:metal:4230:24529274,24527851:metal:4230:24530294,24532153:metal:4230:24532913,24535609:metal:4230:24536135,24579506:metal:4230:24579849,24579507:metal:4230:24579924,24579508:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16332368438695918, 'nb_photo': 355343, 'list_port_cont': '24485628,24485807,24485948,24486144,24486226,24486294,24486489,24486619,24486899,24486959,24487178,24487448,24487567,24487863,24487964,24488123,24488205,24488374,24488447,24488594,24488851,24490452,24490842,24529288,24529639,24529669,24529810,24529882,24530143,24530233,24530288,24530295,24530478,24530626,24530738,24532928,24536146,24579559,24579586,24579634,24579671,24579707,24579734,24579780,24579812,24579846,24579880,24579918,24614242,24617148,24619072,24620961,24623653,24623760,24623975,24624156,24624209,24624246,24624328,24624372,24624700,24626168,24626611,24628156,24650183,24650235,24650288,24650316,24650396,24650477,24650518,24650552,24650594,24650633,24650681,24650717,24650765,24650844,24650877,24650919,24651002,24651048,24651094,24651214,24651344,24651499,24652764,24652943,24657029,24657052,24657109,24657170,24657243,24657545,24657681,24657711,24657744,24657786,24657803,24657894,24658044,24658156,24658208,24658263,24658399,24658442,24658473,24658588,24658855,24659124,24659332,24659517,24696788,2469731', 'assoc_port': '24485056:24488851,24485059:24488447,24485063:24488594,24485066:24488205,24485070:24488374,24485073:24488123,24485077:24487863,24485080:24487964,24485084:24487448,24485087:24487567,24485091:24486899,24485093:24490842,24485095:24487178,24485097:24486959,24485099:24486489,24485101:24486619,24485103:24486226,24485105:24486144,24485107:24486294,24485109:24485948,24485111:24485628,24485114:24485807,24490318:24490452,24527805:24530143,24527807:24530738,24527809:24530233,24527811:24530478,24527813:24529882,24527815:24530626,24527816:24529810,24527817:24530295,24527818:24529639,24527841:24529669,24527850:24529288,24527851:24530288,24532153:24532928,24535609:24536146,24579506:24579846,24579507:24579918,24579508:24579780,24579509:24579880,24579510:24579671,24579511:24579734,24579512:24579586,24579513:24579634,24579514:24579707,24579515:24579812,24579516:24579559,24613934:24614242,24616412:24617148,24618676:24619072,24620683:24620961,24622678:24624372,24622680:24624700,24622694:24624156,24622708:24624328,24622710:2462397', 'assoc_mat': '24485056:papier:4230:24488851,24485059:papier:4230:24488447,24485063:papier:4230:24488594,24485066:papier:4230:24488205,24485070:papier:4230:24488374,24485073:papier:4230:24488123,24485077:papier:4230:24487863,24485080:papier:4230:24487964,24485084:papier:4230:24487448,24485087:papier:4230:24487567,24485091:papier:4230:24486899,24485093:papier:4230:24490842,24485095:papier:4230:24487178,24485097:papier:4230:24486959,24485099:papier:4230:24486489,24485101:papier:4230:24486619,24485103:papier:4230:24486226,24485105:papier:4230:24486144,24485107:papier:4230:24486294,24485109:papier:4230:24485948,24485111:papier:4230:24485628,24485114:papier:4230:24485807,24490318:papier:4230:24490452,24527805:papier:4230:24530143,24527807:papier:4230:24530738,24527809:papier:4230:24530233,24527811:papier:4230:24530478,24527813:papier:4230:24529882,24527815:papier:4230:24530626,24527816:papier:4230:24529810,24527817:papier:4230:24530295,24527818:papier:4230:24529639,24527841:papier:4230:24529669,24527850:papier:4230:24529288,2452'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0038254685251989623, 'nb_photo': 1443, 'list_port_cont': '24485619,24485806,24485946,24486131,24486222,24486305,24486491,24486618,24486904,24486956,24487171,24487449,24487568,24487864,24487966,24488129,24488376,24490449,24490840,24529290,24529633,24529673,24529809,24529880,24530139,24530232,24530298,24530299,24530466,24530618,24530737,24532930,24536136,24579552,24579595,24579619,24579665,24579704,24579740,24579775,24579807,24579851,24579877,24579916,24614237,24623969,24624154,24624216,24624333,24624702,24626176,24626603,24650192,24650244,24650281,24650323,24650388,24650517,24650557,24650624,24650676,24650709,24650762,24650916,24650990,24651212,24651336,24651511,24652762,24657012,24657059,24657114,24657165,24657238,24657554,24657671,24657709,24657745,24657782,24657807,24658046,24658155,24658200,24658858,24659121,24697833,24698366,24698614,24698702,24698741,24698933,24699195,24699403,24699633,24699736,24702391,24704220,24737486,24737516,24737555,24737592,24737773,24737807,24737881,24737928,24738034,24738090,24738117,24738521,24738595,24738669,24738793,24738882,2473907', 'assoc_port': '24485070:24488376,24485073:24488129,24485077:24487864,24485080:24487966,24485084:24487449,24485087:24487568,24485091:24486904,24485093:24490840,24485095:24487171,24485097:24486956,24485099:24486491,24485101:24486618,24485103:24486222,24485105:24486131,24485107:24486305,24485109:24485946,24485111:24485619,24485114:24485806,24490318:24490449,24527805:24530139,24527807:24530737,24527809:24530232,24527811:24530466,24527813:24529880,24527815:24530618,24527816:24529809,24527817:24530299,24527818:24529633,24527841:24529673,24527850:24529290,24527851:24530298,24532153:24532930,24535609:24536136,24579506:24579851,24579507:24579916,24579508:24579775,24579509:24579877,24579510:24579665,24579511:24579740,24579512:24579595,24579513:24579619,24579514:24579704,24579515:24579807,24579516:24579552,24613934:24614237,24622680:24624702,24622694:24624154,24622708:24624333,24622710:24623969,24622714:24624216,24622716:24626603,24625789:24626176,24650041:24651336,24650043:24651511,24650054:24650916,24650058:24650990,24650061:2465070', 'assoc_mat': '24485070:pehd:4230:24488376,24485073:pehd:4230:24488129,24485077:pehd:4230:24487864,24485080:pehd:4230:24487966,24485084:pehd:4230:24487449,24485087:pehd:4230:24487568,24485091:pehd:4230:24486904,24485093:pehd:4230:24490840,24485095:pehd:4230:24487171,24485097:pehd:4230:24486956,24485099:pehd:4230:24486491,24485101:pehd:4230:24486618,24485103:pehd:4230:24486222,24485105:pehd:4230:24486131,24485107:pehd:4230:24486305,24485109:pehd:4230:24485946,24485111:pehd:4230:24485619,24485114:pehd:4230:24485806,24490318:pehd:4230:24490449,24527805:pehd:4230:24530139,24527807:pehd:4230:24530737,24527809:pehd:4230:24530232,24527811:pehd:4230:24530466,24527813:pehd:4230:24529880,24527815:pehd:4230:24530618,24527816:pehd:4230:24529809,24527817:pehd:4230:24530299,24527818:pehd:4230:24529633,24527841:pehd:4230:24529673,24527850:pehd:4230:24529290,24527851:pehd:4230:24530298,24532153:pehd:4230:24532930,24535609:pehd:4230:24536136,24579506:pehd:4230:24579851,24579507:pehd:4230:24579916,24579508:pehd:4230:24579775,24579509:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014094189222324405, 'nb_photo': 29211, 'list_port_cont': '24485620,24485796,24485947,24486141,24486221,24486301,24486493,24486614,24486900,24486950,24487177,24487461,24487571,24487869,24487967,24488134,24488207,24488364,24488442,24488612,24488858,24490453,24490843,24529279,24529632,24529677,24529800,24529891,24530133,24530237,24530304,24530305,24530477,24530624,24530746,24532923,24536145,24579555,24579598,24579620,24579666,24579706,24579733,24579770,24579808,24579845,24579873,24579919,24614238,24617140,24619070,24620959,24623663,24623755,24623972,24624159,24624215,24624258,24624340,24624373,24624706,24626172,24626601,24628165,24650189,24650246,24650279,24650320,24650390,24650466,24650516,24650556,24650589,24650628,24650679,24650714,24650755,24650833,24650875,24650917,24650989,24651045,24651090,24651211,24651339,24651513,24652769,24652952,24657026,24657051,24657104,24657167,24657239,24657549,24657673,24657712,24657753,24657780,24657804,24657897,24658038,24658154,24658210,24658252,24658407,24658444,24658481,24658576,24658854,24659131,24659336,24659511,24696789,2469730', 'assoc_port': '24485056:24488858,24485059:24488442,24485063:24488612,24485066:24488207,24485070:24488364,24485073:24488134,24485077:24487869,24485080:24487967,24485084:24487461,24485087:24487571,24485091:24486900,24485093:24490843,24485095:24487177,24485097:24486950,24485099:24486493,24485101:24486614,24485103:24486221,24485105:24486141,24485107:24486301,24485109:24485947,24485111:24485620,24485114:24485796,24490318:24490453,24527805:24530133,24527807:24530746,24527809:24530237,24527811:24530477,24527813:24529891,24527815:24530624,24527816:24529800,24527817:24530305,24527818:24529632,24527841:24529677,24527850:24529279,24527851:24530304,24532153:24532923,24535609:24536145,24579506:24579845,24579507:24579919,24579508:24579770,24579509:24579873,24579510:24579666,24579511:24579733,24579512:24579598,24579513:24579620,24579514:24579706,24579515:24579808,24579516:24579555,24613934:24614238,24616412:24617140,24618676:24619070,24620683:24620959,24622678:24624373,24622680:24624706,24622694:24624159,24622708:24624340,24622710:2462397', 'assoc_mat': '24485056:pet_clair:4230:24488858,24485059:pet_clair:4230:24488442,24485063:pet_clair:4230:24488612,24485066:pet_clair:4230:24488207,24485070:pet_clair:4230:24488364,24485073:pet_clair:4230:24488134,24485077:pet_clair:4230:24487869,24485080:pet_clair:4230:24487967,24485084:pet_clair:4230:24487461,24485087:pet_clair:4230:24487571,24485091:pet_clair:4230:24486900,24485093:pet_clair:4230:24490843,24485095:pet_clair:4230:24487177,24485097:pet_clair:4230:24486950,24485099:pet_clair:4230:24486493,24485101:pet_clair:4230:24486614,24485103:pet_clair:4230:24486221,24485105:pet_clair:4230:24486141,24485107:pet_clair:4230:24486301,24485109:pet_clair:4230:24485947,24485111:pet_clair:4230:24485620,24485114:pet_clair:4230:24485796,24490318:pet_clair:4230:24490453,24527805:pet_clair:4230:24530133,24527807:pet_clair:4230:24530746,24527809:pet_clair:4230:24530237,24527811:pet_clair:4230:24530477,24527813:pet_clair:4230:24529891,24527815:pet_clair:4230:24530624,24527816:pet_clair:4230:24529800,24527817:pet_clair:4230:24530305,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021948311179941834, 'nb_photo': 841, 'list_port_cont': '24485624,24485952,24486299,24486488,24486902,24486957,24487168,24487452,24487566,24487857,24487954,24488137,24488199,24488371,24488445,24490832,24529671,24530309,24530621,24532927,24579556,24579630,24579741,24579810,24579882,24579920,24614241,24619063,24624250,24624337,24624377,24650195,24650248,24650287,24650315,24650394,24650509,24650554,24650630,24650837,24650880,24650991,24651512,24652763,24657115,24657171,24657244,24657540,24657892,24658147,24658205,24658406,24658433,24658479,24658856,24659132,24697307,24697590,24697826,24697999,24698358,24698445,24698616,24698710,24698928,24699397,24699686,24700108,24702388,24737487,24737520,24737561,24737764,24737856,24737884,24738023,24738038,24738082,24738125,24738515,24738596,24738665,24738790,24738885,24739040,24739077,24739116,24739313,24740417,24744439,24745005,24746165,24749855,24752749,24756064,24758590,24761248,24769218,24769401,24769677,24769916,24817804,24856434,24856467,24856525,24856567,24856634,24856670,24857029,24857464,24857502,24857917,24858269,2485831', 'assoc_port': '24485059:24488445,24485066:24488199,24485070:24488371,24485073:24488137,24485077:24487857,24485080:24487954,24485084:24487452,24485087:24487566,24485091:24486902,24485093:24490832,24485095:24487168,24485097:24486957,24485099:24486488,24485107:24486299,24485109:24485952,24485111:24485624,24527815:24530621,24527841:24529671,24527851:24530309,24532153:24532927,24579507:24579920,24579509:24579882,24579511:24579741,24579513:24579630,24579515:24579810,24579516:24579556,24613934:24614241,24618676:24619063,24622678:24624377,24622708:24624337,24622712:24624250,24650043:24651512,24650045:24650880,24650058:24650991,24650076:24650837,24650079:24650554,24650089:24650248,24650091:24650315,24650094:24650287,24650095:24650630,24650096:24650195,24650097:24650509,24650098:24650394,24652706:24652763,24656768:24658856,24656772:24659132,24656775:24658406,24656779:24658479,24656786:24658205,24656793:24658433,24656796:24657892,24656802:24658147,24656814:24657540,24656816:24657115,24656822:24657171,24656824:24657244,24695377:2469968', 'assoc_mat': '24485059:pet_fonce:4230:24488445,24485066:pet_fonce:4230:24488199,24485070:pet_fonce:4230:24488371,24485073:pet_fonce:4230:24488137,24485077:pet_fonce:4230:24487857,24485080:pet_fonce:4230:24487954,24485084:pet_fonce:4230:24487452,24485087:pet_fonce:4230:24487566,24485091:pet_fonce:4230:24486902,24485093:pet_fonce:4230:24490832,24485095:pet_fonce:4230:24487168,24485097:pet_fonce:4230:24486957,24485099:pet_fonce:4230:24486488,24485107:pet_fonce:4230:24486299,24485109:pet_fonce:4230:24485952,24485111:pet_fonce:4230:24485624,24527815:pet_fonce:4230:24530621,24527841:pet_fonce:4230:24529671,24527851:pet_fonce:4230:24530309,24532153:pet_fonce:4230:24532927,24579507:pet_fonce:4230:24579920,24579509:pet_fonce:4230:24579882,24579511:pet_fonce:4230:24579741,24579513:pet_fonce:4230:24579630,24579515:pet_fonce:4230:24579810,24579516:pet_fonce:4230:24579556,24613934:pet_fonce:4230:24614241,24618676:pet_fonce:4230:24619063,24622678:pet_fonce:4230:24624377,24622708:pet_fonce:4230:24624337,24622712:pet_fonce:4230:24624250,2'}), 'main_stat': {'nb_photos': 2155}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-07', 0.7715736588761196),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # 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': ((2155,),), 'unwanted_material_monthly_percentage': ((0.7715736588761196,),), 'material_repartition': (('incineration', 2155),), 'material_dict': {'incineration': 2155}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 7, 1), 0.7912228232343024, 83), (datetime.date(2025, 7, 2), 0.6896873851075702, 41), (datetime.date(2025, 7, 3), 0.6818392215245094, 34), (datetime.date(2025, 7, 4), 0.7786588774270982, 45), (datetime.date(2025, 7, 5), 0.8016838830602628, 83), (datetime.date(2025, 7, 6), 0.8110703139311308, 84), (datetime.date(2025, 7, 7), 0.7831379733461118, 74), (datetime.date(2025, 7, 8), 0.753629090300987, 82), (datetime.date(2025, 7, 9), 0.8009400838265346, 65), (datetime.date(2025, 7, 10), 0.6652047896383109, 48), (datetime.date(2025, 7, 11), 0.7137237854724252, 70), (datetime.date(2025, 7, 12), 0.7349288383143121, 82), (datetime.date(2025, 7, 13), 0.7778483834720371, 72), (datetime.date(2025, 7, 14), 0.8481735102347672, 77), (datetime.date(2025, 7, 15), 0.7774730322439117, 54), (datetime.date(2025, 7, 16), 0.7830483330549004, 39), (datetime.date(2025, 7, 17), 0.7833070125250177, 87), (datetime.date(2025, 7, 18), 0.7891701751933212, 55), (datetime.date(2025, 7, 19), 0.7596449149788799, 77), (datetime.date(2025, 7, 20), 0.8048066073130057, 76), (datetime.date(2025, 7, 21), 0.7770081326407581, 81), (datetime.date(2025, 7, 22), 0.7077421180163587, 75), (datetime.date(2025, 7, 23), 0.7564003080651085, 71), (datetime.date(2025, 7, 24), 0.7523245077553709, 79), (datetime.date(2025, 7, 25), 0.7218784012119719, 82), (datetime.date(2025, 7, 26), 0.7146116424070499, 67), (datetime.date(2025, 7, 27), 0.7630213967372275, 75), (datetime.date(2025, 7, 28), 0.8295767130404801, 69), (datetime.date(2025, 7, 29), 0.8321284594954335, 81), (datetime.date(2025, 7, 30), 0.8332592562695748, 70), (datetime.date(2025, 7, 31), 0.7817682733038958, 77)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 7, 1), 0.7912228232343024, 83), (datetime.date(2025, 7, 2), 0.6896873851075702, 41), (datetime.date(2025, 7, 3), 0.6818392215245094, 34), (datetime.date(2025, 7, 4), 0.7786588774270982, 45), (datetime.date(2025, 7, 5), 0.8016838830602628, 83), (datetime.date(2025, 7, 6), 0.8110703139311308, 84), (datetime.date(2025, 7, 7), 0.7831379733461118, 74), (datetime.date(2025, 7, 8), 0.753629090300987, 82), (datetime.date(2025, 7, 9), 0.8009400838265346, 65), (datetime.date(2025, 7, 10), 0.6652047896383109, 48), (datetime.date(2025, 7, 11), 0.7137237854724252, 70), (datetime.date(2025, 7, 12), 0.7349288383143121, 82), (datetime.date(2025, 7, 13), 0.7778483834720371, 72), (datetime.date(2025, 7, 14), 0.8481735102347672, 77), (datetime.date(2025, 7, 15), 0.7774730322439117, 54), (datetime.date(2025, 7, 16), 0.7830483330549004, 39), (datetime.date(2025, 7, 17), 0.7833070125250177, 87), (datetime.date(2025, 7, 18), 0.7891701751933212, 55), (datetime.date(2025, 7, 19), 0.7596449149788799, 77), (datetime.date(2025, 7, 20), 0.8048066073130057, 76), (datetime.date(2025, 7, 21), 0.7770081326407581, 81), (datetime.date(2025, 7, 22), 0.7077421180163587, 75), (datetime.date(2025, 7, 23), 0.7564003080651085, 71), (datetime.date(2025, 7, 24), 0.7523245077553709, 79), (datetime.date(2025, 7, 25), 0.7218784012119719, 82), (datetime.date(2025, 7, 26), 0.7146116424070499, 67), (datetime.date(2025, 7, 27), 0.7630213967372275, 75), (datetime.date(2025, 7, 28), 0.8295767130404801, 69), (datetime.date(2025, 7, 29), 0.8321284594954335, 81), (datetime.date(2025, 7, 30), 0.8332592562695748, 70), (datetime.date(2025, 7, 31), 0.7817682733038958, 77))}, 'quality_array': [['-8.291343821638542', '01072025'], ['-8.361873280075779', '02072025'], ['-8.281884914652679', '03072025'], ['-8.079178171788051', '04072025'], ['-8.116309951511877', '05072025'], ['-8.22581151040472', '06072025'], ['-7.943572053107086', '07072025'], ['-7.851680968107506', '08072025'], ['-7.9676464214014215', '09072025'], ['-8.144262714790463', '10072025'], ['-8.35047249550421', '11072025'], ['-8.361261448163772', '12072025'], ['-8.403046407801106', '13072025'], ['-7.952826591656781', '14072025'], ['-6.840935958233493', '15072025'], ['-7.447732642854183', '16072025'], ['-7.7884731187655065', '17072025'], ['-8.213453246636048', '18072025'], ['-7.994855437249302', '19072025'], ['-8.146236429431905', '20072025'], ['-7.531606856415653', '21072025'], ['-7.800332990831904', '22072025'], ['-8.06572508755478', '23072025'], ['-7.938016293750944', '24072025'], ['-8.098304412892041', '25072025'], ['-7.99923805019047', '26072025'], ['-8.127996310777126', '27072025'], ['-8.171166219004515', '28072025'], ['-8.071706011711255', '29072025'], ['-8.028443509808966', '30072025'], ['-7.852861609893568', '31072025']], 'number_of_batch': ((667,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013502926306493633, 'nb_photo': 17671, 'list_port_cont': '24485626,24485808,24485935,24486123,24486213,24486302,24486484,24486621,24486901,24486961,24487173,24487447,24487564,24487853,24487951,24488124,24488189,24488367,24488441,24488608,24488856,24490438,24490839,24529282,24529637,24529670,24529796,24529887,24530130,24530231,24530296,24530303,24530480,24530617,24530744,24532915,24536147,24579560,24579596,24579628,24579657,24579702,24579739,24579765,24579815,24579839,24579884,24579921,24614250,24617149,24619056,24620958,24623659,24623754,24623976,24624146,24624218,24624252,24624342,24624379,24624691,24626166,24626608,24628152,24650182,24650245,24650284,24650322,24650382,24650470,24650505,24650545,24650587,24650629,24650673,24650721,24650748,24650845,24650871,24650911,24650985,24651041,24651077,24651199,24651343,24651504,24652757,24652951,24657014,24657062,24657119,24657159,24657232,24657553,24657676,24657705,24657750,24657774,24657809,24657901,24658036,24658141,24658201,24658257,24658402,24658435,24658468,24658589,24658853,24659125,24659335,24659510,24696781,2469729', 'assoc_port': '24485056:24488856,24485059:24488441,24485063:24488608,24485066:24488189,24485070:24488367,24485073:24488124,24485077:24487853,24485080:24487951,24485084:24487447,24485087:24487564,24485091:24486901,24485093:24490839,24485095:24487173,24485097:24486961,24485099:24486484,24485101:24486621,24485103:24486213,24485105:24486123,24485107:24486302,24485109:24485935,24485111:24485626,24485114:24485808,24490318:24490438,24527805:24530130,24527807:24530744,24527809:24530231,24527811:24530480,24527813:24529887,24527815:24530617,24527816:24529796,24527817:24530303,24527818:24529637,24527841:24529670,24527850:24529282,24527851:24530296,24532153:24532915,24535609:24536147,24579506:24579839,24579507:24579921,24579508:24579765,24579509:24579884,24579510:24579657,24579511:24579739,24579512:24579596,24579513:24579628,24579514:24579702,24579515:24579815,24579516:24579560,24613934:24614250,24616412:24617149,24618676:24619056,24620683:24620958,24622678:24624379,24622680:24624691,24622694:24624146,24622708:24624342,24622710:2462397', 'assoc_mat': '24485056:autre:4230:24488856,24485059:autre:4230:24488441,24485063:autre:4230:24488608,24485066:autre:4230:24488189,24485070:autre:4230:24488367,24485073:autre:4230:24488124,24485077:autre:4230:24487853,24485080:autre:4230:24487951,24485084:autre:4230:24487447,24485087:autre:4230:24487564,24485091:autre:4230:24486901,24485093:autre:4230:24490839,24485095:autre:4230:24487173,24485097:autre:4230:24486961,24485099:autre:4230:24486484,24485101:autre:4230:24486621,24485103:autre:4230:24486213,24485105:autre:4230:24486123,24485107:autre:4230:24486302,24485109:autre:4230:24485935,24485111:autre:4230:24485626,24485114:autre:4230:24485808,24490318:autre:4230:24490438,24527805:autre:4230:24530130,24527807:autre:4230:24530744,24527809:autre:4230:24530231,24527811:autre:4230:24530480,24527813:autre:4230:24529887,24527815:autre:4230:24530617,24527816:autre:4230:24529796,24527817:autre:4230:24530303,24527818:autre:4230:24529637,24527841:autre:4230:24529670,24527850:autre:4230:24529282,24527851:autre:4230:24530296,24532153:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.042146350027552584, 'nb_photo': 84188, 'list_port_cont': '24485617,24485809,24485943,24486143,24486219,24486297,24486497,24486612,24486894,24486963,24487170,24487453,24487558,24487867,24487963,24488136,24488206,24488375,24488443,24488588,24488857,24490450,24490836,24529287,24529629,24529676,24529802,24529893,24530134,24530239,24530283,24530308,24530469,24530627,24530741,24532929,24536144,24579554,24579597,24579631,24579669,24579697,24579736,24579777,24579803,24579850,24579888,24579913,24614249,24617153,24619059,24620957,24623660,24623759,24623970,24624158,24624212,24624248,24624341,24624378,24624697,24626171,24626612,24628167,24650191,24650243,24650280,24650324,24650395,24650480,24650513,24650555,24650588,24650637,24650683,24650711,24650757,24650838,24650878,24650910,24650997,24651043,24651088,24651205,24651338,24651508,24652759,24652949,24657028,24657058,24657111,24657173,24657245,24657551,24657678,24657716,24657751,24657783,24657802,24657902,24658047,24658151,24658206,24658250,24658401,24658439,24658471,24658581,24658852,24659130,24659339,24659508,24696791,2469730', 'assoc_port': '24485056:24488857,24485059:24488443,24485063:24488588,24485066:24488206,24485070:24488375,24485073:24488136,24485077:24487867,24485080:24487963,24485084:24487453,24485087:24487558,24485091:24486894,24485093:24490836,24485095:24487170,24485097:24486963,24485099:24486497,24485101:24486612,24485103:24486219,24485105:24486143,24485107:24486297,24485109:24485943,24485111:24485617,24485114:24485809,24490318:24490450,24527805:24530134,24527807:24530741,24527809:24530239,24527811:24530469,24527813:24529893,24527815:24530627,24527816:24529802,24527817:24530283,24527818:24529629,24527841:24529676,24527850:24529287,24527851:24530308,24532153:24532929,24535609:24536144,24579506:24579850,24579507:24579913,24579508:24579777,24579509:24579888,24579510:24579669,24579511:24579736,24579512:24579597,24579513:24579631,24579514:24579697,24579515:24579803,24579516:24579554,24613934:24614249,24616412:24617153,24618676:24619059,24620683:24620957,24622678:24624378,24622680:24624697,24622694:24624158,24622708:24624341,24622710:2462397', 'assoc_mat': '24485056:carton:4230:24488857,24485059:carton:4230:24488443,24485063:carton:4230:24488588,24485066:carton:4230:24488206,24485070:carton:4230:24488375,24485073:carton:4230:24488136,24485077:carton:4230:24487867,24485080:carton:4230:24487963,24485084:carton:4230:24487453,24485087:carton:4230:24487558,24485091:carton:4230:24486894,24485093:carton:4230:24490836,24485095:carton:4230:24487170,24485097:carton:4230:24486963,24485099:carton:4230:24486497,24485101:carton:4230:24486612,24485103:carton:4230:24486219,24485105:carton:4230:24486143,24485107:carton:4230:24486297,24485109:carton:4230:24485943,24485111:carton:4230:24485617,24485114:carton:4230:24485809,24490318:carton:4230:24490450,24527805:carton:4230:24530134,24527807:carton:4230:24530741,24527809:carton:4230:24530239,24527811:carton:4230:24530469,24527813:carton:4230:24529893,24527815:carton:4230:24530627,24527816:carton:4230:24529802,24527817:carton:4230:24530283,24527818:carton:4230:24529629,24527841:carton:4230:24529676,24527850:carton:4230:24529287,2452'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0009380997866097974, 'nb_photo': 1648, 'list_port_cont': '24485625,24485792,24485951,24486125,24486217,24486304,24486494,24486613,24486951,24487179,24487868,24488130,24488203,24488370,24488448,24488590,24488854,24490448,24490841,24529274,24529628,24529672,24529811,24529870,24530132,24530238,24530270,24530294,24530464,24530622,24530745,24532913,24536135,24579561,24579582,24579664,24579705,24579763,24579813,24579849,24579878,24579924,24614243,24617150,24619060,24620956,24623757,24624150,24624219,24624336,24624370,24624701,24626155,24626609,24628154,24650194,24650272,24650381,24650553,24650595,24650634,24650669,24650713,24650751,24650832,24650867,24650909,24651001,24651035,24651089,24651215,24651337,24651507,24652767,24652942,24657020,24657063,24657117,24657168,24657246,24657550,24657675,24657715,24657752,24657789,24657815,24657885,24658030,24658139,24658193,24658256,24658409,24658430,24658480,24658578,24658859,24659127,24659324,24659516,24696793,24697449,24697594,24697829,24697998,24698355,24698435,24698597,24698713,24698748,24699046,24699183,24699391,24699680,2469973', 'assoc_port': '24485056:24488854,24485059:24488448,24485063:24488590,24485066:24488203,24485070:24488370,24485073:24488130,24485077:24487868,24485093:24490841,24485095:24487179,24485097:24486951,24485099:24486494,24485101:24486613,24485103:24486217,24485105:24486125,24485107:24486304,24485109:24485951,24485111:24485625,24485114:24485792,24490318:24490448,24527805:24530132,24527807:24530745,24527809:24530238,24527811:24530464,24527813:24529870,24527815:24530622,24527816:24529811,24527817:24530270,24527818:24529628,24527841:24529672,24527850:24529274,24527851:24530294,24532153:24532913,24535609:24536135,24579506:24579849,24579507:24579924,24579508:24579763,24579509:24579878,24579510:24579664,24579512:24579582,24579514:24579705,24579515:24579813,24579516:24579561,24613934:24614243,24616412:24617150,24618676:24619060,24620683:24620956,24622678:24624370,24622680:24624701,24622694:24624150,24622708:24624336,24622714:24624219,24622716:24626609,24622718:24623757,24625789:24626155,24627861:24628154,24650041:24651337,24650043:2465150', 'assoc_mat': '24485056:metal:4230:24488854,24485059:metal:4230:24488448,24485063:metal:4230:24488590,24485066:metal:4230:24488203,24485070:metal:4230:24488370,24485073:metal:4230:24488130,24485077:metal:4230:24487868,24485093:metal:4230:24490841,24485095:metal:4230:24487179,24485097:metal:4230:24486951,24485099:metal:4230:24486494,24485101:metal:4230:24486613,24485103:metal:4230:24486217,24485105:metal:4230:24486125,24485107:metal:4230:24486304,24485109:metal:4230:24485951,24485111:metal:4230:24485625,24485114:metal:4230:24485792,24490318:metal:4230:24490448,24527805:metal:4230:24530132,24527807:metal:4230:24530745,24527809:metal:4230:24530238,24527811:metal:4230:24530464,24527813:metal:4230:24529870,24527815:metal:4230:24530622,24527816:metal:4230:24529811,24527817:metal:4230:24530270,24527818:metal:4230:24529628,24527841:metal:4230:24529672,24527850:metal:4230:24529274,24527851:metal:4230:24530294,24532153:metal:4230:24532913,24535609:metal:4230:24536135,24579506:metal:4230:24579849,24579507:metal:4230:24579924,24579508:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16332368438695918, 'nb_photo': 355343, 'list_port_cont': '24485628,24485807,24485948,24486144,24486226,24486294,24486489,24486619,24486899,24486959,24487178,24487448,24487567,24487863,24487964,24488123,24488205,24488374,24488447,24488594,24488851,24490452,24490842,24529288,24529639,24529669,24529810,24529882,24530143,24530233,24530288,24530295,24530478,24530626,24530738,24532928,24536146,24579559,24579586,24579634,24579671,24579707,24579734,24579780,24579812,24579846,24579880,24579918,24614242,24617148,24619072,24620961,24623653,24623760,24623975,24624156,24624209,24624246,24624328,24624372,24624700,24626168,24626611,24628156,24650183,24650235,24650288,24650316,24650396,24650477,24650518,24650552,24650594,24650633,24650681,24650717,24650765,24650844,24650877,24650919,24651002,24651048,24651094,24651214,24651344,24651499,24652764,24652943,24657029,24657052,24657109,24657170,24657243,24657545,24657681,24657711,24657744,24657786,24657803,24657894,24658044,24658156,24658208,24658263,24658399,24658442,24658473,24658588,24658855,24659124,24659332,24659517,24696788,2469731', 'assoc_port': '24485056:24488851,24485059:24488447,24485063:24488594,24485066:24488205,24485070:24488374,24485073:24488123,24485077:24487863,24485080:24487964,24485084:24487448,24485087:24487567,24485091:24486899,24485093:24490842,24485095:24487178,24485097:24486959,24485099:24486489,24485101:24486619,24485103:24486226,24485105:24486144,24485107:24486294,24485109:24485948,24485111:24485628,24485114:24485807,24490318:24490452,24527805:24530143,24527807:24530738,24527809:24530233,24527811:24530478,24527813:24529882,24527815:24530626,24527816:24529810,24527817:24530295,24527818:24529639,24527841:24529669,24527850:24529288,24527851:24530288,24532153:24532928,24535609:24536146,24579506:24579846,24579507:24579918,24579508:24579780,24579509:24579880,24579510:24579671,24579511:24579734,24579512:24579586,24579513:24579634,24579514:24579707,24579515:24579812,24579516:24579559,24613934:24614242,24616412:24617148,24618676:24619072,24620683:24620961,24622678:24624372,24622680:24624700,24622694:24624156,24622708:24624328,24622710:2462397', 'assoc_mat': '24485056:papier:4230:24488851,24485059:papier:4230:24488447,24485063:papier:4230:24488594,24485066:papier:4230:24488205,24485070:papier:4230:24488374,24485073:papier:4230:24488123,24485077:papier:4230:24487863,24485080:papier:4230:24487964,24485084:papier:4230:24487448,24485087:papier:4230:24487567,24485091:papier:4230:24486899,24485093:papier:4230:24490842,24485095:papier:4230:24487178,24485097:papier:4230:24486959,24485099:papier:4230:24486489,24485101:papier:4230:24486619,24485103:papier:4230:24486226,24485105:papier:4230:24486144,24485107:papier:4230:24486294,24485109:papier:4230:24485948,24485111:papier:4230:24485628,24485114:papier:4230:24485807,24490318:papier:4230:24490452,24527805:papier:4230:24530143,24527807:papier:4230:24530738,24527809:papier:4230:24530233,24527811:papier:4230:24530478,24527813:papier:4230:24529882,24527815:papier:4230:24530626,24527816:papier:4230:24529810,24527817:papier:4230:24530295,24527818:papier:4230:24529639,24527841:papier:4230:24529669,24527850:papier:4230:24529288,2452'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0038254685251989623, 'nb_photo': 1443, 'list_port_cont': '24485619,24485806,24485946,24486131,24486222,24486305,24486491,24486618,24486904,24486956,24487171,24487449,24487568,24487864,24487966,24488129,24488376,24490449,24490840,24529290,24529633,24529673,24529809,24529880,24530139,24530232,24530298,24530299,24530466,24530618,24530737,24532930,24536136,24579552,24579595,24579619,24579665,24579704,24579740,24579775,24579807,24579851,24579877,24579916,24614237,24623969,24624154,24624216,24624333,24624702,24626176,24626603,24650192,24650244,24650281,24650323,24650388,24650517,24650557,24650624,24650676,24650709,24650762,24650916,24650990,24651212,24651336,24651511,24652762,24657012,24657059,24657114,24657165,24657238,24657554,24657671,24657709,24657745,24657782,24657807,24658046,24658155,24658200,24658858,24659121,24697833,24698366,24698614,24698702,24698741,24698933,24699195,24699403,24699633,24699736,24702391,24704220,24737486,24737516,24737555,24737592,24737773,24737807,24737881,24737928,24738034,24738090,24738117,24738521,24738595,24738669,24738793,24738882,2473907', 'assoc_port': '24485070:24488376,24485073:24488129,24485077:24487864,24485080:24487966,24485084:24487449,24485087:24487568,24485091:24486904,24485093:24490840,24485095:24487171,24485097:24486956,24485099:24486491,24485101:24486618,24485103:24486222,24485105:24486131,24485107:24486305,24485109:24485946,24485111:24485619,24485114:24485806,24490318:24490449,24527805:24530139,24527807:24530737,24527809:24530232,24527811:24530466,24527813:24529880,24527815:24530618,24527816:24529809,24527817:24530299,24527818:24529633,24527841:24529673,24527850:24529290,24527851:24530298,24532153:24532930,24535609:24536136,24579506:24579851,24579507:24579916,24579508:24579775,24579509:24579877,24579510:24579665,24579511:24579740,24579512:24579595,24579513:24579619,24579514:24579704,24579515:24579807,24579516:24579552,24613934:24614237,24622680:24624702,24622694:24624154,24622708:24624333,24622710:24623969,24622714:24624216,24622716:24626603,24625789:24626176,24650041:24651336,24650043:24651511,24650054:24650916,24650058:24650990,24650061:2465070', 'assoc_mat': '24485070:pehd:4230:24488376,24485073:pehd:4230:24488129,24485077:pehd:4230:24487864,24485080:pehd:4230:24487966,24485084:pehd:4230:24487449,24485087:pehd:4230:24487568,24485091:pehd:4230:24486904,24485093:pehd:4230:24490840,24485095:pehd:4230:24487171,24485097:pehd:4230:24486956,24485099:pehd:4230:24486491,24485101:pehd:4230:24486618,24485103:pehd:4230:24486222,24485105:pehd:4230:24486131,24485107:pehd:4230:24486305,24485109:pehd:4230:24485946,24485111:pehd:4230:24485619,24485114:pehd:4230:24485806,24490318:pehd:4230:24490449,24527805:pehd:4230:24530139,24527807:pehd:4230:24530737,24527809:pehd:4230:24530232,24527811:pehd:4230:24530466,24527813:pehd:4230:24529880,24527815:pehd:4230:24530618,24527816:pehd:4230:24529809,24527817:pehd:4230:24530299,24527818:pehd:4230:24529633,24527841:pehd:4230:24529673,24527850:pehd:4230:24529290,24527851:pehd:4230:24530298,24532153:pehd:4230:24532930,24535609:pehd:4230:24536136,24579506:pehd:4230:24579851,24579507:pehd:4230:24579916,24579508:pehd:4230:24579775,24579509:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014094189222324405, 'nb_photo': 29211, 'list_port_cont': '24485620,24485796,24485947,24486141,24486221,24486301,24486493,24486614,24486900,24486950,24487177,24487461,24487571,24487869,24487967,24488134,24488207,24488364,24488442,24488612,24488858,24490453,24490843,24529279,24529632,24529677,24529800,24529891,24530133,24530237,24530304,24530305,24530477,24530624,24530746,24532923,24536145,24579555,24579598,24579620,24579666,24579706,24579733,24579770,24579808,24579845,24579873,24579919,24614238,24617140,24619070,24620959,24623663,24623755,24623972,24624159,24624215,24624258,24624340,24624373,24624706,24626172,24626601,24628165,24650189,24650246,24650279,24650320,24650390,24650466,24650516,24650556,24650589,24650628,24650679,24650714,24650755,24650833,24650875,24650917,24650989,24651045,24651090,24651211,24651339,24651513,24652769,24652952,24657026,24657051,24657104,24657167,24657239,24657549,24657673,24657712,24657753,24657780,24657804,24657897,24658038,24658154,24658210,24658252,24658407,24658444,24658481,24658576,24658854,24659131,24659336,24659511,24696789,2469730', 'assoc_port': '24485056:24488858,24485059:24488442,24485063:24488612,24485066:24488207,24485070:24488364,24485073:24488134,24485077:24487869,24485080:24487967,24485084:24487461,24485087:24487571,24485091:24486900,24485093:24490843,24485095:24487177,24485097:24486950,24485099:24486493,24485101:24486614,24485103:24486221,24485105:24486141,24485107:24486301,24485109:24485947,24485111:24485620,24485114:24485796,24490318:24490453,24527805:24530133,24527807:24530746,24527809:24530237,24527811:24530477,24527813:24529891,24527815:24530624,24527816:24529800,24527817:24530305,24527818:24529632,24527841:24529677,24527850:24529279,24527851:24530304,24532153:24532923,24535609:24536145,24579506:24579845,24579507:24579919,24579508:24579770,24579509:24579873,24579510:24579666,24579511:24579733,24579512:24579598,24579513:24579620,24579514:24579706,24579515:24579808,24579516:24579555,24613934:24614238,24616412:24617140,24618676:24619070,24620683:24620959,24622678:24624373,24622680:24624706,24622694:24624159,24622708:24624340,24622710:2462397', 'assoc_mat': '24485056:pet_clair:4230:24488858,24485059:pet_clair:4230:24488442,24485063:pet_clair:4230:24488612,24485066:pet_clair:4230:24488207,24485070:pet_clair:4230:24488364,24485073:pet_clair:4230:24488134,24485077:pet_clair:4230:24487869,24485080:pet_clair:4230:24487967,24485084:pet_clair:4230:24487461,24485087:pet_clair:4230:24487571,24485091:pet_clair:4230:24486900,24485093:pet_clair:4230:24490843,24485095:pet_clair:4230:24487177,24485097:pet_clair:4230:24486950,24485099:pet_clair:4230:24486493,24485101:pet_clair:4230:24486614,24485103:pet_clair:4230:24486221,24485105:pet_clair:4230:24486141,24485107:pet_clair:4230:24486301,24485109:pet_clair:4230:24485947,24485111:pet_clair:4230:24485620,24485114:pet_clair:4230:24485796,24490318:pet_clair:4230:24490453,24527805:pet_clair:4230:24530133,24527807:pet_clair:4230:24530746,24527809:pet_clair:4230:24530237,24527811:pet_clair:4230:24530477,24527813:pet_clair:4230:24529891,24527815:pet_clair:4230:24530624,24527816:pet_clair:4230:24529800,24527817:pet_clair:4230:24530305,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021948311179941834, 'nb_photo': 841, 'list_port_cont': '24485624,24485952,24486299,24486488,24486902,24486957,24487168,24487452,24487566,24487857,24487954,24488137,24488199,24488371,24488445,24490832,24529671,24530309,24530621,24532927,24579556,24579630,24579741,24579810,24579882,24579920,24614241,24619063,24624250,24624337,24624377,24650195,24650248,24650287,24650315,24650394,24650509,24650554,24650630,24650837,24650880,24650991,24651512,24652763,24657115,24657171,24657244,24657540,24657892,24658147,24658205,24658406,24658433,24658479,24658856,24659132,24697307,24697590,24697826,24697999,24698358,24698445,24698616,24698710,24698928,24699397,24699686,24700108,24702388,24737487,24737520,24737561,24737764,24737856,24737884,24738023,24738038,24738082,24738125,24738515,24738596,24738665,24738790,24738885,24739040,24739077,24739116,24739313,24740417,24744439,24745005,24746165,24749855,24752749,24756064,24758590,24761248,24769218,24769401,24769677,24769916,24817804,24856434,24856467,24856525,24856567,24856634,24856670,24857029,24857464,24857502,24857917,24858269,2485831', 'assoc_port': '24485059:24488445,24485066:24488199,24485070:24488371,24485073:24488137,24485077:24487857,24485080:24487954,24485084:24487452,24485087:24487566,24485091:24486902,24485093:24490832,24485095:24487168,24485097:24486957,24485099:24486488,24485107:24486299,24485109:24485952,24485111:24485624,24527815:24530621,24527841:24529671,24527851:24530309,24532153:24532927,24579507:24579920,24579509:24579882,24579511:24579741,24579513:24579630,24579515:24579810,24579516:24579556,24613934:24614241,24618676:24619063,24622678:24624377,24622708:24624337,24622712:24624250,24650043:24651512,24650045:24650880,24650058:24650991,24650076:24650837,24650079:24650554,24650089:24650248,24650091:24650315,24650094:24650287,24650095:24650630,24650096:24650195,24650097:24650509,24650098:24650394,24652706:24652763,24656768:24658856,24656772:24659132,24656775:24658406,24656779:24658479,24656786:24658205,24656793:24658433,24656796:24657892,24656802:24658147,24656814:24657540,24656816:24657115,24656822:24657171,24656824:24657244,24695377:2469968', 'assoc_mat': '24485059:pet_fonce:4230:24488445,24485066:pet_fonce:4230:24488199,24485070:pet_fonce:4230:24488371,24485073:pet_fonce:4230:24488137,24485077:pet_fonce:4230:24487857,24485080:pet_fonce:4230:24487954,24485084:pet_fonce:4230:24487452,24485087:pet_fonce:4230:24487566,24485091:pet_fonce:4230:24486902,24485093:pet_fonce:4230:24490832,24485095:pet_fonce:4230:24487168,24485097:pet_fonce:4230:24486957,24485099:pet_fonce:4230:24486488,24485107:pet_fonce:4230:24486299,24485109:pet_fonce:4230:24485952,24485111:pet_fonce:4230:24485624,24527815:pet_fonce:4230:24530621,24527841:pet_fonce:4230:24529671,24527851:pet_fonce:4230:24530309,24532153:pet_fonce:4230:24532927,24579507:pet_fonce:4230:24579920,24579509:pet_fonce:4230:24579882,24579511:pet_fonce:4230:24579741,24579513:pet_fonce:4230:24579630,24579515:pet_fonce:4230:24579810,24579516:pet_fonce:4230:24579556,24613934:pet_fonce:4230:24614241,24618676:pet_fonce:4230:24619063,24622678:pet_fonce:4230:24624377,24622708:pet_fonce:4230:24624337,24622712:pet_fonce:4230:24624250,2'}), 'main_stat': {'nb_photos': 2155}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-07', 0.7715736588761196),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_07_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.35%', 17671], 'carton': ['carton', '4.21%', 84188], 'metal': ['metal', '0.09%', 1648], 'papier': ['papier', '16.33%', 355343], 'pehd': ['pehd', '0.38%', 1443], 'pet_clair': ['pet_clair', '1.41%', 29211], 'pet_fonce': ['pet_fonce', '0.22%', 841]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_07_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.25user 2.58system 0:07.56elapsed 63%CPU (0avgtext+0avgdata 176252maxresident)k 224inputs+280outputs (22major+44639minor)pagefaults 0swaps