python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-02 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (6, 28) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (6, 28) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 02 mtr_id : dashboard_places : SCCU_cam7 date : 2026-02 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam7' and date like '%2026-02%') and created_at like '%2026-02%'))); nb_day : (6, 28) 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), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 204 and month(ded.date) = 02 and year(ded.date) = 2026 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), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 204 and month(ded.date) = 02 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 204 and mp.name like '%022026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-02-01 : dt_date_just_month_year : 2026-02-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-02-01" AND ded.date <= "2026-02-28" 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 (2897175,2898371,2899415,2900189,2901462,2902238,2903172,2903639,2904627,2905405,2906431,2907539,2908591,2909393,2909952,2911149,2912405,2913611,2919454,2922893,2923657,2924349,2925278,2926592,2927212,2928101,2929337,2933504) 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.014084997871061933, 'nb_photo': 13664, 'list_port_cont': '30284370,30284406,30284950,30285021,30285044,30285089,30285232,30285269,30285376,30285445,30285487,30285555,30285668,30285708,30285771,30285849,30285876,30285959,30286025,30286543,30286662,30295985,30296063,30296096,30296120,30296174,30296221,30296247,30296298,30296321,30296363,30296406,30296440,30296473,30296501,30296551,30296576,30296649,30296694,30296721,30297622,30304568,30304610,30304645,30304698,30304718,30304767,30304779,30304831,30304862,30304900,30304945,30304983,30305016,30305044,30305088,30305119,30305166,30305193,30305225,30305435,30306216,30312292,30312401,30312437,30312442,30312497,30312542,30312581,30312610,30312653,30312675,30312749,30312766,30312837,30312859,30312883,30312929,30312973,30313005,30313052,30313087,30313817,30313950,30323718,30323804,30323925,30323972,30324171,30324251,30324280,30324358,30324425,30324498,30324544,30324684,30324804,30324965,30324995,30325040,30325296,30325360,30325395,30325435,30325589,30325696,30326081,30326107,30326192,30326390,30326659,30326706,30326794,3032694', 'assoc_port': '30284295:30286025,30284297:30285959,30284299:30285876,30284301:30285849,30284303:30285771,30284306:30285668,30284308:30285708,30284310:30285555,30284312:30284406,30284315:30285487,30284316:30285376,30284321:30285445,30284324:30285232,30284326:30285269,30284329:30285089,30284333:30285044,30284336:30284950,30284338:30285021,30284340:30284370,30286527:30286543,30286650:30286662,30295936:30296694,30295938:30296721,30295940:30296551,30295942:30296576,30295944:30296649,30295946:30296501,30295948:30296406,30295950:30296473,30295952:30296298,30295954:30296440,30295956:30296363,30295958:30296247,30295960:30296321,30295963:30295985,30295965:30296221,30295967:30296174,30295969:30296120,30295971:30296096,30295972:30296063,30297611:30297622,30304497:30304645,30304498:30304983,30304499:30305225,30304500:30305119,30304501:30305088,30304502:30305016,30304503:30305166,30304504:30304945,30304505:30304831,30304506:30305193,30304507:30304862,30304508:30304900,30304509:30305044,30304510:30304767,30304511:30304718,30304512:3030477', 'assoc_mat': '30284295:autre:4230:30286025,30284297:autre:4230:30285959,30284299:autre:4230:30285876,30284301:autre:4230:30285849,30284303:autre:4230:30285771,30284306:autre:4230:30285668,30284308:autre:4230:30285708,30284310:autre:4230:30285555,30284312:autre:4230:30284406,30284315:autre:4230:30285487,30284316:autre:4230:30285376,30284321:autre:4230:30285445,30284324:autre:4230:30285232,30284326:autre:4230:30285269,30284329:autre:4230:30285089,30284333:autre:4230:30285044,30284336:autre:4230:30284950,30284338:autre:4230:30285021,30284340:autre:4230:30284370,30286527:autre:4230:30286543,30286650:autre:4230:30286662,30295936:autre:4230:30296694,30295938:autre:4230:30296721,30295940:autre:4230:30296551,30295942:autre:4230:30296576,30295944:autre:4230:30296649,30295946:autre:4230:30296501,30295948:autre:4230:30296406,30295950:autre:4230:30296473,30295952:autre:4230:30296298,30295954:autre:4230:30296440,30295956:autre:4230:30296363,30295958:autre:4230:30296247,30295960:autre:4230:30296321,30295963:autre:4230:30295985,30295965:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0381686502298891, 'nb_photo': 64161, 'list_port_cont': '30284356,30284398,30284947,30285019,30285054,30285081,30285240,30285265,30285377,30285453,30285484,30285556,30285669,30285709,30285770,30285852,30285878,30285954,30286029,30286532,30286668,30295991,30296026,30296065,30296100,30296132,30296188,30296223,30296260,30296297,30296323,30296366,30296401,30296442,30296481,30296515,30296549,30296587,30296659,30296699,30296726,30297627,30304565,30304618,30304661,30304691,30304734,30304760,30304784,30304834,30304878,30304911,30304935,30304981,30305018,30305053,30305090,30305129,30305158,30305202,30305231,30305439,30306204,30312291,30312395,30312433,30312461,30312499,30312547,30312575,30312611,30312652,30312685,30312763,30312775,30312835,30312869,30312882,30312936,30312982,30313017,30313044,30313088,30313829,30313959,30323714,30323807,30323936,30323963,30324188,30324255,30324296,30324359,30324434,30324510,30324535,30324689,30324815,30324968,30325001,30325034,30325311,30325356,30325389,30325426,30325591,30325695,30326080,30326116,30326206,30326399,30326649,30326701,3032680', 'assoc_port': '30284295:30286029,30284297:30285954,30284299:30285878,30284301:30285852,30284303:30285770,30284306:30285669,30284308:30285709,30284310:30285556,30284312:30284398,30284315:30285484,30284316:30285377,30284321:30285453,30284324:30285240,30284326:30285265,30284329:30285081,30284333:30285054,30284336:30284947,30284338:30285019,30284340:30284356,30286527:30286532,30286650:30286668,30295936:30296699,30295938:30296726,30295940:30296549,30295942:30296587,30295944:30296659,30295946:30296515,30295948:30296401,30295950:30296481,30295952:30296297,30295954:30296442,30295956:30296366,30295958:30296260,30295960:30296323,30295963:30295991,30295965:30296223,30295967:30296188,30295969:30296132,30295971:30296100,30295972:30296065,30295973:30296026,30297611:30297627,30304497:30304661,30304498:30304981,30304499:30305231,30304500:30305129,30304501:30305090,30304502:30305018,30304503:30305158,30304504:30304935,30304505:30304834,30304506:30305202,30304507:30304878,30304508:30304911,30304509:30305053,30304510:30304760,30304511:3030473', 'assoc_mat': '30284295:carton:4230:30286029,30284297:carton:4230:30285954,30284299:carton:4230:30285878,30284301:carton:4230:30285852,30284303:carton:4230:30285770,30284306:carton:4230:30285669,30284308:carton:4230:30285709,30284310:carton:4230:30285556,30284312:carton:4230:30284398,30284315:carton:4230:30285484,30284316:carton:4230:30285377,30284321:carton:4230:30285453,30284324:carton:4230:30285240,30284326:carton:4230:30285265,30284329:carton:4230:30285081,30284333:carton:4230:30285054,30284336:carton:4230:30284947,30284338:carton:4230:30285019,30284340:carton:4230:30284356,30286527:carton:4230:30286532,30286650:carton:4230:30286668,30295936:carton:4230:30296699,30295938:carton:4230:30296726,30295940:carton:4230:30296549,30295942:carton:4230:30296587,30295944:carton:4230:30296659,30295946:carton:4230:30296515,30295948:carton:4230:30296401,30295950:carton:4230:30296481,30295952:carton:4230:30296297,30295954:carton:4230:30296442,30295956:carton:4230:30296366,30295958:carton:4230:30296260,30295960:carton:4230:30296323,3029'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00107574308866471, 'nb_photo': 1371, 'list_port_cont': '30284359,30284408,30284937,30285010,30285047,30285096,30285239,30285275,30285367,30285449,30285477,30285549,30285656,30285693,30285768,30285848,30285883,30285956,30286021,30286544,30286669,30295976,30296021,30296061,30296255,30296300,30296335,30296431,30296513,30296553,30296589,30296648,30296683,30296727,30297626,30304649,30304681,30304717,30304765,30304787,30304869,30304912,30304986,30305009,30305051,30305087,30305153,30305189,30305242,30305447,30306203,30312279,30312426,30312465,30312543,30312573,30312612,30312689,30312762,30312779,30312820,30312860,30312889,30312943,30313014,30313054,30313078,30313952,30323709,30323797,30323928,30323956,30324174,30324287,30324352,30324439,30324505,30324698,30324803,30324954,30324989,30325026,30325306,30325349,30325424,30325596,30325689,30326068,30326110,30326195,30326398,30326656,30326704,30326950,30327693,30328088,30328634,30328711,30329515,30329967,30330398,30330538,30330894,30331205,30332080,30332814,30333036,30333148,30333464,30334370,30334864,30335437,30336234,3033940', 'assoc_port': '30284295:30286021,30284297:30285956,30284299:30285883,30284301:30285848,30284303:30285768,30284306:30285656,30284308:30285693,30284310:30285549,30284312:30284408,30284315:30285477,30284316:30285367,30284321:30285449,30284324:30285239,30284326:30285275,30284329:30285096,30284333:30285047,30284336:30284937,30284338:30285010,30284340:30284359,30286527:30286544,30286650:30286669,30295936:30296683,30295938:30296727,30295940:30296553,30295942:30296589,30295944:30296648,30295946:30296513,30295952:30296300,30295954:30296431,30295958:30296255,30295960:30296335,30295963:30295976,30295972:30296061,30295973:30296021,30297611:30297626,30304497:30304649,30304498:30304986,30304499:30305242,30304501:30305087,30304502:30305009,30304503:30305153,30304506:30305189,30304507:30304869,30304508:30304912,30304509:30305051,30304510:30304765,30304511:30304717,30304512:30304787,30304515:30304681,30305365:30305447,30306198:30306203,30312240:30313078,30312243:30312889,30312246:30313014,30312248:30312860,30312250:30313054,30312254:3031276', 'assoc_mat': '30284295:metal:4230:30286021,30284297:metal:4230:30285956,30284299:metal:4230:30285883,30284301:metal:4230:30285848,30284303:metal:4230:30285768,30284306:metal:4230:30285656,30284308:metal:4230:30285693,30284310:metal:4230:30285549,30284312:metal:4230:30284408,30284315:metal:4230:30285477,30284316:metal:4230:30285367,30284321:metal:4230:30285449,30284324:metal:4230:30285239,30284326:metal:4230:30285275,30284329:metal:4230:30285096,30284333:metal:4230:30285047,30284336:metal:4230:30284937,30284338:metal:4230:30285010,30284340:metal:4230:30284359,30286527:metal:4230:30286544,30286650:metal:4230:30286669,30295936:metal:4230:30296683,30295938:metal:4230:30296727,30295940:metal:4230:30296553,30295942:metal:4230:30296589,30295944:metal:4230:30296648,30295946:metal:4230:30296513,30295952:metal:4230:30296300,30295954:metal:4230:30296431,30295958:metal:4230:30296255,30295960:metal:4230:30296335,30295963:metal:4230:30295976,30295972:metal:4230:30296061,30295973:metal:4230:30296021,30297611:metal:4230:30297626,30304497:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.17407144357554027, 'nb_photo': 213953, 'list_port_cont': '30284365,30284407,30284946,30285020,30285052,30285093,30285238,30285273,30285382,30285450,30285481,30285563,30285666,30285706,30285780,30285851,30285889,30285960,30286035,30286539,30286664,30295979,30296029,30296059,30296090,30296133,30296191,30296220,30296263,30296294,30296328,30296371,30296404,30296444,30296477,30296506,30296546,30296582,30296658,30296700,30296731,30297628,30304566,30304619,30304656,30304690,30304731,30304759,30304786,30304842,30304877,30304903,30304950,30304985,30305017,30305056,30305081,30305125,30305161,30305203,30305239,30305445,30306201,30312290,30312394,30312438,30312446,30312505,30312535,30312578,30312609,30312651,30312691,30312754,30312771,30312834,30312862,30312885,30312944,30312971,30313016,30313046,30313084,30313822,30313948,30323707,30323810,30323932,30323969,30324184,30324252,30324290,30324366,30324438,30324513,30324549,30324694,30324813,30324953,30324997,30325039,30325310,30325358,30325396,30325428,30325597,30325691,30326073,30326113,30326205,30326388,30326654,30326707,3032680', 'assoc_port': '30284295:30286035,30284297:30285960,30284299:30285889,30284301:30285851,30284303:30285780,30284306:30285666,30284308:30285706,30284310:30285563,30284312:30284407,30284315:30285481,30284316:30285382,30284321:30285450,30284324:30285238,30284326:30285273,30284329:30285093,30284333:30285052,30284336:30284946,30284338:30285020,30284340:30284365,30286527:30286539,30286650:30286664,30295936:30296700,30295938:30296731,30295940:30296546,30295942:30296582,30295944:30296658,30295946:30296506,30295948:30296404,30295950:30296477,30295952:30296294,30295954:30296444,30295956:30296371,30295958:30296263,30295960:30296328,30295963:30295979,30295965:30296220,30295967:30296191,30295969:30296133,30295971:30296090,30295972:30296059,30295973:30296029,30297611:30297628,30304497:30304656,30304498:30304985,30304499:30305239,30304500:30305125,30304501:30305081,30304502:30305017,30304503:30305161,30304504:30304950,30304505:30304842,30304506:30305203,30304507:30304877,30304508:30304903,30304509:30305056,30304510:30304759,30304511:3030473', 'assoc_mat': '30284295:papier:4230:30286035,30284297:papier:4230:30285960,30284299:papier:4230:30285889,30284301:papier:4230:30285851,30284303:papier:4230:30285780,30284306:papier:4230:30285666,30284308:papier:4230:30285706,30284310:papier:4230:30285563,30284312:papier:4230:30284407,30284315:papier:4230:30285481,30284316:papier:4230:30285382,30284321:papier:4230:30285450,30284324:papier:4230:30285238,30284326:papier:4230:30285273,30284329:papier:4230:30285093,30284333:papier:4230:30285052,30284336:papier:4230:30284946,30284338:papier:4230:30285020,30284340:papier:4230:30284365,30286527:papier:4230:30286539,30286650:papier:4230:30286664,30295936:papier:4230:30296700,30295938:papier:4230:30296731,30295940:papier:4230:30296546,30295942:papier:4230:30296582,30295944:papier:4230:30296658,30295946:papier:4230:30296506,30295948:papier:4230:30296404,30295950:papier:4230:30296477,30295952:papier:4230:30296294,30295954:papier:4230:30296444,30295956:papier:4230:30296371,30295958:papier:4230:30296263,30295960:papier:4230:30296328,3029'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028005455879661282, 'nb_photo': 1020, 'list_port_cont': '30284404,30285095,30285551,30296224,30296333,30296362,30296433,30296516,30296578,30296732,30304689,30304728,30304762,30304776,30304870,30304910,30305054,30305085,30305167,30305196,30305229,30312429,30312455,30312502,30312541,30312582,30312614,30312692,30312760,30312777,30312833,30312978,30313090,30313824,30323799,30323935,30323967,30324185,30324257,30324288,30324365,30324433,30324512,30324547,30324695,30324809,30324955,30325002,30325033,30325364,30325400,30325438,30325598,30325693,30326075,30326389,30326657,30326700,30326807,30326947,30327704,30328094,30328643,30328719,30329517,30329976,30330404,30330892,30330994,30331203,30333150,30334368,30334645,30335427,30336243,30337496,30338268,30339538,30339586,30341084,30344400,30344651,30345196,30345344,30345380,30346069,30352234,30352382,30352561,30352667,30352923,30352994,30353623,30358459,30358498,30360142,30360210,30360289,30360327,30360362,30360434,30360810,30360842,30360914,30360951,30361682,30368057,30368167,30368492,30368563,30368600,30369088,30369139,3036927', 'assoc_port': '30284310:30285551,30284312:30284404,30284329:30285095,30295938:30296732,30295942:30296578,30295946:30296516,30295954:30296433,30295956:30296362,30295960:30296333,30295965:30296224,30304499:30305229,30304501:30305085,30304503:30305167,30304506:30305196,30304507:30304870,30304508:30304910,30304509:30305054,30304510:30304762,30304511:30304728,30304512:30304776,30304515:30304689,30312240:30313090,30312254:30312760,30312258:30312978,30312260:30312582,30312262:30312777,30312264:30312614,30312265:30312692,30312266:30312502,30312267:30312833,30312268:30312455,30312269:30312541,30312270:30312429,30313807:30313824,30323292:30324433,30323295:30324955,30323301:30325598,30323304:30325364,30323307:30325400,30323310:30325438,30323313:30325033,30323316:30325002,30323319:30324809,30323322:30324695,30323325:30324547,30323328:30324512,30323331:30324365,30323334:30324257,30323337:30323967,30323338:30324288,30323343:30324185,30323347:30323935,30323351:30323799,30325680:30325693,30326005:30326075,30326365:30326389,30326593:3032665', 'assoc_mat': '30284310:pehd:4230:30285551,30284312:pehd:4230:30284404,30284329:pehd:4230:30285095,30295938:pehd:4230:30296732,30295942:pehd:4230:30296578,30295946:pehd:4230:30296516,30295954:pehd:4230:30296433,30295956:pehd:4230:30296362,30295960:pehd:4230:30296333,30295965:pehd:4230:30296224,30304499:pehd:4230:30305229,30304501:pehd:4230:30305085,30304503:pehd:4230:30305167,30304506:pehd:4230:30305196,30304507:pehd:4230:30304870,30304508:pehd:4230:30304910,30304509:pehd:4230:30305054,30304510:pehd:4230:30304762,30304511:pehd:4230:30304728,30304512:pehd:4230:30304776,30304515:pehd:4230:30304689,30312240:pehd:4230:30313090,30312254:pehd:4230:30312760,30312258:pehd:4230:30312978,30312260:pehd:4230:30312582,30312262:pehd:4230:30312777,30312264:pehd:4230:30312614,30312265:pehd:4230:30312692,30312266:pehd:4230:30312502,30312267:pehd:4230:30312833,30312268:pehd:4230:30312455,30312269:pehd:4230:30312541,30312270:pehd:4230:30312429,30313807:pehd:4230:30313824,30323292:pehd:4230:30324433,30323295:pehd:4230:30324955,30323301:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.018447126375513878, 'nb_photo': 20295, 'list_port_cont': '30284364,30284396,30284945,30285022,30285048,30285091,30285237,30285276,30285384,30285447,30285488,30285559,30285670,30285695,30285776,30285850,30285885,30285965,30286032,30286546,30286663,30295989,30296022,30296058,30296095,30296126,30296181,30296227,30296261,30296287,30296334,30296370,30296403,30296441,30296479,30296517,30296541,30296586,30296664,30296698,30296734,30297616,30304567,30304613,30304653,30304693,30304732,30304761,30304783,30304833,30304867,30304913,30304947,30304980,30305019,30305058,30305091,30305128,30305165,30305192,30305235,30305448,30306207,30312287,30312402,30312434,30312453,30312506,30312546,30312576,30312620,30312645,30312683,30312752,30312778,30312836,30312867,30312886,30312941,30312980,30313011,30313050,30313092,30313825,30313956,30323712,30323802,30323929,30323971,30324176,30324250,30324285,30324363,30324432,30324514,30324546,30324697,30324812,30324966,30325004,30325036,30325309,30325361,30325392,30325437,30325599,30325698,30326071,30326108,30326199,30326395,30326652,30326693,3032679', 'assoc_port': '30284295:30286032,30284297:30285965,30284299:30285885,30284301:30285850,30284303:30285776,30284306:30285670,30284308:30285695,30284310:30285559,30284312:30284396,30284315:30285488,30284316:30285384,30284321:30285447,30284324:30285237,30284326:30285276,30284329:30285091,30284333:30285048,30284336:30284945,30284338:30285022,30284340:30284364,30286527:30286546,30286650:30286663,30295936:30296698,30295938:30296734,30295940:30296541,30295942:30296586,30295944:30296664,30295946:30296517,30295948:30296403,30295950:30296479,30295952:30296287,30295954:30296441,30295956:30296370,30295958:30296261,30295960:30296334,30295963:30295989,30295965:30296227,30295967:30296181,30295969:30296126,30295971:30296095,30295972:30296058,30295973:30296022,30297611:30297616,30304497:30304653,30304498:30304980,30304499:30305235,30304500:30305128,30304501:30305091,30304502:30305019,30304503:30305165,30304504:30304947,30304505:30304833,30304506:30305192,30304507:30304867,30304508:30304913,30304509:30305058,30304510:30304761,30304511:3030473', 'assoc_mat': '30284295:pet_clair:4230:30286032,30284297:pet_clair:4230:30285965,30284299:pet_clair:4230:30285885,30284301:pet_clair:4230:30285850,30284303:pet_clair:4230:30285776,30284306:pet_clair:4230:30285670,30284308:pet_clair:4230:30285695,30284310:pet_clair:4230:30285559,30284312:pet_clair:4230:30284396,30284315:pet_clair:4230:30285488,30284316:pet_clair:4230:30285384,30284321:pet_clair:4230:30285447,30284324:pet_clair:4230:30285237,30284326:pet_clair:4230:30285276,30284329:pet_clair:4230:30285091,30284333:pet_clair:4230:30285048,30284336:pet_clair:4230:30284945,30284338:pet_clair:4230:30285022,30284340:pet_clair:4230:30284364,30286527:pet_clair:4230:30286546,30286650:pet_clair:4230:30286663,30295936:pet_clair:4230:30296698,30295938:pet_clair:4230:30296734,30295940:pet_clair:4230:30296541,30295942:pet_clair:4230:30296586,30295944:pet_clair:4230:30296664,30295946:pet_clair:4230:30296517,30295948:pet_clair:4230:30296403,30295950:pet_clair:4230:30296479,30295952:pet_clair:4230:30296287,30295954:pet_clair:4230:30296441,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0029251602335128753, 'nb_photo': 585, 'list_port_cont': '30284403,30284949,30285023,30285383,30285446,30285564,30285775,30285846,30285963,30286547,30296368,30296439,30296511,30296583,30296652,30296695,30296730,30304660,30304694,30304829,30304902,30305055,30305094,30305162,30305204,30312283,30312447,30312507,30312545,30312579,30312617,30312687,30312761,30312776,30312826,30312945,30312977,30313955,30323719,30323806,30324253,30324289,30324367,30324437,30324548,30324690,30324962,30325000,30325302,30325355,30325393,30325433,30325595,30326076,30326104,30326393,30326655,30326800,30326993,30327707,30328703,30329511,30329968,30330407,30330898,30332660,30332725,30333151,30334652,30334862,30336251,30339527,30341094,30344317,30344399,30344432,30344652,30345204,30345230,30345351,30345377,30352062,30352236,30352389,30352564,30352670,30352686,30352748,30352788,30352852,30352918,30353000,30358460,30359883,30360143,30360211,30360278,30360323,30360358,30360431,30360507,30360638,30360805,30360886,30366610,30368495,30368594,30368624,30368680,30369069,30369150,30369306,30369419,3036962', 'assoc_port': '30284297:30285963,30284301:30285846,30284303:30285775,30284310:30285564,30284312:30284403,30284316:30285383,30284321:30285446,30284336:30284949,30284338:30285023,30286527:30286547,30295936:30296695,30295938:30296730,30295942:30296583,30295944:30296652,30295946:30296511,30295954:30296439,30295956:30296368,30304497:30304660,30304501:30305094,30304503:30305162,30304505:30304829,30304506:30305204,30304508:30304902,30304509:30305055,30304515:30304694,30312254:30312761,30312256:30312945,30312258:30312977,30312260:30312579,30312262:30312776,30312264:30312617,30312265:30312687,30312266:30312507,30312267:30312826,30312268:30312447,30312269:30312545,30312272:30312283,30313941:30313955,30323292:30324437,30323295:30324962,30323298:30325302,30323301:30325595,30323304:30325355,30323307:30325393,30323310:30325433,30323316:30325000,30323322:30324690,30323325:30324548,30323331:30324367,30323334:30324253,30323338:30324289,30323345:30323719,30323351:30323806,30326004:30326104,30326005:30326076,30326365:30326393,30326593:3032665', 'assoc_mat': '30284297:pet_fonce:4230:30285963,30284301:pet_fonce:4230:30285846,30284303:pet_fonce:4230:30285775,30284310:pet_fonce:4230:30285564,30284312:pet_fonce:4230:30284403,30284316:pet_fonce:4230:30285383,30284321:pet_fonce:4230:30285446,30284336:pet_fonce:4230:30284949,30284338:pet_fonce:4230:30285023,30286527:pet_fonce:4230:30286547,30295936:pet_fonce:4230:30296695,30295938:pet_fonce:4230:30296730,30295942:pet_fonce:4230:30296583,30295944:pet_fonce:4230:30296652,30295946:pet_fonce:4230:30296511,30295954:pet_fonce:4230:30296439,30295956:pet_fonce:4230:30296368,30304497:pet_fonce:4230:30304660,30304501:pet_fonce:4230:30305094,30304503:pet_fonce:4230:30305162,30304505:pet_fonce:4230:30304829,30304506:pet_fonce:4230:30305204,30304508:pet_fonce:4230:30304902,30304509:pet_fonce:4230:30305055,30304515:pet_fonce:4230:30304694,30312254:pet_fonce:4230:30312761,30312256:pet_fonce:4230:30312945,30312258:pet_fonce:4230:30312977,30312260:pet_fonce:4230:30312579,30312262:pet_fonce:4230:30312776,30312264:pet_fonce:4230:30312617,3'}) 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(2897175,2898371,2899415,2900189,2901462,2902238,2903172,2903639,2904627,2905405,2906431,2907539,2908591,2909393,2909952,2911149,2912405,2913611,2919454,2922893,2923657,2924349,2925278,2926592,2927212,2928101,2929337,2933504)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496538, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284370,30284406,30284950,30285021,30285044,30285089,30285232,30285269,30285376,30285445,30285487,30285555,30285668,30285708,30285771,30285849,30285876,30285959,30286025,30286543,30286662,30295985,30296063,30296096,30296120,30296174,30296221,30296247,30296298,30296321,30296363,30296406,30296440,30296473,30296501,30296551,30296576,30296649,30296694,30296721,30297622,30304568,30304610,30304645,30304698,30304718,30304767,30304779,30304831,30304862,30304900,30304945,30304983,30305016,30305044,30305088,30305119,30305166,30305193,30305225,30305435,30306216,30312292,30312401,30312437,30312442,30312497,30312542,30312581,30312610,30312653,30312675,30312749,30312766,30312837,30312859,30312883,30312929,30312973,30313005,30313052,30313087,30313817,30313950,30323718,30323804,30323925,30323972,30324171,30324251,30324280,30324358,30324425,30324498,30324544,30324684,30324804,30324965,30324995,30325040,30325296,30325360,30325395,30325435,30325589,30325696,30326081,30326107,30326192,30326390,30326659,30326706,30326794,3032694 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496539, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284356,30284398,30284947,30285019,30285054,30285081,30285240,30285265,30285377,30285453,30285484,30285556,30285669,30285709,30285770,30285852,30285878,30285954,30286029,30286532,30286668,30295991,30296026,30296065,30296100,30296132,30296188,30296223,30296260,30296297,30296323,30296366,30296401,30296442,30296481,30296515,30296549,30296587,30296659,30296699,30296726,30297627,30304565,30304618,30304661,30304691,30304734,30304760,30304784,30304834,30304878,30304911,30304935,30304981,30305018,30305053,30305090,30305129,30305158,30305202,30305231,30305439,30306204,30312291,30312395,30312433,30312461,30312499,30312547,30312575,30312611,30312652,30312685,30312763,30312775,30312835,30312869,30312882,30312936,30312982,30313017,30313044,30313088,30313829,30313959,30323714,30323807,30323936,30323963,30324188,30324255,30324296,30324359,30324434,30324510,30324535,30324689,30324815,30324968,30325001,30325034,30325311,30325356,30325389,30325426,30325591,30325695,30326080,30326116,30326206,30326399,30326649,30326701,3032680 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496540, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284359,30284408,30284937,30285010,30285047,30285096,30285239,30285275,30285367,30285449,30285477,30285549,30285656,30285693,30285768,30285848,30285883,30285956,30286021,30286544,30286669,30295976,30296021,30296061,30296255,30296300,30296335,30296431,30296513,30296553,30296589,30296648,30296683,30296727,30297626,30304649,30304681,30304717,30304765,30304787,30304869,30304912,30304986,30305009,30305051,30305087,30305153,30305189,30305242,30305447,30306203,30312279,30312426,30312465,30312543,30312573,30312612,30312689,30312762,30312779,30312820,30312860,30312889,30312943,30313014,30313054,30313078,30313952,30323709,30323797,30323928,30323956,30324174,30324287,30324352,30324439,30324505,30324698,30324803,30324954,30324989,30325026,30325306,30325349,30325424,30325596,30325689,30326068,30326110,30326195,30326398,30326656,30326704,30326950,30327693,30328088,30328634,30328711,30329515,30329967,30330398,30330538,30330894,30331205,30332080,30332814,30333036,30333148,30333464,30334370,30334864,30335437,30336234,3033940 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496541, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284365,30284407,30284946,30285020,30285052,30285093,30285238,30285273,30285382,30285450,30285481,30285563,30285666,30285706,30285780,30285851,30285889,30285960,30286035,30286539,30286664,30295979,30296029,30296059,30296090,30296133,30296191,30296220,30296263,30296294,30296328,30296371,30296404,30296444,30296477,30296506,30296546,30296582,30296658,30296700,30296731,30297628,30304566,30304619,30304656,30304690,30304731,30304759,30304786,30304842,30304877,30304903,30304950,30304985,30305017,30305056,30305081,30305125,30305161,30305203,30305239,30305445,30306201,30312290,30312394,30312438,30312446,30312505,30312535,30312578,30312609,30312651,30312691,30312754,30312771,30312834,30312862,30312885,30312944,30312971,30313016,30313046,30313084,30313822,30313948,30323707,30323810,30323932,30323969,30324184,30324252,30324290,30324366,30324438,30324513,30324549,30324694,30324813,30324953,30324997,30325039,30325310,30325358,30325396,30325428,30325597,30325691,30326073,30326113,30326205,30326388,30326654,30326707,3032680 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496542, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284404,30285095,30285551,30296224,30296333,30296362,30296433,30296516,30296578,30296732,30304689,30304728,30304762,30304776,30304870,30304910,30305054,30305085,30305167,30305196,30305229,30312429,30312455,30312502,30312541,30312582,30312614,30312692,30312760,30312777,30312833,30312978,30313090,30313824,30323799,30323935,30323967,30324185,30324257,30324288,30324365,30324433,30324512,30324547,30324695,30324809,30324955,30325002,30325033,30325364,30325400,30325438,30325598,30325693,30326075,30326389,30326657,30326700,30326807,30326947,30327704,30328094,30328643,30328719,30329517,30329976,30330404,30330892,30330994,30331203,30333150,30334368,30334645,30335427,30336243,30337496,30338268,30339538,30339586,30341084,30344400,30344651,30345196,30345344,30345380,30346069,30352234,30352382,30352561,30352667,30352923,30352994,30353623,30358459,30358498,30360142,30360210,30360289,30360327,30360362,30360434,30360810,30360842,30360914,30360951,30361682,30368057,30368167,30368492,30368563,30368600,30369088,30369139,3036927 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496543, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284364,30284396,30284945,30285022,30285048,30285091,30285237,30285276,30285384,30285447,30285488,30285559,30285670,30285695,30285776,30285850,30285885,30285965,30286032,30286546,30286663,30295989,30296022,30296058,30296095,30296126,30296181,30296227,30296261,30296287,30296334,30296370,30296403,30296441,30296479,30296517,30296541,30296586,30296664,30296698,30296734,30297616,30304567,30304613,30304653,30304693,30304732,30304761,30304783,30304833,30304867,30304913,30304947,30304980,30305019,30305058,30305091,30305128,30305165,30305192,30305235,30305448,30306207,30312287,30312402,30312434,30312453,30312506,30312546,30312576,30312620,30312645,30312683,30312752,30312778,30312836,30312867,30312886,30312941,30312980,30313011,30313050,30313092,30313825,30313956,30323712,30323802,30323929,30323971,30324176,30324250,30324285,30324363,30324432,30324514,30324546,30324697,30324812,30324966,30325004,30325036,30325309,30325361,30325392,30325437,30325599,30325698,30326071,30326108,30326199,30326395,30326652,30326693,3032679 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496544, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284403,30284949,30285023,30285383,30285446,30285564,30285775,30285846,30285963,30286547,30296368,30296439,30296511,30296583,30296652,30296695,30296730,30304660,30304694,30304829,30304902,30305055,30305094,30305162,30305204,30312283,30312447,30312507,30312545,30312579,30312617,30312687,30312761,30312776,30312826,30312945,30312977,30313955,30323719,30323806,30324253,30324289,30324367,30324437,30324548,30324690,30324962,30325000,30325302,30325355,30325393,30325433,30325595,30326076,30326104,30326393,30326655,30326800,30326993,30327707,30328703,30329511,30329968,30330407,30330898,30332660,30332725,30333151,30334652,30334862,30336251,30339527,30341094,30344317,30344399,30344432,30344652,30345204,30345230,30345351,30345377,30352062,30352236,30352389,30352564,30352670,30352686,30352748,30352788,30352852,30352918,30353000,30358460,30359883,30360143,30360211,30360278,30360323,30360358,30360431,30360507,30360638,30360805,30360886,30366610,30368495,30368594,30368624,30368680,30369069,30369150,30369306,30369419,3036962 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30496538,30496539,30496540,30496541,30496542,30496543,30496544?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2026-02-01' and date <= '2026-02-28') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1493,),), 'unwanted_material_monthly_percentage': ((0.7660132380024866,),), 'material_repartition': (('incineration', 1478),), 'material_dict': {'incineration': 1478}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 2, 1), 0.8358947113761331, 1), (datetime.date(2026, 2, 2), 0.7992878456591486, 4), (datetime.date(2026, 2, 3), 0.7732263142013616, 2), (datetime.date(2026, 2, 4), 0.7408216009656097, 2), (datetime.date(2026, 2, 5), 0.7347471293616162, 3), (datetime.date(2026, 2, 6), 0.6842270085041842, 2), (datetime.date(2026, 2, 7), 0.7141252488727067, 2), (datetime.date(2026, 2, 8), 0.7937977858009144, 2), (datetime.date(2026, 2, 9), 0.7918451409405932, 1), (datetime.date(2026, 2, 10), 0.7645706029335063, 3), (datetime.date(2026, 2, 11), 0.7537210526534003, 1), (datetime.date(2026, 2, 12), 0.7501958455407957, 4), (datetime.date(2026, 2, 13), 0.7243552586167308, 3), (datetime.date(2026, 2, 14), 0.7740312906738486, 1), (datetime.date(2026, 2, 15), 0.7793390081332421, 2), (datetime.date(2026, 2, 16), 0.7972834394102264, 1), (datetime.date(2026, 2, 17), 0.7398892645291538, 4), (datetime.date(2026, 2, 18), 0.7596662247837833, 4), (datetime.date(2026, 2, 19), 0.7654589345024544, 3), (datetime.date(2026, 2, 20), 0.7567197972698457, 3), (datetime.date(2026, 2, 21), 0.7684292277867123, 2), (datetime.date(2026, 2, 22), 0.8423632279858323, 1), (datetime.date(2026, 2, 23), 0.7711028941686017, 3), (datetime.date(2026, 2, 24), 0.8008491899048781, 3), (datetime.date(2026, 2, 25), 0.7706170716062283, 3), (datetime.date(2026, 2, 26), 0.7863880858325115, 3), (datetime.date(2026, 2, 27), 0.7245572952959568, 3), (datetime.date(2026, 2, 28), 0.7584837421068612, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 2, 1), 0.8358947113761331, 1), (datetime.date(2026, 2, 2), 0.7992878456591486, 4), (datetime.date(2026, 2, 3), 0.7732263142013616, 2), (datetime.date(2026, 2, 4), 0.7408216009656097, 2), (datetime.date(2026, 2, 5), 0.7347471293616162, 3), (datetime.date(2026, 2, 6), 0.6842270085041842, 2), (datetime.date(2026, 2, 7), 0.7141252488727067, 2), (datetime.date(2026, 2, 8), 0.7937977858009144, 2), (datetime.date(2026, 2, 9), 0.7918451409405932, 1), (datetime.date(2026, 2, 10), 0.7645706029335063, 3), (datetime.date(2026, 2, 11), 0.7537210526534003, 1), (datetime.date(2026, 2, 12), 0.7501958455407957, 4), (datetime.date(2026, 2, 13), 0.7243552586167308, 3), (datetime.date(2026, 2, 14), 0.7740312906738486, 1), (datetime.date(2026, 2, 15), 0.7793390081332421, 2), (datetime.date(2026, 2, 16), 0.7972834394102264, 1), (datetime.date(2026, 2, 17), 0.7398892645291538, 4), (datetime.date(2026, 2, 18), 0.7596662247837833, 4), (datetime.date(2026, 2, 19), 0.7654589345024544, 3), (datetime.date(2026, 2, 20), 0.7567197972698457, 3), (datetime.date(2026, 2, 21), 0.7684292277867123, 2), (datetime.date(2026, 2, 22), 0.8423632279858323, 1), (datetime.date(2026, 2, 23), 0.7711028941686017, 3), (datetime.date(2026, 2, 24), 0.8008491899048781, 3), (datetime.date(2026, 2, 25), 0.7706170716062283, 3), (datetime.date(2026, 2, 26), 0.7863880858325115, 3), (datetime.date(2026, 2, 27), 0.7245572952959568, 3), (datetime.date(2026, 2, 28), 0.7584837421068612, 2))}, 'quality_array': [['-7.0174438043949365', '01022026'], ['-6.972403568872812', '02022026'], ['-7.162004957398237', '03022026'], ['-7.045748070194506', '04022026'], ['-7.0975751543680445', '05022026'], ['-7.080120559008167', '06022026'], ['-7.249198912278988', '07022026'], ['-6.9856705082649935', '08022026'], ['-6.835955255458963', '09022026'], ['-6.662959295807319', '10022026'], ['-7.369842346259211', '11022026'], ['-7.27227992031007', '12022026'], ['-7.4739214583567195', '13022026'], ['-7.281268203243784', '14022026'], ['-7.088766231932711', '15022026'], ['-7.139712912111642', '16022026'], ['-7.067623239379003', '17022026'], ['-6.851287889587614', '18022026'], ['-7.094522352413267', '19022026'], ['-6.975782922407332', '20022026'], ['-7.224147651877178', '21022026'], ['-7.272017716708878', '22022026'], ['-7.1147024598292745', '23022026'], ['-7.192874703500046', '24022026'], ['-6.9334150953213705', '25022026'], ['-7.002359856330322', '26022026'], ['-7.328439448477066', '27022026'], ['-6.969684607823064', '28022026']], 'number_of_batch': ((617,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014084997871061933, 'nb_photo': 13664, 'list_port_cont': '30284370,30284406,30284950,30285021,30285044,30285089,30285232,30285269,30285376,30285445,30285487,30285555,30285668,30285708,30285771,30285849,30285876,30285959,30286025,30286543,30286662,30295985,30296063,30296096,30296120,30296174,30296221,30296247,30296298,30296321,30296363,30296406,30296440,30296473,30296501,30296551,30296576,30296649,30296694,30296721,30297622,30304568,30304610,30304645,30304698,30304718,30304767,30304779,30304831,30304862,30304900,30304945,30304983,30305016,30305044,30305088,30305119,30305166,30305193,30305225,30305435,30306216,30312292,30312401,30312437,30312442,30312497,30312542,30312581,30312610,30312653,30312675,30312749,30312766,30312837,30312859,30312883,30312929,30312973,30313005,30313052,30313087,30313817,30313950,30323718,30323804,30323925,30323972,30324171,30324251,30324280,30324358,30324425,30324498,30324544,30324684,30324804,30324965,30324995,30325040,30325296,30325360,30325395,30325435,30325589,30325696,30326081,30326107,30326192,30326390,30326659,30326706,30326794,3032694', 'assoc_port': '30284295:30286025,30284297:30285959,30284299:30285876,30284301:30285849,30284303:30285771,30284306:30285668,30284308:30285708,30284310:30285555,30284312:30284406,30284315:30285487,30284316:30285376,30284321:30285445,30284324:30285232,30284326:30285269,30284329:30285089,30284333:30285044,30284336:30284950,30284338:30285021,30284340:30284370,30286527:30286543,30286650:30286662,30295936:30296694,30295938:30296721,30295940:30296551,30295942:30296576,30295944:30296649,30295946:30296501,30295948:30296406,30295950:30296473,30295952:30296298,30295954:30296440,30295956:30296363,30295958:30296247,30295960:30296321,30295963:30295985,30295965:30296221,30295967:30296174,30295969:30296120,30295971:30296096,30295972:30296063,30297611:30297622,30304497:30304645,30304498:30304983,30304499:30305225,30304500:30305119,30304501:30305088,30304502:30305016,30304503:30305166,30304504:30304945,30304505:30304831,30304506:30305193,30304507:30304862,30304508:30304900,30304509:30305044,30304510:30304767,30304511:30304718,30304512:3030477', 'assoc_mat': '30284295:autre:4230:30286025,30284297:autre:4230:30285959,30284299:autre:4230:30285876,30284301:autre:4230:30285849,30284303:autre:4230:30285771,30284306:autre:4230:30285668,30284308:autre:4230:30285708,30284310:autre:4230:30285555,30284312:autre:4230:30284406,30284315:autre:4230:30285487,30284316:autre:4230:30285376,30284321:autre:4230:30285445,30284324:autre:4230:30285232,30284326:autre:4230:30285269,30284329:autre:4230:30285089,30284333:autre:4230:30285044,30284336:autre:4230:30284950,30284338:autre:4230:30285021,30284340:autre:4230:30284370,30286527:autre:4230:30286543,30286650:autre:4230:30286662,30295936:autre:4230:30296694,30295938:autre:4230:30296721,30295940:autre:4230:30296551,30295942:autre:4230:30296576,30295944:autre:4230:30296649,30295946:autre:4230:30296501,30295948:autre:4230:30296406,30295950:autre:4230:30296473,30295952:autre:4230:30296298,30295954:autre:4230:30296440,30295956:autre:4230:30296363,30295958:autre:4230:30296247,30295960:autre:4230:30296321,30295963:autre:4230:30295985,30295965:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0381686502298891, 'nb_photo': 64161, 'list_port_cont': '30284356,30284398,30284947,30285019,30285054,30285081,30285240,30285265,30285377,30285453,30285484,30285556,30285669,30285709,30285770,30285852,30285878,30285954,30286029,30286532,30286668,30295991,30296026,30296065,30296100,30296132,30296188,30296223,30296260,30296297,30296323,30296366,30296401,30296442,30296481,30296515,30296549,30296587,30296659,30296699,30296726,30297627,30304565,30304618,30304661,30304691,30304734,30304760,30304784,30304834,30304878,30304911,30304935,30304981,30305018,30305053,30305090,30305129,30305158,30305202,30305231,30305439,30306204,30312291,30312395,30312433,30312461,30312499,30312547,30312575,30312611,30312652,30312685,30312763,30312775,30312835,30312869,30312882,30312936,30312982,30313017,30313044,30313088,30313829,30313959,30323714,30323807,30323936,30323963,30324188,30324255,30324296,30324359,30324434,30324510,30324535,30324689,30324815,30324968,30325001,30325034,30325311,30325356,30325389,30325426,30325591,30325695,30326080,30326116,30326206,30326399,30326649,30326701,3032680', 'assoc_port': '30284295:30286029,30284297:30285954,30284299:30285878,30284301:30285852,30284303:30285770,30284306:30285669,30284308:30285709,30284310:30285556,30284312:30284398,30284315:30285484,30284316:30285377,30284321:30285453,30284324:30285240,30284326:30285265,30284329:30285081,30284333:30285054,30284336:30284947,30284338:30285019,30284340:30284356,30286527:30286532,30286650:30286668,30295936:30296699,30295938:30296726,30295940:30296549,30295942:30296587,30295944:30296659,30295946:30296515,30295948:30296401,30295950:30296481,30295952:30296297,30295954:30296442,30295956:30296366,30295958:30296260,30295960:30296323,30295963:30295991,30295965:30296223,30295967:30296188,30295969:30296132,30295971:30296100,30295972:30296065,30295973:30296026,30297611:30297627,30304497:30304661,30304498:30304981,30304499:30305231,30304500:30305129,30304501:30305090,30304502:30305018,30304503:30305158,30304504:30304935,30304505:30304834,30304506:30305202,30304507:30304878,30304508:30304911,30304509:30305053,30304510:30304760,30304511:3030473', 'assoc_mat': '30284295:carton:4230:30286029,30284297:carton:4230:30285954,30284299:carton:4230:30285878,30284301:carton:4230:30285852,30284303:carton:4230:30285770,30284306:carton:4230:30285669,30284308:carton:4230:30285709,30284310:carton:4230:30285556,30284312:carton:4230:30284398,30284315:carton:4230:30285484,30284316:carton:4230:30285377,30284321:carton:4230:30285453,30284324:carton:4230:30285240,30284326:carton:4230:30285265,30284329:carton:4230:30285081,30284333:carton:4230:30285054,30284336:carton:4230:30284947,30284338:carton:4230:30285019,30284340:carton:4230:30284356,30286527:carton:4230:30286532,30286650:carton:4230:30286668,30295936:carton:4230:30296699,30295938:carton:4230:30296726,30295940:carton:4230:30296549,30295942:carton:4230:30296587,30295944:carton:4230:30296659,30295946:carton:4230:30296515,30295948:carton:4230:30296401,30295950:carton:4230:30296481,30295952:carton:4230:30296297,30295954:carton:4230:30296442,30295956:carton:4230:30296366,30295958:carton:4230:30296260,30295960:carton:4230:30296323,3029'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00107574308866471, 'nb_photo': 1371, 'list_port_cont': '30284359,30284408,30284937,30285010,30285047,30285096,30285239,30285275,30285367,30285449,30285477,30285549,30285656,30285693,30285768,30285848,30285883,30285956,30286021,30286544,30286669,30295976,30296021,30296061,30296255,30296300,30296335,30296431,30296513,30296553,30296589,30296648,30296683,30296727,30297626,30304649,30304681,30304717,30304765,30304787,30304869,30304912,30304986,30305009,30305051,30305087,30305153,30305189,30305242,30305447,30306203,30312279,30312426,30312465,30312543,30312573,30312612,30312689,30312762,30312779,30312820,30312860,30312889,30312943,30313014,30313054,30313078,30313952,30323709,30323797,30323928,30323956,30324174,30324287,30324352,30324439,30324505,30324698,30324803,30324954,30324989,30325026,30325306,30325349,30325424,30325596,30325689,30326068,30326110,30326195,30326398,30326656,30326704,30326950,30327693,30328088,30328634,30328711,30329515,30329967,30330398,30330538,30330894,30331205,30332080,30332814,30333036,30333148,30333464,30334370,30334864,30335437,30336234,3033940', 'assoc_port': '30284295:30286021,30284297:30285956,30284299:30285883,30284301:30285848,30284303:30285768,30284306:30285656,30284308:30285693,30284310:30285549,30284312:30284408,30284315:30285477,30284316:30285367,30284321:30285449,30284324:30285239,30284326:30285275,30284329:30285096,30284333:30285047,30284336:30284937,30284338:30285010,30284340:30284359,30286527:30286544,30286650:30286669,30295936:30296683,30295938:30296727,30295940:30296553,30295942:30296589,30295944:30296648,30295946:30296513,30295952:30296300,30295954:30296431,30295958:30296255,30295960:30296335,30295963:30295976,30295972:30296061,30295973:30296021,30297611:30297626,30304497:30304649,30304498:30304986,30304499:30305242,30304501:30305087,30304502:30305009,30304503:30305153,30304506:30305189,30304507:30304869,30304508:30304912,30304509:30305051,30304510:30304765,30304511:30304717,30304512:30304787,30304515:30304681,30305365:30305447,30306198:30306203,30312240:30313078,30312243:30312889,30312246:30313014,30312248:30312860,30312250:30313054,30312254:3031276', 'assoc_mat': '30284295:metal:4230:30286021,30284297:metal:4230:30285956,30284299:metal:4230:30285883,30284301:metal:4230:30285848,30284303:metal:4230:30285768,30284306:metal:4230:30285656,30284308:metal:4230:30285693,30284310:metal:4230:30285549,30284312:metal:4230:30284408,30284315:metal:4230:30285477,30284316:metal:4230:30285367,30284321:metal:4230:30285449,30284324:metal:4230:30285239,30284326:metal:4230:30285275,30284329:metal:4230:30285096,30284333:metal:4230:30285047,30284336:metal:4230:30284937,30284338:metal:4230:30285010,30284340:metal:4230:30284359,30286527:metal:4230:30286544,30286650:metal:4230:30286669,30295936:metal:4230:30296683,30295938:metal:4230:30296727,30295940:metal:4230:30296553,30295942:metal:4230:30296589,30295944:metal:4230:30296648,30295946:metal:4230:30296513,30295952:metal:4230:30296300,30295954:metal:4230:30296431,30295958:metal:4230:30296255,30295960:metal:4230:30296335,30295963:metal:4230:30295976,30295972:metal:4230:30296061,30295973:metal:4230:30296021,30297611:metal:4230:30297626,30304497:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.17407144357554027, 'nb_photo': 213953, 'list_port_cont': '30284365,30284407,30284946,30285020,30285052,30285093,30285238,30285273,30285382,30285450,30285481,30285563,30285666,30285706,30285780,30285851,30285889,30285960,30286035,30286539,30286664,30295979,30296029,30296059,30296090,30296133,30296191,30296220,30296263,30296294,30296328,30296371,30296404,30296444,30296477,30296506,30296546,30296582,30296658,30296700,30296731,30297628,30304566,30304619,30304656,30304690,30304731,30304759,30304786,30304842,30304877,30304903,30304950,30304985,30305017,30305056,30305081,30305125,30305161,30305203,30305239,30305445,30306201,30312290,30312394,30312438,30312446,30312505,30312535,30312578,30312609,30312651,30312691,30312754,30312771,30312834,30312862,30312885,30312944,30312971,30313016,30313046,30313084,30313822,30313948,30323707,30323810,30323932,30323969,30324184,30324252,30324290,30324366,30324438,30324513,30324549,30324694,30324813,30324953,30324997,30325039,30325310,30325358,30325396,30325428,30325597,30325691,30326073,30326113,30326205,30326388,30326654,30326707,3032680', 'assoc_port': '30284295:30286035,30284297:30285960,30284299:30285889,30284301:30285851,30284303:30285780,30284306:30285666,30284308:30285706,30284310:30285563,30284312:30284407,30284315:30285481,30284316:30285382,30284321:30285450,30284324:30285238,30284326:30285273,30284329:30285093,30284333:30285052,30284336:30284946,30284338:30285020,30284340:30284365,30286527:30286539,30286650:30286664,30295936:30296700,30295938:30296731,30295940:30296546,30295942:30296582,30295944:30296658,30295946:30296506,30295948:30296404,30295950:30296477,30295952:30296294,30295954:30296444,30295956:30296371,30295958:30296263,30295960:30296328,30295963:30295979,30295965:30296220,30295967:30296191,30295969:30296133,30295971:30296090,30295972:30296059,30295973:30296029,30297611:30297628,30304497:30304656,30304498:30304985,30304499:30305239,30304500:30305125,30304501:30305081,30304502:30305017,30304503:30305161,30304504:30304950,30304505:30304842,30304506:30305203,30304507:30304877,30304508:30304903,30304509:30305056,30304510:30304759,30304511:3030473', 'assoc_mat': '30284295:papier:4230:30286035,30284297:papier:4230:30285960,30284299:papier:4230:30285889,30284301:papier:4230:30285851,30284303:papier:4230:30285780,30284306:papier:4230:30285666,30284308:papier:4230:30285706,30284310:papier:4230:30285563,30284312:papier:4230:30284407,30284315:papier:4230:30285481,30284316:papier:4230:30285382,30284321:papier:4230:30285450,30284324:papier:4230:30285238,30284326:papier:4230:30285273,30284329:papier:4230:30285093,30284333:papier:4230:30285052,30284336:papier:4230:30284946,30284338:papier:4230:30285020,30284340:papier:4230:30284365,30286527:papier:4230:30286539,30286650:papier:4230:30286664,30295936:papier:4230:30296700,30295938:papier:4230:30296731,30295940:papier:4230:30296546,30295942:papier:4230:30296582,30295944:papier:4230:30296658,30295946:papier:4230:30296506,30295948:papier:4230:30296404,30295950:papier:4230:30296477,30295952:papier:4230:30296294,30295954:papier:4230:30296444,30295956:papier:4230:30296371,30295958:papier:4230:30296263,30295960:papier:4230:30296328,3029'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028005455879661282, 'nb_photo': 1020, 'list_port_cont': '30284404,30285095,30285551,30296224,30296333,30296362,30296433,30296516,30296578,30296732,30304689,30304728,30304762,30304776,30304870,30304910,30305054,30305085,30305167,30305196,30305229,30312429,30312455,30312502,30312541,30312582,30312614,30312692,30312760,30312777,30312833,30312978,30313090,30313824,30323799,30323935,30323967,30324185,30324257,30324288,30324365,30324433,30324512,30324547,30324695,30324809,30324955,30325002,30325033,30325364,30325400,30325438,30325598,30325693,30326075,30326389,30326657,30326700,30326807,30326947,30327704,30328094,30328643,30328719,30329517,30329976,30330404,30330892,30330994,30331203,30333150,30334368,30334645,30335427,30336243,30337496,30338268,30339538,30339586,30341084,30344400,30344651,30345196,30345344,30345380,30346069,30352234,30352382,30352561,30352667,30352923,30352994,30353623,30358459,30358498,30360142,30360210,30360289,30360327,30360362,30360434,30360810,30360842,30360914,30360951,30361682,30368057,30368167,30368492,30368563,30368600,30369088,30369139,3036927', 'assoc_port': '30284310:30285551,30284312:30284404,30284329:30285095,30295938:30296732,30295942:30296578,30295946:30296516,30295954:30296433,30295956:30296362,30295960:30296333,30295965:30296224,30304499:30305229,30304501:30305085,30304503:30305167,30304506:30305196,30304507:30304870,30304508:30304910,30304509:30305054,30304510:30304762,30304511:30304728,30304512:30304776,30304515:30304689,30312240:30313090,30312254:30312760,30312258:30312978,30312260:30312582,30312262:30312777,30312264:30312614,30312265:30312692,30312266:30312502,30312267:30312833,30312268:30312455,30312269:30312541,30312270:30312429,30313807:30313824,30323292:30324433,30323295:30324955,30323301:30325598,30323304:30325364,30323307:30325400,30323310:30325438,30323313:30325033,30323316:30325002,30323319:30324809,30323322:30324695,30323325:30324547,30323328:30324512,30323331:30324365,30323334:30324257,30323337:30323967,30323338:30324288,30323343:30324185,30323347:30323935,30323351:30323799,30325680:30325693,30326005:30326075,30326365:30326389,30326593:3032665', 'assoc_mat': '30284310:pehd:4230:30285551,30284312:pehd:4230:30284404,30284329:pehd:4230:30285095,30295938:pehd:4230:30296732,30295942:pehd:4230:30296578,30295946:pehd:4230:30296516,30295954:pehd:4230:30296433,30295956:pehd:4230:30296362,30295960:pehd:4230:30296333,30295965:pehd:4230:30296224,30304499:pehd:4230:30305229,30304501:pehd:4230:30305085,30304503:pehd:4230:30305167,30304506:pehd:4230:30305196,30304507:pehd:4230:30304870,30304508:pehd:4230:30304910,30304509:pehd:4230:30305054,30304510:pehd:4230:30304762,30304511:pehd:4230:30304728,30304512:pehd:4230:30304776,30304515:pehd:4230:30304689,30312240:pehd:4230:30313090,30312254:pehd:4230:30312760,30312258:pehd:4230:30312978,30312260:pehd:4230:30312582,30312262:pehd:4230:30312777,30312264:pehd:4230:30312614,30312265:pehd:4230:30312692,30312266:pehd:4230:30312502,30312267:pehd:4230:30312833,30312268:pehd:4230:30312455,30312269:pehd:4230:30312541,30312270:pehd:4230:30312429,30313807:pehd:4230:30313824,30323292:pehd:4230:30324433,30323295:pehd:4230:30324955,30323301:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.018447126375513878, 'nb_photo': 20295, 'list_port_cont': '30284364,30284396,30284945,30285022,30285048,30285091,30285237,30285276,30285384,30285447,30285488,30285559,30285670,30285695,30285776,30285850,30285885,30285965,30286032,30286546,30286663,30295989,30296022,30296058,30296095,30296126,30296181,30296227,30296261,30296287,30296334,30296370,30296403,30296441,30296479,30296517,30296541,30296586,30296664,30296698,30296734,30297616,30304567,30304613,30304653,30304693,30304732,30304761,30304783,30304833,30304867,30304913,30304947,30304980,30305019,30305058,30305091,30305128,30305165,30305192,30305235,30305448,30306207,30312287,30312402,30312434,30312453,30312506,30312546,30312576,30312620,30312645,30312683,30312752,30312778,30312836,30312867,30312886,30312941,30312980,30313011,30313050,30313092,30313825,30313956,30323712,30323802,30323929,30323971,30324176,30324250,30324285,30324363,30324432,30324514,30324546,30324697,30324812,30324966,30325004,30325036,30325309,30325361,30325392,30325437,30325599,30325698,30326071,30326108,30326199,30326395,30326652,30326693,3032679', 'assoc_port': '30284295:30286032,30284297:30285965,30284299:30285885,30284301:30285850,30284303:30285776,30284306:30285670,30284308:30285695,30284310:30285559,30284312:30284396,30284315:30285488,30284316:30285384,30284321:30285447,30284324:30285237,30284326:30285276,30284329:30285091,30284333:30285048,30284336:30284945,30284338:30285022,30284340:30284364,30286527:30286546,30286650:30286663,30295936:30296698,30295938:30296734,30295940:30296541,30295942:30296586,30295944:30296664,30295946:30296517,30295948:30296403,30295950:30296479,30295952:30296287,30295954:30296441,30295956:30296370,30295958:30296261,30295960:30296334,30295963:30295989,30295965:30296227,30295967:30296181,30295969:30296126,30295971:30296095,30295972:30296058,30295973:30296022,30297611:30297616,30304497:30304653,30304498:30304980,30304499:30305235,30304500:30305128,30304501:30305091,30304502:30305019,30304503:30305165,30304504:30304947,30304505:30304833,30304506:30305192,30304507:30304867,30304508:30304913,30304509:30305058,30304510:30304761,30304511:3030473', 'assoc_mat': '30284295:pet_clair:4230:30286032,30284297:pet_clair:4230:30285965,30284299:pet_clair:4230:30285885,30284301:pet_clair:4230:30285850,30284303:pet_clair:4230:30285776,30284306:pet_clair:4230:30285670,30284308:pet_clair:4230:30285695,30284310:pet_clair:4230:30285559,30284312:pet_clair:4230:30284396,30284315:pet_clair:4230:30285488,30284316:pet_clair:4230:30285384,30284321:pet_clair:4230:30285447,30284324:pet_clair:4230:30285237,30284326:pet_clair:4230:30285276,30284329:pet_clair:4230:30285091,30284333:pet_clair:4230:30285048,30284336:pet_clair:4230:30284945,30284338:pet_clair:4230:30285022,30284340:pet_clair:4230:30284364,30286527:pet_clair:4230:30286546,30286650:pet_clair:4230:30286663,30295936:pet_clair:4230:30296698,30295938:pet_clair:4230:30296734,30295940:pet_clair:4230:30296541,30295942:pet_clair:4230:30296586,30295944:pet_clair:4230:30296664,30295946:pet_clair:4230:30296517,30295948:pet_clair:4230:30296403,30295950:pet_clair:4230:30296479,30295952:pet_clair:4230:30296287,30295954:pet_clair:4230:30296441,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0029251602335128753, 'nb_photo': 585, 'list_port_cont': '30284403,30284949,30285023,30285383,30285446,30285564,30285775,30285846,30285963,30286547,30296368,30296439,30296511,30296583,30296652,30296695,30296730,30304660,30304694,30304829,30304902,30305055,30305094,30305162,30305204,30312283,30312447,30312507,30312545,30312579,30312617,30312687,30312761,30312776,30312826,30312945,30312977,30313955,30323719,30323806,30324253,30324289,30324367,30324437,30324548,30324690,30324962,30325000,30325302,30325355,30325393,30325433,30325595,30326076,30326104,30326393,30326655,30326800,30326993,30327707,30328703,30329511,30329968,30330407,30330898,30332660,30332725,30333151,30334652,30334862,30336251,30339527,30341094,30344317,30344399,30344432,30344652,30345204,30345230,30345351,30345377,30352062,30352236,30352389,30352564,30352670,30352686,30352748,30352788,30352852,30352918,30353000,30358460,30359883,30360143,30360211,30360278,30360323,30360358,30360431,30360507,30360638,30360805,30360886,30366610,30368495,30368594,30368624,30368680,30369069,30369150,30369306,30369419,3036962', 'assoc_port': '30284297:30285963,30284301:30285846,30284303:30285775,30284310:30285564,30284312:30284403,30284316:30285383,30284321:30285446,30284336:30284949,30284338:30285023,30286527:30286547,30295936:30296695,30295938:30296730,30295942:30296583,30295944:30296652,30295946:30296511,30295954:30296439,30295956:30296368,30304497:30304660,30304501:30305094,30304503:30305162,30304505:30304829,30304506:30305204,30304508:30304902,30304509:30305055,30304515:30304694,30312254:30312761,30312256:30312945,30312258:30312977,30312260:30312579,30312262:30312776,30312264:30312617,30312265:30312687,30312266:30312507,30312267:30312826,30312268:30312447,30312269:30312545,30312272:30312283,30313941:30313955,30323292:30324437,30323295:30324962,30323298:30325302,30323301:30325595,30323304:30325355,30323307:30325393,30323310:30325433,30323316:30325000,30323322:30324690,30323325:30324548,30323331:30324367,30323334:30324253,30323338:30324289,30323345:30323719,30323351:30323806,30326004:30326104,30326005:30326076,30326365:30326393,30326593:3032665', 'assoc_mat': '30284297:pet_fonce:4230:30285963,30284301:pet_fonce:4230:30285846,30284303:pet_fonce:4230:30285775,30284310:pet_fonce:4230:30285564,30284312:pet_fonce:4230:30284403,30284316:pet_fonce:4230:30285383,30284321:pet_fonce:4230:30285446,30284336:pet_fonce:4230:30284949,30284338:pet_fonce:4230:30285023,30286527:pet_fonce:4230:30286547,30295936:pet_fonce:4230:30296695,30295938:pet_fonce:4230:30296730,30295942:pet_fonce:4230:30296583,30295944:pet_fonce:4230:30296652,30295946:pet_fonce:4230:30296511,30295954:pet_fonce:4230:30296439,30295956:pet_fonce:4230:30296368,30304497:pet_fonce:4230:30304660,30304501:pet_fonce:4230:30305094,30304503:pet_fonce:4230:30305162,30304505:pet_fonce:4230:30304829,30304506:pet_fonce:4230:30305204,30304508:pet_fonce:4230:30304902,30304509:pet_fonce:4230:30305055,30304515:pet_fonce:4230:30304694,30312254:pet_fonce:4230:30312761,30312256:pet_fonce:4230:30312945,30312258:pet_fonce:4230:30312977,30312260:pet_fonce:4230:30312579,30312262:pet_fonce:4230:30312776,30312264:pet_fonce:4230:30312617,3'}), 'main_stat': {'nb_photos': 1493}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30496538,30496539,30496540,30496541,30496542,30496543,30496544?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-02', 0.7660132380024866),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1493,),), 'unwanted_material_monthly_percentage': ((0.7660132380024866,),), 'material_repartition': (('incineration', 1478),), 'material_dict': {'incineration': 1478}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 2, 1), 0.8358947113761331, 1), (datetime.date(2026, 2, 2), 0.7992878456591486, 4), (datetime.date(2026, 2, 3), 0.7732263142013616, 2), (datetime.date(2026, 2, 4), 0.7408216009656097, 2), (datetime.date(2026, 2, 5), 0.7347471293616162, 3), (datetime.date(2026, 2, 6), 0.6842270085041842, 2), (datetime.date(2026, 2, 7), 0.7141252488727067, 2), (datetime.date(2026, 2, 8), 0.7937977858009144, 2), (datetime.date(2026, 2, 9), 0.7918451409405932, 1), (datetime.date(2026, 2, 10), 0.7645706029335063, 3), (datetime.date(2026, 2, 11), 0.7537210526534003, 1), (datetime.date(2026, 2, 12), 0.7501958455407957, 4), (datetime.date(2026, 2, 13), 0.7243552586167308, 3), (datetime.date(2026, 2, 14), 0.7740312906738486, 1), (datetime.date(2026, 2, 15), 0.7793390081332421, 2), (datetime.date(2026, 2, 16), 0.7972834394102264, 1), (datetime.date(2026, 2, 17), 0.7398892645291538, 4), (datetime.date(2026, 2, 18), 0.7596662247837833, 4), (datetime.date(2026, 2, 19), 0.7654589345024544, 3), (datetime.date(2026, 2, 20), 0.7567197972698457, 3), (datetime.date(2026, 2, 21), 0.7684292277867123, 2), (datetime.date(2026, 2, 22), 0.8423632279858323, 1), (datetime.date(2026, 2, 23), 0.7711028941686017, 3), (datetime.date(2026, 2, 24), 0.8008491899048781, 3), (datetime.date(2026, 2, 25), 0.7706170716062283, 3), (datetime.date(2026, 2, 26), 0.7863880858325115, 3), (datetime.date(2026, 2, 27), 0.7245572952959568, 3), (datetime.date(2026, 2, 28), 0.7584837421068612, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 2, 1), 0.8358947113761331, 1), (datetime.date(2026, 2, 2), 0.7992878456591486, 4), (datetime.date(2026, 2, 3), 0.7732263142013616, 2), (datetime.date(2026, 2, 4), 0.7408216009656097, 2), (datetime.date(2026, 2, 5), 0.7347471293616162, 3), (datetime.date(2026, 2, 6), 0.6842270085041842, 2), (datetime.date(2026, 2, 7), 0.7141252488727067, 2), (datetime.date(2026, 2, 8), 0.7937977858009144, 2), (datetime.date(2026, 2, 9), 0.7918451409405932, 1), (datetime.date(2026, 2, 10), 0.7645706029335063, 3), (datetime.date(2026, 2, 11), 0.7537210526534003, 1), (datetime.date(2026, 2, 12), 0.7501958455407957, 4), (datetime.date(2026, 2, 13), 0.7243552586167308, 3), (datetime.date(2026, 2, 14), 0.7740312906738486, 1), (datetime.date(2026, 2, 15), 0.7793390081332421, 2), (datetime.date(2026, 2, 16), 0.7972834394102264, 1), (datetime.date(2026, 2, 17), 0.7398892645291538, 4), (datetime.date(2026, 2, 18), 0.7596662247837833, 4), (datetime.date(2026, 2, 19), 0.7654589345024544, 3), (datetime.date(2026, 2, 20), 0.7567197972698457, 3), (datetime.date(2026, 2, 21), 0.7684292277867123, 2), (datetime.date(2026, 2, 22), 0.8423632279858323, 1), (datetime.date(2026, 2, 23), 0.7711028941686017, 3), (datetime.date(2026, 2, 24), 0.8008491899048781, 3), (datetime.date(2026, 2, 25), 0.7706170716062283, 3), (datetime.date(2026, 2, 26), 0.7863880858325115, 3), (datetime.date(2026, 2, 27), 0.7245572952959568, 3), (datetime.date(2026, 2, 28), 0.7584837421068612, 2))}, 'quality_array': [['-7.0174438043949365', '01022026'], ['-6.972403568872812', '02022026'], ['-7.162004957398237', '03022026'], ['-7.045748070194506', '04022026'], ['-7.0975751543680445', '05022026'], ['-7.080120559008167', '06022026'], ['-7.249198912278988', '07022026'], ['-6.9856705082649935', '08022026'], ['-6.835955255458963', '09022026'], ['-6.662959295807319', '10022026'], ['-7.369842346259211', '11022026'], ['-7.27227992031007', '12022026'], ['-7.4739214583567195', '13022026'], ['-7.281268203243784', '14022026'], ['-7.088766231932711', '15022026'], ['-7.139712912111642', '16022026'], ['-7.067623239379003', '17022026'], ['-6.851287889587614', '18022026'], ['-7.094522352413267', '19022026'], ['-6.975782922407332', '20022026'], ['-7.224147651877178', '21022026'], ['-7.272017716708878', '22022026'], ['-7.1147024598292745', '23022026'], ['-7.192874703500046', '24022026'], ['-6.9334150953213705', '25022026'], ['-7.002359856330322', '26022026'], ['-7.328439448477066', '27022026'], ['-6.969684607823064', '28022026']], 'number_of_batch': ((617,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014084997871061933, 'nb_photo': 13664, 'list_port_cont': '30284370,30284406,30284950,30285021,30285044,30285089,30285232,30285269,30285376,30285445,30285487,30285555,30285668,30285708,30285771,30285849,30285876,30285959,30286025,30286543,30286662,30295985,30296063,30296096,30296120,30296174,30296221,30296247,30296298,30296321,30296363,30296406,30296440,30296473,30296501,30296551,30296576,30296649,30296694,30296721,30297622,30304568,30304610,30304645,30304698,30304718,30304767,30304779,30304831,30304862,30304900,30304945,30304983,30305016,30305044,30305088,30305119,30305166,30305193,30305225,30305435,30306216,30312292,30312401,30312437,30312442,30312497,30312542,30312581,30312610,30312653,30312675,30312749,30312766,30312837,30312859,30312883,30312929,30312973,30313005,30313052,30313087,30313817,30313950,30323718,30323804,30323925,30323972,30324171,30324251,30324280,30324358,30324425,30324498,30324544,30324684,30324804,30324965,30324995,30325040,30325296,30325360,30325395,30325435,30325589,30325696,30326081,30326107,30326192,30326390,30326659,30326706,30326794,3032694', 'assoc_port': '30284295:30286025,30284297:30285959,30284299:30285876,30284301:30285849,30284303:30285771,30284306:30285668,30284308:30285708,30284310:30285555,30284312:30284406,30284315:30285487,30284316:30285376,30284321:30285445,30284324:30285232,30284326:30285269,30284329:30285089,30284333:30285044,30284336:30284950,30284338:30285021,30284340:30284370,30286527:30286543,30286650:30286662,30295936:30296694,30295938:30296721,30295940:30296551,30295942:30296576,30295944:30296649,30295946:30296501,30295948:30296406,30295950:30296473,30295952:30296298,30295954:30296440,30295956:30296363,30295958:30296247,30295960:30296321,30295963:30295985,30295965:30296221,30295967:30296174,30295969:30296120,30295971:30296096,30295972:30296063,30297611:30297622,30304497:30304645,30304498:30304983,30304499:30305225,30304500:30305119,30304501:30305088,30304502:30305016,30304503:30305166,30304504:30304945,30304505:30304831,30304506:30305193,30304507:30304862,30304508:30304900,30304509:30305044,30304510:30304767,30304511:30304718,30304512:3030477', 'assoc_mat': '30284295:autre:4230:30286025,30284297:autre:4230:30285959,30284299:autre:4230:30285876,30284301:autre:4230:30285849,30284303:autre:4230:30285771,30284306:autre:4230:30285668,30284308:autre:4230:30285708,30284310:autre:4230:30285555,30284312:autre:4230:30284406,30284315:autre:4230:30285487,30284316:autre:4230:30285376,30284321:autre:4230:30285445,30284324:autre:4230:30285232,30284326:autre:4230:30285269,30284329:autre:4230:30285089,30284333:autre:4230:30285044,30284336:autre:4230:30284950,30284338:autre:4230:30285021,30284340:autre:4230:30284370,30286527:autre:4230:30286543,30286650:autre:4230:30286662,30295936:autre:4230:30296694,30295938:autre:4230:30296721,30295940:autre:4230:30296551,30295942:autre:4230:30296576,30295944:autre:4230:30296649,30295946:autre:4230:30296501,30295948:autre:4230:30296406,30295950:autre:4230:30296473,30295952:autre:4230:30296298,30295954:autre:4230:30296440,30295956:autre:4230:30296363,30295958:autre:4230:30296247,30295960:autre:4230:30296321,30295963:autre:4230:30295985,30295965:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0381686502298891, 'nb_photo': 64161, 'list_port_cont': '30284356,30284398,30284947,30285019,30285054,30285081,30285240,30285265,30285377,30285453,30285484,30285556,30285669,30285709,30285770,30285852,30285878,30285954,30286029,30286532,30286668,30295991,30296026,30296065,30296100,30296132,30296188,30296223,30296260,30296297,30296323,30296366,30296401,30296442,30296481,30296515,30296549,30296587,30296659,30296699,30296726,30297627,30304565,30304618,30304661,30304691,30304734,30304760,30304784,30304834,30304878,30304911,30304935,30304981,30305018,30305053,30305090,30305129,30305158,30305202,30305231,30305439,30306204,30312291,30312395,30312433,30312461,30312499,30312547,30312575,30312611,30312652,30312685,30312763,30312775,30312835,30312869,30312882,30312936,30312982,30313017,30313044,30313088,30313829,30313959,30323714,30323807,30323936,30323963,30324188,30324255,30324296,30324359,30324434,30324510,30324535,30324689,30324815,30324968,30325001,30325034,30325311,30325356,30325389,30325426,30325591,30325695,30326080,30326116,30326206,30326399,30326649,30326701,3032680', 'assoc_port': '30284295:30286029,30284297:30285954,30284299:30285878,30284301:30285852,30284303:30285770,30284306:30285669,30284308:30285709,30284310:30285556,30284312:30284398,30284315:30285484,30284316:30285377,30284321:30285453,30284324:30285240,30284326:30285265,30284329:30285081,30284333:30285054,30284336:30284947,30284338:30285019,30284340:30284356,30286527:30286532,30286650:30286668,30295936:30296699,30295938:30296726,30295940:30296549,30295942:30296587,30295944:30296659,30295946:30296515,30295948:30296401,30295950:30296481,30295952:30296297,30295954:30296442,30295956:30296366,30295958:30296260,30295960:30296323,30295963:30295991,30295965:30296223,30295967:30296188,30295969:30296132,30295971:30296100,30295972:30296065,30295973:30296026,30297611:30297627,30304497:30304661,30304498:30304981,30304499:30305231,30304500:30305129,30304501:30305090,30304502:30305018,30304503:30305158,30304504:30304935,30304505:30304834,30304506:30305202,30304507:30304878,30304508:30304911,30304509:30305053,30304510:30304760,30304511:3030473', 'assoc_mat': '30284295:carton:4230:30286029,30284297:carton:4230:30285954,30284299:carton:4230:30285878,30284301:carton:4230:30285852,30284303:carton:4230:30285770,30284306:carton:4230:30285669,30284308:carton:4230:30285709,30284310:carton:4230:30285556,30284312:carton:4230:30284398,30284315:carton:4230:30285484,30284316:carton:4230:30285377,30284321:carton:4230:30285453,30284324:carton:4230:30285240,30284326:carton:4230:30285265,30284329:carton:4230:30285081,30284333:carton:4230:30285054,30284336:carton:4230:30284947,30284338:carton:4230:30285019,30284340:carton:4230:30284356,30286527:carton:4230:30286532,30286650:carton:4230:30286668,30295936:carton:4230:30296699,30295938:carton:4230:30296726,30295940:carton:4230:30296549,30295942:carton:4230:30296587,30295944:carton:4230:30296659,30295946:carton:4230:30296515,30295948:carton:4230:30296401,30295950:carton:4230:30296481,30295952:carton:4230:30296297,30295954:carton:4230:30296442,30295956:carton:4230:30296366,30295958:carton:4230:30296260,30295960:carton:4230:30296323,3029'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00107574308866471, 'nb_photo': 1371, 'list_port_cont': '30284359,30284408,30284937,30285010,30285047,30285096,30285239,30285275,30285367,30285449,30285477,30285549,30285656,30285693,30285768,30285848,30285883,30285956,30286021,30286544,30286669,30295976,30296021,30296061,30296255,30296300,30296335,30296431,30296513,30296553,30296589,30296648,30296683,30296727,30297626,30304649,30304681,30304717,30304765,30304787,30304869,30304912,30304986,30305009,30305051,30305087,30305153,30305189,30305242,30305447,30306203,30312279,30312426,30312465,30312543,30312573,30312612,30312689,30312762,30312779,30312820,30312860,30312889,30312943,30313014,30313054,30313078,30313952,30323709,30323797,30323928,30323956,30324174,30324287,30324352,30324439,30324505,30324698,30324803,30324954,30324989,30325026,30325306,30325349,30325424,30325596,30325689,30326068,30326110,30326195,30326398,30326656,30326704,30326950,30327693,30328088,30328634,30328711,30329515,30329967,30330398,30330538,30330894,30331205,30332080,30332814,30333036,30333148,30333464,30334370,30334864,30335437,30336234,3033940', 'assoc_port': '30284295:30286021,30284297:30285956,30284299:30285883,30284301:30285848,30284303:30285768,30284306:30285656,30284308:30285693,30284310:30285549,30284312:30284408,30284315:30285477,30284316:30285367,30284321:30285449,30284324:30285239,30284326:30285275,30284329:30285096,30284333:30285047,30284336:30284937,30284338:30285010,30284340:30284359,30286527:30286544,30286650:30286669,30295936:30296683,30295938:30296727,30295940:30296553,30295942:30296589,30295944:30296648,30295946:30296513,30295952:30296300,30295954:30296431,30295958:30296255,30295960:30296335,30295963:30295976,30295972:30296061,30295973:30296021,30297611:30297626,30304497:30304649,30304498:30304986,30304499:30305242,30304501:30305087,30304502:30305009,30304503:30305153,30304506:30305189,30304507:30304869,30304508:30304912,30304509:30305051,30304510:30304765,30304511:30304717,30304512:30304787,30304515:30304681,30305365:30305447,30306198:30306203,30312240:30313078,30312243:30312889,30312246:30313014,30312248:30312860,30312250:30313054,30312254:3031276', 'assoc_mat': '30284295:metal:4230:30286021,30284297:metal:4230:30285956,30284299:metal:4230:30285883,30284301:metal:4230:30285848,30284303:metal:4230:30285768,30284306:metal:4230:30285656,30284308:metal:4230:30285693,30284310:metal:4230:30285549,30284312:metal:4230:30284408,30284315:metal:4230:30285477,30284316:metal:4230:30285367,30284321:metal:4230:30285449,30284324:metal:4230:30285239,30284326:metal:4230:30285275,30284329:metal:4230:30285096,30284333:metal:4230:30285047,30284336:metal:4230:30284937,30284338:metal:4230:30285010,30284340:metal:4230:30284359,30286527:metal:4230:30286544,30286650:metal:4230:30286669,30295936:metal:4230:30296683,30295938:metal:4230:30296727,30295940:metal:4230:30296553,30295942:metal:4230:30296589,30295944:metal:4230:30296648,30295946:metal:4230:30296513,30295952:metal:4230:30296300,30295954:metal:4230:30296431,30295958:metal:4230:30296255,30295960:metal:4230:30296335,30295963:metal:4230:30295976,30295972:metal:4230:30296061,30295973:metal:4230:30296021,30297611:metal:4230:30297626,30304497:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.17407144357554027, 'nb_photo': 213953, 'list_port_cont': '30284365,30284407,30284946,30285020,30285052,30285093,30285238,30285273,30285382,30285450,30285481,30285563,30285666,30285706,30285780,30285851,30285889,30285960,30286035,30286539,30286664,30295979,30296029,30296059,30296090,30296133,30296191,30296220,30296263,30296294,30296328,30296371,30296404,30296444,30296477,30296506,30296546,30296582,30296658,30296700,30296731,30297628,30304566,30304619,30304656,30304690,30304731,30304759,30304786,30304842,30304877,30304903,30304950,30304985,30305017,30305056,30305081,30305125,30305161,30305203,30305239,30305445,30306201,30312290,30312394,30312438,30312446,30312505,30312535,30312578,30312609,30312651,30312691,30312754,30312771,30312834,30312862,30312885,30312944,30312971,30313016,30313046,30313084,30313822,30313948,30323707,30323810,30323932,30323969,30324184,30324252,30324290,30324366,30324438,30324513,30324549,30324694,30324813,30324953,30324997,30325039,30325310,30325358,30325396,30325428,30325597,30325691,30326073,30326113,30326205,30326388,30326654,30326707,3032680', 'assoc_port': '30284295:30286035,30284297:30285960,30284299:30285889,30284301:30285851,30284303:30285780,30284306:30285666,30284308:30285706,30284310:30285563,30284312:30284407,30284315:30285481,30284316:30285382,30284321:30285450,30284324:30285238,30284326:30285273,30284329:30285093,30284333:30285052,30284336:30284946,30284338:30285020,30284340:30284365,30286527:30286539,30286650:30286664,30295936:30296700,30295938:30296731,30295940:30296546,30295942:30296582,30295944:30296658,30295946:30296506,30295948:30296404,30295950:30296477,30295952:30296294,30295954:30296444,30295956:30296371,30295958:30296263,30295960:30296328,30295963:30295979,30295965:30296220,30295967:30296191,30295969:30296133,30295971:30296090,30295972:30296059,30295973:30296029,30297611:30297628,30304497:30304656,30304498:30304985,30304499:30305239,30304500:30305125,30304501:30305081,30304502:30305017,30304503:30305161,30304504:30304950,30304505:30304842,30304506:30305203,30304507:30304877,30304508:30304903,30304509:30305056,30304510:30304759,30304511:3030473', 'assoc_mat': '30284295:papier:4230:30286035,30284297:papier:4230:30285960,30284299:papier:4230:30285889,30284301:papier:4230:30285851,30284303:papier:4230:30285780,30284306:papier:4230:30285666,30284308:papier:4230:30285706,30284310:papier:4230:30285563,30284312:papier:4230:30284407,30284315:papier:4230:30285481,30284316:papier:4230:30285382,30284321:papier:4230:30285450,30284324:papier:4230:30285238,30284326:papier:4230:30285273,30284329:papier:4230:30285093,30284333:papier:4230:30285052,30284336:papier:4230:30284946,30284338:papier:4230:30285020,30284340:papier:4230:30284365,30286527:papier:4230:30286539,30286650:papier:4230:30286664,30295936:papier:4230:30296700,30295938:papier:4230:30296731,30295940:papier:4230:30296546,30295942:papier:4230:30296582,30295944:papier:4230:30296658,30295946:papier:4230:30296506,30295948:papier:4230:30296404,30295950:papier:4230:30296477,30295952:papier:4230:30296294,30295954:papier:4230:30296444,30295956:papier:4230:30296371,30295958:papier:4230:30296263,30295960:papier:4230:30296328,3029'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028005455879661282, 'nb_photo': 1020, 'list_port_cont': '30284404,30285095,30285551,30296224,30296333,30296362,30296433,30296516,30296578,30296732,30304689,30304728,30304762,30304776,30304870,30304910,30305054,30305085,30305167,30305196,30305229,30312429,30312455,30312502,30312541,30312582,30312614,30312692,30312760,30312777,30312833,30312978,30313090,30313824,30323799,30323935,30323967,30324185,30324257,30324288,30324365,30324433,30324512,30324547,30324695,30324809,30324955,30325002,30325033,30325364,30325400,30325438,30325598,30325693,30326075,30326389,30326657,30326700,30326807,30326947,30327704,30328094,30328643,30328719,30329517,30329976,30330404,30330892,30330994,30331203,30333150,30334368,30334645,30335427,30336243,30337496,30338268,30339538,30339586,30341084,30344400,30344651,30345196,30345344,30345380,30346069,30352234,30352382,30352561,30352667,30352923,30352994,30353623,30358459,30358498,30360142,30360210,30360289,30360327,30360362,30360434,30360810,30360842,30360914,30360951,30361682,30368057,30368167,30368492,30368563,30368600,30369088,30369139,3036927', 'assoc_port': '30284310:30285551,30284312:30284404,30284329:30285095,30295938:30296732,30295942:30296578,30295946:30296516,30295954:30296433,30295956:30296362,30295960:30296333,30295965:30296224,30304499:30305229,30304501:30305085,30304503:30305167,30304506:30305196,30304507:30304870,30304508:30304910,30304509:30305054,30304510:30304762,30304511:30304728,30304512:30304776,30304515:30304689,30312240:30313090,30312254:30312760,30312258:30312978,30312260:30312582,30312262:30312777,30312264:30312614,30312265:30312692,30312266:30312502,30312267:30312833,30312268:30312455,30312269:30312541,30312270:30312429,30313807:30313824,30323292:30324433,30323295:30324955,30323301:30325598,30323304:30325364,30323307:30325400,30323310:30325438,30323313:30325033,30323316:30325002,30323319:30324809,30323322:30324695,30323325:30324547,30323328:30324512,30323331:30324365,30323334:30324257,30323337:30323967,30323338:30324288,30323343:30324185,30323347:30323935,30323351:30323799,30325680:30325693,30326005:30326075,30326365:30326389,30326593:3032665', 'assoc_mat': '30284310:pehd:4230:30285551,30284312:pehd:4230:30284404,30284329:pehd:4230:30285095,30295938:pehd:4230:30296732,30295942:pehd:4230:30296578,30295946:pehd:4230:30296516,30295954:pehd:4230:30296433,30295956:pehd:4230:30296362,30295960:pehd:4230:30296333,30295965:pehd:4230:30296224,30304499:pehd:4230:30305229,30304501:pehd:4230:30305085,30304503:pehd:4230:30305167,30304506:pehd:4230:30305196,30304507:pehd:4230:30304870,30304508:pehd:4230:30304910,30304509:pehd:4230:30305054,30304510:pehd:4230:30304762,30304511:pehd:4230:30304728,30304512:pehd:4230:30304776,30304515:pehd:4230:30304689,30312240:pehd:4230:30313090,30312254:pehd:4230:30312760,30312258:pehd:4230:30312978,30312260:pehd:4230:30312582,30312262:pehd:4230:30312777,30312264:pehd:4230:30312614,30312265:pehd:4230:30312692,30312266:pehd:4230:30312502,30312267:pehd:4230:30312833,30312268:pehd:4230:30312455,30312269:pehd:4230:30312541,30312270:pehd:4230:30312429,30313807:pehd:4230:30313824,30323292:pehd:4230:30324433,30323295:pehd:4230:30324955,30323301:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.018447126375513878, 'nb_photo': 20295, 'list_port_cont': '30284364,30284396,30284945,30285022,30285048,30285091,30285237,30285276,30285384,30285447,30285488,30285559,30285670,30285695,30285776,30285850,30285885,30285965,30286032,30286546,30286663,30295989,30296022,30296058,30296095,30296126,30296181,30296227,30296261,30296287,30296334,30296370,30296403,30296441,30296479,30296517,30296541,30296586,30296664,30296698,30296734,30297616,30304567,30304613,30304653,30304693,30304732,30304761,30304783,30304833,30304867,30304913,30304947,30304980,30305019,30305058,30305091,30305128,30305165,30305192,30305235,30305448,30306207,30312287,30312402,30312434,30312453,30312506,30312546,30312576,30312620,30312645,30312683,30312752,30312778,30312836,30312867,30312886,30312941,30312980,30313011,30313050,30313092,30313825,30313956,30323712,30323802,30323929,30323971,30324176,30324250,30324285,30324363,30324432,30324514,30324546,30324697,30324812,30324966,30325004,30325036,30325309,30325361,30325392,30325437,30325599,30325698,30326071,30326108,30326199,30326395,30326652,30326693,3032679', 'assoc_port': '30284295:30286032,30284297:30285965,30284299:30285885,30284301:30285850,30284303:30285776,30284306:30285670,30284308:30285695,30284310:30285559,30284312:30284396,30284315:30285488,30284316:30285384,30284321:30285447,30284324:30285237,30284326:30285276,30284329:30285091,30284333:30285048,30284336:30284945,30284338:30285022,30284340:30284364,30286527:30286546,30286650:30286663,30295936:30296698,30295938:30296734,30295940:30296541,30295942:30296586,30295944:30296664,30295946:30296517,30295948:30296403,30295950:30296479,30295952:30296287,30295954:30296441,30295956:30296370,30295958:30296261,30295960:30296334,30295963:30295989,30295965:30296227,30295967:30296181,30295969:30296126,30295971:30296095,30295972:30296058,30295973:30296022,30297611:30297616,30304497:30304653,30304498:30304980,30304499:30305235,30304500:30305128,30304501:30305091,30304502:30305019,30304503:30305165,30304504:30304947,30304505:30304833,30304506:30305192,30304507:30304867,30304508:30304913,30304509:30305058,30304510:30304761,30304511:3030473', 'assoc_mat': '30284295:pet_clair:4230:30286032,30284297:pet_clair:4230:30285965,30284299:pet_clair:4230:30285885,30284301:pet_clair:4230:30285850,30284303:pet_clair:4230:30285776,30284306:pet_clair:4230:30285670,30284308:pet_clair:4230:30285695,30284310:pet_clair:4230:30285559,30284312:pet_clair:4230:30284396,30284315:pet_clair:4230:30285488,30284316:pet_clair:4230:30285384,30284321:pet_clair:4230:30285447,30284324:pet_clair:4230:30285237,30284326:pet_clair:4230:30285276,30284329:pet_clair:4230:30285091,30284333:pet_clair:4230:30285048,30284336:pet_clair:4230:30284945,30284338:pet_clair:4230:30285022,30284340:pet_clair:4230:30284364,30286527:pet_clair:4230:30286546,30286650:pet_clair:4230:30286663,30295936:pet_clair:4230:30296698,30295938:pet_clair:4230:30296734,30295940:pet_clair:4230:30296541,30295942:pet_clair:4230:30296586,30295944:pet_clair:4230:30296664,30295946:pet_clair:4230:30296517,30295948:pet_clair:4230:30296403,30295950:pet_clair:4230:30296479,30295952:pet_clair:4230:30296287,30295954:pet_clair:4230:30296441,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0029251602335128753, 'nb_photo': 585, 'list_port_cont': '30284403,30284949,30285023,30285383,30285446,30285564,30285775,30285846,30285963,30286547,30296368,30296439,30296511,30296583,30296652,30296695,30296730,30304660,30304694,30304829,30304902,30305055,30305094,30305162,30305204,30312283,30312447,30312507,30312545,30312579,30312617,30312687,30312761,30312776,30312826,30312945,30312977,30313955,30323719,30323806,30324253,30324289,30324367,30324437,30324548,30324690,30324962,30325000,30325302,30325355,30325393,30325433,30325595,30326076,30326104,30326393,30326655,30326800,30326993,30327707,30328703,30329511,30329968,30330407,30330898,30332660,30332725,30333151,30334652,30334862,30336251,30339527,30341094,30344317,30344399,30344432,30344652,30345204,30345230,30345351,30345377,30352062,30352236,30352389,30352564,30352670,30352686,30352748,30352788,30352852,30352918,30353000,30358460,30359883,30360143,30360211,30360278,30360323,30360358,30360431,30360507,30360638,30360805,30360886,30366610,30368495,30368594,30368624,30368680,30369069,30369150,30369306,30369419,3036962', 'assoc_port': '30284297:30285963,30284301:30285846,30284303:30285775,30284310:30285564,30284312:30284403,30284316:30285383,30284321:30285446,30284336:30284949,30284338:30285023,30286527:30286547,30295936:30296695,30295938:30296730,30295942:30296583,30295944:30296652,30295946:30296511,30295954:30296439,30295956:30296368,30304497:30304660,30304501:30305094,30304503:30305162,30304505:30304829,30304506:30305204,30304508:30304902,30304509:30305055,30304515:30304694,30312254:30312761,30312256:30312945,30312258:30312977,30312260:30312579,30312262:30312776,30312264:30312617,30312265:30312687,30312266:30312507,30312267:30312826,30312268:30312447,30312269:30312545,30312272:30312283,30313941:30313955,30323292:30324437,30323295:30324962,30323298:30325302,30323301:30325595,30323304:30325355,30323307:30325393,30323310:30325433,30323316:30325000,30323322:30324690,30323325:30324548,30323331:30324367,30323334:30324253,30323338:30324289,30323345:30323719,30323351:30323806,30326004:30326104,30326005:30326076,30326365:30326393,30326593:3032665', 'assoc_mat': '30284297:pet_fonce:4230:30285963,30284301:pet_fonce:4230:30285846,30284303:pet_fonce:4230:30285775,30284310:pet_fonce:4230:30285564,30284312:pet_fonce:4230:30284403,30284316:pet_fonce:4230:30285383,30284321:pet_fonce:4230:30285446,30284336:pet_fonce:4230:30284949,30284338:pet_fonce:4230:30285023,30286527:pet_fonce:4230:30286547,30295936:pet_fonce:4230:30296695,30295938:pet_fonce:4230:30296730,30295942:pet_fonce:4230:30296583,30295944:pet_fonce:4230:30296652,30295946:pet_fonce:4230:30296511,30295954:pet_fonce:4230:30296439,30295956:pet_fonce:4230:30296368,30304497:pet_fonce:4230:30304660,30304501:pet_fonce:4230:30305094,30304503:pet_fonce:4230:30305162,30304505:pet_fonce:4230:30304829,30304506:pet_fonce:4230:30305204,30304508:pet_fonce:4230:30304902,30304509:pet_fonce:4230:30305055,30304515:pet_fonce:4230:30304694,30312254:pet_fonce:4230:30312761,30312256:pet_fonce:4230:30312945,30312258:pet_fonce:4230:30312977,30312260:pet_fonce:4230:30312579,30312262:pet_fonce:4230:30312776,30312264:pet_fonce:4230:30312617,3'}), 'main_stat': {'nb_photos': 1493}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30496538,30496539,30496540,30496541,30496542,30496543,30496544?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-02', 0.7660132380024866),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_02_annee_2026.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.41%', 13664], 'carton': ['carton', '3.82%', 64161], 'metal': ['metal', '0.11%', 1371], 'papier': ['papier', '17.41%', 213953], 'pehd': ['pehd', '0.28%', 1020], 'pet_clair': ['pet_clair', '1.84%', 20295], 'pet_fonce': ['pet_fonce', '0.29%', 585]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_02_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.37user 2.71system 0:07.06elapsed 72%CPU (0avgtext+0avgdata 182544maxresident)k 8inputs+304outputs (1major+48565minor)pagefaults 0swaps