python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-06 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (6, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (6, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 203 month : 06 mtr_id : dashboard_places : SCCU_cam8 date : 2025-06 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam8' and date like '%2025-06%') and created_at like '%2025-06%'))); nb_day : (6, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 203 and month(ded.date) = 06 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______incineration' and ded.dashboard_place_id = 203 and month(ded.date) = 06 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 203 and mp.name like '%062025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-06-01 : dt_date_just_month_year : 2025-06-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam8" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-06-01" AND ded.date <= "2025-06-30" apple3 {'incineration': {'mat': 'incineration', 'pht': 4230, 'datou_carac_id': 4234, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1862599,1866480,1870976,1873058,1878466,1884729,1887901,1893002,1896974,1900232,1903351,1907900,1909902,1910821,1913554,1915961,1918605,1921321,1924877,1926451,1926700,1927308,1928653,1937303,1940056,1940583,1944933) 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.02363889412515608, 'nb_photo': 19022, 'list_port_cont': '23519998,23520032,23520103,23520148,23520199,23520204,23520285,23520323,23520368,23520405,23520440,23520508,23520546,23520569,23520608,23520681,23520723,23520765,23520791,23520879,23520932,23521150,23522498,23522830,23568031,23568110,23569702,23569855,23569922,23570022,23570058,23570175,23570249,23570292,23570374,23570413,23570475,23570592,23570647,23570691,23570849,23570899,23570939,23570967,23571017,23571117,23571311,23572237,23613844,23615698,23619896,23620096,23621016,23621082,23621148,23621267,23621360,23621386,23621469,23621586,23621597,23621713,23621769,23621941,23621992,23622080,23622181,23622262,23622346,23622699,23622738,23622882,23622923,23622960,23623134,23623259,23623365,23626268,23629432,23630813,23632972,23635740,23641292,23641656,23641817,23642549,23644387,23644468,23646224,23649060,23651084,23651122,23651195,23651256,23651328,23654704,23705514,23705708,23705764,23705806,23705964,23706027,23706220,23706358,23706418,23706440,23706504,23706598,23706827,23749694,23749723,23749831,23749933,2375010', 'assoc_port': '23519905:23520723,23519910:23520879,23519914:23520765,23519918:23521150,23519923:23520932,23519926:23520681,23519931:23520508,23519935:23520569,23519939:23520791,23519942:23520608,23519943:23520440,23519944:23520368,23519945:23520204,23519946:23520405,23519947:23520546,23519948:23520323,23519949:23520199,23519950:23520103,23519951:23519998,23519952:23520032,23519953:23520148,23519954:23520285,23522491:23522498,23522699:23522830,23567565:23571311,23567567:23571117,23567579:23571017,23567583:23570967,23567585:23570899,23567589:23570647,23567591:23570939,23567606:23570691,23567621:23570849,23567624:23570475,23567628:23570374,23567630:23570175,23567632:23570249,23567634:23570413,23567636:23570292,23567639:23570058,23567640:23569855,23567642:23569922,23567645:23568031,23567646:23570022,23567649:23569702,23567667:23568110,23570269:23570592,23572187:23572237,23613742:23613844,23615526:23615698,23619453:23620096,23619454:23619896,23620412:23622923,23620415:23623259,23620418:23623365,23620421:23622882,23620425:2362269', 'assoc_mat': '23519905:autre:4230:23520723,23519910:autre:4230:23520879,23519914:autre:4230:23520765,23519918:autre:4230:23521150,23519923:autre:4230:23520932,23519926:autre:4230:23520681,23519931:autre:4230:23520508,23519935:autre:4230:23520569,23519939:autre:4230:23520791,23519942:autre:4230:23520608,23519943:autre:4230:23520440,23519944:autre:4230:23520368,23519945:autre:4230:23520204,23519946:autre:4230:23520405,23519947:autre:4230:23520546,23519948:autre:4230:23520323,23519949:autre:4230:23520199,23519950:autre:4230:23520103,23519951:autre:4230:23519998,23519952:autre:4230:23520032,23519953:autre:4230:23520148,23519954:autre:4230:23520285,23522491:autre:4230:23522498,23522699:autre:4230:23522830,23567565:autre:4230:23571311,23567567:autre:4230:23571117,23567579:autre:4230:23571017,23567583:autre:4230:23570967,23567585:autre:4230:23570899,23567589:autre:4230:23570647,23567591:autre:4230:23570939,23567606:autre:4230:23570691,23567621:autre:4230:23570849,23567624:autre:4230:23570475,23567628:autre:4230:23570374,23567630:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.09169215082503135, 'nb_photo': 110353, 'list_port_cont': '23520008,23520044,23520117,23520151,23520198,23520202,23520288,23520333,23520362,23520398,23520441,23520507,23520547,23520581,23520617,23520690,23520718,23520759,23520801,23520901,23520942,23521158,23522501,23522836,23568029,23568123,23569703,23569848,23569918,23570031,23570072,23570185,23570239,23570296,23570382,23570429,23570480,23570595,23570636,23570702,23570851,23570900,23570941,23570977,23571004,23571127,23571318,23572238,23613847,23615702,23619907,23620095,23621021,23621074,23621149,23621272,23621368,23621387,23621478,23621577,23621600,23621718,23621765,23621937,23621985,23622082,23622173,23622259,23622327,23622706,23622739,23622897,23622934,23622970,23623138,23623255,23623374,23626267,23629435,23630815,23632984,23635736,23641286,23641651,23641815,23642552,23644388,23644472,23646217,23649054,23651077,23651131,23651201,23651251,23651330,23654702,23705509,23705724,23705767,23705802,23705974,23706033,23706223,23706368,23706423,23706446,23706510,23706595,23706832,23749698,23749738,23749845,23749942,2375012', 'assoc_port': '23519905:23520718,23519910:23520901,23519914:23520759,23519918:23521158,23519923:23520942,23519926:23520690,23519931:23520507,23519935:23520581,23519939:23520801,23519942:23520617,23519943:23520441,23519944:23520362,23519945:23520198,23519946:23520398,23519947:23520547,23519948:23520333,23519949:23520202,23519950:23520117,23519951:23520008,23519952:23520044,23519953:23520151,23519954:23520288,23522491:23522501,23522699:23522836,23567565:23571318,23567567:23571127,23567579:23571004,23567583:23570977,23567585:23570900,23567589:23570636,23567591:23570941,23567606:23570702,23567621:23570851,23567624:23570480,23567628:23570382,23567630:23570185,23567632:23570239,23567634:23570429,23567636:23570296,23567639:23570072,23567640:23569848,23567642:23569918,23567645:23568029,23567646:23570031,23567649:23569703,23567667:23568123,23570269:23570595,23572187:23572238,23613742:23613847,23615526:23615702,23619453:23620095,23619454:23619907,23620412:23622934,23620415:23623255,23620418:23623374,23620421:23622897,23620425:2362270', 'assoc_mat': '23519905:carton:4230:23520718,23519910:carton:4230:23520901,23519914:carton:4230:23520759,23519918:carton:4230:23521158,23519923:carton:4230:23520942,23519926:carton:4230:23520690,23519931:carton:4230:23520507,23519935:carton:4230:23520581,23519939:carton:4230:23520801,23519942:carton:4230:23520617,23519943:carton:4230:23520441,23519944:carton:4230:23520362,23519945:carton:4230:23520198,23519946:carton:4230:23520398,23519947:carton:4230:23520547,23519948:carton:4230:23520333,23519949:carton:4230:23520202,23519950:carton:4230:23520117,23519951:carton:4230:23520008,23519952:carton:4230:23520044,23519953:carton:4230:23520151,23519954:carton:4230:23520288,23522491:carton:4230:23522501,23522699:carton:4230:23522836,23567565:carton:4230:23571318,23567567:carton:4230:23571127,23567579:carton:4230:23571004,23567583:carton:4230:23570977,23567585:carton:4230:23570900,23567589:carton:4230:23570636,23567591:carton:4230:23570941,23567606:carton:4230:23570702,23567621:carton:4230:23570851,23567624:carton:4230:23570480,2356'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00178684398573594, 'nb_photo': 2246, 'list_port_cont': '23520046,23520102,23520140,23520214,23520295,23520370,23520384,23520439,23520535,23520582,23520604,23520715,23520763,23520800,23520909,23520933,23522500,23522839,23568111,23569701,23569850,23570032,23570073,23570186,23570233,23570287,23570385,23570427,23570479,23570901,23571312,23615689,23619902,23620094,23621077,23621140,23621379,23621477,23621587,23621608,23621726,23621770,23621932,23622073,23622344,23622703,23622742,23622958,23623133,23626245,23629440,23630816,23632988,23635724,23641294,23641640,23641812,23642544,23644386,23644467,23651075,23651137,23651209,23651257,23651319,23705505,23705709,23705753,23705793,23705962,23706037,23706219,23706441,23706592,23749683,23749740,23750112,23750210,23750403,23750493,23750536,23751338,23751566,23755626,23756122,23756268,23756430,23756561,23756610,23756649,23756760,23756824,23756870,23756943,23756952,23756970,23757074,23757118,23757164,23757190,23757247,23757357,23757396,23764144,23765417,23768188,23770969,23772241,23774341,23777090,23779126,23782032,23784714,2378717', 'assoc_port': '23519905:23520715,23519910:23520909,23519914:23520763,23519923:23520933,23519935:23520582,23519939:23520800,23519942:23520604,23519943:23520439,23519944:23520370,23519946:23520384,23519947:23520535,23519949:23520214,23519950:23520102,23519952:23520046,23519953:23520140,23519954:23520295,23522491:23522500,23522699:23522839,23567565:23571312,23567585:23570901,23567624:23570479,23567628:23570385,23567630:23570186,23567632:23570233,23567634:23570427,23567636:23570287,23567639:23570073,23567640:23569850,23567646:23570032,23567649:23569701,23567667:23568111,23615526:23615689,23619453:23620094,23619454:23619902,23620425:23622703,23620428:23623133,23620431:23622958,23620433:23622344,23620461:23622073,23620476:23621932,23620489:23621608,23620490:23621770,23620493:23621726,23620495:23621477,23620497:23621587,23620500:23621140,23620503:23621379,23620504:23621077,23621968:23622742,23625623:23626245,23628746:23629440,23630656:23630816,23632611:23632988,23635198:23635724,23639555:23641812,23639556:23641640,23639557:2364438', 'assoc_mat': '23519905:metal:4230:23520715,23519910:metal:4230:23520909,23519914:metal:4230:23520763,23519923:metal:4230:23520933,23519935:metal:4230:23520582,23519939:metal:4230:23520800,23519942:metal:4230:23520604,23519943:metal:4230:23520439,23519944:metal:4230:23520370,23519946:metal:4230:23520384,23519947:metal:4230:23520535,23519949:metal:4230:23520214,23519950:metal:4230:23520102,23519952:metal:4230:23520046,23519953:metal:4230:23520140,23519954:metal:4230:23520295,23522491:metal:4230:23522500,23522699:metal:4230:23522839,23567565:metal:4230:23571312,23567585:metal:4230:23570901,23567624:metal:4230:23570479,23567628:metal:4230:23570385,23567630:metal:4230:23570186,23567632:metal:4230:23570233,23567634:metal:4230:23570427,23567636:metal:4230:23570287,23567639:metal:4230:23570073,23567640:metal:4230:23569850,23567646:metal:4230:23570032,23567649:metal:4230:23569701,23567667:metal:4230:23568111,23615526:metal:4230:23615689,23619453:metal:4230:23620094,23619454:metal:4230:23619902,23620425:metal:4230:23622703,23620428:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.24438767444089954, 'nb_photo': 373276, 'list_port_cont': '23520009,23520030,23520110,23520152,23520184,23520201,23520291,23520324,23520363,23520403,23520435,23520509,23520545,23520584,23520616,23520678,23520722,23520753,23520798,23520899,23520943,23521155,23522510,23522829,23568021,23568120,23569712,23569844,23569913,23570029,23570075,23570173,23570243,23570299,23570384,23570428,23570482,23570588,23570645,23570698,23570840,23570904,23570943,23570976,23571012,23571116,23571313,23572242,23613843,23615705,23619906,23620093,23621019,23621078,23621151,23621271,23621364,23621381,23621476,23621580,23621606,23621719,23621771,23621935,23621976,23622086,23622175,23622257,23622329,23622704,23622744,23622890,23622927,23622968,23623140,23623268,23623370,23626266,23629446,23630808,23632985,23635732,23641280,23641653,23641818,23642550,23644385,23644457,23646225,23649058,23651082,23651129,23651202,23651252,23651331,23654700,23705513,23705719,23705755,23705805,23705978,23706041,23706215,23706374,23706432,23706442,23706518,23706597,23706844,23749693,23749741,23749840,23749941,2375011', 'assoc_port': '23519905:23520722,23519910:23520899,23519914:23520753,23519918:23521155,23519923:23520943,23519926:23520678,23519931:23520509,23519935:23520584,23519939:23520798,23519942:23520616,23519943:23520435,23519944:23520363,23519945:23520201,23519946:23520403,23519947:23520545,23519948:23520324,23519949:23520184,23519950:23520110,23519951:23520009,23519952:23520030,23519953:23520152,23519954:23520291,23522491:23522510,23522699:23522829,23567565:23571313,23567567:23571116,23567579:23571012,23567583:23570976,23567585:23570904,23567589:23570645,23567591:23570943,23567606:23570698,23567621:23570840,23567624:23570482,23567628:23570384,23567630:23570173,23567632:23570243,23567634:23570428,23567636:23570299,23567639:23570075,23567640:23569844,23567642:23569913,23567645:23568021,23567646:23570029,23567649:23569712,23567667:23568120,23570269:23570588,23572187:23572242,23613742:23613843,23615526:23615705,23619453:23620093,23619454:23619906,23620412:23622927,23620415:23623268,23620418:23623370,23620421:23622890,23620425:2362270', 'assoc_mat': '23519905:papier:4230:23520722,23519910:papier:4230:23520899,23519914:papier:4230:23520753,23519918:papier:4230:23521155,23519923:papier:4230:23520943,23519926:papier:4230:23520678,23519931:papier:4230:23520509,23519935:papier:4230:23520584,23519939:papier:4230:23520798,23519942:papier:4230:23520616,23519943:papier:4230:23520435,23519944:papier:4230:23520363,23519945:papier:4230:23520201,23519946:papier:4230:23520403,23519947:papier:4230:23520545,23519948:papier:4230:23520324,23519949:papier:4230:23520184,23519950:papier:4230:23520110,23519951:papier:4230:23520009,23519952:papier:4230:23520030,23519953:papier:4230:23520152,23519954:papier:4230:23520291,23522491:papier:4230:23522510,23522699:papier:4230:23522829,23567565:papier:4230:23571313,23567567:papier:4230:23571116,23567579:papier:4230:23571012,23567583:papier:4230:23570976,23567585:papier:4230:23570904,23567589:papier:4230:23570645,23567591:papier:4230:23570943,23567606:papier:4230:23570698,23567621:papier:4230:23570840,23567624:papier:4230:23570482,2356'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006940816044582928, 'nb_photo': 2774, 'list_port_cont': '23519994,23520113,23520144,23520189,23520329,23520366,23520378,23520438,23520549,23520580,23520618,23520686,23520761,23520796,23520903,23520947,23521160,23522504,23568034,23568121,23569711,23569846,23569927,23570023,23570071,23570182,23570245,23570301,23570422,23570585,23570850,23570978,23571010,23571126,23571307,23572248,23619911,23621008,23621369,23621581,23621603,23621725,23621775,23621943,23621986,23622084,23622179,23622261,23622343,23622701,23622746,23622896,23622933,23622967,23623139,23623262,23623371,23626249,23629438,23630806,23632987,23635737,23641655,23641816,23646222,23649059,23705510,23705796,23705968,23706032,23706212,23749836,23749944,23750200,23750350,23750416,23750545,23751581,23756127,23756651,23756835,23756944,23756947,23756968,23757078,23757129,23757159,23757191,23757248,23757364,23757405,23764151,23765406,23767028,23769633,23787189,23791746,23795427,23796946,23797118,23797446,23797513,23797734,23824654,23825221,23825539,23826240,23826283,23826376,23827175,23827290,23827337,23827371,2382754', 'assoc_port': '23519910:23520903,23519914:23520761,23519918:23521160,23519923:23520947,23519926:23520686,23519935:23520580,23519939:23520796,23519942:23520618,23519943:23520438,23519944:23520366,23519945:23520189,23519946:23520378,23519947:23520549,23519948:23520329,23519950:23520113,23519951:23519994,23519953:23520144,23522491:23522504,23567565:23571307,23567567:23571126,23567579:23571010,23567583:23570978,23567621:23570850,23567630:23570182,23567632:23570245,23567634:23570422,23567636:23570301,23567639:23570071,23567640:23569846,23567642:23569927,23567645:23568034,23567646:23570023,23567649:23569711,23567667:23568121,23570269:23570585,23572187:23572248,23619454:23619911,23620412:23622933,23620415:23623262,23620418:23623371,23620421:23622896,23620425:23622701,23620428:23623139,23620431:23622967,23620433:23622343,23620448:23622261,23620461:23622084,23620462:23622179,23620476:23621943,23620489:23621603,23620490:23621775,23620492:23621986,23620493:23621725,23620496:23621369,23620497:23621581,23620502:23621008,23621968:2362274', 'assoc_mat': '23519910:pehd:4230:23520903,23519914:pehd:4230:23520761,23519918:pehd:4230:23521160,23519923:pehd:4230:23520947,23519926:pehd:4230:23520686,23519935:pehd:4230:23520580,23519939:pehd:4230:23520796,23519942:pehd:4230:23520618,23519943:pehd:4230:23520438,23519944:pehd:4230:23520366,23519945:pehd:4230:23520189,23519946:pehd:4230:23520378,23519947:pehd:4230:23520549,23519948:pehd:4230:23520329,23519950:pehd:4230:23520113,23519951:pehd:4230:23519994,23519953:pehd:4230:23520144,23522491:pehd:4230:23522504,23567565:pehd:4230:23571307,23567567:pehd:4230:23571126,23567579:pehd:4230:23571010,23567583:pehd:4230:23570978,23567621:pehd:4230:23570850,23567630:pehd:4230:23570182,23567632:pehd:4230:23570245,23567634:pehd:4230:23570422,23567636:pehd:4230:23570301,23567639:pehd:4230:23570071,23567640:pehd:4230:23569846,23567642:pehd:4230:23569927,23567645:pehd:4230:23568034,23567646:pehd:4230:23570023,23567649:pehd:4230:23569711,23567667:pehd:4230:23568121,23570269:pehd:4230:23570585,23572187:pehd:4230:23572248,23619454:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01027364838437848, 'nb_photo': 20461, 'list_port_cont': '23520005,23520035,23520115,23520153,23520181,23520213,23520298,23520327,23520369,23520386,23520437,23520505,23520542,23520583,23520614,23520685,23520728,23520764,23520790,23520910,23520945,23521156,23522509,23522842,23568033,23568114,23569709,23569857,23569910,23570030,23570068,23570187,23570247,23570298,23570375,23570424,23570485,23570584,23570640,23570701,23570842,23570907,23570946,23570972,23571015,23571123,23571317,23572241,23613849,23615701,23619909,23620085,23621017,23621084,23621146,23621269,23621353,23621376,23621483,23621589,23621607,23621723,23621764,23621938,23621990,23622076,23622178,23622260,23622336,23622705,23622745,23622894,23622929,23622955,23623128,23623264,23623373,23626265,23629439,23630812,23632986,23635742,23641288,23641654,23641822,23642543,23644379,23644463,23646221,23649046,23651083,23651138,23651204,23651242,23651325,23654706,23705515,23705717,23705769,23705804,23705977,23706040,23706209,23706372,23706429,23706445,23706516,23706588,23706831,23749686,23749728,23749843,23749945,2375011', 'assoc_port': '23519905:23520728,23519910:23520910,23519914:23520764,23519918:23521156,23519923:23520945,23519926:23520685,23519931:23520505,23519935:23520583,23519939:23520790,23519942:23520614,23519943:23520437,23519944:23520369,23519945:23520213,23519946:23520386,23519947:23520542,23519948:23520327,23519949:23520181,23519950:23520115,23519951:23520005,23519952:23520035,23519953:23520153,23519954:23520298,23522491:23522509,23522699:23522842,23567565:23571317,23567567:23571123,23567579:23571015,23567583:23570972,23567585:23570907,23567589:23570640,23567591:23570946,23567606:23570701,23567621:23570842,23567624:23570485,23567628:23570375,23567630:23570187,23567632:23570247,23567634:23570424,23567636:23570298,23567639:23570068,23567640:23569857,23567642:23569910,23567645:23568033,23567646:23570030,23567649:23569709,23567667:23568114,23570269:23570584,23572187:23572241,23613742:23613849,23615526:23615701,23619453:23620085,23619454:23619909,23620412:23622929,23620415:23623264,23620418:23623373,23620421:23622894,23620425:2362270', 'assoc_mat': '23519905:pet_clair:4230:23520728,23519910:pet_clair:4230:23520910,23519914:pet_clair:4230:23520764,23519918:pet_clair:4230:23521156,23519923:pet_clair:4230:23520945,23519926:pet_clair:4230:23520685,23519931:pet_clair:4230:23520505,23519935:pet_clair:4230:23520583,23519939:pet_clair:4230:23520790,23519942:pet_clair:4230:23520614,23519943:pet_clair:4230:23520437,23519944:pet_clair:4230:23520369,23519945:pet_clair:4230:23520213,23519946:pet_clair:4230:23520386,23519947:pet_clair:4230:23520542,23519948:pet_clair:4230:23520327,23519949:pet_clair:4230:23520181,23519950:pet_clair:4230:23520115,23519951:pet_clair:4230:23520005,23519952:pet_clair:4230:23520035,23519953:pet_clair:4230:23520153,23519954:pet_clair:4230:23520298,23522491:pet_clair:4230:23522509,23522699:pet_clair:4230:23522842,23567565:pet_clair:4230:23571317,23567567:pet_clair:4230:23571123,23567579:pet_clair:4230:23571015,23567583:pet_clair:4230:23570972,23567585:pet_clair:4230:23570907,23567589:pet_clair:4230:23570640,23567591:pet_clair:4230:23570946,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003316893681534689, 'nb_photo': 806, 'list_port_cont': '23520045,23520361,23520539,23520620,23520687,23520760,23520897,23520944,23522838,23568023,23569707,23569926,23570174,23570381,23570426,23570594,23570844,23572243,23620086,23621080,23621362,23621378,23621473,23621717,23621776,23621931,23621989,23622079,23622172,23622253,23622747,23622925,23623141,23626269,23629447,23630809,23632980,23641284,23641819,23642555,23644471,23649057,23651207,23654707,23705502,23705718,23705768,23705808,23706036,23706373,23706594,23706843,23749940,23751580,23756393,23756606,23756650,23756836,23756871,23756948,23756953,23756975,23757089,23757128,23757163,23757194,23757365,23757500,23764148,23777091,23784733,23787187,23795426,23797732,23797887,23798312,23825534,23825657,23826287,23826969,23829211,23880741,23880800,23881051,23881134,23881189,23881256,23881514,23881549,23881559,23881624,23881664,23901138,23920111,23921626,23922803,23922926,23923012,23923216,23923289,23923324,23923380,23923464,23923516,23923568,23923613,23923753,23923802,23923874,23954017,23957198,23960846,23967658,2396787', 'assoc_port': '23519910:23520897,23519914:23520760,23519923:23520944,23519926:23520687,23519942:23520620,23519944:23520361,23519947:23520539,23519952:23520045,23522699:23522838,23567621:23570844,23567628:23570381,23567630:23570174,23567634:23570426,23567642:23569926,23567645:23568023,23567649:23569707,23570269:23570594,23572187:23572243,23619453:23620086,23620412:23622925,23620428:23623141,23620448:23622253,23620461:23622079,23620462:23622172,23620476:23621931,23620490:23621776,23620492:23621989,23620493:23621717,23620495:23621473,23620496:23621362,23620503:23621378,23620504:23621080,23621968:23622747,23625623:23626269,23628746:23629447,23630656:23630809,23632611:23632980,23639555:23641819,23639558:23641284,23642236:23642555,23644085:23644471,23645589:23651207,23648496:23649057,23651229:23654707,23705219:23706373,23705224:23706843,23705226:23706594,23705257:23705768,23705263:23706036,23705265:23705718,23705270:23705808,23705273:23705502,23749599:23749940,23751462:23751580,23755567:23757365,23755569:23757128,23755570:2375719', 'assoc_mat': '23519910:pet_fonce:4230:23520897,23519914:pet_fonce:4230:23520760,23519923:pet_fonce:4230:23520944,23519926:pet_fonce:4230:23520687,23519942:pet_fonce:4230:23520620,23519944:pet_fonce:4230:23520361,23519947:pet_fonce:4230:23520539,23519952:pet_fonce:4230:23520045,23522699:pet_fonce:4230:23522838,23567621:pet_fonce:4230:23570844,23567628:pet_fonce:4230:23570381,23567630:pet_fonce:4230:23570174,23567634:pet_fonce:4230:23570426,23567642:pet_fonce:4230:23569926,23567645:pet_fonce:4230:23568023,23567649:pet_fonce:4230:23569707,23570269:pet_fonce:4230:23570594,23572187:pet_fonce:4230:23572243,23619453:pet_fonce:4230:23620086,23620412:pet_fonce:4230:23622925,23620428:pet_fonce:4230:23623141,23620448:pet_fonce:4230:23622253,23620461:pet_fonce:4230:23622079,23620462:pet_fonce:4230:23622172,23620476:pet_fonce:4230:23621931,23620490:pet_fonce:4230:23621776,23620492:pet_fonce:4230:23621989,23620493:pet_fonce:4230:23621717,23620495:pet_fonce:4230:23621473,23620496:pet_fonce:4230:23621362,23620503:pet_fonce:4230:23621378,2'}) select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(1862599,1866480,1870976,1873058,1878466,1884729,1887901,1893002,1896974,1900232,1903351,1907900,1909902,1910821,1913554,1915961,1918605,1921321,1924877,1926451,1926700,1927308,1928653,1937303,1940056,1940583,1944933)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=203 and date >='2025-06-01' and date <= '2025-06-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1671,),), 'unwanted_material_monthly_percentage': ((0.6647268003597339,),), 'material_repartition': (('incineration', 1671),), 'material_dict': {'incineration': 1671}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 6, 1), 0.7762426887007059, 59), (datetime.date(2025, 6, 2), 0.7475896376377249, 72), (datetime.date(2025, 6, 3), 0.769815254502648, 72), (datetime.date(2025, 6, 4), 0.7444678440792307, 78), (datetime.date(2025, 6, 5), 0.7882234314108081, 43), (datetime.date(2025, 6, 7), 0.737004984754395, 35), (datetime.date(2025, 6, 8), 0.789743578472673, 73), (datetime.date(2025, 6, 9), 0.8143180915731109, 77), (datetime.date(2025, 6, 10), 0.7948533921386319, 77), (datetime.date(2025, 6, 11), 0.7164717008861279, 75), (datetime.date(2025, 6, 12), 0.6402572780335191, 83), (datetime.date(2025, 6, 13), 0.6098771222330214, 76), (datetime.date(2025, 6, 14), 0.4778416071828962, 78), (datetime.date(2025, 6, 15), 0.4233990965082236, 68), (datetime.date(2025, 6, 16), 0.6139730303997855, 27), (datetime.date(2025, 6, 17), 0.6789241695253222, 69), (datetime.date(2025, 6, 18), 0.5655885733964616, 13), (datetime.date(2025, 6, 19), 0.6381436423203732, 27), (datetime.date(2025, 6, 20), 0.5703996936812757, 84), (datetime.date(2025, 6, 21), 0.5899991901644813, 87), (datetime.date(2025, 6, 22), 0.5943741929523109, 88), (datetime.date(2025, 6, 23), 0.5627740987787593, 69), (datetime.date(2025, 6, 24), 0.47677876934139046, 47), (datetime.date(2025, 6, 27), 0.4742011204094025, 10), (datetime.date(2025, 6, 28), 0.5785814251036887, 41), (datetime.date(2025, 6, 29), 0.7235582320114031, 73), (datetime.date(2025, 6, 30), 0.790538261177359, 70)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 6, 1), 0.7762426887007059, 59), (datetime.date(2025, 6, 2), 0.7475896376377249, 72), (datetime.date(2025, 6, 3), 0.769815254502648, 72), (datetime.date(2025, 6, 4), 0.7444678440792307, 78), (datetime.date(2025, 6, 5), 0.7882234314108081, 43), (datetime.date(2025, 6, 7), 0.737004984754395, 35), (datetime.date(2025, 6, 8), 0.789743578472673, 73), (datetime.date(2025, 6, 9), 0.8143180915731109, 77), (datetime.date(2025, 6, 10), 0.7948533921386319, 77), (datetime.date(2025, 6, 11), 0.7164717008861279, 75), (datetime.date(2025, 6, 12), 0.6402572780335191, 83), (datetime.date(2025, 6, 13), 0.6098771222330214, 76), (datetime.date(2025, 6, 14), 0.4778416071828962, 78), (datetime.date(2025, 6, 15), 0.4233990965082236, 68), (datetime.date(2025, 6, 16), 0.6139730303997855, 27), (datetime.date(2025, 6, 17), 0.6789241695253222, 69), (datetime.date(2025, 6, 18), 0.5655885733964616, 13), (datetime.date(2025, 6, 19), 0.6381436423203732, 27), (datetime.date(2025, 6, 20), 0.5703996936812757, 84), (datetime.date(2025, 6, 21), 0.5899991901644813, 87), (datetime.date(2025, 6, 22), 0.5943741929523109, 88), (datetime.date(2025, 6, 23), 0.5627740987787593, 69), (datetime.date(2025, 6, 24), 0.47677876934139046, 47), (datetime.date(2025, 6, 27), 0.4742011204094025, 10), (datetime.date(2025, 6, 28), 0.5785814251036887, 41), (datetime.date(2025, 6, 29), 0.7235582320114031, 73), (datetime.date(2025, 6, 30), 0.790538261177359, 70))}, 'quality_array': [['-8.33871447354743', '01062025'], ['-8.29721657756702', '02062025'], ['-8.256911496024427', '03062025'], ['-8.494599508302983', '04062025'], ['-8.514828159071087', '05062025'], ['-8.596670944424451', '07062025'], ['-8.7360162683929', '08062025'], ['-8.158620788068704', '09062025'], ['-7.868432145743764', '10062025'], ['-8.053167662795339', '11062025'], ['-8.587637591943572', '12062025'], ['-9.00600258714606', '13062025'], ['-8.927731593679656', '14062025'], ['-8.711659133421112', '15062025'], ['-8.679332750573995', '16062025'], ['-8.689364671109258', '17062025'], ['-8.739430332080087', '18062025'], ['-9.146312977020687', '19062025'], ['-9.20946880953978', '20062025'], ['-9.18415509634738', '21062025'], ['-9.235003466044272', '22062025'], ['-9.176402145360841', '23062025'], ['-9.129607916249983', '24062025'], ['-9.507093473934109', '27062025'], ['-9.431232603562647', '28062025'], ['-9.14477740001722', '29062025'], ['-8.60711638947335', '30062025']], 'number_of_batch': ((538,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02363889412515608, 'nb_photo': 19022, 'list_port_cont': '23519998,23520032,23520103,23520148,23520199,23520204,23520285,23520323,23520368,23520405,23520440,23520508,23520546,23520569,23520608,23520681,23520723,23520765,23520791,23520879,23520932,23521150,23522498,23522830,23568031,23568110,23569702,23569855,23569922,23570022,23570058,23570175,23570249,23570292,23570374,23570413,23570475,23570592,23570647,23570691,23570849,23570899,23570939,23570967,23571017,23571117,23571311,23572237,23613844,23615698,23619896,23620096,23621016,23621082,23621148,23621267,23621360,23621386,23621469,23621586,23621597,23621713,23621769,23621941,23621992,23622080,23622181,23622262,23622346,23622699,23622738,23622882,23622923,23622960,23623134,23623259,23623365,23626268,23629432,23630813,23632972,23635740,23641292,23641656,23641817,23642549,23644387,23644468,23646224,23649060,23651084,23651122,23651195,23651256,23651328,23654704,23705514,23705708,23705764,23705806,23705964,23706027,23706220,23706358,23706418,23706440,23706504,23706598,23706827,23749694,23749723,23749831,23749933,2375010', 'assoc_port': '23519905:23520723,23519910:23520879,23519914:23520765,23519918:23521150,23519923:23520932,23519926:23520681,23519931:23520508,23519935:23520569,23519939:23520791,23519942:23520608,23519943:23520440,23519944:23520368,23519945:23520204,23519946:23520405,23519947:23520546,23519948:23520323,23519949:23520199,23519950:23520103,23519951:23519998,23519952:23520032,23519953:23520148,23519954:23520285,23522491:23522498,23522699:23522830,23567565:23571311,23567567:23571117,23567579:23571017,23567583:23570967,23567585:23570899,23567589:23570647,23567591:23570939,23567606:23570691,23567621:23570849,23567624:23570475,23567628:23570374,23567630:23570175,23567632:23570249,23567634:23570413,23567636:23570292,23567639:23570058,23567640:23569855,23567642:23569922,23567645:23568031,23567646:23570022,23567649:23569702,23567667:23568110,23570269:23570592,23572187:23572237,23613742:23613844,23615526:23615698,23619453:23620096,23619454:23619896,23620412:23622923,23620415:23623259,23620418:23623365,23620421:23622882,23620425:2362269', 'assoc_mat': '23519905:autre:4230:23520723,23519910:autre:4230:23520879,23519914:autre:4230:23520765,23519918:autre:4230:23521150,23519923:autre:4230:23520932,23519926:autre:4230:23520681,23519931:autre:4230:23520508,23519935:autre:4230:23520569,23519939:autre:4230:23520791,23519942:autre:4230:23520608,23519943:autre:4230:23520440,23519944:autre:4230:23520368,23519945:autre:4230:23520204,23519946:autre:4230:23520405,23519947:autre:4230:23520546,23519948:autre:4230:23520323,23519949:autre:4230:23520199,23519950:autre:4230:23520103,23519951:autre:4230:23519998,23519952:autre:4230:23520032,23519953:autre:4230:23520148,23519954:autre:4230:23520285,23522491:autre:4230:23522498,23522699:autre:4230:23522830,23567565:autre:4230:23571311,23567567:autre:4230:23571117,23567579:autre:4230:23571017,23567583:autre:4230:23570967,23567585:autre:4230:23570899,23567589:autre:4230:23570647,23567591:autre:4230:23570939,23567606:autre:4230:23570691,23567621:autre:4230:23570849,23567624:autre:4230:23570475,23567628:autre:4230:23570374,23567630:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.09169215082503135, 'nb_photo': 110353, 'list_port_cont': '23520008,23520044,23520117,23520151,23520198,23520202,23520288,23520333,23520362,23520398,23520441,23520507,23520547,23520581,23520617,23520690,23520718,23520759,23520801,23520901,23520942,23521158,23522501,23522836,23568029,23568123,23569703,23569848,23569918,23570031,23570072,23570185,23570239,23570296,23570382,23570429,23570480,23570595,23570636,23570702,23570851,23570900,23570941,23570977,23571004,23571127,23571318,23572238,23613847,23615702,23619907,23620095,23621021,23621074,23621149,23621272,23621368,23621387,23621478,23621577,23621600,23621718,23621765,23621937,23621985,23622082,23622173,23622259,23622327,23622706,23622739,23622897,23622934,23622970,23623138,23623255,23623374,23626267,23629435,23630815,23632984,23635736,23641286,23641651,23641815,23642552,23644388,23644472,23646217,23649054,23651077,23651131,23651201,23651251,23651330,23654702,23705509,23705724,23705767,23705802,23705974,23706033,23706223,23706368,23706423,23706446,23706510,23706595,23706832,23749698,23749738,23749845,23749942,2375012', 'assoc_port': '23519905:23520718,23519910:23520901,23519914:23520759,23519918:23521158,23519923:23520942,23519926:23520690,23519931:23520507,23519935:23520581,23519939:23520801,23519942:23520617,23519943:23520441,23519944:23520362,23519945:23520198,23519946:23520398,23519947:23520547,23519948:23520333,23519949:23520202,23519950:23520117,23519951:23520008,23519952:23520044,23519953:23520151,23519954:23520288,23522491:23522501,23522699:23522836,23567565:23571318,23567567:23571127,23567579:23571004,23567583:23570977,23567585:23570900,23567589:23570636,23567591:23570941,23567606:23570702,23567621:23570851,23567624:23570480,23567628:23570382,23567630:23570185,23567632:23570239,23567634:23570429,23567636:23570296,23567639:23570072,23567640:23569848,23567642:23569918,23567645:23568029,23567646:23570031,23567649:23569703,23567667:23568123,23570269:23570595,23572187:23572238,23613742:23613847,23615526:23615702,23619453:23620095,23619454:23619907,23620412:23622934,23620415:23623255,23620418:23623374,23620421:23622897,23620425:2362270', 'assoc_mat': '23519905:carton:4230:23520718,23519910:carton:4230:23520901,23519914:carton:4230:23520759,23519918:carton:4230:23521158,23519923:carton:4230:23520942,23519926:carton:4230:23520690,23519931:carton:4230:23520507,23519935:carton:4230:23520581,23519939:carton:4230:23520801,23519942:carton:4230:23520617,23519943:carton:4230:23520441,23519944:carton:4230:23520362,23519945:carton:4230:23520198,23519946:carton:4230:23520398,23519947:carton:4230:23520547,23519948:carton:4230:23520333,23519949:carton:4230:23520202,23519950:carton:4230:23520117,23519951:carton:4230:23520008,23519952:carton:4230:23520044,23519953:carton:4230:23520151,23519954:carton:4230:23520288,23522491:carton:4230:23522501,23522699:carton:4230:23522836,23567565:carton:4230:23571318,23567567:carton:4230:23571127,23567579:carton:4230:23571004,23567583:carton:4230:23570977,23567585:carton:4230:23570900,23567589:carton:4230:23570636,23567591:carton:4230:23570941,23567606:carton:4230:23570702,23567621:carton:4230:23570851,23567624:carton:4230:23570480,2356'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00178684398573594, 'nb_photo': 2246, 'list_port_cont': '23520046,23520102,23520140,23520214,23520295,23520370,23520384,23520439,23520535,23520582,23520604,23520715,23520763,23520800,23520909,23520933,23522500,23522839,23568111,23569701,23569850,23570032,23570073,23570186,23570233,23570287,23570385,23570427,23570479,23570901,23571312,23615689,23619902,23620094,23621077,23621140,23621379,23621477,23621587,23621608,23621726,23621770,23621932,23622073,23622344,23622703,23622742,23622958,23623133,23626245,23629440,23630816,23632988,23635724,23641294,23641640,23641812,23642544,23644386,23644467,23651075,23651137,23651209,23651257,23651319,23705505,23705709,23705753,23705793,23705962,23706037,23706219,23706441,23706592,23749683,23749740,23750112,23750210,23750403,23750493,23750536,23751338,23751566,23755626,23756122,23756268,23756430,23756561,23756610,23756649,23756760,23756824,23756870,23756943,23756952,23756970,23757074,23757118,23757164,23757190,23757247,23757357,23757396,23764144,23765417,23768188,23770969,23772241,23774341,23777090,23779126,23782032,23784714,2378717', 'assoc_port': '23519905:23520715,23519910:23520909,23519914:23520763,23519923:23520933,23519935:23520582,23519939:23520800,23519942:23520604,23519943:23520439,23519944:23520370,23519946:23520384,23519947:23520535,23519949:23520214,23519950:23520102,23519952:23520046,23519953:23520140,23519954:23520295,23522491:23522500,23522699:23522839,23567565:23571312,23567585:23570901,23567624:23570479,23567628:23570385,23567630:23570186,23567632:23570233,23567634:23570427,23567636:23570287,23567639:23570073,23567640:23569850,23567646:23570032,23567649:23569701,23567667:23568111,23615526:23615689,23619453:23620094,23619454:23619902,23620425:23622703,23620428:23623133,23620431:23622958,23620433:23622344,23620461:23622073,23620476:23621932,23620489:23621608,23620490:23621770,23620493:23621726,23620495:23621477,23620497:23621587,23620500:23621140,23620503:23621379,23620504:23621077,23621968:23622742,23625623:23626245,23628746:23629440,23630656:23630816,23632611:23632988,23635198:23635724,23639555:23641812,23639556:23641640,23639557:2364438', 'assoc_mat': '23519905:metal:4230:23520715,23519910:metal:4230:23520909,23519914:metal:4230:23520763,23519923:metal:4230:23520933,23519935:metal:4230:23520582,23519939:metal:4230:23520800,23519942:metal:4230:23520604,23519943:metal:4230:23520439,23519944:metal:4230:23520370,23519946:metal:4230:23520384,23519947:metal:4230:23520535,23519949:metal:4230:23520214,23519950:metal:4230:23520102,23519952:metal:4230:23520046,23519953:metal:4230:23520140,23519954:metal:4230:23520295,23522491:metal:4230:23522500,23522699:metal:4230:23522839,23567565:metal:4230:23571312,23567585:metal:4230:23570901,23567624:metal:4230:23570479,23567628:metal:4230:23570385,23567630:metal:4230:23570186,23567632:metal:4230:23570233,23567634:metal:4230:23570427,23567636:metal:4230:23570287,23567639:metal:4230:23570073,23567640:metal:4230:23569850,23567646:metal:4230:23570032,23567649:metal:4230:23569701,23567667:metal:4230:23568111,23615526:metal:4230:23615689,23619453:metal:4230:23620094,23619454:metal:4230:23619902,23620425:metal:4230:23622703,23620428:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.24438767444089954, 'nb_photo': 373276, 'list_port_cont': '23520009,23520030,23520110,23520152,23520184,23520201,23520291,23520324,23520363,23520403,23520435,23520509,23520545,23520584,23520616,23520678,23520722,23520753,23520798,23520899,23520943,23521155,23522510,23522829,23568021,23568120,23569712,23569844,23569913,23570029,23570075,23570173,23570243,23570299,23570384,23570428,23570482,23570588,23570645,23570698,23570840,23570904,23570943,23570976,23571012,23571116,23571313,23572242,23613843,23615705,23619906,23620093,23621019,23621078,23621151,23621271,23621364,23621381,23621476,23621580,23621606,23621719,23621771,23621935,23621976,23622086,23622175,23622257,23622329,23622704,23622744,23622890,23622927,23622968,23623140,23623268,23623370,23626266,23629446,23630808,23632985,23635732,23641280,23641653,23641818,23642550,23644385,23644457,23646225,23649058,23651082,23651129,23651202,23651252,23651331,23654700,23705513,23705719,23705755,23705805,23705978,23706041,23706215,23706374,23706432,23706442,23706518,23706597,23706844,23749693,23749741,23749840,23749941,2375011', 'assoc_port': '23519905:23520722,23519910:23520899,23519914:23520753,23519918:23521155,23519923:23520943,23519926:23520678,23519931:23520509,23519935:23520584,23519939:23520798,23519942:23520616,23519943:23520435,23519944:23520363,23519945:23520201,23519946:23520403,23519947:23520545,23519948:23520324,23519949:23520184,23519950:23520110,23519951:23520009,23519952:23520030,23519953:23520152,23519954:23520291,23522491:23522510,23522699:23522829,23567565:23571313,23567567:23571116,23567579:23571012,23567583:23570976,23567585:23570904,23567589:23570645,23567591:23570943,23567606:23570698,23567621:23570840,23567624:23570482,23567628:23570384,23567630:23570173,23567632:23570243,23567634:23570428,23567636:23570299,23567639:23570075,23567640:23569844,23567642:23569913,23567645:23568021,23567646:23570029,23567649:23569712,23567667:23568120,23570269:23570588,23572187:23572242,23613742:23613843,23615526:23615705,23619453:23620093,23619454:23619906,23620412:23622927,23620415:23623268,23620418:23623370,23620421:23622890,23620425:2362270', 'assoc_mat': '23519905:papier:4230:23520722,23519910:papier:4230:23520899,23519914:papier:4230:23520753,23519918:papier:4230:23521155,23519923:papier:4230:23520943,23519926:papier:4230:23520678,23519931:papier:4230:23520509,23519935:papier:4230:23520584,23519939:papier:4230:23520798,23519942:papier:4230:23520616,23519943:papier:4230:23520435,23519944:papier:4230:23520363,23519945:papier:4230:23520201,23519946:papier:4230:23520403,23519947:papier:4230:23520545,23519948:papier:4230:23520324,23519949:papier:4230:23520184,23519950:papier:4230:23520110,23519951:papier:4230:23520009,23519952:papier:4230:23520030,23519953:papier:4230:23520152,23519954:papier:4230:23520291,23522491:papier:4230:23522510,23522699:papier:4230:23522829,23567565:papier:4230:23571313,23567567:papier:4230:23571116,23567579:papier:4230:23571012,23567583:papier:4230:23570976,23567585:papier:4230:23570904,23567589:papier:4230:23570645,23567591:papier:4230:23570943,23567606:papier:4230:23570698,23567621:papier:4230:23570840,23567624:papier:4230:23570482,2356'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006940816044582928, 'nb_photo': 2774, 'list_port_cont': '23519994,23520113,23520144,23520189,23520329,23520366,23520378,23520438,23520549,23520580,23520618,23520686,23520761,23520796,23520903,23520947,23521160,23522504,23568034,23568121,23569711,23569846,23569927,23570023,23570071,23570182,23570245,23570301,23570422,23570585,23570850,23570978,23571010,23571126,23571307,23572248,23619911,23621008,23621369,23621581,23621603,23621725,23621775,23621943,23621986,23622084,23622179,23622261,23622343,23622701,23622746,23622896,23622933,23622967,23623139,23623262,23623371,23626249,23629438,23630806,23632987,23635737,23641655,23641816,23646222,23649059,23705510,23705796,23705968,23706032,23706212,23749836,23749944,23750200,23750350,23750416,23750545,23751581,23756127,23756651,23756835,23756944,23756947,23756968,23757078,23757129,23757159,23757191,23757248,23757364,23757405,23764151,23765406,23767028,23769633,23787189,23791746,23795427,23796946,23797118,23797446,23797513,23797734,23824654,23825221,23825539,23826240,23826283,23826376,23827175,23827290,23827337,23827371,2382754', 'assoc_port': '23519910:23520903,23519914:23520761,23519918:23521160,23519923:23520947,23519926:23520686,23519935:23520580,23519939:23520796,23519942:23520618,23519943:23520438,23519944:23520366,23519945:23520189,23519946:23520378,23519947:23520549,23519948:23520329,23519950:23520113,23519951:23519994,23519953:23520144,23522491:23522504,23567565:23571307,23567567:23571126,23567579:23571010,23567583:23570978,23567621:23570850,23567630:23570182,23567632:23570245,23567634:23570422,23567636:23570301,23567639:23570071,23567640:23569846,23567642:23569927,23567645:23568034,23567646:23570023,23567649:23569711,23567667:23568121,23570269:23570585,23572187:23572248,23619454:23619911,23620412:23622933,23620415:23623262,23620418:23623371,23620421:23622896,23620425:23622701,23620428:23623139,23620431:23622967,23620433:23622343,23620448:23622261,23620461:23622084,23620462:23622179,23620476:23621943,23620489:23621603,23620490:23621775,23620492:23621986,23620493:23621725,23620496:23621369,23620497:23621581,23620502:23621008,23621968:2362274', 'assoc_mat': '23519910:pehd:4230:23520903,23519914:pehd:4230:23520761,23519918:pehd:4230:23521160,23519923:pehd:4230:23520947,23519926:pehd:4230:23520686,23519935:pehd:4230:23520580,23519939:pehd:4230:23520796,23519942:pehd:4230:23520618,23519943:pehd:4230:23520438,23519944:pehd:4230:23520366,23519945:pehd:4230:23520189,23519946:pehd:4230:23520378,23519947:pehd:4230:23520549,23519948:pehd:4230:23520329,23519950:pehd:4230:23520113,23519951:pehd:4230:23519994,23519953:pehd:4230:23520144,23522491:pehd:4230:23522504,23567565:pehd:4230:23571307,23567567:pehd:4230:23571126,23567579:pehd:4230:23571010,23567583:pehd:4230:23570978,23567621:pehd:4230:23570850,23567630:pehd:4230:23570182,23567632:pehd:4230:23570245,23567634:pehd:4230:23570422,23567636:pehd:4230:23570301,23567639:pehd:4230:23570071,23567640:pehd:4230:23569846,23567642:pehd:4230:23569927,23567645:pehd:4230:23568034,23567646:pehd:4230:23570023,23567649:pehd:4230:23569711,23567667:pehd:4230:23568121,23570269:pehd:4230:23570585,23572187:pehd:4230:23572248,23619454:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01027364838437848, 'nb_photo': 20461, 'list_port_cont': '23520005,23520035,23520115,23520153,23520181,23520213,23520298,23520327,23520369,23520386,23520437,23520505,23520542,23520583,23520614,23520685,23520728,23520764,23520790,23520910,23520945,23521156,23522509,23522842,23568033,23568114,23569709,23569857,23569910,23570030,23570068,23570187,23570247,23570298,23570375,23570424,23570485,23570584,23570640,23570701,23570842,23570907,23570946,23570972,23571015,23571123,23571317,23572241,23613849,23615701,23619909,23620085,23621017,23621084,23621146,23621269,23621353,23621376,23621483,23621589,23621607,23621723,23621764,23621938,23621990,23622076,23622178,23622260,23622336,23622705,23622745,23622894,23622929,23622955,23623128,23623264,23623373,23626265,23629439,23630812,23632986,23635742,23641288,23641654,23641822,23642543,23644379,23644463,23646221,23649046,23651083,23651138,23651204,23651242,23651325,23654706,23705515,23705717,23705769,23705804,23705977,23706040,23706209,23706372,23706429,23706445,23706516,23706588,23706831,23749686,23749728,23749843,23749945,2375011', 'assoc_port': '23519905:23520728,23519910:23520910,23519914:23520764,23519918:23521156,23519923:23520945,23519926:23520685,23519931:23520505,23519935:23520583,23519939:23520790,23519942:23520614,23519943:23520437,23519944:23520369,23519945:23520213,23519946:23520386,23519947:23520542,23519948:23520327,23519949:23520181,23519950:23520115,23519951:23520005,23519952:23520035,23519953:23520153,23519954:23520298,23522491:23522509,23522699:23522842,23567565:23571317,23567567:23571123,23567579:23571015,23567583:23570972,23567585:23570907,23567589:23570640,23567591:23570946,23567606:23570701,23567621:23570842,23567624:23570485,23567628:23570375,23567630:23570187,23567632:23570247,23567634:23570424,23567636:23570298,23567639:23570068,23567640:23569857,23567642:23569910,23567645:23568033,23567646:23570030,23567649:23569709,23567667:23568114,23570269:23570584,23572187:23572241,23613742:23613849,23615526:23615701,23619453:23620085,23619454:23619909,23620412:23622929,23620415:23623264,23620418:23623373,23620421:23622894,23620425:2362270', 'assoc_mat': '23519905:pet_clair:4230:23520728,23519910:pet_clair:4230:23520910,23519914:pet_clair:4230:23520764,23519918:pet_clair:4230:23521156,23519923:pet_clair:4230:23520945,23519926:pet_clair:4230:23520685,23519931:pet_clair:4230:23520505,23519935:pet_clair:4230:23520583,23519939:pet_clair:4230:23520790,23519942:pet_clair:4230:23520614,23519943:pet_clair:4230:23520437,23519944:pet_clair:4230:23520369,23519945:pet_clair:4230:23520213,23519946:pet_clair:4230:23520386,23519947:pet_clair:4230:23520542,23519948:pet_clair:4230:23520327,23519949:pet_clair:4230:23520181,23519950:pet_clair:4230:23520115,23519951:pet_clair:4230:23520005,23519952:pet_clair:4230:23520035,23519953:pet_clair:4230:23520153,23519954:pet_clair:4230:23520298,23522491:pet_clair:4230:23522509,23522699:pet_clair:4230:23522842,23567565:pet_clair:4230:23571317,23567567:pet_clair:4230:23571123,23567579:pet_clair:4230:23571015,23567583:pet_clair:4230:23570972,23567585:pet_clair:4230:23570907,23567589:pet_clair:4230:23570640,23567591:pet_clair:4230:23570946,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003316893681534689, 'nb_photo': 806, 'list_port_cont': '23520045,23520361,23520539,23520620,23520687,23520760,23520897,23520944,23522838,23568023,23569707,23569926,23570174,23570381,23570426,23570594,23570844,23572243,23620086,23621080,23621362,23621378,23621473,23621717,23621776,23621931,23621989,23622079,23622172,23622253,23622747,23622925,23623141,23626269,23629447,23630809,23632980,23641284,23641819,23642555,23644471,23649057,23651207,23654707,23705502,23705718,23705768,23705808,23706036,23706373,23706594,23706843,23749940,23751580,23756393,23756606,23756650,23756836,23756871,23756948,23756953,23756975,23757089,23757128,23757163,23757194,23757365,23757500,23764148,23777091,23784733,23787187,23795426,23797732,23797887,23798312,23825534,23825657,23826287,23826969,23829211,23880741,23880800,23881051,23881134,23881189,23881256,23881514,23881549,23881559,23881624,23881664,23901138,23920111,23921626,23922803,23922926,23923012,23923216,23923289,23923324,23923380,23923464,23923516,23923568,23923613,23923753,23923802,23923874,23954017,23957198,23960846,23967658,2396787', 'assoc_port': '23519910:23520897,23519914:23520760,23519923:23520944,23519926:23520687,23519942:23520620,23519944:23520361,23519947:23520539,23519952:23520045,23522699:23522838,23567621:23570844,23567628:23570381,23567630:23570174,23567634:23570426,23567642:23569926,23567645:23568023,23567649:23569707,23570269:23570594,23572187:23572243,23619453:23620086,23620412:23622925,23620428:23623141,23620448:23622253,23620461:23622079,23620462:23622172,23620476:23621931,23620490:23621776,23620492:23621989,23620493:23621717,23620495:23621473,23620496:23621362,23620503:23621378,23620504:23621080,23621968:23622747,23625623:23626269,23628746:23629447,23630656:23630809,23632611:23632980,23639555:23641819,23639558:23641284,23642236:23642555,23644085:23644471,23645589:23651207,23648496:23649057,23651229:23654707,23705219:23706373,23705224:23706843,23705226:23706594,23705257:23705768,23705263:23706036,23705265:23705718,23705270:23705808,23705273:23705502,23749599:23749940,23751462:23751580,23755567:23757365,23755569:23757128,23755570:2375719', 'assoc_mat': '23519910:pet_fonce:4230:23520897,23519914:pet_fonce:4230:23520760,23519923:pet_fonce:4230:23520944,23519926:pet_fonce:4230:23520687,23519942:pet_fonce:4230:23520620,23519944:pet_fonce:4230:23520361,23519947:pet_fonce:4230:23520539,23519952:pet_fonce:4230:23520045,23522699:pet_fonce:4230:23522838,23567621:pet_fonce:4230:23570844,23567628:pet_fonce:4230:23570381,23567630:pet_fonce:4230:23570174,23567634:pet_fonce:4230:23570426,23567642:pet_fonce:4230:23569926,23567645:pet_fonce:4230:23568023,23567649:pet_fonce:4230:23569707,23570269:pet_fonce:4230:23570594,23572187:pet_fonce:4230:23572243,23619453:pet_fonce:4230:23620086,23620412:pet_fonce:4230:23622925,23620428:pet_fonce:4230:23623141,23620448:pet_fonce:4230:23622253,23620461:pet_fonce:4230:23622079,23620462:pet_fonce:4230:23622172,23620476:pet_fonce:4230:23621931,23620490:pet_fonce:4230:23621776,23620492:pet_fonce:4230:23621989,23620493:pet_fonce:4230:23621717,23620495:pet_fonce:4230:23621473,23620496:pet_fonce:4230:23621362,23620503:pet_fonce:4230:23621378,2'}), 'main_stat': {'nb_photos': 1671}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-06', 0.6647268003597339),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1671,),), 'unwanted_material_monthly_percentage': ((0.6647268003597339,),), 'material_repartition': (('incineration', 1671),), 'material_dict': {'incineration': 1671}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 6, 1), 0.7762426887007059, 59), (datetime.date(2025, 6, 2), 0.7475896376377249, 72), (datetime.date(2025, 6, 3), 0.769815254502648, 72), (datetime.date(2025, 6, 4), 0.7444678440792307, 78), (datetime.date(2025, 6, 5), 0.7882234314108081, 43), (datetime.date(2025, 6, 7), 0.737004984754395, 35), (datetime.date(2025, 6, 8), 0.789743578472673, 73), (datetime.date(2025, 6, 9), 0.8143180915731109, 77), (datetime.date(2025, 6, 10), 0.7948533921386319, 77), (datetime.date(2025, 6, 11), 0.7164717008861279, 75), (datetime.date(2025, 6, 12), 0.6402572780335191, 83), (datetime.date(2025, 6, 13), 0.6098771222330214, 76), (datetime.date(2025, 6, 14), 0.4778416071828962, 78), (datetime.date(2025, 6, 15), 0.4233990965082236, 68), (datetime.date(2025, 6, 16), 0.6139730303997855, 27), (datetime.date(2025, 6, 17), 0.6789241695253222, 69), (datetime.date(2025, 6, 18), 0.5655885733964616, 13), (datetime.date(2025, 6, 19), 0.6381436423203732, 27), (datetime.date(2025, 6, 20), 0.5703996936812757, 84), (datetime.date(2025, 6, 21), 0.5899991901644813, 87), (datetime.date(2025, 6, 22), 0.5943741929523109, 88), (datetime.date(2025, 6, 23), 0.5627740987787593, 69), (datetime.date(2025, 6, 24), 0.47677876934139046, 47), (datetime.date(2025, 6, 27), 0.4742011204094025, 10), (datetime.date(2025, 6, 28), 0.5785814251036887, 41), (datetime.date(2025, 6, 29), 0.7235582320114031, 73), (datetime.date(2025, 6, 30), 0.790538261177359, 70)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 6, 1), 0.7762426887007059, 59), (datetime.date(2025, 6, 2), 0.7475896376377249, 72), (datetime.date(2025, 6, 3), 0.769815254502648, 72), (datetime.date(2025, 6, 4), 0.7444678440792307, 78), (datetime.date(2025, 6, 5), 0.7882234314108081, 43), (datetime.date(2025, 6, 7), 0.737004984754395, 35), (datetime.date(2025, 6, 8), 0.789743578472673, 73), (datetime.date(2025, 6, 9), 0.8143180915731109, 77), (datetime.date(2025, 6, 10), 0.7948533921386319, 77), (datetime.date(2025, 6, 11), 0.7164717008861279, 75), (datetime.date(2025, 6, 12), 0.6402572780335191, 83), (datetime.date(2025, 6, 13), 0.6098771222330214, 76), (datetime.date(2025, 6, 14), 0.4778416071828962, 78), (datetime.date(2025, 6, 15), 0.4233990965082236, 68), (datetime.date(2025, 6, 16), 0.6139730303997855, 27), (datetime.date(2025, 6, 17), 0.6789241695253222, 69), (datetime.date(2025, 6, 18), 0.5655885733964616, 13), (datetime.date(2025, 6, 19), 0.6381436423203732, 27), (datetime.date(2025, 6, 20), 0.5703996936812757, 84), (datetime.date(2025, 6, 21), 0.5899991901644813, 87), (datetime.date(2025, 6, 22), 0.5943741929523109, 88), (datetime.date(2025, 6, 23), 0.5627740987787593, 69), (datetime.date(2025, 6, 24), 0.47677876934139046, 47), (datetime.date(2025, 6, 27), 0.4742011204094025, 10), (datetime.date(2025, 6, 28), 0.5785814251036887, 41), (datetime.date(2025, 6, 29), 0.7235582320114031, 73), (datetime.date(2025, 6, 30), 0.790538261177359, 70))}, 'quality_array': [['-8.33871447354743', '01062025'], ['-8.29721657756702', '02062025'], ['-8.256911496024427', '03062025'], ['-8.494599508302983', '04062025'], ['-8.514828159071087', '05062025'], ['-8.596670944424451', '07062025'], ['-8.7360162683929', '08062025'], ['-8.158620788068704', '09062025'], ['-7.868432145743764', '10062025'], ['-8.053167662795339', '11062025'], ['-8.587637591943572', '12062025'], ['-9.00600258714606', '13062025'], ['-8.927731593679656', '14062025'], ['-8.711659133421112', '15062025'], ['-8.679332750573995', '16062025'], ['-8.689364671109258', '17062025'], ['-8.739430332080087', '18062025'], ['-9.146312977020687', '19062025'], ['-9.20946880953978', '20062025'], ['-9.18415509634738', '21062025'], ['-9.235003466044272', '22062025'], ['-9.176402145360841', '23062025'], ['-9.129607916249983', '24062025'], ['-9.507093473934109', '27062025'], ['-9.431232603562647', '28062025'], ['-9.14477740001722', '29062025'], ['-8.60711638947335', '30062025']], 'number_of_batch': ((538,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02363889412515608, 'nb_photo': 19022, 'list_port_cont': '23519998,23520032,23520103,23520148,23520199,23520204,23520285,23520323,23520368,23520405,23520440,23520508,23520546,23520569,23520608,23520681,23520723,23520765,23520791,23520879,23520932,23521150,23522498,23522830,23568031,23568110,23569702,23569855,23569922,23570022,23570058,23570175,23570249,23570292,23570374,23570413,23570475,23570592,23570647,23570691,23570849,23570899,23570939,23570967,23571017,23571117,23571311,23572237,23613844,23615698,23619896,23620096,23621016,23621082,23621148,23621267,23621360,23621386,23621469,23621586,23621597,23621713,23621769,23621941,23621992,23622080,23622181,23622262,23622346,23622699,23622738,23622882,23622923,23622960,23623134,23623259,23623365,23626268,23629432,23630813,23632972,23635740,23641292,23641656,23641817,23642549,23644387,23644468,23646224,23649060,23651084,23651122,23651195,23651256,23651328,23654704,23705514,23705708,23705764,23705806,23705964,23706027,23706220,23706358,23706418,23706440,23706504,23706598,23706827,23749694,23749723,23749831,23749933,2375010', 'assoc_port': '23519905:23520723,23519910:23520879,23519914:23520765,23519918:23521150,23519923:23520932,23519926:23520681,23519931:23520508,23519935:23520569,23519939:23520791,23519942:23520608,23519943:23520440,23519944:23520368,23519945:23520204,23519946:23520405,23519947:23520546,23519948:23520323,23519949:23520199,23519950:23520103,23519951:23519998,23519952:23520032,23519953:23520148,23519954:23520285,23522491:23522498,23522699:23522830,23567565:23571311,23567567:23571117,23567579:23571017,23567583:23570967,23567585:23570899,23567589:23570647,23567591:23570939,23567606:23570691,23567621:23570849,23567624:23570475,23567628:23570374,23567630:23570175,23567632:23570249,23567634:23570413,23567636:23570292,23567639:23570058,23567640:23569855,23567642:23569922,23567645:23568031,23567646:23570022,23567649:23569702,23567667:23568110,23570269:23570592,23572187:23572237,23613742:23613844,23615526:23615698,23619453:23620096,23619454:23619896,23620412:23622923,23620415:23623259,23620418:23623365,23620421:23622882,23620425:2362269', 'assoc_mat': '23519905:autre:4230:23520723,23519910:autre:4230:23520879,23519914:autre:4230:23520765,23519918:autre:4230:23521150,23519923:autre:4230:23520932,23519926:autre:4230:23520681,23519931:autre:4230:23520508,23519935:autre:4230:23520569,23519939:autre:4230:23520791,23519942:autre:4230:23520608,23519943:autre:4230:23520440,23519944:autre:4230:23520368,23519945:autre:4230:23520204,23519946:autre:4230:23520405,23519947:autre:4230:23520546,23519948:autre:4230:23520323,23519949:autre:4230:23520199,23519950:autre:4230:23520103,23519951:autre:4230:23519998,23519952:autre:4230:23520032,23519953:autre:4230:23520148,23519954:autre:4230:23520285,23522491:autre:4230:23522498,23522699:autre:4230:23522830,23567565:autre:4230:23571311,23567567:autre:4230:23571117,23567579:autre:4230:23571017,23567583:autre:4230:23570967,23567585:autre:4230:23570899,23567589:autre:4230:23570647,23567591:autre:4230:23570939,23567606:autre:4230:23570691,23567621:autre:4230:23570849,23567624:autre:4230:23570475,23567628:autre:4230:23570374,23567630:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.09169215082503135, 'nb_photo': 110353, 'list_port_cont': '23520008,23520044,23520117,23520151,23520198,23520202,23520288,23520333,23520362,23520398,23520441,23520507,23520547,23520581,23520617,23520690,23520718,23520759,23520801,23520901,23520942,23521158,23522501,23522836,23568029,23568123,23569703,23569848,23569918,23570031,23570072,23570185,23570239,23570296,23570382,23570429,23570480,23570595,23570636,23570702,23570851,23570900,23570941,23570977,23571004,23571127,23571318,23572238,23613847,23615702,23619907,23620095,23621021,23621074,23621149,23621272,23621368,23621387,23621478,23621577,23621600,23621718,23621765,23621937,23621985,23622082,23622173,23622259,23622327,23622706,23622739,23622897,23622934,23622970,23623138,23623255,23623374,23626267,23629435,23630815,23632984,23635736,23641286,23641651,23641815,23642552,23644388,23644472,23646217,23649054,23651077,23651131,23651201,23651251,23651330,23654702,23705509,23705724,23705767,23705802,23705974,23706033,23706223,23706368,23706423,23706446,23706510,23706595,23706832,23749698,23749738,23749845,23749942,2375012', 'assoc_port': '23519905:23520718,23519910:23520901,23519914:23520759,23519918:23521158,23519923:23520942,23519926:23520690,23519931:23520507,23519935:23520581,23519939:23520801,23519942:23520617,23519943:23520441,23519944:23520362,23519945:23520198,23519946:23520398,23519947:23520547,23519948:23520333,23519949:23520202,23519950:23520117,23519951:23520008,23519952:23520044,23519953:23520151,23519954:23520288,23522491:23522501,23522699:23522836,23567565:23571318,23567567:23571127,23567579:23571004,23567583:23570977,23567585:23570900,23567589:23570636,23567591:23570941,23567606:23570702,23567621:23570851,23567624:23570480,23567628:23570382,23567630:23570185,23567632:23570239,23567634:23570429,23567636:23570296,23567639:23570072,23567640:23569848,23567642:23569918,23567645:23568029,23567646:23570031,23567649:23569703,23567667:23568123,23570269:23570595,23572187:23572238,23613742:23613847,23615526:23615702,23619453:23620095,23619454:23619907,23620412:23622934,23620415:23623255,23620418:23623374,23620421:23622897,23620425:2362270', 'assoc_mat': '23519905:carton:4230:23520718,23519910:carton:4230:23520901,23519914:carton:4230:23520759,23519918:carton:4230:23521158,23519923:carton:4230:23520942,23519926:carton:4230:23520690,23519931:carton:4230:23520507,23519935:carton:4230:23520581,23519939:carton:4230:23520801,23519942:carton:4230:23520617,23519943:carton:4230:23520441,23519944:carton:4230:23520362,23519945:carton:4230:23520198,23519946:carton:4230:23520398,23519947:carton:4230:23520547,23519948:carton:4230:23520333,23519949:carton:4230:23520202,23519950:carton:4230:23520117,23519951:carton:4230:23520008,23519952:carton:4230:23520044,23519953:carton:4230:23520151,23519954:carton:4230:23520288,23522491:carton:4230:23522501,23522699:carton:4230:23522836,23567565:carton:4230:23571318,23567567:carton:4230:23571127,23567579:carton:4230:23571004,23567583:carton:4230:23570977,23567585:carton:4230:23570900,23567589:carton:4230:23570636,23567591:carton:4230:23570941,23567606:carton:4230:23570702,23567621:carton:4230:23570851,23567624:carton:4230:23570480,2356'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00178684398573594, 'nb_photo': 2246, 'list_port_cont': '23520046,23520102,23520140,23520214,23520295,23520370,23520384,23520439,23520535,23520582,23520604,23520715,23520763,23520800,23520909,23520933,23522500,23522839,23568111,23569701,23569850,23570032,23570073,23570186,23570233,23570287,23570385,23570427,23570479,23570901,23571312,23615689,23619902,23620094,23621077,23621140,23621379,23621477,23621587,23621608,23621726,23621770,23621932,23622073,23622344,23622703,23622742,23622958,23623133,23626245,23629440,23630816,23632988,23635724,23641294,23641640,23641812,23642544,23644386,23644467,23651075,23651137,23651209,23651257,23651319,23705505,23705709,23705753,23705793,23705962,23706037,23706219,23706441,23706592,23749683,23749740,23750112,23750210,23750403,23750493,23750536,23751338,23751566,23755626,23756122,23756268,23756430,23756561,23756610,23756649,23756760,23756824,23756870,23756943,23756952,23756970,23757074,23757118,23757164,23757190,23757247,23757357,23757396,23764144,23765417,23768188,23770969,23772241,23774341,23777090,23779126,23782032,23784714,2378717', 'assoc_port': '23519905:23520715,23519910:23520909,23519914:23520763,23519923:23520933,23519935:23520582,23519939:23520800,23519942:23520604,23519943:23520439,23519944:23520370,23519946:23520384,23519947:23520535,23519949:23520214,23519950:23520102,23519952:23520046,23519953:23520140,23519954:23520295,23522491:23522500,23522699:23522839,23567565:23571312,23567585:23570901,23567624:23570479,23567628:23570385,23567630:23570186,23567632:23570233,23567634:23570427,23567636:23570287,23567639:23570073,23567640:23569850,23567646:23570032,23567649:23569701,23567667:23568111,23615526:23615689,23619453:23620094,23619454:23619902,23620425:23622703,23620428:23623133,23620431:23622958,23620433:23622344,23620461:23622073,23620476:23621932,23620489:23621608,23620490:23621770,23620493:23621726,23620495:23621477,23620497:23621587,23620500:23621140,23620503:23621379,23620504:23621077,23621968:23622742,23625623:23626245,23628746:23629440,23630656:23630816,23632611:23632988,23635198:23635724,23639555:23641812,23639556:23641640,23639557:2364438', 'assoc_mat': '23519905:metal:4230:23520715,23519910:metal:4230:23520909,23519914:metal:4230:23520763,23519923:metal:4230:23520933,23519935:metal:4230:23520582,23519939:metal:4230:23520800,23519942:metal:4230:23520604,23519943:metal:4230:23520439,23519944:metal:4230:23520370,23519946:metal:4230:23520384,23519947:metal:4230:23520535,23519949:metal:4230:23520214,23519950:metal:4230:23520102,23519952:metal:4230:23520046,23519953:metal:4230:23520140,23519954:metal:4230:23520295,23522491:metal:4230:23522500,23522699:metal:4230:23522839,23567565:metal:4230:23571312,23567585:metal:4230:23570901,23567624:metal:4230:23570479,23567628:metal:4230:23570385,23567630:metal:4230:23570186,23567632:metal:4230:23570233,23567634:metal:4230:23570427,23567636:metal:4230:23570287,23567639:metal:4230:23570073,23567640:metal:4230:23569850,23567646:metal:4230:23570032,23567649:metal:4230:23569701,23567667:metal:4230:23568111,23615526:metal:4230:23615689,23619453:metal:4230:23620094,23619454:metal:4230:23619902,23620425:metal:4230:23622703,23620428:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.24438767444089954, 'nb_photo': 373276, 'list_port_cont': '23520009,23520030,23520110,23520152,23520184,23520201,23520291,23520324,23520363,23520403,23520435,23520509,23520545,23520584,23520616,23520678,23520722,23520753,23520798,23520899,23520943,23521155,23522510,23522829,23568021,23568120,23569712,23569844,23569913,23570029,23570075,23570173,23570243,23570299,23570384,23570428,23570482,23570588,23570645,23570698,23570840,23570904,23570943,23570976,23571012,23571116,23571313,23572242,23613843,23615705,23619906,23620093,23621019,23621078,23621151,23621271,23621364,23621381,23621476,23621580,23621606,23621719,23621771,23621935,23621976,23622086,23622175,23622257,23622329,23622704,23622744,23622890,23622927,23622968,23623140,23623268,23623370,23626266,23629446,23630808,23632985,23635732,23641280,23641653,23641818,23642550,23644385,23644457,23646225,23649058,23651082,23651129,23651202,23651252,23651331,23654700,23705513,23705719,23705755,23705805,23705978,23706041,23706215,23706374,23706432,23706442,23706518,23706597,23706844,23749693,23749741,23749840,23749941,2375011', 'assoc_port': '23519905:23520722,23519910:23520899,23519914:23520753,23519918:23521155,23519923:23520943,23519926:23520678,23519931:23520509,23519935:23520584,23519939:23520798,23519942:23520616,23519943:23520435,23519944:23520363,23519945:23520201,23519946:23520403,23519947:23520545,23519948:23520324,23519949:23520184,23519950:23520110,23519951:23520009,23519952:23520030,23519953:23520152,23519954:23520291,23522491:23522510,23522699:23522829,23567565:23571313,23567567:23571116,23567579:23571012,23567583:23570976,23567585:23570904,23567589:23570645,23567591:23570943,23567606:23570698,23567621:23570840,23567624:23570482,23567628:23570384,23567630:23570173,23567632:23570243,23567634:23570428,23567636:23570299,23567639:23570075,23567640:23569844,23567642:23569913,23567645:23568021,23567646:23570029,23567649:23569712,23567667:23568120,23570269:23570588,23572187:23572242,23613742:23613843,23615526:23615705,23619453:23620093,23619454:23619906,23620412:23622927,23620415:23623268,23620418:23623370,23620421:23622890,23620425:2362270', 'assoc_mat': '23519905:papier:4230:23520722,23519910:papier:4230:23520899,23519914:papier:4230:23520753,23519918:papier:4230:23521155,23519923:papier:4230:23520943,23519926:papier:4230:23520678,23519931:papier:4230:23520509,23519935:papier:4230:23520584,23519939:papier:4230:23520798,23519942:papier:4230:23520616,23519943:papier:4230:23520435,23519944:papier:4230:23520363,23519945:papier:4230:23520201,23519946:papier:4230:23520403,23519947:papier:4230:23520545,23519948:papier:4230:23520324,23519949:papier:4230:23520184,23519950:papier:4230:23520110,23519951:papier:4230:23520009,23519952:papier:4230:23520030,23519953:papier:4230:23520152,23519954:papier:4230:23520291,23522491:papier:4230:23522510,23522699:papier:4230:23522829,23567565:papier:4230:23571313,23567567:papier:4230:23571116,23567579:papier:4230:23571012,23567583:papier:4230:23570976,23567585:papier:4230:23570904,23567589:papier:4230:23570645,23567591:papier:4230:23570943,23567606:papier:4230:23570698,23567621:papier:4230:23570840,23567624:papier:4230:23570482,2356'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006940816044582928, 'nb_photo': 2774, 'list_port_cont': '23519994,23520113,23520144,23520189,23520329,23520366,23520378,23520438,23520549,23520580,23520618,23520686,23520761,23520796,23520903,23520947,23521160,23522504,23568034,23568121,23569711,23569846,23569927,23570023,23570071,23570182,23570245,23570301,23570422,23570585,23570850,23570978,23571010,23571126,23571307,23572248,23619911,23621008,23621369,23621581,23621603,23621725,23621775,23621943,23621986,23622084,23622179,23622261,23622343,23622701,23622746,23622896,23622933,23622967,23623139,23623262,23623371,23626249,23629438,23630806,23632987,23635737,23641655,23641816,23646222,23649059,23705510,23705796,23705968,23706032,23706212,23749836,23749944,23750200,23750350,23750416,23750545,23751581,23756127,23756651,23756835,23756944,23756947,23756968,23757078,23757129,23757159,23757191,23757248,23757364,23757405,23764151,23765406,23767028,23769633,23787189,23791746,23795427,23796946,23797118,23797446,23797513,23797734,23824654,23825221,23825539,23826240,23826283,23826376,23827175,23827290,23827337,23827371,2382754', 'assoc_port': '23519910:23520903,23519914:23520761,23519918:23521160,23519923:23520947,23519926:23520686,23519935:23520580,23519939:23520796,23519942:23520618,23519943:23520438,23519944:23520366,23519945:23520189,23519946:23520378,23519947:23520549,23519948:23520329,23519950:23520113,23519951:23519994,23519953:23520144,23522491:23522504,23567565:23571307,23567567:23571126,23567579:23571010,23567583:23570978,23567621:23570850,23567630:23570182,23567632:23570245,23567634:23570422,23567636:23570301,23567639:23570071,23567640:23569846,23567642:23569927,23567645:23568034,23567646:23570023,23567649:23569711,23567667:23568121,23570269:23570585,23572187:23572248,23619454:23619911,23620412:23622933,23620415:23623262,23620418:23623371,23620421:23622896,23620425:23622701,23620428:23623139,23620431:23622967,23620433:23622343,23620448:23622261,23620461:23622084,23620462:23622179,23620476:23621943,23620489:23621603,23620490:23621775,23620492:23621986,23620493:23621725,23620496:23621369,23620497:23621581,23620502:23621008,23621968:2362274', 'assoc_mat': '23519910:pehd:4230:23520903,23519914:pehd:4230:23520761,23519918:pehd:4230:23521160,23519923:pehd:4230:23520947,23519926:pehd:4230:23520686,23519935:pehd:4230:23520580,23519939:pehd:4230:23520796,23519942:pehd:4230:23520618,23519943:pehd:4230:23520438,23519944:pehd:4230:23520366,23519945:pehd:4230:23520189,23519946:pehd:4230:23520378,23519947:pehd:4230:23520549,23519948:pehd:4230:23520329,23519950:pehd:4230:23520113,23519951:pehd:4230:23519994,23519953:pehd:4230:23520144,23522491:pehd:4230:23522504,23567565:pehd:4230:23571307,23567567:pehd:4230:23571126,23567579:pehd:4230:23571010,23567583:pehd:4230:23570978,23567621:pehd:4230:23570850,23567630:pehd:4230:23570182,23567632:pehd:4230:23570245,23567634:pehd:4230:23570422,23567636:pehd:4230:23570301,23567639:pehd:4230:23570071,23567640:pehd:4230:23569846,23567642:pehd:4230:23569927,23567645:pehd:4230:23568034,23567646:pehd:4230:23570023,23567649:pehd:4230:23569711,23567667:pehd:4230:23568121,23570269:pehd:4230:23570585,23572187:pehd:4230:23572248,23619454:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01027364838437848, 'nb_photo': 20461, 'list_port_cont': '23520005,23520035,23520115,23520153,23520181,23520213,23520298,23520327,23520369,23520386,23520437,23520505,23520542,23520583,23520614,23520685,23520728,23520764,23520790,23520910,23520945,23521156,23522509,23522842,23568033,23568114,23569709,23569857,23569910,23570030,23570068,23570187,23570247,23570298,23570375,23570424,23570485,23570584,23570640,23570701,23570842,23570907,23570946,23570972,23571015,23571123,23571317,23572241,23613849,23615701,23619909,23620085,23621017,23621084,23621146,23621269,23621353,23621376,23621483,23621589,23621607,23621723,23621764,23621938,23621990,23622076,23622178,23622260,23622336,23622705,23622745,23622894,23622929,23622955,23623128,23623264,23623373,23626265,23629439,23630812,23632986,23635742,23641288,23641654,23641822,23642543,23644379,23644463,23646221,23649046,23651083,23651138,23651204,23651242,23651325,23654706,23705515,23705717,23705769,23705804,23705977,23706040,23706209,23706372,23706429,23706445,23706516,23706588,23706831,23749686,23749728,23749843,23749945,2375011', 'assoc_port': '23519905:23520728,23519910:23520910,23519914:23520764,23519918:23521156,23519923:23520945,23519926:23520685,23519931:23520505,23519935:23520583,23519939:23520790,23519942:23520614,23519943:23520437,23519944:23520369,23519945:23520213,23519946:23520386,23519947:23520542,23519948:23520327,23519949:23520181,23519950:23520115,23519951:23520005,23519952:23520035,23519953:23520153,23519954:23520298,23522491:23522509,23522699:23522842,23567565:23571317,23567567:23571123,23567579:23571015,23567583:23570972,23567585:23570907,23567589:23570640,23567591:23570946,23567606:23570701,23567621:23570842,23567624:23570485,23567628:23570375,23567630:23570187,23567632:23570247,23567634:23570424,23567636:23570298,23567639:23570068,23567640:23569857,23567642:23569910,23567645:23568033,23567646:23570030,23567649:23569709,23567667:23568114,23570269:23570584,23572187:23572241,23613742:23613849,23615526:23615701,23619453:23620085,23619454:23619909,23620412:23622929,23620415:23623264,23620418:23623373,23620421:23622894,23620425:2362270', 'assoc_mat': '23519905:pet_clair:4230:23520728,23519910:pet_clair:4230:23520910,23519914:pet_clair:4230:23520764,23519918:pet_clair:4230:23521156,23519923:pet_clair:4230:23520945,23519926:pet_clair:4230:23520685,23519931:pet_clair:4230:23520505,23519935:pet_clair:4230:23520583,23519939:pet_clair:4230:23520790,23519942:pet_clair:4230:23520614,23519943:pet_clair:4230:23520437,23519944:pet_clair:4230:23520369,23519945:pet_clair:4230:23520213,23519946:pet_clair:4230:23520386,23519947:pet_clair:4230:23520542,23519948:pet_clair:4230:23520327,23519949:pet_clair:4230:23520181,23519950:pet_clair:4230:23520115,23519951:pet_clair:4230:23520005,23519952:pet_clair:4230:23520035,23519953:pet_clair:4230:23520153,23519954:pet_clair:4230:23520298,23522491:pet_clair:4230:23522509,23522699:pet_clair:4230:23522842,23567565:pet_clair:4230:23571317,23567567:pet_clair:4230:23571123,23567579:pet_clair:4230:23571015,23567583:pet_clair:4230:23570972,23567585:pet_clair:4230:23570907,23567589:pet_clair:4230:23570640,23567591:pet_clair:4230:23570946,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003316893681534689, 'nb_photo': 806, 'list_port_cont': '23520045,23520361,23520539,23520620,23520687,23520760,23520897,23520944,23522838,23568023,23569707,23569926,23570174,23570381,23570426,23570594,23570844,23572243,23620086,23621080,23621362,23621378,23621473,23621717,23621776,23621931,23621989,23622079,23622172,23622253,23622747,23622925,23623141,23626269,23629447,23630809,23632980,23641284,23641819,23642555,23644471,23649057,23651207,23654707,23705502,23705718,23705768,23705808,23706036,23706373,23706594,23706843,23749940,23751580,23756393,23756606,23756650,23756836,23756871,23756948,23756953,23756975,23757089,23757128,23757163,23757194,23757365,23757500,23764148,23777091,23784733,23787187,23795426,23797732,23797887,23798312,23825534,23825657,23826287,23826969,23829211,23880741,23880800,23881051,23881134,23881189,23881256,23881514,23881549,23881559,23881624,23881664,23901138,23920111,23921626,23922803,23922926,23923012,23923216,23923289,23923324,23923380,23923464,23923516,23923568,23923613,23923753,23923802,23923874,23954017,23957198,23960846,23967658,2396787', 'assoc_port': '23519910:23520897,23519914:23520760,23519923:23520944,23519926:23520687,23519942:23520620,23519944:23520361,23519947:23520539,23519952:23520045,23522699:23522838,23567621:23570844,23567628:23570381,23567630:23570174,23567634:23570426,23567642:23569926,23567645:23568023,23567649:23569707,23570269:23570594,23572187:23572243,23619453:23620086,23620412:23622925,23620428:23623141,23620448:23622253,23620461:23622079,23620462:23622172,23620476:23621931,23620490:23621776,23620492:23621989,23620493:23621717,23620495:23621473,23620496:23621362,23620503:23621378,23620504:23621080,23621968:23622747,23625623:23626269,23628746:23629447,23630656:23630809,23632611:23632980,23639555:23641819,23639558:23641284,23642236:23642555,23644085:23644471,23645589:23651207,23648496:23649057,23651229:23654707,23705219:23706373,23705224:23706843,23705226:23706594,23705257:23705768,23705263:23706036,23705265:23705718,23705270:23705808,23705273:23705502,23749599:23749940,23751462:23751580,23755567:23757365,23755569:23757128,23755570:2375719', 'assoc_mat': '23519910:pet_fonce:4230:23520897,23519914:pet_fonce:4230:23520760,23519923:pet_fonce:4230:23520944,23519926:pet_fonce:4230:23520687,23519942:pet_fonce:4230:23520620,23519944:pet_fonce:4230:23520361,23519947:pet_fonce:4230:23520539,23519952:pet_fonce:4230:23520045,23522699:pet_fonce:4230:23522838,23567621:pet_fonce:4230:23570844,23567628:pet_fonce:4230:23570381,23567630:pet_fonce:4230:23570174,23567634:pet_fonce:4230:23570426,23567642:pet_fonce:4230:23569926,23567645:pet_fonce:4230:23568023,23567649:pet_fonce:4230:23569707,23570269:pet_fonce:4230:23570594,23572187:pet_fonce:4230:23572243,23619453:pet_fonce:4230:23620086,23620412:pet_fonce:4230:23622925,23620428:pet_fonce:4230:23623141,23620448:pet_fonce:4230:23622253,23620461:pet_fonce:4230:23622079,23620462:pet_fonce:4230:23622172,23620476:pet_fonce:4230:23621931,23620490:pet_fonce:4230:23621776,23620492:pet_fonce:4230:23621989,23620493:pet_fonce:4230:23621717,23620495:pet_fonce:4230:23621473,23620496:pet_fonce:4230:23621362,23620503:pet_fonce:4230:23621378,2'}), 'main_stat': {'nb_photos': 1671}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-06', 0.6647268003597339),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_06_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '2.36%', 19022], 'carton': ['carton', '9.17%', 110353], 'metal': ['metal', '0.18%', 2246], 'papier': ['papier', '24.44%', 373276], 'pehd': ['pehd', '0.69%', 2774], 'pet_clair': ['pet_clair', '1.03%', 20461], 'pet_fonce': ['pet_fonce', '0.33%', 806]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_06_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.37user 2.68system 0:07.48elapsed 67%CPU (0avgtext+0avgdata 194556maxresident)k 8inputs+288outputs (1major+67736minor)pagefaults 0swaps