python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_2/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-05 _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 : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 05 mtr_id : dashboard_places : SCCU_cam7 date : 2025-05 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam7' and date like '%2025-05%') and created_at like '%2025-05%'))); nb_day : (3, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 204 and month(ded.date) = 05 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______incineration' and ded.dashboard_place_id = 204 and month(ded.date) = 05 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 204 and mp.name like '%052025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-05-01 : dt_date_just_month_year : 2025-05-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-05-01" AND ded.date <= "2025-05-31" apple3 {'incineration': {'mat': 'incineration', 'pht': 4230, 'datou_carac_id': 4234, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1772917,1777129,1780225,1780580,1784617,1788309,1792960,1796827,1801059,1810357,1810301,1810404,1810269,1814879,1818937,1822889,1824119) 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.015555843847217777, 'nb_photo': 8452, 'list_port_cont': '22586774,22586820,22586847,22586898,22586960,22587147,22587232,22587330,22587371,22587594,22587685,22587715,22587762,22587836,22587866,22587897,22587938,22587972,22588009,22588120,22588334,22588375,22625586,22625645,22625697,22625754,22625798,22625940,22626046,22626108,22626241,22626428,22626544,22626580,22626621,22626677,22626785,22626833,22626905,22626976,22627053,22627491,22627571,22627675,22627740,22628139,22647584,22647619,22647662,22647701,22647814,22647852,22647886,22648000,22648038,22648069,22648148,22648265,22648323,22648368,22648430,22648465,22648553,22648581,22648730,22648883,22649035,22649065,22649586,22653966,22653997,22654039,22654066,22654130,22654179,22654222,22654247,22654290,22654330,22654355,22654377,22654428,22654473,22654515,22654539,22654571,22654621,22654644,22654700,22654963,22696826,22696876,22696962,22696991,22697133,22697178,22697530,22697627,22697647,22697993,22698032,22698073,22698142,22698223,22698266,22698325,22698354,22698433,22698471,22698517,22698586,22698621,22699103,2270022', 'assoc_port': '22586329:22586820,22586331:22588375,22586333:22586898,22586335:22588009,22586337:22587762,22586339:22587685,22586341:22587897,22586343:22587972,22586345:22587836,22586347:22587938,22586349:22587866,22586351:22587594,22586353:22587232,22586355:22587715,22586357:22587330,22586359:22587371,22586361:22586847,22586363:22586960,22586365:22587147,22586367:22586774,22588040:22588120,22588275:22588334,22625260:22627675,22625261:22627491,22625262:22627740,22625263:22626976,22625264:22627571,22625265:22627053,22625266:22626785,22625267:22626833,22625268:22626544,22625269:22626580,22625270:22626621,22625271:22626428,22625272:22626905,22625273:22626677,22625274:22626108,22625275:22626241,22625295:22626046,22625301:22625940,22625302:22625754,22625303:22625697,22625304:22625798,22625305:22625645,22625306:22625586,22628077:22628139,22647476:22648730,22647478:22648883,22647480:22649035,22647482:22648581,22647484:22648465,22647486:22648430,22647488:22648553,22647490:22648368,22647492:22648265,22647494:22648323,22647496:2264806', 'assoc_mat': '22586329:autre:4230:22586820,22586331:autre:4230:22588375,22586333:autre:4230:22586898,22586335:autre:4230:22588009,22586337:autre:4230:22587762,22586339:autre:4230:22587685,22586341:autre:4230:22587897,22586343:autre:4230:22587972,22586345:autre:4230:22587836,22586347:autre:4230:22587938,22586349:autre:4230:22587866,22586351:autre:4230:22587594,22586353:autre:4230:22587232,22586355:autre:4230:22587715,22586357:autre:4230:22587330,22586359:autre:4230:22587371,22586361:autre:4230:22586847,22586363:autre:4230:22586960,22586365:autre:4230:22587147,22586367:autre:4230:22586774,22588040:autre:4230:22588120,22588275:autre:4230:22588334,22625260:autre:4230:22627675,22625261:autre:4230:22627491,22625262:autre:4230:22627740,22625263:autre:4230:22626976,22625264:autre:4230:22627571,22625265:autre:4230:22627053,22625266:autre:4230:22626785,22625267:autre:4230:22626833,22625268:autre:4230:22626544,22625269:autre:4230:22626580,22625270:autre:4230:22626621,22625271:autre:4230:22626428,22625272:autre:4230:22626905,22625273:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05140210338609948, 'nb_photo': 40237, 'list_port_cont': '22586782,22586818,22586857,22586896,22586969,22587143,22587231,22587340,22587375,22587592,22587689,22587721,22587764,22587833,22587870,22587901,22587943,22587978,22588018,22588133,22588349,22588378,22625589,22625653,22625705,22625759,22625803,22625941,22626043,22626117,22626242,22626426,22626548,22626587,22626619,22626685,22626784,22626844,22626897,22626973,22627076,22627500,22627578,22627678,22627730,22628143,22647597,22647634,22647671,22647705,22647812,22647857,22647880,22647998,22648039,22648075,22648159,22648260,22648330,22648362,22648441,22648479,22648552,22648590,22648735,22648881,22649030,22649079,22649592,22653973,22654004,22654044,22654081,22654132,22654189,22654220,22654254,22654298,22654324,22654364,22654380,22654437,22654469,22654503,22654552,22654581,22654622,22654656,22654698,22654969,22696834,22696879,22696958,22696989,22697132,22697188,22697531,22697637,22697660,22698003,22698039,22698078,22698138,22698231,22698267,22698328,22698368,22698425,22698477,22698522,22698585,22698628,22699102,2270023', 'assoc_port': '22586329:22586818,22586331:22588378,22586333:22586896,22586335:22588018,22586337:22587764,22586339:22587689,22586341:22587901,22586343:22587978,22586345:22587833,22586347:22587943,22586349:22587870,22586351:22587592,22586353:22587231,22586355:22587721,22586357:22587340,22586359:22587375,22586361:22586857,22586363:22586969,22586365:22587143,22586367:22586782,22588040:22588133,22588275:22588349,22625260:22627678,22625261:22627500,22625262:22627730,22625263:22626973,22625264:22627578,22625265:22627076,22625266:22626784,22625267:22626844,22625268:22626548,22625269:22626587,22625270:22626619,22625271:22626426,22625272:22626897,22625273:22626685,22625274:22626117,22625275:22626242,22625295:22626043,22625301:22625941,22625302:22625759,22625303:22625705,22625304:22625803,22625305:22625653,22625306:22625589,22628077:22628143,22647476:22648735,22647478:22648881,22647480:22649030,22647482:22648590,22647484:22648479,22647486:22648441,22647488:22648552,22647490:22648362,22647492:22648260,22647494:22648330,22647496:2264807', 'assoc_mat': '22586329:carton:4230:22586818,22586331:carton:4230:22588378,22586333:carton:4230:22586896,22586335:carton:4230:22588018,22586337:carton:4230:22587764,22586339:carton:4230:22587689,22586341:carton:4230:22587901,22586343:carton:4230:22587978,22586345:carton:4230:22587833,22586347:carton:4230:22587943,22586349:carton:4230:22587870,22586351:carton:4230:22587592,22586353:carton:4230:22587231,22586355:carton:4230:22587721,22586357:carton:4230:22587340,22586359:carton:4230:22587375,22586361:carton:4230:22586857,22586363:carton:4230:22586969,22586365:carton:4230:22587143,22586367:carton:4230:22586782,22588040:carton:4230:22588133,22588275:carton:4230:22588349,22625260:carton:4230:22627678,22625261:carton:4230:22627500,22625262:carton:4230:22627730,22625263:carton:4230:22626973,22625264:carton:4230:22627578,22625265:carton:4230:22627076,22625266:carton:4230:22626784,22625267:carton:4230:22626844,22625268:carton:4230:22626548,22625269:carton:4230:22626587,22625270:carton:4230:22626619,22625271:carton:4230:22626426,2262'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013853444791884805, 'nb_photo': 812, 'list_port_cont': '22586783,22586809,22586854,22586888,22586962,22587148,22587224,22587326,22587368,22587593,22587688,22587720,22587754,22587822,22587909,22587946,22587982,22588005,22588130,22588338,22588385,22625588,22625643,22625756,22625795,22625927,22626049,22626110,22626230,22626424,22626543,22626582,22626625,22626692,22626786,22626848,22626908,22627060,22627506,22627556,22627742,22647589,22647631,22647658,22647797,22647845,22647891,22648002,22648040,22648076,22648152,22648257,22648328,22648366,22648433,22648480,22648543,22648583,22648726,22648886,22649032,22649595,22653972,22654037,22654080,22654129,22654187,22654210,22654255,22654288,22654326,22654357,22654385,22654431,22654463,22654504,22654549,22654578,22654618,22654649,22654686,22654966,22696825,22696881,22696965,22696987,22697533,22697644,22698071,22698233,22698255,22698330,22698358,22698429,22698470,22698524,22698589,22698622,22701880,22702304,22702562,22706342,22708639,22711498,22712383,22713016,22713873,22715137,22719390,22719505,22719800,22725879,22726323,2272906', 'assoc_port': '22586329:22586809,22586331:22588385,22586333:22586888,22586335:22588005,22586337:22587754,22586339:22587688,22586341:22587909,22586343:22587982,22586345:22587822,22586347:22587946,22586351:22587593,22586353:22587224,22586355:22587720,22586357:22587326,22586359:22587368,22586361:22586854,22586363:22586962,22586365:22587148,22586367:22586783,22588040:22588130,22588275:22588338,22625261:22627506,22625262:22627742,22625264:22627556,22625265:22627060,22625266:22626786,22625267:22626848,22625268:22626543,22625269:22626582,22625270:22626625,22625271:22626424,22625272:22626908,22625273:22626692,22625274:22626110,22625275:22626230,22625295:22626049,22625301:22625927,22625302:22625756,22625304:22625795,22625305:22625643,22625306:22625588,22647476:22648726,22647478:22648886,22647480:22649032,22647482:22648583,22647484:22648480,22647486:22648433,22647488:22648543,22647490:22648366,22647492:22648257,22647494:22648328,22647496:22648076,22647498:22648152,22647500:22648002,22647502:22647891,22647504:22647845,22647506:2264804', 'assoc_mat': '22586329:metal:4230:22586809,22586331:metal:4230:22588385,22586333:metal:4230:22586888,22586335:metal:4230:22588005,22586337:metal:4230:22587754,22586339:metal:4230:22587688,22586341:metal:4230:22587909,22586343:metal:4230:22587982,22586345:metal:4230:22587822,22586347:metal:4230:22587946,22586351:metal:4230:22587593,22586353:metal:4230:22587224,22586355:metal:4230:22587720,22586357:metal:4230:22587326,22586359:metal:4230:22587368,22586361:metal:4230:22586854,22586363:metal:4230:22586962,22586365:metal:4230:22587148,22586367:metal:4230:22586783,22588040:metal:4230:22588130,22588275:metal:4230:22588338,22625261:metal:4230:22627506,22625262:metal:4230:22627742,22625264:metal:4230:22627556,22625265:metal:4230:22627060,22625266:metal:4230:22626786,22625267:metal:4230:22626848,22625268:metal:4230:22626543,22625269:metal:4230:22626582,22625270:metal:4230:22626625,22625271:metal:4230:22626424,22625272:metal:4230:22626908,22625273:metal:4230:22626692,22625274:metal:4230:22626110,22625275:metal:4230:22626230,22625295:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20466155924433616, 'nb_photo': 147743, 'list_port_cont': '22586784,22586819,22586861,22586891,22586964,22587153,22587223,22587333,22587366,22587587,22587684,22587726,22587763,22587835,22587856,22587898,22587945,22587983,22588006,22588128,22588343,22588377,22625583,22625642,22625704,22625763,22625808,22625939,22626050,22626109,22626234,22626423,22626550,22626592,22626624,22626689,22626790,22626841,22626901,22626966,22627080,22627505,22627583,22627682,22627741,22628151,22647599,22647632,22647659,22647707,22647815,22647856,22647893,22648003,22648029,22648070,22648158,22648272,22648335,22648370,22648445,22648477,22648555,22648577,22648737,22648891,22649034,22649074,22649602,22653970,22653995,22654036,22654079,22654135,22654182,22654219,22654261,22654296,22654335,22654366,22654387,22654444,22654478,22654511,22654538,22654585,22654624,22654660,22654699,22654964,22696830,22696878,22696956,22696996,22697134,22697184,22697537,22697635,22697654,22698007,22698046,22698076,22698139,22698234,22698258,22698329,22698365,22698426,22698479,22698525,22698584,22698626,22699100,2270023', 'assoc_port': '22586329:22586819,22586331:22588377,22586333:22586891,22586335:22588006,22586337:22587763,22586339:22587684,22586341:22587898,22586343:22587983,22586345:22587835,22586347:22587945,22586349:22587856,22586351:22587587,22586353:22587223,22586355:22587726,22586357:22587333,22586359:22587366,22586361:22586861,22586363:22586964,22586365:22587153,22586367:22586784,22588040:22588128,22588275:22588343,22625260:22627682,22625261:22627505,22625262:22627741,22625263:22626966,22625264:22627583,22625265:22627080,22625266:22626790,22625267:22626841,22625268:22626550,22625269:22626592,22625270:22626624,22625271:22626423,22625272:22626901,22625273:22626689,22625274:22626109,22625275:22626234,22625295:22626050,22625301:22625939,22625302:22625763,22625303:22625704,22625304:22625808,22625305:22625642,22625306:22625583,22628077:22628151,22647476:22648737,22647478:22648891,22647480:22649034,22647482:22648577,22647484:22648477,22647486:22648445,22647488:22648555,22647490:22648370,22647492:22648272,22647494:22648335,22647496:2264807', 'assoc_mat': '22586329:papier:4230:22586819,22586331:papier:4230:22588377,22586333:papier:4230:22586891,22586335:papier:4230:22588006,22586337:papier:4230:22587763,22586339:papier:4230:22587684,22586341:papier:4230:22587898,22586343:papier:4230:22587983,22586345:papier:4230:22587835,22586347:papier:4230:22587945,22586349:papier:4230:22587856,22586351:papier:4230:22587587,22586353:papier:4230:22587223,22586355:papier:4230:22587726,22586357:papier:4230:22587333,22586359:papier:4230:22587366,22586361:papier:4230:22586861,22586363:papier:4230:22586964,22586365:papier:4230:22587153,22586367:papier:4230:22586784,22588040:papier:4230:22588128,22588275:papier:4230:22588343,22625260:papier:4230:22627682,22625261:papier:4230:22627505,22625262:papier:4230:22627741,22625263:papier:4230:22626966,22625264:papier:4230:22627583,22625265:papier:4230:22627080,22625266:papier:4230:22626790,22625267:papier:4230:22626841,22625268:papier:4230:22626550,22625269:papier:4230:22626592,22625270:papier:4230:22626624,22625271:papier:4230:22626423,2262'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004103592902803068, 'nb_photo': 1170, 'list_port_cont': '22586785,22586823,22586860,22586894,22586971,22587151,22587229,22587335,22587374,22587585,22587679,22587722,22587752,22587832,22587865,22587908,22587939,22587985,22588017,22588134,22588345,22588384,22625592,22625646,22625702,22625762,22625809,22625931,22626053,22626113,22626244,22626431,22626552,22626591,22626630,22626686,22626789,22626847,22626902,22626974,22627092,22627504,22627579,22627673,22627737,22628146,22647590,22647627,22647667,22647708,22647816,22647858,22648001,22648037,22648157,22648273,22648333,22648367,22648432,22648476,22648550,22648579,22648739,22648893,22649039,22649601,22653969,22654001,22654045,22654067,22654133,22654225,22654259,22654289,22654323,22654361,22654381,22654442,22654480,22654514,22654543,22654587,22654617,22654657,22654697,22654976,22696827,22696874,22696961,22696998,22697123,22697187,22697538,22697633,22697664,22698006,22698043,22698070,22698137,22698230,22698264,22698327,22698353,22698434,22698472,22698591,22698623,22699090,22700234,22702298,22702568,22704459,22706356,2270864', 'assoc_port': '22586329:22586823,22586331:22588384,22586333:22586894,22586335:22588017,22586337:22587752,22586339:22587679,22586341:22587908,22586343:22587985,22586345:22587832,22586347:22587939,22586349:22587865,22586351:22587585,22586353:22587229,22586355:22587722,22586357:22587335,22586359:22587374,22586361:22586860,22586363:22586971,22586365:22587151,22586367:22586785,22588040:22588134,22588275:22588345,22625260:22627673,22625261:22627504,22625262:22627737,22625263:22626974,22625264:22627579,22625265:22627092,22625266:22626789,22625267:22626847,22625268:22626552,22625269:22626591,22625270:22626630,22625271:22626431,22625272:22626902,22625273:22626686,22625274:22626113,22625275:22626244,22625295:22626053,22625301:22625931,22625302:22625762,22625303:22625702,22625304:22625809,22625305:22625646,22625306:22625592,22628077:22628146,22647476:22648739,22647478:22648893,22647480:22649039,22647482:22648579,22647484:22648476,22647486:22648432,22647488:22648550,22647490:22648367,22647492:22648273,22647494:22648333,22647498:2264815', 'assoc_mat': '22586329:pehd:4230:22586823,22586331:pehd:4230:22588384,22586333:pehd:4230:22586894,22586335:pehd:4230:22588017,22586337:pehd:4230:22587752,22586339:pehd:4230:22587679,22586341:pehd:4230:22587908,22586343:pehd:4230:22587985,22586345:pehd:4230:22587832,22586347:pehd:4230:22587939,22586349:pehd:4230:22587865,22586351:pehd:4230:22587585,22586353:pehd:4230:22587229,22586355:pehd:4230:22587722,22586357:pehd:4230:22587335,22586359:pehd:4230:22587374,22586361:pehd:4230:22586860,22586363:pehd:4230:22586971,22586365:pehd:4230:22587151,22586367:pehd:4230:22586785,22588040:pehd:4230:22588134,22588275:pehd:4230:22588345,22625260:pehd:4230:22627673,22625261:pehd:4230:22627504,22625262:pehd:4230:22627737,22625263:pehd:4230:22626974,22625264:pehd:4230:22627579,22625265:pehd:4230:22627092,22625266:pehd:4230:22626789,22625267:pehd:4230:22626847,22625268:pehd:4230:22626552,22625269:pehd:4230:22626591,22625270:pehd:4230:22626630,22625271:pehd:4230:22626431,22625272:pehd:4230:22626902,22625273:pehd:4230:22626686,22625274:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.025449225661360472, 'nb_photo': 16107, 'list_port_cont': '22586781,22586813,22586862,22586889,22586970,22587142,22587218,22587341,22587373,22587584,22587687,22587714,22587757,22587834,22587869,22587905,22587947,22587979,22588015,22588129,22588348,22588386,22625594,22625654,22625693,22625755,22625807,22625936,22626051,22626119,22626240,22626433,22626555,22626589,22626622,22626690,22626788,22626849,22626911,22626979,22627075,22627498,22627576,22627676,22627739,22628148,22647594,22647630,22647668,22647706,22647819,22647854,22647887,22647992,22648027,22648067,22648162,22648271,22648329,22648365,22648443,22648470,22648549,22648591,22648732,22648892,22649028,22649078,22649599,22653962,22654005,22654043,22654075,22654127,22654188,22654223,22654262,22654284,22654328,22654371,22654386,22654443,22654467,22654516,22654537,22654588,22654620,22654659,22654696,22654973,22696831,22696875,22696957,22696997,22697131,22697175,22697540,22697641,22697656,22697995,22698047,22698083,22698134,22698232,22698261,22698318,22698362,22698424,22698473,22698529,22698582,22698618,22699104,2270022', 'assoc_port': '22586329:22586813,22586331:22588386,22586333:22586889,22586335:22588015,22586337:22587757,22586339:22587687,22586341:22587905,22586343:22587979,22586345:22587834,22586347:22587947,22586349:22587869,22586351:22587584,22586353:22587218,22586355:22587714,22586357:22587341,22586359:22587373,22586361:22586862,22586363:22586970,22586365:22587142,22586367:22586781,22588040:22588129,22588275:22588348,22625260:22627676,22625261:22627498,22625262:22627739,22625263:22626979,22625264:22627576,22625265:22627075,22625266:22626788,22625267:22626849,22625268:22626555,22625269:22626589,22625270:22626622,22625271:22626433,22625272:22626911,22625273:22626690,22625274:22626119,22625275:22626240,22625295:22626051,22625301:22625936,22625302:22625755,22625303:22625693,22625304:22625807,22625305:22625654,22625306:22625594,22628077:22628148,22647476:22648732,22647478:22648892,22647480:22649028,22647482:22648591,22647484:22648470,22647486:22648443,22647488:22648549,22647490:22648365,22647492:22648271,22647494:22648329,22647496:2264806', 'assoc_mat': '22586329:pet_clair:4230:22586813,22586331:pet_clair:4230:22588386,22586333:pet_clair:4230:22586889,22586335:pet_clair:4230:22588015,22586337:pet_clair:4230:22587757,22586339:pet_clair:4230:22587687,22586341:pet_clair:4230:22587905,22586343:pet_clair:4230:22587979,22586345:pet_clair:4230:22587834,22586347:pet_clair:4230:22587947,22586349:pet_clair:4230:22587869,22586351:pet_clair:4230:22587584,22586353:pet_clair:4230:22587218,22586355:pet_clair:4230:22587714,22586357:pet_clair:4230:22587341,22586359:pet_clair:4230:22587373,22586361:pet_clair:4230:22586862,22586363:pet_clair:4230:22586970,22586365:pet_clair:4230:22587142,22586367:pet_clair:4230:22586781,22588040:pet_clair:4230:22588129,22588275:pet_clair:4230:22588348,22625260:pet_clair:4230:22627676,22625261:pet_clair:4230:22627498,22625262:pet_clair:4230:22627739,22625263:pet_clair:4230:22626979,22625264:pet_clair:4230:22627576,22625265:pet_clair:4230:22627075,22625266:pet_clair:4230:22626788,22625267:pet_clair:4230:22626849,22625268:pet_clair:4230:22626555,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028008707773118113, 'nb_photo': 605, 'list_port_cont': '22586786,22586821,22586849,22586892,22586972,22587230,22587338,22587376,22587690,22587725,22587758,22587872,22587902,22587940,22587969,22588021,22588124,22588337,22588382,22625581,22625647,22625699,22625751,22625805,22626045,22626106,22626429,22626554,22626590,22626628,22626684,22626779,22626837,22626903,22627090,22627501,22627580,22627680,22627745,22628150,22647595,22647635,22647669,22647700,22647817,22647851,22648004,22648033,22648065,22648161,22648270,22648334,22648369,22648442,22648478,22648554,22648589,22648740,22648888,22649041,22649081,22649596,22653963,22654009,22654032,22654074,22654128,22654181,22654226,22654250,22654295,22654334,22654365,22654384,22654440,22654472,22654500,22654551,22654582,22654623,22654651,22654689,22654975,22696819,22696869,22696964,22697000,22697126,22697177,22697543,22697670,22698001,22698038,22698080,22698235,22698259,22698367,22698430,22698480,22698520,22698592,22698619,22699097,22702305,22702566,22704460,22708646,22711505,22712399,22713032,22713877,22715140,22719402,2271951', 'assoc_port': '22586329:22586821,22586331:22588382,22586333:22586892,22586335:22588021,22586337:22587758,22586339:22587690,22586341:22587902,22586343:22587969,22586347:22587940,22586349:22587872,22586353:22587230,22586355:22587725,22586357:22587338,22586359:22587376,22586361:22586849,22586363:22586972,22586367:22586786,22588040:22588124,22588275:22588337,22625260:22627680,22625261:22627501,22625262:22627745,22625264:22627580,22625265:22627090,22625266:22626779,22625267:22626837,22625268:22626554,22625269:22626590,22625270:22626628,22625271:22626429,22625272:22626903,22625273:22626684,22625274:22626106,22625295:22626045,22625302:22625751,22625303:22625699,22625304:22625805,22625305:22625647,22625306:22625581,22628077:22628150,22647476:22648740,22647478:22648888,22647480:22649041,22647482:22648589,22647484:22648478,22647486:22648442,22647488:22648554,22647490:22648369,22647492:22648270,22647494:22648334,22647496:22648065,22647498:22648161,22647500:22648004,22647504:22647851,22647506:22648033,22647508:22647817,22647510:2264766', 'assoc_mat': '22586329:pet_fonce:4230:22586821,22586331:pet_fonce:4230:22588382,22586333:pet_fonce:4230:22586892,22586335:pet_fonce:4230:22588021,22586337:pet_fonce:4230:22587758,22586339:pet_fonce:4230:22587690,22586341:pet_fonce:4230:22587902,22586343:pet_fonce:4230:22587969,22586347:pet_fonce:4230:22587940,22586349:pet_fonce:4230:22587872,22586353:pet_fonce:4230:22587230,22586355:pet_fonce:4230:22587725,22586357:pet_fonce:4230:22587338,22586359:pet_fonce:4230:22587376,22586361:pet_fonce:4230:22586849,22586363:pet_fonce:4230:22586972,22586367:pet_fonce:4230:22586786,22588040:pet_fonce:4230:22588124,22588275:pet_fonce:4230:22588337,22625260:pet_fonce:4230:22627680,22625261:pet_fonce:4230:22627501,22625262:pet_fonce:4230:22627745,22625264:pet_fonce:4230:22627580,22625265:pet_fonce:4230:22627090,22625266:pet_fonce:4230:22626779,22625267:pet_fonce:4230:22626837,22625268:pet_fonce:4230:22626554,22625269:pet_fonce:4230:22626590,22625270:pet_fonce:4230:22626628,22625271:pet_fonce:4230:22626429,22625272:pet_fonce:4230:22626903,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(1772917,1777129,1780225,1780580,1784617,1788309,1792960,1796827,1801059,1810357,1810301,1810404,1810269,1814879,1818937,1822889,1824119)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2025-05-01' and date <= '2025-05-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((965,),), 'unwanted_material_monthly_percentage': ((0.7163999001484371,),), 'material_repartition': (('incineration', 842),), 'material_dict': {'incineration': 842}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 5, 1), 0.6558752903730001, 64), (datetime.date(2025, 5, 2), 0.6655309058613872, 53), (datetime.date(2025, 5, 3), 0.6468510326735613, 57), (datetime.date(2025, 5, 4), 0.6786318245766207, 55), (datetime.date(2025, 5, 5), 0.756645300447586, 66), (datetime.date(2025, 5, 6), 0.7352071936052227, 49), (datetime.date(2025, 5, 7), 0.7172542268897295, 55), (datetime.date(2025, 5, 8), 0.7417934911777475, 57), (datetime.date(2025, 5, 9), 0.7033389677793801, 58), (datetime.date(2025, 5, 10), 0.6896427604561274, 64), (datetime.date(2025, 5, 11), 0.8121358840902677, 61), (datetime.date(2025, 5, 12), 0.777838633223728, 52), (datetime.date(2025, 5, 13), 0.7418478347110377, 44), (datetime.date(2025, 5, 14), 0.6809754107317024, 42), (datetime.date(2025, 5, 15), 0.7329744875779354, 65)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 5, 1), 0.6558752903730001, 64), (datetime.date(2025, 5, 2), 0.6655309058613872, 53), (datetime.date(2025, 5, 3), 0.6468510326735613, 57), (datetime.date(2025, 5, 4), 0.6786318245766207, 55), (datetime.date(2025, 5, 5), 0.756645300447586, 66), (datetime.date(2025, 5, 6), 0.7352071936052227, 49), (datetime.date(2025, 5, 7), 0.7172542268897295, 55), (datetime.date(2025, 5, 8), 0.7417934911777475, 57), (datetime.date(2025, 5, 9), 0.7033389677793801, 58), (datetime.date(2025, 5, 10), 0.6896427604561274, 64), (datetime.date(2025, 5, 11), 0.8121358840902677, 61), (datetime.date(2025, 5, 12), 0.777838633223728, 52), (datetime.date(2025, 5, 13), 0.7418478347110377, 44), (datetime.date(2025, 5, 14), 0.6809754107317024, 42), (datetime.date(2025, 5, 15), 0.7329744875779354, 65))}, 'quality_array': [['-8.127684377413791', '01052025'], ['-7.748373021041279', '02052025'], ['-7.983864452487453', '03052025'], ['-7.908419366979895', '04052025'], ['-7.078741858771597', '05052025'], ['-7.149341122478435', '06052025'], ['-7.500339868647435', '07052025'], ['-7.838995097760057', '08052025'], ['-7.202813800695644', '09052025'], ['-7.41266508650041', '10052025'], ['-7.6057706893734895', '11052025'], ['-7.156395979705296', '12052025'], ['-7.355972856475352', '13052025'], ['-7.807675379416226', '14052025'], ['-7.705924786456619', '15052025'], ['-8.134074916486899', '16052025']], 'number_of_batch': ((378,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015555843847217777, 'nb_photo': 8452, 'list_port_cont': '22586774,22586820,22586847,22586898,22586960,22587147,22587232,22587330,22587371,22587594,22587685,22587715,22587762,22587836,22587866,22587897,22587938,22587972,22588009,22588120,22588334,22588375,22625586,22625645,22625697,22625754,22625798,22625940,22626046,22626108,22626241,22626428,22626544,22626580,22626621,22626677,22626785,22626833,22626905,22626976,22627053,22627491,22627571,22627675,22627740,22628139,22647584,22647619,22647662,22647701,22647814,22647852,22647886,22648000,22648038,22648069,22648148,22648265,22648323,22648368,22648430,22648465,22648553,22648581,22648730,22648883,22649035,22649065,22649586,22653966,22653997,22654039,22654066,22654130,22654179,22654222,22654247,22654290,22654330,22654355,22654377,22654428,22654473,22654515,22654539,22654571,22654621,22654644,22654700,22654963,22696826,22696876,22696962,22696991,22697133,22697178,22697530,22697627,22697647,22697993,22698032,22698073,22698142,22698223,22698266,22698325,22698354,22698433,22698471,22698517,22698586,22698621,22699103,2270022', 'assoc_port': '22586329:22586820,22586331:22588375,22586333:22586898,22586335:22588009,22586337:22587762,22586339:22587685,22586341:22587897,22586343:22587972,22586345:22587836,22586347:22587938,22586349:22587866,22586351:22587594,22586353:22587232,22586355:22587715,22586357:22587330,22586359:22587371,22586361:22586847,22586363:22586960,22586365:22587147,22586367:22586774,22588040:22588120,22588275:22588334,22625260:22627675,22625261:22627491,22625262:22627740,22625263:22626976,22625264:22627571,22625265:22627053,22625266:22626785,22625267:22626833,22625268:22626544,22625269:22626580,22625270:22626621,22625271:22626428,22625272:22626905,22625273:22626677,22625274:22626108,22625275:22626241,22625295:22626046,22625301:22625940,22625302:22625754,22625303:22625697,22625304:22625798,22625305:22625645,22625306:22625586,22628077:22628139,22647476:22648730,22647478:22648883,22647480:22649035,22647482:22648581,22647484:22648465,22647486:22648430,22647488:22648553,22647490:22648368,22647492:22648265,22647494:22648323,22647496:2264806', 'assoc_mat': '22586329:autre:4230:22586820,22586331:autre:4230:22588375,22586333:autre:4230:22586898,22586335:autre:4230:22588009,22586337:autre:4230:22587762,22586339:autre:4230:22587685,22586341:autre:4230:22587897,22586343:autre:4230:22587972,22586345:autre:4230:22587836,22586347:autre:4230:22587938,22586349:autre:4230:22587866,22586351:autre:4230:22587594,22586353:autre:4230:22587232,22586355:autre:4230:22587715,22586357:autre:4230:22587330,22586359:autre:4230:22587371,22586361:autre:4230:22586847,22586363:autre:4230:22586960,22586365:autre:4230:22587147,22586367:autre:4230:22586774,22588040:autre:4230:22588120,22588275:autre:4230:22588334,22625260:autre:4230:22627675,22625261:autre:4230:22627491,22625262:autre:4230:22627740,22625263:autre:4230:22626976,22625264:autre:4230:22627571,22625265:autre:4230:22627053,22625266:autre:4230:22626785,22625267:autre:4230:22626833,22625268:autre:4230:22626544,22625269:autre:4230:22626580,22625270:autre:4230:22626621,22625271:autre:4230:22626428,22625272:autre:4230:22626905,22625273:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05140210338609948, 'nb_photo': 40237, 'list_port_cont': '22586782,22586818,22586857,22586896,22586969,22587143,22587231,22587340,22587375,22587592,22587689,22587721,22587764,22587833,22587870,22587901,22587943,22587978,22588018,22588133,22588349,22588378,22625589,22625653,22625705,22625759,22625803,22625941,22626043,22626117,22626242,22626426,22626548,22626587,22626619,22626685,22626784,22626844,22626897,22626973,22627076,22627500,22627578,22627678,22627730,22628143,22647597,22647634,22647671,22647705,22647812,22647857,22647880,22647998,22648039,22648075,22648159,22648260,22648330,22648362,22648441,22648479,22648552,22648590,22648735,22648881,22649030,22649079,22649592,22653973,22654004,22654044,22654081,22654132,22654189,22654220,22654254,22654298,22654324,22654364,22654380,22654437,22654469,22654503,22654552,22654581,22654622,22654656,22654698,22654969,22696834,22696879,22696958,22696989,22697132,22697188,22697531,22697637,22697660,22698003,22698039,22698078,22698138,22698231,22698267,22698328,22698368,22698425,22698477,22698522,22698585,22698628,22699102,2270023', 'assoc_port': '22586329:22586818,22586331:22588378,22586333:22586896,22586335:22588018,22586337:22587764,22586339:22587689,22586341:22587901,22586343:22587978,22586345:22587833,22586347:22587943,22586349:22587870,22586351:22587592,22586353:22587231,22586355:22587721,22586357:22587340,22586359:22587375,22586361:22586857,22586363:22586969,22586365:22587143,22586367:22586782,22588040:22588133,22588275:22588349,22625260:22627678,22625261:22627500,22625262:22627730,22625263:22626973,22625264:22627578,22625265:22627076,22625266:22626784,22625267:22626844,22625268:22626548,22625269:22626587,22625270:22626619,22625271:22626426,22625272:22626897,22625273:22626685,22625274:22626117,22625275:22626242,22625295:22626043,22625301:22625941,22625302:22625759,22625303:22625705,22625304:22625803,22625305:22625653,22625306:22625589,22628077:22628143,22647476:22648735,22647478:22648881,22647480:22649030,22647482:22648590,22647484:22648479,22647486:22648441,22647488:22648552,22647490:22648362,22647492:22648260,22647494:22648330,22647496:2264807', 'assoc_mat': '22586329:carton:4230:22586818,22586331:carton:4230:22588378,22586333:carton:4230:22586896,22586335:carton:4230:22588018,22586337:carton:4230:22587764,22586339:carton:4230:22587689,22586341:carton:4230:22587901,22586343:carton:4230:22587978,22586345:carton:4230:22587833,22586347:carton:4230:22587943,22586349:carton:4230:22587870,22586351:carton:4230:22587592,22586353:carton:4230:22587231,22586355:carton:4230:22587721,22586357:carton:4230:22587340,22586359:carton:4230:22587375,22586361:carton:4230:22586857,22586363:carton:4230:22586969,22586365:carton:4230:22587143,22586367:carton:4230:22586782,22588040:carton:4230:22588133,22588275:carton:4230:22588349,22625260:carton:4230:22627678,22625261:carton:4230:22627500,22625262:carton:4230:22627730,22625263:carton:4230:22626973,22625264:carton:4230:22627578,22625265:carton:4230:22627076,22625266:carton:4230:22626784,22625267:carton:4230:22626844,22625268:carton:4230:22626548,22625269:carton:4230:22626587,22625270:carton:4230:22626619,22625271:carton:4230:22626426,2262'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013853444791884805, 'nb_photo': 812, 'list_port_cont': '22586783,22586809,22586854,22586888,22586962,22587148,22587224,22587326,22587368,22587593,22587688,22587720,22587754,22587822,22587909,22587946,22587982,22588005,22588130,22588338,22588385,22625588,22625643,22625756,22625795,22625927,22626049,22626110,22626230,22626424,22626543,22626582,22626625,22626692,22626786,22626848,22626908,22627060,22627506,22627556,22627742,22647589,22647631,22647658,22647797,22647845,22647891,22648002,22648040,22648076,22648152,22648257,22648328,22648366,22648433,22648480,22648543,22648583,22648726,22648886,22649032,22649595,22653972,22654037,22654080,22654129,22654187,22654210,22654255,22654288,22654326,22654357,22654385,22654431,22654463,22654504,22654549,22654578,22654618,22654649,22654686,22654966,22696825,22696881,22696965,22696987,22697533,22697644,22698071,22698233,22698255,22698330,22698358,22698429,22698470,22698524,22698589,22698622,22701880,22702304,22702562,22706342,22708639,22711498,22712383,22713016,22713873,22715137,22719390,22719505,22719800,22725879,22726323,2272906', 'assoc_port': '22586329:22586809,22586331:22588385,22586333:22586888,22586335:22588005,22586337:22587754,22586339:22587688,22586341:22587909,22586343:22587982,22586345:22587822,22586347:22587946,22586351:22587593,22586353:22587224,22586355:22587720,22586357:22587326,22586359:22587368,22586361:22586854,22586363:22586962,22586365:22587148,22586367:22586783,22588040:22588130,22588275:22588338,22625261:22627506,22625262:22627742,22625264:22627556,22625265:22627060,22625266:22626786,22625267:22626848,22625268:22626543,22625269:22626582,22625270:22626625,22625271:22626424,22625272:22626908,22625273:22626692,22625274:22626110,22625275:22626230,22625295:22626049,22625301:22625927,22625302:22625756,22625304:22625795,22625305:22625643,22625306:22625588,22647476:22648726,22647478:22648886,22647480:22649032,22647482:22648583,22647484:22648480,22647486:22648433,22647488:22648543,22647490:22648366,22647492:22648257,22647494:22648328,22647496:22648076,22647498:22648152,22647500:22648002,22647502:22647891,22647504:22647845,22647506:2264804', 'assoc_mat': '22586329:metal:4230:22586809,22586331:metal:4230:22588385,22586333:metal:4230:22586888,22586335:metal:4230:22588005,22586337:metal:4230:22587754,22586339:metal:4230:22587688,22586341:metal:4230:22587909,22586343:metal:4230:22587982,22586345:metal:4230:22587822,22586347:metal:4230:22587946,22586351:metal:4230:22587593,22586353:metal:4230:22587224,22586355:metal:4230:22587720,22586357:metal:4230:22587326,22586359:metal:4230:22587368,22586361:metal:4230:22586854,22586363:metal:4230:22586962,22586365:metal:4230:22587148,22586367:metal:4230:22586783,22588040:metal:4230:22588130,22588275:metal:4230:22588338,22625261:metal:4230:22627506,22625262:metal:4230:22627742,22625264:metal:4230:22627556,22625265:metal:4230:22627060,22625266:metal:4230:22626786,22625267:metal:4230:22626848,22625268:metal:4230:22626543,22625269:metal:4230:22626582,22625270:metal:4230:22626625,22625271:metal:4230:22626424,22625272:metal:4230:22626908,22625273:metal:4230:22626692,22625274:metal:4230:22626110,22625275:metal:4230:22626230,22625295:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20466155924433616, 'nb_photo': 147743, 'list_port_cont': '22586784,22586819,22586861,22586891,22586964,22587153,22587223,22587333,22587366,22587587,22587684,22587726,22587763,22587835,22587856,22587898,22587945,22587983,22588006,22588128,22588343,22588377,22625583,22625642,22625704,22625763,22625808,22625939,22626050,22626109,22626234,22626423,22626550,22626592,22626624,22626689,22626790,22626841,22626901,22626966,22627080,22627505,22627583,22627682,22627741,22628151,22647599,22647632,22647659,22647707,22647815,22647856,22647893,22648003,22648029,22648070,22648158,22648272,22648335,22648370,22648445,22648477,22648555,22648577,22648737,22648891,22649034,22649074,22649602,22653970,22653995,22654036,22654079,22654135,22654182,22654219,22654261,22654296,22654335,22654366,22654387,22654444,22654478,22654511,22654538,22654585,22654624,22654660,22654699,22654964,22696830,22696878,22696956,22696996,22697134,22697184,22697537,22697635,22697654,22698007,22698046,22698076,22698139,22698234,22698258,22698329,22698365,22698426,22698479,22698525,22698584,22698626,22699100,2270023', 'assoc_port': '22586329:22586819,22586331:22588377,22586333:22586891,22586335:22588006,22586337:22587763,22586339:22587684,22586341:22587898,22586343:22587983,22586345:22587835,22586347:22587945,22586349:22587856,22586351:22587587,22586353:22587223,22586355:22587726,22586357:22587333,22586359:22587366,22586361:22586861,22586363:22586964,22586365:22587153,22586367:22586784,22588040:22588128,22588275:22588343,22625260:22627682,22625261:22627505,22625262:22627741,22625263:22626966,22625264:22627583,22625265:22627080,22625266:22626790,22625267:22626841,22625268:22626550,22625269:22626592,22625270:22626624,22625271:22626423,22625272:22626901,22625273:22626689,22625274:22626109,22625275:22626234,22625295:22626050,22625301:22625939,22625302:22625763,22625303:22625704,22625304:22625808,22625305:22625642,22625306:22625583,22628077:22628151,22647476:22648737,22647478:22648891,22647480:22649034,22647482:22648577,22647484:22648477,22647486:22648445,22647488:22648555,22647490:22648370,22647492:22648272,22647494:22648335,22647496:2264807', 'assoc_mat': '22586329:papier:4230:22586819,22586331:papier:4230:22588377,22586333:papier:4230:22586891,22586335:papier:4230:22588006,22586337:papier:4230:22587763,22586339:papier:4230:22587684,22586341:papier:4230:22587898,22586343:papier:4230:22587983,22586345:papier:4230:22587835,22586347:papier:4230:22587945,22586349:papier:4230:22587856,22586351:papier:4230:22587587,22586353:papier:4230:22587223,22586355:papier:4230:22587726,22586357:papier:4230:22587333,22586359:papier:4230:22587366,22586361:papier:4230:22586861,22586363:papier:4230:22586964,22586365:papier:4230:22587153,22586367:papier:4230:22586784,22588040:papier:4230:22588128,22588275:papier:4230:22588343,22625260:papier:4230:22627682,22625261:papier:4230:22627505,22625262:papier:4230:22627741,22625263:papier:4230:22626966,22625264:papier:4230:22627583,22625265:papier:4230:22627080,22625266:papier:4230:22626790,22625267:papier:4230:22626841,22625268:papier:4230:22626550,22625269:papier:4230:22626592,22625270:papier:4230:22626624,22625271:papier:4230:22626423,2262'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004103592902803068, 'nb_photo': 1170, 'list_port_cont': '22586785,22586823,22586860,22586894,22586971,22587151,22587229,22587335,22587374,22587585,22587679,22587722,22587752,22587832,22587865,22587908,22587939,22587985,22588017,22588134,22588345,22588384,22625592,22625646,22625702,22625762,22625809,22625931,22626053,22626113,22626244,22626431,22626552,22626591,22626630,22626686,22626789,22626847,22626902,22626974,22627092,22627504,22627579,22627673,22627737,22628146,22647590,22647627,22647667,22647708,22647816,22647858,22648001,22648037,22648157,22648273,22648333,22648367,22648432,22648476,22648550,22648579,22648739,22648893,22649039,22649601,22653969,22654001,22654045,22654067,22654133,22654225,22654259,22654289,22654323,22654361,22654381,22654442,22654480,22654514,22654543,22654587,22654617,22654657,22654697,22654976,22696827,22696874,22696961,22696998,22697123,22697187,22697538,22697633,22697664,22698006,22698043,22698070,22698137,22698230,22698264,22698327,22698353,22698434,22698472,22698591,22698623,22699090,22700234,22702298,22702568,22704459,22706356,2270864', 'assoc_port': '22586329:22586823,22586331:22588384,22586333:22586894,22586335:22588017,22586337:22587752,22586339:22587679,22586341:22587908,22586343:22587985,22586345:22587832,22586347:22587939,22586349:22587865,22586351:22587585,22586353:22587229,22586355:22587722,22586357:22587335,22586359:22587374,22586361:22586860,22586363:22586971,22586365:22587151,22586367:22586785,22588040:22588134,22588275:22588345,22625260:22627673,22625261:22627504,22625262:22627737,22625263:22626974,22625264:22627579,22625265:22627092,22625266:22626789,22625267:22626847,22625268:22626552,22625269:22626591,22625270:22626630,22625271:22626431,22625272:22626902,22625273:22626686,22625274:22626113,22625275:22626244,22625295:22626053,22625301:22625931,22625302:22625762,22625303:22625702,22625304:22625809,22625305:22625646,22625306:22625592,22628077:22628146,22647476:22648739,22647478:22648893,22647480:22649039,22647482:22648579,22647484:22648476,22647486:22648432,22647488:22648550,22647490:22648367,22647492:22648273,22647494:22648333,22647498:2264815', 'assoc_mat': '22586329:pehd:4230:22586823,22586331:pehd:4230:22588384,22586333:pehd:4230:22586894,22586335:pehd:4230:22588017,22586337:pehd:4230:22587752,22586339:pehd:4230:22587679,22586341:pehd:4230:22587908,22586343:pehd:4230:22587985,22586345:pehd:4230:22587832,22586347:pehd:4230:22587939,22586349:pehd:4230:22587865,22586351:pehd:4230:22587585,22586353:pehd:4230:22587229,22586355:pehd:4230:22587722,22586357:pehd:4230:22587335,22586359:pehd:4230:22587374,22586361:pehd:4230:22586860,22586363:pehd:4230:22586971,22586365:pehd:4230:22587151,22586367:pehd:4230:22586785,22588040:pehd:4230:22588134,22588275:pehd:4230:22588345,22625260:pehd:4230:22627673,22625261:pehd:4230:22627504,22625262:pehd:4230:22627737,22625263:pehd:4230:22626974,22625264:pehd:4230:22627579,22625265:pehd:4230:22627092,22625266:pehd:4230:22626789,22625267:pehd:4230:22626847,22625268:pehd:4230:22626552,22625269:pehd:4230:22626591,22625270:pehd:4230:22626630,22625271:pehd:4230:22626431,22625272:pehd:4230:22626902,22625273:pehd:4230:22626686,22625274:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.025449225661360472, 'nb_photo': 16107, 'list_port_cont': '22586781,22586813,22586862,22586889,22586970,22587142,22587218,22587341,22587373,22587584,22587687,22587714,22587757,22587834,22587869,22587905,22587947,22587979,22588015,22588129,22588348,22588386,22625594,22625654,22625693,22625755,22625807,22625936,22626051,22626119,22626240,22626433,22626555,22626589,22626622,22626690,22626788,22626849,22626911,22626979,22627075,22627498,22627576,22627676,22627739,22628148,22647594,22647630,22647668,22647706,22647819,22647854,22647887,22647992,22648027,22648067,22648162,22648271,22648329,22648365,22648443,22648470,22648549,22648591,22648732,22648892,22649028,22649078,22649599,22653962,22654005,22654043,22654075,22654127,22654188,22654223,22654262,22654284,22654328,22654371,22654386,22654443,22654467,22654516,22654537,22654588,22654620,22654659,22654696,22654973,22696831,22696875,22696957,22696997,22697131,22697175,22697540,22697641,22697656,22697995,22698047,22698083,22698134,22698232,22698261,22698318,22698362,22698424,22698473,22698529,22698582,22698618,22699104,2270022', 'assoc_port': '22586329:22586813,22586331:22588386,22586333:22586889,22586335:22588015,22586337:22587757,22586339:22587687,22586341:22587905,22586343:22587979,22586345:22587834,22586347:22587947,22586349:22587869,22586351:22587584,22586353:22587218,22586355:22587714,22586357:22587341,22586359:22587373,22586361:22586862,22586363:22586970,22586365:22587142,22586367:22586781,22588040:22588129,22588275:22588348,22625260:22627676,22625261:22627498,22625262:22627739,22625263:22626979,22625264:22627576,22625265:22627075,22625266:22626788,22625267:22626849,22625268:22626555,22625269:22626589,22625270:22626622,22625271:22626433,22625272:22626911,22625273:22626690,22625274:22626119,22625275:22626240,22625295:22626051,22625301:22625936,22625302:22625755,22625303:22625693,22625304:22625807,22625305:22625654,22625306:22625594,22628077:22628148,22647476:22648732,22647478:22648892,22647480:22649028,22647482:22648591,22647484:22648470,22647486:22648443,22647488:22648549,22647490:22648365,22647492:22648271,22647494:22648329,22647496:2264806', 'assoc_mat': '22586329:pet_clair:4230:22586813,22586331:pet_clair:4230:22588386,22586333:pet_clair:4230:22586889,22586335:pet_clair:4230:22588015,22586337:pet_clair:4230:22587757,22586339:pet_clair:4230:22587687,22586341:pet_clair:4230:22587905,22586343:pet_clair:4230:22587979,22586345:pet_clair:4230:22587834,22586347:pet_clair:4230:22587947,22586349:pet_clair:4230:22587869,22586351:pet_clair:4230:22587584,22586353:pet_clair:4230:22587218,22586355:pet_clair:4230:22587714,22586357:pet_clair:4230:22587341,22586359:pet_clair:4230:22587373,22586361:pet_clair:4230:22586862,22586363:pet_clair:4230:22586970,22586365:pet_clair:4230:22587142,22586367:pet_clair:4230:22586781,22588040:pet_clair:4230:22588129,22588275:pet_clair:4230:22588348,22625260:pet_clair:4230:22627676,22625261:pet_clair:4230:22627498,22625262:pet_clair:4230:22627739,22625263:pet_clair:4230:22626979,22625264:pet_clair:4230:22627576,22625265:pet_clair:4230:22627075,22625266:pet_clair:4230:22626788,22625267:pet_clair:4230:22626849,22625268:pet_clair:4230:22626555,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028008707773118113, 'nb_photo': 605, 'list_port_cont': '22586786,22586821,22586849,22586892,22586972,22587230,22587338,22587376,22587690,22587725,22587758,22587872,22587902,22587940,22587969,22588021,22588124,22588337,22588382,22625581,22625647,22625699,22625751,22625805,22626045,22626106,22626429,22626554,22626590,22626628,22626684,22626779,22626837,22626903,22627090,22627501,22627580,22627680,22627745,22628150,22647595,22647635,22647669,22647700,22647817,22647851,22648004,22648033,22648065,22648161,22648270,22648334,22648369,22648442,22648478,22648554,22648589,22648740,22648888,22649041,22649081,22649596,22653963,22654009,22654032,22654074,22654128,22654181,22654226,22654250,22654295,22654334,22654365,22654384,22654440,22654472,22654500,22654551,22654582,22654623,22654651,22654689,22654975,22696819,22696869,22696964,22697000,22697126,22697177,22697543,22697670,22698001,22698038,22698080,22698235,22698259,22698367,22698430,22698480,22698520,22698592,22698619,22699097,22702305,22702566,22704460,22708646,22711505,22712399,22713032,22713877,22715140,22719402,2271951', 'assoc_port': '22586329:22586821,22586331:22588382,22586333:22586892,22586335:22588021,22586337:22587758,22586339:22587690,22586341:22587902,22586343:22587969,22586347:22587940,22586349:22587872,22586353:22587230,22586355:22587725,22586357:22587338,22586359:22587376,22586361:22586849,22586363:22586972,22586367:22586786,22588040:22588124,22588275:22588337,22625260:22627680,22625261:22627501,22625262:22627745,22625264:22627580,22625265:22627090,22625266:22626779,22625267:22626837,22625268:22626554,22625269:22626590,22625270:22626628,22625271:22626429,22625272:22626903,22625273:22626684,22625274:22626106,22625295:22626045,22625302:22625751,22625303:22625699,22625304:22625805,22625305:22625647,22625306:22625581,22628077:22628150,22647476:22648740,22647478:22648888,22647480:22649041,22647482:22648589,22647484:22648478,22647486:22648442,22647488:22648554,22647490:22648369,22647492:22648270,22647494:22648334,22647496:22648065,22647498:22648161,22647500:22648004,22647504:22647851,22647506:22648033,22647508:22647817,22647510:2264766', 'assoc_mat': '22586329:pet_fonce:4230:22586821,22586331:pet_fonce:4230:22588382,22586333:pet_fonce:4230:22586892,22586335:pet_fonce:4230:22588021,22586337:pet_fonce:4230:22587758,22586339:pet_fonce:4230:22587690,22586341:pet_fonce:4230:22587902,22586343:pet_fonce:4230:22587969,22586347:pet_fonce:4230:22587940,22586349:pet_fonce:4230:22587872,22586353:pet_fonce:4230:22587230,22586355:pet_fonce:4230:22587725,22586357:pet_fonce:4230:22587338,22586359:pet_fonce:4230:22587376,22586361:pet_fonce:4230:22586849,22586363:pet_fonce:4230:22586972,22586367:pet_fonce:4230:22586786,22588040:pet_fonce:4230:22588124,22588275:pet_fonce:4230:22588337,22625260:pet_fonce:4230:22627680,22625261:pet_fonce:4230:22627501,22625262:pet_fonce:4230:22627745,22625264:pet_fonce:4230:22627580,22625265:pet_fonce:4230:22627090,22625266:pet_fonce:4230:22626779,22625267:pet_fonce:4230:22626837,22625268:pet_fonce:4230:22626554,22625269:pet_fonce:4230:22626590,22625270:pet_fonce:4230:22626628,22625271:pet_fonce:4230:22626429,22625272:pet_fonce:4230:22626903,2'}), 'main_stat': {'nb_photos': 965}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-05', 0.7163999001484371),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((965,),), 'unwanted_material_monthly_percentage': ((0.7163999001484371,),), 'material_repartition': (('incineration', 842),), 'material_dict': {'incineration': 842}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 5, 1), 0.6558752903730001, 64), (datetime.date(2025, 5, 2), 0.6655309058613872, 53), (datetime.date(2025, 5, 3), 0.6468510326735613, 57), (datetime.date(2025, 5, 4), 0.6786318245766207, 55), (datetime.date(2025, 5, 5), 0.756645300447586, 66), (datetime.date(2025, 5, 6), 0.7352071936052227, 49), (datetime.date(2025, 5, 7), 0.7172542268897295, 55), (datetime.date(2025, 5, 8), 0.7417934911777475, 57), (datetime.date(2025, 5, 9), 0.7033389677793801, 58), (datetime.date(2025, 5, 10), 0.6896427604561274, 64), (datetime.date(2025, 5, 11), 0.8121358840902677, 61), (datetime.date(2025, 5, 12), 0.777838633223728, 52), (datetime.date(2025, 5, 13), 0.7418478347110377, 44), (datetime.date(2025, 5, 14), 0.6809754107317024, 42), (datetime.date(2025, 5, 15), 0.7329744875779354, 65)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 5, 1), 0.6558752903730001, 64), (datetime.date(2025, 5, 2), 0.6655309058613872, 53), (datetime.date(2025, 5, 3), 0.6468510326735613, 57), (datetime.date(2025, 5, 4), 0.6786318245766207, 55), (datetime.date(2025, 5, 5), 0.756645300447586, 66), (datetime.date(2025, 5, 6), 0.7352071936052227, 49), (datetime.date(2025, 5, 7), 0.7172542268897295, 55), (datetime.date(2025, 5, 8), 0.7417934911777475, 57), (datetime.date(2025, 5, 9), 0.7033389677793801, 58), (datetime.date(2025, 5, 10), 0.6896427604561274, 64), (datetime.date(2025, 5, 11), 0.8121358840902677, 61), (datetime.date(2025, 5, 12), 0.777838633223728, 52), (datetime.date(2025, 5, 13), 0.7418478347110377, 44), (datetime.date(2025, 5, 14), 0.6809754107317024, 42), (datetime.date(2025, 5, 15), 0.7329744875779354, 65))}, 'quality_array': [['-8.127684377413791', '01052025'], ['-7.748373021041279', '02052025'], ['-7.983864452487453', '03052025'], ['-7.908419366979895', '04052025'], ['-7.078741858771597', '05052025'], ['-7.149341122478435', '06052025'], ['-7.500339868647435', '07052025'], ['-7.838995097760057', '08052025'], ['-7.202813800695644', '09052025'], ['-7.41266508650041', '10052025'], ['-7.6057706893734895', '11052025'], ['-7.156395979705296', '12052025'], ['-7.355972856475352', '13052025'], ['-7.807675379416226', '14052025'], ['-7.705924786456619', '15052025'], ['-8.134074916486899', '16052025']], 'number_of_batch': ((378,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015555843847217777, 'nb_photo': 8452, 'list_port_cont': '22586774,22586820,22586847,22586898,22586960,22587147,22587232,22587330,22587371,22587594,22587685,22587715,22587762,22587836,22587866,22587897,22587938,22587972,22588009,22588120,22588334,22588375,22625586,22625645,22625697,22625754,22625798,22625940,22626046,22626108,22626241,22626428,22626544,22626580,22626621,22626677,22626785,22626833,22626905,22626976,22627053,22627491,22627571,22627675,22627740,22628139,22647584,22647619,22647662,22647701,22647814,22647852,22647886,22648000,22648038,22648069,22648148,22648265,22648323,22648368,22648430,22648465,22648553,22648581,22648730,22648883,22649035,22649065,22649586,22653966,22653997,22654039,22654066,22654130,22654179,22654222,22654247,22654290,22654330,22654355,22654377,22654428,22654473,22654515,22654539,22654571,22654621,22654644,22654700,22654963,22696826,22696876,22696962,22696991,22697133,22697178,22697530,22697627,22697647,22697993,22698032,22698073,22698142,22698223,22698266,22698325,22698354,22698433,22698471,22698517,22698586,22698621,22699103,2270022', 'assoc_port': '22586329:22586820,22586331:22588375,22586333:22586898,22586335:22588009,22586337:22587762,22586339:22587685,22586341:22587897,22586343:22587972,22586345:22587836,22586347:22587938,22586349:22587866,22586351:22587594,22586353:22587232,22586355:22587715,22586357:22587330,22586359:22587371,22586361:22586847,22586363:22586960,22586365:22587147,22586367:22586774,22588040:22588120,22588275:22588334,22625260:22627675,22625261:22627491,22625262:22627740,22625263:22626976,22625264:22627571,22625265:22627053,22625266:22626785,22625267:22626833,22625268:22626544,22625269:22626580,22625270:22626621,22625271:22626428,22625272:22626905,22625273:22626677,22625274:22626108,22625275:22626241,22625295:22626046,22625301:22625940,22625302:22625754,22625303:22625697,22625304:22625798,22625305:22625645,22625306:22625586,22628077:22628139,22647476:22648730,22647478:22648883,22647480:22649035,22647482:22648581,22647484:22648465,22647486:22648430,22647488:22648553,22647490:22648368,22647492:22648265,22647494:22648323,22647496:2264806', 'assoc_mat': '22586329:autre:4230:22586820,22586331:autre:4230:22588375,22586333:autre:4230:22586898,22586335:autre:4230:22588009,22586337:autre:4230:22587762,22586339:autre:4230:22587685,22586341:autre:4230:22587897,22586343:autre:4230:22587972,22586345:autre:4230:22587836,22586347:autre:4230:22587938,22586349:autre:4230:22587866,22586351:autre:4230:22587594,22586353:autre:4230:22587232,22586355:autre:4230:22587715,22586357:autre:4230:22587330,22586359:autre:4230:22587371,22586361:autre:4230:22586847,22586363:autre:4230:22586960,22586365:autre:4230:22587147,22586367:autre:4230:22586774,22588040:autre:4230:22588120,22588275:autre:4230:22588334,22625260:autre:4230:22627675,22625261:autre:4230:22627491,22625262:autre:4230:22627740,22625263:autre:4230:22626976,22625264:autre:4230:22627571,22625265:autre:4230:22627053,22625266:autre:4230:22626785,22625267:autre:4230:22626833,22625268:autre:4230:22626544,22625269:autre:4230:22626580,22625270:autre:4230:22626621,22625271:autre:4230:22626428,22625272:autre:4230:22626905,22625273:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05140210338609948, 'nb_photo': 40237, 'list_port_cont': '22586782,22586818,22586857,22586896,22586969,22587143,22587231,22587340,22587375,22587592,22587689,22587721,22587764,22587833,22587870,22587901,22587943,22587978,22588018,22588133,22588349,22588378,22625589,22625653,22625705,22625759,22625803,22625941,22626043,22626117,22626242,22626426,22626548,22626587,22626619,22626685,22626784,22626844,22626897,22626973,22627076,22627500,22627578,22627678,22627730,22628143,22647597,22647634,22647671,22647705,22647812,22647857,22647880,22647998,22648039,22648075,22648159,22648260,22648330,22648362,22648441,22648479,22648552,22648590,22648735,22648881,22649030,22649079,22649592,22653973,22654004,22654044,22654081,22654132,22654189,22654220,22654254,22654298,22654324,22654364,22654380,22654437,22654469,22654503,22654552,22654581,22654622,22654656,22654698,22654969,22696834,22696879,22696958,22696989,22697132,22697188,22697531,22697637,22697660,22698003,22698039,22698078,22698138,22698231,22698267,22698328,22698368,22698425,22698477,22698522,22698585,22698628,22699102,2270023', 'assoc_port': '22586329:22586818,22586331:22588378,22586333:22586896,22586335:22588018,22586337:22587764,22586339:22587689,22586341:22587901,22586343:22587978,22586345:22587833,22586347:22587943,22586349:22587870,22586351:22587592,22586353:22587231,22586355:22587721,22586357:22587340,22586359:22587375,22586361:22586857,22586363:22586969,22586365:22587143,22586367:22586782,22588040:22588133,22588275:22588349,22625260:22627678,22625261:22627500,22625262:22627730,22625263:22626973,22625264:22627578,22625265:22627076,22625266:22626784,22625267:22626844,22625268:22626548,22625269:22626587,22625270:22626619,22625271:22626426,22625272:22626897,22625273:22626685,22625274:22626117,22625275:22626242,22625295:22626043,22625301:22625941,22625302:22625759,22625303:22625705,22625304:22625803,22625305:22625653,22625306:22625589,22628077:22628143,22647476:22648735,22647478:22648881,22647480:22649030,22647482:22648590,22647484:22648479,22647486:22648441,22647488:22648552,22647490:22648362,22647492:22648260,22647494:22648330,22647496:2264807', 'assoc_mat': '22586329:carton:4230:22586818,22586331:carton:4230:22588378,22586333:carton:4230:22586896,22586335:carton:4230:22588018,22586337:carton:4230:22587764,22586339:carton:4230:22587689,22586341:carton:4230:22587901,22586343:carton:4230:22587978,22586345:carton:4230:22587833,22586347:carton:4230:22587943,22586349:carton:4230:22587870,22586351:carton:4230:22587592,22586353:carton:4230:22587231,22586355:carton:4230:22587721,22586357:carton:4230:22587340,22586359:carton:4230:22587375,22586361:carton:4230:22586857,22586363:carton:4230:22586969,22586365:carton:4230:22587143,22586367:carton:4230:22586782,22588040:carton:4230:22588133,22588275:carton:4230:22588349,22625260:carton:4230:22627678,22625261:carton:4230:22627500,22625262:carton:4230:22627730,22625263:carton:4230:22626973,22625264:carton:4230:22627578,22625265:carton:4230:22627076,22625266:carton:4230:22626784,22625267:carton:4230:22626844,22625268:carton:4230:22626548,22625269:carton:4230:22626587,22625270:carton:4230:22626619,22625271:carton:4230:22626426,2262'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013853444791884805, 'nb_photo': 812, 'list_port_cont': '22586783,22586809,22586854,22586888,22586962,22587148,22587224,22587326,22587368,22587593,22587688,22587720,22587754,22587822,22587909,22587946,22587982,22588005,22588130,22588338,22588385,22625588,22625643,22625756,22625795,22625927,22626049,22626110,22626230,22626424,22626543,22626582,22626625,22626692,22626786,22626848,22626908,22627060,22627506,22627556,22627742,22647589,22647631,22647658,22647797,22647845,22647891,22648002,22648040,22648076,22648152,22648257,22648328,22648366,22648433,22648480,22648543,22648583,22648726,22648886,22649032,22649595,22653972,22654037,22654080,22654129,22654187,22654210,22654255,22654288,22654326,22654357,22654385,22654431,22654463,22654504,22654549,22654578,22654618,22654649,22654686,22654966,22696825,22696881,22696965,22696987,22697533,22697644,22698071,22698233,22698255,22698330,22698358,22698429,22698470,22698524,22698589,22698622,22701880,22702304,22702562,22706342,22708639,22711498,22712383,22713016,22713873,22715137,22719390,22719505,22719800,22725879,22726323,2272906', 'assoc_port': '22586329:22586809,22586331:22588385,22586333:22586888,22586335:22588005,22586337:22587754,22586339:22587688,22586341:22587909,22586343:22587982,22586345:22587822,22586347:22587946,22586351:22587593,22586353:22587224,22586355:22587720,22586357:22587326,22586359:22587368,22586361:22586854,22586363:22586962,22586365:22587148,22586367:22586783,22588040:22588130,22588275:22588338,22625261:22627506,22625262:22627742,22625264:22627556,22625265:22627060,22625266:22626786,22625267:22626848,22625268:22626543,22625269:22626582,22625270:22626625,22625271:22626424,22625272:22626908,22625273:22626692,22625274:22626110,22625275:22626230,22625295:22626049,22625301:22625927,22625302:22625756,22625304:22625795,22625305:22625643,22625306:22625588,22647476:22648726,22647478:22648886,22647480:22649032,22647482:22648583,22647484:22648480,22647486:22648433,22647488:22648543,22647490:22648366,22647492:22648257,22647494:22648328,22647496:22648076,22647498:22648152,22647500:22648002,22647502:22647891,22647504:22647845,22647506:2264804', 'assoc_mat': '22586329:metal:4230:22586809,22586331:metal:4230:22588385,22586333:metal:4230:22586888,22586335:metal:4230:22588005,22586337:metal:4230:22587754,22586339:metal:4230:22587688,22586341:metal:4230:22587909,22586343:metal:4230:22587982,22586345:metal:4230:22587822,22586347:metal:4230:22587946,22586351:metal:4230:22587593,22586353:metal:4230:22587224,22586355:metal:4230:22587720,22586357:metal:4230:22587326,22586359:metal:4230:22587368,22586361:metal:4230:22586854,22586363:metal:4230:22586962,22586365:metal:4230:22587148,22586367:metal:4230:22586783,22588040:metal:4230:22588130,22588275:metal:4230:22588338,22625261:metal:4230:22627506,22625262:metal:4230:22627742,22625264:metal:4230:22627556,22625265:metal:4230:22627060,22625266:metal:4230:22626786,22625267:metal:4230:22626848,22625268:metal:4230:22626543,22625269:metal:4230:22626582,22625270:metal:4230:22626625,22625271:metal:4230:22626424,22625272:metal:4230:22626908,22625273:metal:4230:22626692,22625274:metal:4230:22626110,22625275:metal:4230:22626230,22625295:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20466155924433616, 'nb_photo': 147743, 'list_port_cont': '22586784,22586819,22586861,22586891,22586964,22587153,22587223,22587333,22587366,22587587,22587684,22587726,22587763,22587835,22587856,22587898,22587945,22587983,22588006,22588128,22588343,22588377,22625583,22625642,22625704,22625763,22625808,22625939,22626050,22626109,22626234,22626423,22626550,22626592,22626624,22626689,22626790,22626841,22626901,22626966,22627080,22627505,22627583,22627682,22627741,22628151,22647599,22647632,22647659,22647707,22647815,22647856,22647893,22648003,22648029,22648070,22648158,22648272,22648335,22648370,22648445,22648477,22648555,22648577,22648737,22648891,22649034,22649074,22649602,22653970,22653995,22654036,22654079,22654135,22654182,22654219,22654261,22654296,22654335,22654366,22654387,22654444,22654478,22654511,22654538,22654585,22654624,22654660,22654699,22654964,22696830,22696878,22696956,22696996,22697134,22697184,22697537,22697635,22697654,22698007,22698046,22698076,22698139,22698234,22698258,22698329,22698365,22698426,22698479,22698525,22698584,22698626,22699100,2270023', 'assoc_port': '22586329:22586819,22586331:22588377,22586333:22586891,22586335:22588006,22586337:22587763,22586339:22587684,22586341:22587898,22586343:22587983,22586345:22587835,22586347:22587945,22586349:22587856,22586351:22587587,22586353:22587223,22586355:22587726,22586357:22587333,22586359:22587366,22586361:22586861,22586363:22586964,22586365:22587153,22586367:22586784,22588040:22588128,22588275:22588343,22625260:22627682,22625261:22627505,22625262:22627741,22625263:22626966,22625264:22627583,22625265:22627080,22625266:22626790,22625267:22626841,22625268:22626550,22625269:22626592,22625270:22626624,22625271:22626423,22625272:22626901,22625273:22626689,22625274:22626109,22625275:22626234,22625295:22626050,22625301:22625939,22625302:22625763,22625303:22625704,22625304:22625808,22625305:22625642,22625306:22625583,22628077:22628151,22647476:22648737,22647478:22648891,22647480:22649034,22647482:22648577,22647484:22648477,22647486:22648445,22647488:22648555,22647490:22648370,22647492:22648272,22647494:22648335,22647496:2264807', 'assoc_mat': '22586329:papier:4230:22586819,22586331:papier:4230:22588377,22586333:papier:4230:22586891,22586335:papier:4230:22588006,22586337:papier:4230:22587763,22586339:papier:4230:22587684,22586341:papier:4230:22587898,22586343:papier:4230:22587983,22586345:papier:4230:22587835,22586347:papier:4230:22587945,22586349:papier:4230:22587856,22586351:papier:4230:22587587,22586353:papier:4230:22587223,22586355:papier:4230:22587726,22586357:papier:4230:22587333,22586359:papier:4230:22587366,22586361:papier:4230:22586861,22586363:papier:4230:22586964,22586365:papier:4230:22587153,22586367:papier:4230:22586784,22588040:papier:4230:22588128,22588275:papier:4230:22588343,22625260:papier:4230:22627682,22625261:papier:4230:22627505,22625262:papier:4230:22627741,22625263:papier:4230:22626966,22625264:papier:4230:22627583,22625265:papier:4230:22627080,22625266:papier:4230:22626790,22625267:papier:4230:22626841,22625268:papier:4230:22626550,22625269:papier:4230:22626592,22625270:papier:4230:22626624,22625271:papier:4230:22626423,2262'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004103592902803068, 'nb_photo': 1170, 'list_port_cont': '22586785,22586823,22586860,22586894,22586971,22587151,22587229,22587335,22587374,22587585,22587679,22587722,22587752,22587832,22587865,22587908,22587939,22587985,22588017,22588134,22588345,22588384,22625592,22625646,22625702,22625762,22625809,22625931,22626053,22626113,22626244,22626431,22626552,22626591,22626630,22626686,22626789,22626847,22626902,22626974,22627092,22627504,22627579,22627673,22627737,22628146,22647590,22647627,22647667,22647708,22647816,22647858,22648001,22648037,22648157,22648273,22648333,22648367,22648432,22648476,22648550,22648579,22648739,22648893,22649039,22649601,22653969,22654001,22654045,22654067,22654133,22654225,22654259,22654289,22654323,22654361,22654381,22654442,22654480,22654514,22654543,22654587,22654617,22654657,22654697,22654976,22696827,22696874,22696961,22696998,22697123,22697187,22697538,22697633,22697664,22698006,22698043,22698070,22698137,22698230,22698264,22698327,22698353,22698434,22698472,22698591,22698623,22699090,22700234,22702298,22702568,22704459,22706356,2270864', 'assoc_port': '22586329:22586823,22586331:22588384,22586333:22586894,22586335:22588017,22586337:22587752,22586339:22587679,22586341:22587908,22586343:22587985,22586345:22587832,22586347:22587939,22586349:22587865,22586351:22587585,22586353:22587229,22586355:22587722,22586357:22587335,22586359:22587374,22586361:22586860,22586363:22586971,22586365:22587151,22586367:22586785,22588040:22588134,22588275:22588345,22625260:22627673,22625261:22627504,22625262:22627737,22625263:22626974,22625264:22627579,22625265:22627092,22625266:22626789,22625267:22626847,22625268:22626552,22625269:22626591,22625270:22626630,22625271:22626431,22625272:22626902,22625273:22626686,22625274:22626113,22625275:22626244,22625295:22626053,22625301:22625931,22625302:22625762,22625303:22625702,22625304:22625809,22625305:22625646,22625306:22625592,22628077:22628146,22647476:22648739,22647478:22648893,22647480:22649039,22647482:22648579,22647484:22648476,22647486:22648432,22647488:22648550,22647490:22648367,22647492:22648273,22647494:22648333,22647498:2264815', 'assoc_mat': '22586329:pehd:4230:22586823,22586331:pehd:4230:22588384,22586333:pehd:4230:22586894,22586335:pehd:4230:22588017,22586337:pehd:4230:22587752,22586339:pehd:4230:22587679,22586341:pehd:4230:22587908,22586343:pehd:4230:22587985,22586345:pehd:4230:22587832,22586347:pehd:4230:22587939,22586349:pehd:4230:22587865,22586351:pehd:4230:22587585,22586353:pehd:4230:22587229,22586355:pehd:4230:22587722,22586357:pehd:4230:22587335,22586359:pehd:4230:22587374,22586361:pehd:4230:22586860,22586363:pehd:4230:22586971,22586365:pehd:4230:22587151,22586367:pehd:4230:22586785,22588040:pehd:4230:22588134,22588275:pehd:4230:22588345,22625260:pehd:4230:22627673,22625261:pehd:4230:22627504,22625262:pehd:4230:22627737,22625263:pehd:4230:22626974,22625264:pehd:4230:22627579,22625265:pehd:4230:22627092,22625266:pehd:4230:22626789,22625267:pehd:4230:22626847,22625268:pehd:4230:22626552,22625269:pehd:4230:22626591,22625270:pehd:4230:22626630,22625271:pehd:4230:22626431,22625272:pehd:4230:22626902,22625273:pehd:4230:22626686,22625274:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.025449225661360472, 'nb_photo': 16107, 'list_port_cont': '22586781,22586813,22586862,22586889,22586970,22587142,22587218,22587341,22587373,22587584,22587687,22587714,22587757,22587834,22587869,22587905,22587947,22587979,22588015,22588129,22588348,22588386,22625594,22625654,22625693,22625755,22625807,22625936,22626051,22626119,22626240,22626433,22626555,22626589,22626622,22626690,22626788,22626849,22626911,22626979,22627075,22627498,22627576,22627676,22627739,22628148,22647594,22647630,22647668,22647706,22647819,22647854,22647887,22647992,22648027,22648067,22648162,22648271,22648329,22648365,22648443,22648470,22648549,22648591,22648732,22648892,22649028,22649078,22649599,22653962,22654005,22654043,22654075,22654127,22654188,22654223,22654262,22654284,22654328,22654371,22654386,22654443,22654467,22654516,22654537,22654588,22654620,22654659,22654696,22654973,22696831,22696875,22696957,22696997,22697131,22697175,22697540,22697641,22697656,22697995,22698047,22698083,22698134,22698232,22698261,22698318,22698362,22698424,22698473,22698529,22698582,22698618,22699104,2270022', 'assoc_port': '22586329:22586813,22586331:22588386,22586333:22586889,22586335:22588015,22586337:22587757,22586339:22587687,22586341:22587905,22586343:22587979,22586345:22587834,22586347:22587947,22586349:22587869,22586351:22587584,22586353:22587218,22586355:22587714,22586357:22587341,22586359:22587373,22586361:22586862,22586363:22586970,22586365:22587142,22586367:22586781,22588040:22588129,22588275:22588348,22625260:22627676,22625261:22627498,22625262:22627739,22625263:22626979,22625264:22627576,22625265:22627075,22625266:22626788,22625267:22626849,22625268:22626555,22625269:22626589,22625270:22626622,22625271:22626433,22625272:22626911,22625273:22626690,22625274:22626119,22625275:22626240,22625295:22626051,22625301:22625936,22625302:22625755,22625303:22625693,22625304:22625807,22625305:22625654,22625306:22625594,22628077:22628148,22647476:22648732,22647478:22648892,22647480:22649028,22647482:22648591,22647484:22648470,22647486:22648443,22647488:22648549,22647490:22648365,22647492:22648271,22647494:22648329,22647496:2264806', 'assoc_mat': '22586329:pet_clair:4230:22586813,22586331:pet_clair:4230:22588386,22586333:pet_clair:4230:22586889,22586335:pet_clair:4230:22588015,22586337:pet_clair:4230:22587757,22586339:pet_clair:4230:22587687,22586341:pet_clair:4230:22587905,22586343:pet_clair:4230:22587979,22586345:pet_clair:4230:22587834,22586347:pet_clair:4230:22587947,22586349:pet_clair:4230:22587869,22586351:pet_clair:4230:22587584,22586353:pet_clair:4230:22587218,22586355:pet_clair:4230:22587714,22586357:pet_clair:4230:22587341,22586359:pet_clair:4230:22587373,22586361:pet_clair:4230:22586862,22586363:pet_clair:4230:22586970,22586365:pet_clair:4230:22587142,22586367:pet_clair:4230:22586781,22588040:pet_clair:4230:22588129,22588275:pet_clair:4230:22588348,22625260:pet_clair:4230:22627676,22625261:pet_clair:4230:22627498,22625262:pet_clair:4230:22627739,22625263:pet_clair:4230:22626979,22625264:pet_clair:4230:22627576,22625265:pet_clair:4230:22627075,22625266:pet_clair:4230:22626788,22625267:pet_clair:4230:22626849,22625268:pet_clair:4230:22626555,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028008707773118113, 'nb_photo': 605, 'list_port_cont': '22586786,22586821,22586849,22586892,22586972,22587230,22587338,22587376,22587690,22587725,22587758,22587872,22587902,22587940,22587969,22588021,22588124,22588337,22588382,22625581,22625647,22625699,22625751,22625805,22626045,22626106,22626429,22626554,22626590,22626628,22626684,22626779,22626837,22626903,22627090,22627501,22627580,22627680,22627745,22628150,22647595,22647635,22647669,22647700,22647817,22647851,22648004,22648033,22648065,22648161,22648270,22648334,22648369,22648442,22648478,22648554,22648589,22648740,22648888,22649041,22649081,22649596,22653963,22654009,22654032,22654074,22654128,22654181,22654226,22654250,22654295,22654334,22654365,22654384,22654440,22654472,22654500,22654551,22654582,22654623,22654651,22654689,22654975,22696819,22696869,22696964,22697000,22697126,22697177,22697543,22697670,22698001,22698038,22698080,22698235,22698259,22698367,22698430,22698480,22698520,22698592,22698619,22699097,22702305,22702566,22704460,22708646,22711505,22712399,22713032,22713877,22715140,22719402,2271951', 'assoc_port': '22586329:22586821,22586331:22588382,22586333:22586892,22586335:22588021,22586337:22587758,22586339:22587690,22586341:22587902,22586343:22587969,22586347:22587940,22586349:22587872,22586353:22587230,22586355:22587725,22586357:22587338,22586359:22587376,22586361:22586849,22586363:22586972,22586367:22586786,22588040:22588124,22588275:22588337,22625260:22627680,22625261:22627501,22625262:22627745,22625264:22627580,22625265:22627090,22625266:22626779,22625267:22626837,22625268:22626554,22625269:22626590,22625270:22626628,22625271:22626429,22625272:22626903,22625273:22626684,22625274:22626106,22625295:22626045,22625302:22625751,22625303:22625699,22625304:22625805,22625305:22625647,22625306:22625581,22628077:22628150,22647476:22648740,22647478:22648888,22647480:22649041,22647482:22648589,22647484:22648478,22647486:22648442,22647488:22648554,22647490:22648369,22647492:22648270,22647494:22648334,22647496:22648065,22647498:22648161,22647500:22648004,22647504:22647851,22647506:22648033,22647508:22647817,22647510:2264766', 'assoc_mat': '22586329:pet_fonce:4230:22586821,22586331:pet_fonce:4230:22588382,22586333:pet_fonce:4230:22586892,22586335:pet_fonce:4230:22588021,22586337:pet_fonce:4230:22587758,22586339:pet_fonce:4230:22587690,22586341:pet_fonce:4230:22587902,22586343:pet_fonce:4230:22587969,22586347:pet_fonce:4230:22587940,22586349:pet_fonce:4230:22587872,22586353:pet_fonce:4230:22587230,22586355:pet_fonce:4230:22587725,22586357:pet_fonce:4230:22587338,22586359:pet_fonce:4230:22587376,22586361:pet_fonce:4230:22586849,22586363:pet_fonce:4230:22586972,22586367:pet_fonce:4230:22586786,22588040:pet_fonce:4230:22588124,22588275:pet_fonce:4230:22588337,22625260:pet_fonce:4230:22627680,22625261:pet_fonce:4230:22627501,22625262:pet_fonce:4230:22627745,22625264:pet_fonce:4230:22627580,22625265:pet_fonce:4230:22627090,22625266:pet_fonce:4230:22626779,22625267:pet_fonce:4230:22626837,22625268:pet_fonce:4230:22626554,22625269:pet_fonce:4230:22626590,22625270:pet_fonce:4230:22626628,22625271:pet_fonce:4230:22626429,22625272:pet_fonce:4230:22626903,2'}), 'main_stat': {'nb_photos': 965}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-05', 0.7163999001484371),)]} filepath : /data_2/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_05_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.56%', 8452], 'carton': ['carton', '5.14%', 40237], 'metal': ['metal', '0.14%', 812], 'papier': ['papier', '20.47%', 147743], 'pehd': ['pehd', '0.41%', 1170], 'pet_clair': ['pet_clair', '2.54%', 16107], 'pet_fonce': ['pet_fonce', '0.28%', 605]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_05_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/SCCU_cam7 2.92user 2.35system 0:06.20elapsed 85%CPU (0avgtext+0avgdata 192788maxresident)k 47808inputs+272outputs (180major+74909minor)pagefaults 0swaps