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_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 05 mtr_id : dashboard_places : SCCU_cam6 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_cam6' 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 = 202 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 = 202 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 = 202 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_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-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 (1772915,1777126,1780224,1780581,1784618,1788307,1792957,1796826,1801058,1810337,1810280,1810383,1810253,1814881,1818935,1822888,1824118) 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.016577012796638327, 'nb_photo': 9950, 'list_port_cont': '22578983,22579608,22579742,22580381,22580454,22581442,22582454,22583742,22584252,22584510,22584815,22585052,22585390,22585504,22585645,22585845,22586036,22586183,22586393,22586502,22586672,22588095,22588296,22590542,22591753,22593924,22596188,22598096,22600068,22603204,22604398,22604960,22606642,22608643,22610639,22613107,22615637,22618569,22620440,22622541,22622712,22623013,22623086,22623845,22623969,22625318,22628253,22647556,22647730,22647780,22647931,22647967,22648112,22648201,22648220,22648393,22648508,22648612,22648653,22648699,22648763,22648788,22648843,22648918,22648956,22648996,22649103,22649185,22649215,22649541,22652954,22652970,22653016,22653059,22653083,22653133,22653163,22653198,22653236,22653277,22653343,22653387,22653415,22653446,22653474,22653530,22653563,22653596,22653645,22653676,22653716,22653744,22654114,22654779,22697047,22698657,22698704,22698741,22698750,22698811,22698850,22698885,22698939,22699034,22699172,22699197,22699291,22699347,22699400,22699571,22699614,22699635,22699685,2269989', 'assoc_port': '22578790:22578983,22579462:22579608,22579674:22579742,22580323:22580454,22580324:22580381,22581137:22581442,22582425:22582454,22583452:22583742,22584115:22584252,22584385:22584510,22584699:22584815,22584999:22585052,22585264:22585390,22585496:22585504,22585615:22585645,22585754:22585845,22586023:22586036,22586169:22586183,22586326:22586672,22586327:22586393,22586328:22586502,22587966:22588095,22588274:22588296,22590392:22590542,22591352:22591753,22593386:22593924,22595882:22596188,22597590:22598096,22599515:22600068,22601628:22604960,22602970:22603204,22604202:22604398,22605866:22606642,22608185:22608643,22610550:22610639,22612836:22613107,22615484:22615637,22618248:22618569,22620311:22620440,22622213:22623845,22622216:22623969,22622219:22623086,22622222:22622712,22622224:22623013,22622226:22622541,22625259:22625318,22628073:22628253,22647475:22649185,22647477:22649215,22647479:22648918,22647481:22648763,22647483:22648699,22647485:22648996,22647487:22648956,22647489:22648788,22647491:22648508,22647493:2264865', 'assoc_mat': '22578790:autre:4230:22578983,22579462:autre:4230:22579608,22579674:autre:4230:22579742,22580323:autre:4230:22580454,22580324:autre:4230:22580381,22581137:autre:4230:22581442,22582425:autre:4230:22582454,22583452:autre:4230:22583742,22584115:autre:4230:22584252,22584385:autre:4230:22584510,22584699:autre:4230:22584815,22584999:autre:4230:22585052,22585264:autre:4230:22585390,22585496:autre:4230:22585504,22585615:autre:4230:22585645,22585754:autre:4230:22585845,22586023:autre:4230:22586036,22586169:autre:4230:22586183,22586326:autre:4230:22586672,22586327:autre:4230:22586393,22586328:autre:4230:22586502,22587966:autre:4230:22588095,22588274:autre:4230:22588296,22590392:autre:4230:22590542,22591352:autre:4230:22591753,22593386:autre:4230:22593924,22595882:autre:4230:22596188,22597590:autre:4230:22598096,22599515:autre:4230:22600068,22601628:autre:4230:22604960,22602970:autre:4230:22603204,22604202:autre:4230:22604398,22605866:autre:4230:22606642,22608185:autre:4230:22608643,22610550:autre:4230:22610639,22612836:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.046606890208362534, 'nb_photo': 41922, 'list_port_cont': '22578989,22579615,22579732,22580376,22580452,22581447,22582446,22583732,22584253,22584532,22584818,22585049,22585401,22585515,22585649,22585846,22586045,22586185,22586391,22586496,22586684,22588097,22588307,22590539,22591760,22593940,22596196,22598099,22600070,22603208,22604410,22604973,22606648,22608648,22610649,22613103,22615652,22618563,22620444,22622550,22622725,22623021,22623091,22623847,22623970,22625319,22628263,22647554,22647744,22647773,22647923,22647965,22648115,22648199,22648229,22648396,22648516,22648627,22648661,22648704,22648777,22648778,22648845,22648931,22648964,22648994,22649116,22649187,22649222,22649550,22652952,22652960,22653015,22653060,22653097,22653132,22653167,22653207,22653240,22653274,22653353,22653383,22653421,22653455,22653478,22653525,22653561,22653602,22653646,22653682,22653704,22653752,22654112,22654784,22697049,22698658,22698693,22698735,22698756,22698808,22698859,22698899,22698944,22699024,22699164,22699203,22699292,22699349,22699399,22699575,22699604,22699647,22699671,2269989', 'assoc_port': '22578790:22578989,22579462:22579615,22579674:22579732,22580323:22580452,22580324:22580376,22581137:22581447,22582425:22582446,22583452:22583732,22584115:22584253,22584385:22584532,22584699:22584818,22584999:22585049,22585264:22585401,22585496:22585515,22585615:22585649,22585754:22585846,22586023:22586045,22586169:22586185,22586326:22586684,22586327:22586391,22586328:22586496,22587966:22588097,22588274:22588307,22590392:22590539,22591352:22591760,22593386:22593940,22595882:22596196,22597590:22598099,22599515:22600070,22601628:22604973,22602970:22603208,22604202:22604410,22605866:22606648,22608185:22608648,22610550:22610649,22612836:22613103,22615484:22615652,22618248:22618563,22620311:22620444,22622213:22623847,22622216:22623970,22622219:22623091,22622222:22622725,22622224:22623021,22622226:22622550,22625259:22625319,22628073:22628263,22647475:22649187,22647477:22649222,22647479:22648931,22647481:22648777,22647483:22648704,22647485:22648994,22647487:22648964,22647489:22648778,22647491:22648516,22647493:2264866', 'assoc_mat': '22578790:carton:4230:22578989,22579462:carton:4230:22579615,22579674:carton:4230:22579732,22580323:carton:4230:22580452,22580324:carton:4230:22580376,22581137:carton:4230:22581447,22582425:carton:4230:22582446,22583452:carton:4230:22583732,22584115:carton:4230:22584253,22584385:carton:4230:22584532,22584699:carton:4230:22584818,22584999:carton:4230:22585049,22585264:carton:4230:22585401,22585496:carton:4230:22585515,22585615:carton:4230:22585649,22585754:carton:4230:22585846,22586023:carton:4230:22586045,22586169:carton:4230:22586185,22586326:carton:4230:22586684,22586327:carton:4230:22586391,22586328:carton:4230:22586496,22587966:carton:4230:22588097,22588274:carton:4230:22588307,22590392:carton:4230:22590539,22591352:carton:4230:22591760,22593386:carton:4230:22593940,22595882:carton:4230:22596196,22597590:carton:4230:22598099,22599515:carton:4230:22600070,22601628:carton:4230:22604973,22602970:carton:4230:22603208,22604202:carton:4230:22604410,22605866:carton:4230:22606648,22608185:carton:4230:22608648,2261'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001173833047087899, 'nb_photo': 866, 'list_port_cont': '22578993,22579599,22579731,22580375,22580449,22581431,22582452,22583726,22584258,22584536,22584817,22585050,22585402,22585514,22585661,22585849,22586181,22586377,22586498,22586674,22588084,22588291,22590535,22593917,22596190,22598091,22600071,22603209,22604400,22604974,22606645,22613102,22615651,22618561,22620443,22622546,22622721,22623022,22623077,22623832,22623972,22628255,22647745,22647779,22647916,22647962,22648111,22648193,22648226,22648399,22648518,22648628,22648648,22648703,22648775,22648780,22648842,22648914,22648960,22649114,22649211,22649554,22652947,22653009,22653049,22653091,22653125,22653169,22653233,22653340,22653386,22653424,22653464,22653532,22653569,22653607,22653640,22653681,22653717,22653745,22654096,22654789,22697042,22698695,22698729,22698804,22698847,22698898,22698933,22699162,22699194,22699279,22699332,22699574,22699638,22699683,22699880,22699925,22700034,22700265,22733893,22737010,22737200,22737277,22737410,22737493,22737715,22737766,22737787,22737863,22737899,22737922,22738199,2273844', 'assoc_port': '22578790:22578993,22579462:22579599,22579674:22579731,22580323:22580449,22580324:22580375,22581137:22581431,22582425:22582452,22583452:22583726,22584115:22584258,22584385:22584536,22584699:22584817,22584999:22585050,22585264:22585402,22585496:22585514,22585615:22585661,22585754:22585849,22586169:22586181,22586326:22586674,22586327:22586377,22586328:22586498,22587966:22588084,22588274:22588291,22590392:22590535,22593386:22593917,22595882:22596190,22597590:22598091,22599515:22600071,22601628:22604974,22602970:22603209,22604202:22604400,22605866:22606645,22612836:22613102,22615484:22615651,22618248:22618561,22620311:22620443,22622213:22623832,22622216:22623972,22622219:22623077,22622222:22622721,22622224:22623022,22622226:22622546,22628073:22628255,22647477:22649211,22647479:22648914,22647481:22648775,22647483:22648703,22647487:22648960,22647489:22648780,22647491:22648518,22647493:22648648,22647495:22648842,22647497:22648628,22647499:22648399,22647501:22648226,22647503:22647962,22647505:22648193,22647507:2264811', 'assoc_mat': '22578790:metal:4230:22578993,22579462:metal:4230:22579599,22579674:metal:4230:22579731,22580323:metal:4230:22580449,22580324:metal:4230:22580375,22581137:metal:4230:22581431,22582425:metal:4230:22582452,22583452:metal:4230:22583726,22584115:metal:4230:22584258,22584385:metal:4230:22584536,22584699:metal:4230:22584817,22584999:metal:4230:22585050,22585264:metal:4230:22585402,22585496:metal:4230:22585514,22585615:metal:4230:22585661,22585754:metal:4230:22585849,22586169:metal:4230:22586181,22586326:metal:4230:22586674,22586327:metal:4230:22586377,22586328:metal:4230:22586498,22587966:metal:4230:22588084,22588274:metal:4230:22588291,22590392:metal:4230:22590535,22593386:metal:4230:22593917,22595882:metal:4230:22596190,22597590:metal:4230:22598091,22599515:metal:4230:22600071,22601628:metal:4230:22604974,22602970:metal:4230:22603209,22604202:metal:4230:22604400,22605866:metal:4230:22606645,22612836:metal:4230:22613102,22615484:metal:4230:22615651,22618248:metal:4230:22618561,22620311:metal:4230:22620443,22622213:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19724367028975756, 'nb_photo': 206270, 'list_port_cont': '22578991,22579612,22579740,22580382,22580459,22581445,22582444,22583741,22584259,22584514,22584814,22585048,22585403,22585511,22585656,22585847,22586035,22586189,22586394,22586500,22586688,22588087,22588304,22590534,22591758,22593936,22596200,22598095,22600064,22603210,22604396,22604964,22606671,22608647,22610644,22613108,22615642,22618568,22620456,22622557,22622724,22623026,22623088,22623849,22623964,22625327,22628254,22647561,22647743,22647781,22647930,22647968,22648124,22648200,22648237,22648409,22648519,22648618,22648659,22648698,22648782,22648793,22648848,22648924,22648965,22649004,22649108,22649191,22649219,22649556,22652951,22652966,22653021,22653050,22653095,22653119,22653158,22653205,22653244,22653280,22653351,22653388,22653420,22653459,22653480,22653533,22653571,22653595,22653635,22653678,22653710,22653747,22654098,22654785,22697051,22698662,22698705,22698736,22698748,22698812,22698861,22698897,22698947,22699030,22699166,22699199,22699288,22699343,22699398,22699572,22699613,22699642,22699677,2269987', 'assoc_port': '22578790:22578991,22579462:22579612,22579674:22579740,22580323:22580459,22580324:22580382,22581137:22581445,22582425:22582444,22583452:22583741,22584115:22584259,22584385:22584514,22584699:22584814,22584999:22585048,22585264:22585403,22585496:22585511,22585615:22585656,22585754:22585847,22586023:22586035,22586169:22586189,22586326:22586688,22586327:22586394,22586328:22586500,22587966:22588087,22588274:22588304,22590392:22590534,22591352:22591758,22593386:22593936,22595882:22596200,22597590:22598095,22599515:22600064,22601628:22604964,22602970:22603210,22604202:22604396,22605866:22606671,22608185:22608647,22610550:22610644,22612836:22613108,22615484:22615642,22618248:22618568,22620311:22620456,22622213:22623849,22622216:22623964,22622219:22623088,22622222:22622724,22622224:22623026,22622226:22622557,22625259:22625327,22628073:22628254,22647475:22649191,22647477:22649219,22647479:22648924,22647481:22648793,22647483:22648698,22647485:22649004,22647487:22648965,22647489:22648782,22647491:22648519,22647493:2264865', 'assoc_mat': '22578790:papier:4230:22578991,22579462:papier:4230:22579612,22579674:papier:4230:22579740,22580323:papier:4230:22580459,22580324:papier:4230:22580382,22581137:papier:4230:22581445,22582425:papier:4230:22582444,22583452:papier:4230:22583741,22584115:papier:4230:22584259,22584385:papier:4230:22584514,22584699:papier:4230:22584814,22584999:papier:4230:22585048,22585264:papier:4230:22585403,22585496:papier:4230:22585511,22585615:papier:4230:22585656,22585754:papier:4230:22585847,22586023:papier:4230:22586035,22586169:papier:4230:22586189,22586326:papier:4230:22586688,22586327:papier:4230:22586394,22586328:papier:4230:22586500,22587966:papier:4230:22588087,22588274:papier:4230:22588304,22590392:papier:4230:22590534,22591352:papier:4230:22591758,22593386:papier:4230:22593936,22595882:papier:4230:22596200,22597590:papier:4230:22598095,22599515:papier:4230:22600064,22601628:papier:4230:22604964,22602970:papier:4230:22603210,22604202:papier:4230:22604396,22605866:papier:4230:22606671,22608185:papier:4230:22608647,2261'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0038203596601038823, 'nb_photo': 1269, 'list_port_cont': '22578994,22579607,22579737,22580389,22580457,22581446,22582450,22583739,22584260,22584509,22584816,22585038,22585399,22585509,22585657,22585848,22586047,22586188,22586390,22586494,22586687,22588091,22588295,22590543,22591766,22593922,22596193,22598086,22600074,22603213,22604404,22604969,22606644,22608646,22610647,22613105,22618567,22620455,22622558,22622720,22623025,22623082,22623836,22623976,22628258,22647558,22647736,22647771,22647926,22647954,22648128,22648198,22648233,22648410,22648513,22648625,22648655,22648700,22648786,22648789,22648850,22648962,22649000,22649113,22649182,22649221,22649553,22652950,22652965,22653025,22653053,22653087,22653130,22653170,22653202,22653239,22653348,22653422,22653462,22653469,22653526,22653608,22653633,22653670,22653718,22653749,22654117,22697048,22698728,22698758,22698858,22698896,22699023,22699168,22699296,22699394,22699570,22699611,22699651,22699687,22699887,22699926,22700033,22733894,22736997,22737202,22737280,22737421,22737500,22737708,22737767,22737804,22737897,2273793', 'assoc_port': '22578790:22578994,22579462:22579607,22579674:22579737,22580323:22580457,22580324:22580389,22581137:22581446,22582425:22582450,22583452:22583739,22584115:22584260,22584385:22584509,22584699:22584816,22584999:22585038,22585264:22585399,22585496:22585509,22585615:22585657,22585754:22585848,22586023:22586047,22586169:22586188,22586326:22586687,22586327:22586390,22586328:22586494,22587966:22588091,22588274:22588295,22590392:22590543,22591352:22591766,22593386:22593922,22595882:22596193,22597590:22598086,22599515:22600074,22601628:22604969,22602970:22603213,22604202:22604404,22605866:22606644,22608185:22608646,22610550:22610647,22612836:22613105,22618248:22618567,22620311:22620455,22622213:22623836,22622216:22623976,22622219:22623082,22622222:22622720,22622224:22623025,22622226:22622558,22628073:22628258,22647475:22649182,22647477:22649221,22647481:22648789,22647483:22648700,22647485:22649000,22647487:22648962,22647489:22648786,22647491:22648513,22647493:22648655,22647495:22648850,22647497:22648625,22647499:2264841', 'assoc_mat': '22578790:pehd:4230:22578994,22579462:pehd:4230:22579607,22579674:pehd:4230:22579737,22580323:pehd:4230:22580457,22580324:pehd:4230:22580389,22581137:pehd:4230:22581446,22582425:pehd:4230:22582450,22583452:pehd:4230:22583739,22584115:pehd:4230:22584260,22584385:pehd:4230:22584509,22584699:pehd:4230:22584816,22584999:pehd:4230:22585038,22585264:pehd:4230:22585399,22585496:pehd:4230:22585509,22585615:pehd:4230:22585657,22585754:pehd:4230:22585848,22586023:pehd:4230:22586047,22586169:pehd:4230:22586188,22586326:pehd:4230:22586687,22586327:pehd:4230:22586390,22586328:pehd:4230:22586494,22587966:pehd:4230:22588091,22588274:pehd:4230:22588295,22590392:pehd:4230:22590543,22591352:pehd:4230:22591766,22593386:pehd:4230:22593922,22595882:pehd:4230:22596193,22597590:pehd:4230:22598086,22599515:pehd:4230:22600074,22601628:pehd:4230:22604969,22602970:pehd:4230:22603213,22604202:pehd:4230:22604404,22605866:pehd:4230:22606644,22608185:pehd:4230:22608646,22610550:pehd:4230:22610647,22612836:pehd:4230:22613105,22618248:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020426566238101764, 'nb_photo': 12369, 'list_port_cont': '22578982,22579614,22579735,22580385,22580453,22581435,22582453,22583740,22584265,22584530,22584812,22585051,22585397,22585518,22585648,22585852,22586032,22586193,22586384,22586504,22586677,22588094,22588306,22590545,22591756,22593930,22596198,22598093,22600059,22603220,22604403,22604970,22606682,22608636,22610655,22613104,22615641,22618565,22620454,22622551,22622723,22623028,22623089,22623844,22623975,22625323,22628264,22647557,22647740,22647775,22647927,22647966,22648120,22648192,22648225,22648406,22648512,22648623,22648664,22648697,22648784,22648794,22648838,22648926,22648961,22648993,22649118,22649179,22649220,22649558,22652948,22652971,22653026,22653056,22653098,22653134,22653161,22653204,22653241,22653270,22653350,22653381,22653426,22653448,22653481,22653531,22653570,22653604,22653644,22653679,22653712,22653754,22654093,22654793,22697044,22698668,22698703,22698738,22698759,22698813,22698864,22698900,22698948,22699035,22699169,22699202,22699289,22699348,22699401,22699578,22699608,22699645,22699682,2269988', 'assoc_port': '22578790:22578982,22579462:22579614,22579674:22579735,22580323:22580453,22580324:22580385,22581137:22581435,22582425:22582453,22583452:22583740,22584115:22584265,22584385:22584530,22584699:22584812,22584999:22585051,22585264:22585397,22585496:22585518,22585615:22585648,22585754:22585852,22586023:22586032,22586169:22586193,22586326:22586677,22586327:22586384,22586328:22586504,22587966:22588094,22588274:22588306,22590392:22590545,22591352:22591756,22593386:22593930,22595882:22596198,22597590:22598093,22599515:22600059,22601628:22604970,22602970:22603220,22604202:22604403,22605866:22606682,22608185:22608636,22610550:22610655,22612836:22613104,22615484:22615641,22618248:22618565,22620311:22620454,22622213:22623844,22622216:22623975,22622219:22623089,22622222:22622723,22622224:22623028,22622226:22622551,22625259:22625323,22628073:22628264,22647475:22649179,22647477:22649220,22647479:22648926,22647481:22648794,22647483:22648697,22647485:22648993,22647487:22648961,22647489:22648784,22647491:22648512,22647493:2264866', 'assoc_mat': '22578790:pet_clair:4230:22578982,22579462:pet_clair:4230:22579614,22579674:pet_clair:4230:22579735,22580323:pet_clair:4230:22580453,22580324:pet_clair:4230:22580385,22581137:pet_clair:4230:22581435,22582425:pet_clair:4230:22582453,22583452:pet_clair:4230:22583740,22584115:pet_clair:4230:22584265,22584385:pet_clair:4230:22584530,22584699:pet_clair:4230:22584812,22584999:pet_clair:4230:22585051,22585264:pet_clair:4230:22585397,22585496:pet_clair:4230:22585518,22585615:pet_clair:4230:22585648,22585754:pet_clair:4230:22585852,22586023:pet_clair:4230:22586032,22586169:pet_clair:4230:22586193,22586326:pet_clair:4230:22586677,22586327:pet_clair:4230:22586384,22586328:pet_clair:4230:22586504,22587966:pet_clair:4230:22588094,22588274:pet_clair:4230:22588306,22590392:pet_clair:4230:22590545,22591352:pet_clair:4230:22591756,22593386:pet_clair:4230:22593930,22595882:pet_clair:4230:22596198,22597590:pet_clair:4230:22598093,22599515:pet_clair:4230:22600059,22601628:pet_clair:4230:22604970,22602970:pet_clair:4230:22603220,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024297152544737154, 'nb_photo': 490, 'list_port_cont': '22578988,22579609,22583743,22584264,22584534,22584813,22585044,22585405,22585508,22585851,22586041,22586187,22586388,22586499,22586679,22590544,22591762,22593923,22600066,22603215,22604405,22604972,22606666,22608641,22613113,22618557,22622559,22622718,22623085,22623841,22623962,22647778,22647928,22647956,22648196,22648234,22648405,22648626,22648660,22648695,22648766,22648849,22648927,22648968,22649115,22649228,22649547,22653019,22653088,22653470,22653534,22653605,22653639,22653675,22653713,22654116,22654792,22698661,22698696,22698745,22698805,22698857,22698895,22699033,22699293,22699345,22699566,22699648,22699681,22699882,22699921,22700030,22733889,22737009,22737197,22737420,22737503,22737713,22737798,22737862,22737894,22737937,22738690,22738758,22740103,22749038,22755830,22758422,22759864,22762679,22766378,22771911,22774759,22777565,22784712,22789171,22789401,22791685,22791749,22805016,22805346,22805388,22805426,22805605,22805662,22805774,22805928,22805961,22806046,22844695,22844876,22844917,22845041,2284512', 'assoc_port': '22578790:22578988,22579462:22579609,22583452:22583743,22584115:22584264,22584385:22584534,22584699:22584813,22584999:22585044,22585264:22585405,22585496:22585508,22585754:22585851,22586023:22586041,22586169:22586187,22586326:22586679,22586327:22586388,22586328:22586499,22590392:22590544,22591352:22591762,22593386:22593923,22599515:22600066,22601628:22604972,22602970:22603215,22604202:22604405,22605866:22606666,22608185:22608641,22612836:22613113,22618248:22618557,22622213:22623841,22622216:22623962,22622219:22623085,22622222:22622718,22622226:22622559,22647477:22649228,22647479:22648927,22647483:22648695,22647487:22648968,22647489:22648766,22647493:22648660,22647495:22648849,22647497:22648626,22647499:22648405,22647501:22648234,22647503:22647956,22647505:22648196,22647509:22647928,22647511:22647778,22648869:22649115,22649536:22649547,22652908:22653605,22652911:22653675,22652915:22653534,22652917:22653639,22652918:22653019,22652920:22653713,22652923:22653470,22652927:22653088,22653931:22654116,22654769:2265479', 'assoc_mat': '22578790:pet_fonce:4230:22578988,22579462:pet_fonce:4230:22579609,22583452:pet_fonce:4230:22583743,22584115:pet_fonce:4230:22584264,22584385:pet_fonce:4230:22584534,22584699:pet_fonce:4230:22584813,22584999:pet_fonce:4230:22585044,22585264:pet_fonce:4230:22585405,22585496:pet_fonce:4230:22585508,22585754:pet_fonce:4230:22585851,22586023:pet_fonce:4230:22586041,22586169:pet_fonce:4230:22586187,22586326:pet_fonce:4230:22586679,22586327:pet_fonce:4230:22586388,22586328:pet_fonce:4230:22586499,22590392:pet_fonce:4230:22590544,22591352:pet_fonce:4230:22591762,22593386:pet_fonce:4230:22593923,22599515:pet_fonce:4230:22600066,22601628:pet_fonce:4230:22604972,22602970:pet_fonce:4230:22603215,22604202:pet_fonce:4230:22604405,22605866:pet_fonce:4230:22606666,22608185:pet_fonce:4230:22608641,22612836:pet_fonce:4230:22613113,22618248:pet_fonce:4230:22618557,22622213:pet_fonce:4230:22623841,22622216:pet_fonce:4230:22623962,22622219:pet_fonce:4230:22623085,22622222:pet_fonce:4230:22622718,22622226:pet_fonce:4230:22622559,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(1772915,1777126,1780224,1780581,1784618,1788307,1792957,1796826,1801058,1810337,1810280,1810383,1810253,1814881,1818935,1822888,1824118)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2025-05-01' and date <= '2025-05-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1067,),), 'unwanted_material_monthly_percentage': ((0.7410048471317923,),), 'material_repartition': (('incineration', 923),), 'material_dict': {'incineration': 923}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 5, 1), 0.7026687661485111, 55), (datetime.date(2025, 5, 2), 0.694357362448783, 64), (datetime.date(2025, 5, 3), 0.6682129923970126, 59), (datetime.date(2025, 5, 4), 0.765418700190385, 64), (datetime.date(2025, 5, 5), 0.7849458312091068, 64), (datetime.date(2025, 5, 6), 0.750477607100669, 53), (datetime.date(2025, 5, 7), 0.7071179027592335, 62), (datetime.date(2025, 5, 8), 0.7575394384389879, 61), (datetime.date(2025, 5, 9), 0.7308899383214942, 62), (datetime.date(2025, 5, 10), 0.6887540486617323, 64), (datetime.date(2025, 5, 11), 0.8305347567057803, 58), (datetime.date(2025, 5, 12), 0.7985411903158902, 57), (datetime.date(2025, 5, 13), 0.7833158476058157, 50), (datetime.date(2025, 5, 14), 0.728985463254641, 71), (datetime.date(2025, 5, 15), 0.7182723922496408, 79)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 5, 1), 0.7026687661485111, 55), (datetime.date(2025, 5, 2), 0.694357362448783, 64), (datetime.date(2025, 5, 3), 0.6682129923970126, 59), (datetime.date(2025, 5, 4), 0.765418700190385, 64), (datetime.date(2025, 5, 5), 0.7849458312091068, 64), (datetime.date(2025, 5, 6), 0.750477607100669, 53), (datetime.date(2025, 5, 7), 0.7071179027592335, 62), (datetime.date(2025, 5, 8), 0.7575394384389879, 61), (datetime.date(2025, 5, 9), 0.7308899383214942, 62), (datetime.date(2025, 5, 10), 0.6887540486617323, 64), (datetime.date(2025, 5, 11), 0.8305347567057803, 58), (datetime.date(2025, 5, 12), 0.7985411903158902, 57), (datetime.date(2025, 5, 13), 0.7833158476058157, 50), (datetime.date(2025, 5, 14), 0.728985463254641, 71), (datetime.date(2025, 5, 15), 0.7182723922496408, 79))}, 'quality_array': [['-8.577716647958058', '01052025'], ['-7.850816761531449', '02052025'], ['-8.047937271877997', '03052025'], ['-8.11474272464865', '04052025'], ['-6.9411703055565415', '05052025'], ['-7.454609825692585', '06052025'], ['-8.032992837054683', '07052025'], ['-8.358527367741935', '08052025'], ['-7.609637365447718', '09052025'], ['-7.716549215579906', '10052025'], ['-7.415189102953197', '11052025'], ['-6.875554923679928', '12052025'], ['-7.3946309661926435', '13052025'], ['-8.099335085524572', '14052025'], ['-8.149725812461625', '15052025'], ['-8.15680995776548', '16052025']], 'number_of_batch': ((385,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.016577012796638327, 'nb_photo': 9950, 'list_port_cont': '22578983,22579608,22579742,22580381,22580454,22581442,22582454,22583742,22584252,22584510,22584815,22585052,22585390,22585504,22585645,22585845,22586036,22586183,22586393,22586502,22586672,22588095,22588296,22590542,22591753,22593924,22596188,22598096,22600068,22603204,22604398,22604960,22606642,22608643,22610639,22613107,22615637,22618569,22620440,22622541,22622712,22623013,22623086,22623845,22623969,22625318,22628253,22647556,22647730,22647780,22647931,22647967,22648112,22648201,22648220,22648393,22648508,22648612,22648653,22648699,22648763,22648788,22648843,22648918,22648956,22648996,22649103,22649185,22649215,22649541,22652954,22652970,22653016,22653059,22653083,22653133,22653163,22653198,22653236,22653277,22653343,22653387,22653415,22653446,22653474,22653530,22653563,22653596,22653645,22653676,22653716,22653744,22654114,22654779,22697047,22698657,22698704,22698741,22698750,22698811,22698850,22698885,22698939,22699034,22699172,22699197,22699291,22699347,22699400,22699571,22699614,22699635,22699685,2269989', 'assoc_port': '22578790:22578983,22579462:22579608,22579674:22579742,22580323:22580454,22580324:22580381,22581137:22581442,22582425:22582454,22583452:22583742,22584115:22584252,22584385:22584510,22584699:22584815,22584999:22585052,22585264:22585390,22585496:22585504,22585615:22585645,22585754:22585845,22586023:22586036,22586169:22586183,22586326:22586672,22586327:22586393,22586328:22586502,22587966:22588095,22588274:22588296,22590392:22590542,22591352:22591753,22593386:22593924,22595882:22596188,22597590:22598096,22599515:22600068,22601628:22604960,22602970:22603204,22604202:22604398,22605866:22606642,22608185:22608643,22610550:22610639,22612836:22613107,22615484:22615637,22618248:22618569,22620311:22620440,22622213:22623845,22622216:22623969,22622219:22623086,22622222:22622712,22622224:22623013,22622226:22622541,22625259:22625318,22628073:22628253,22647475:22649185,22647477:22649215,22647479:22648918,22647481:22648763,22647483:22648699,22647485:22648996,22647487:22648956,22647489:22648788,22647491:22648508,22647493:2264865', 'assoc_mat': '22578790:autre:4230:22578983,22579462:autre:4230:22579608,22579674:autre:4230:22579742,22580323:autre:4230:22580454,22580324:autre:4230:22580381,22581137:autre:4230:22581442,22582425:autre:4230:22582454,22583452:autre:4230:22583742,22584115:autre:4230:22584252,22584385:autre:4230:22584510,22584699:autre:4230:22584815,22584999:autre:4230:22585052,22585264:autre:4230:22585390,22585496:autre:4230:22585504,22585615:autre:4230:22585645,22585754:autre:4230:22585845,22586023:autre:4230:22586036,22586169:autre:4230:22586183,22586326:autre:4230:22586672,22586327:autre:4230:22586393,22586328:autre:4230:22586502,22587966:autre:4230:22588095,22588274:autre:4230:22588296,22590392:autre:4230:22590542,22591352:autre:4230:22591753,22593386:autre:4230:22593924,22595882:autre:4230:22596188,22597590:autre:4230:22598096,22599515:autre:4230:22600068,22601628:autre:4230:22604960,22602970:autre:4230:22603204,22604202:autre:4230:22604398,22605866:autre:4230:22606642,22608185:autre:4230:22608643,22610550:autre:4230:22610639,22612836:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.046606890208362534, 'nb_photo': 41922, 'list_port_cont': '22578989,22579615,22579732,22580376,22580452,22581447,22582446,22583732,22584253,22584532,22584818,22585049,22585401,22585515,22585649,22585846,22586045,22586185,22586391,22586496,22586684,22588097,22588307,22590539,22591760,22593940,22596196,22598099,22600070,22603208,22604410,22604973,22606648,22608648,22610649,22613103,22615652,22618563,22620444,22622550,22622725,22623021,22623091,22623847,22623970,22625319,22628263,22647554,22647744,22647773,22647923,22647965,22648115,22648199,22648229,22648396,22648516,22648627,22648661,22648704,22648777,22648778,22648845,22648931,22648964,22648994,22649116,22649187,22649222,22649550,22652952,22652960,22653015,22653060,22653097,22653132,22653167,22653207,22653240,22653274,22653353,22653383,22653421,22653455,22653478,22653525,22653561,22653602,22653646,22653682,22653704,22653752,22654112,22654784,22697049,22698658,22698693,22698735,22698756,22698808,22698859,22698899,22698944,22699024,22699164,22699203,22699292,22699349,22699399,22699575,22699604,22699647,22699671,2269989', 'assoc_port': '22578790:22578989,22579462:22579615,22579674:22579732,22580323:22580452,22580324:22580376,22581137:22581447,22582425:22582446,22583452:22583732,22584115:22584253,22584385:22584532,22584699:22584818,22584999:22585049,22585264:22585401,22585496:22585515,22585615:22585649,22585754:22585846,22586023:22586045,22586169:22586185,22586326:22586684,22586327:22586391,22586328:22586496,22587966:22588097,22588274:22588307,22590392:22590539,22591352:22591760,22593386:22593940,22595882:22596196,22597590:22598099,22599515:22600070,22601628:22604973,22602970:22603208,22604202:22604410,22605866:22606648,22608185:22608648,22610550:22610649,22612836:22613103,22615484:22615652,22618248:22618563,22620311:22620444,22622213:22623847,22622216:22623970,22622219:22623091,22622222:22622725,22622224:22623021,22622226:22622550,22625259:22625319,22628073:22628263,22647475:22649187,22647477:22649222,22647479:22648931,22647481:22648777,22647483:22648704,22647485:22648994,22647487:22648964,22647489:22648778,22647491:22648516,22647493:2264866', 'assoc_mat': '22578790:carton:4230:22578989,22579462:carton:4230:22579615,22579674:carton:4230:22579732,22580323:carton:4230:22580452,22580324:carton:4230:22580376,22581137:carton:4230:22581447,22582425:carton:4230:22582446,22583452:carton:4230:22583732,22584115:carton:4230:22584253,22584385:carton:4230:22584532,22584699:carton:4230:22584818,22584999:carton:4230:22585049,22585264:carton:4230:22585401,22585496:carton:4230:22585515,22585615:carton:4230:22585649,22585754:carton:4230:22585846,22586023:carton:4230:22586045,22586169:carton:4230:22586185,22586326:carton:4230:22586684,22586327:carton:4230:22586391,22586328:carton:4230:22586496,22587966:carton:4230:22588097,22588274:carton:4230:22588307,22590392:carton:4230:22590539,22591352:carton:4230:22591760,22593386:carton:4230:22593940,22595882:carton:4230:22596196,22597590:carton:4230:22598099,22599515:carton:4230:22600070,22601628:carton:4230:22604973,22602970:carton:4230:22603208,22604202:carton:4230:22604410,22605866:carton:4230:22606648,22608185:carton:4230:22608648,2261'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001173833047087899, 'nb_photo': 866, 'list_port_cont': '22578993,22579599,22579731,22580375,22580449,22581431,22582452,22583726,22584258,22584536,22584817,22585050,22585402,22585514,22585661,22585849,22586181,22586377,22586498,22586674,22588084,22588291,22590535,22593917,22596190,22598091,22600071,22603209,22604400,22604974,22606645,22613102,22615651,22618561,22620443,22622546,22622721,22623022,22623077,22623832,22623972,22628255,22647745,22647779,22647916,22647962,22648111,22648193,22648226,22648399,22648518,22648628,22648648,22648703,22648775,22648780,22648842,22648914,22648960,22649114,22649211,22649554,22652947,22653009,22653049,22653091,22653125,22653169,22653233,22653340,22653386,22653424,22653464,22653532,22653569,22653607,22653640,22653681,22653717,22653745,22654096,22654789,22697042,22698695,22698729,22698804,22698847,22698898,22698933,22699162,22699194,22699279,22699332,22699574,22699638,22699683,22699880,22699925,22700034,22700265,22733893,22737010,22737200,22737277,22737410,22737493,22737715,22737766,22737787,22737863,22737899,22737922,22738199,2273844', 'assoc_port': '22578790:22578993,22579462:22579599,22579674:22579731,22580323:22580449,22580324:22580375,22581137:22581431,22582425:22582452,22583452:22583726,22584115:22584258,22584385:22584536,22584699:22584817,22584999:22585050,22585264:22585402,22585496:22585514,22585615:22585661,22585754:22585849,22586169:22586181,22586326:22586674,22586327:22586377,22586328:22586498,22587966:22588084,22588274:22588291,22590392:22590535,22593386:22593917,22595882:22596190,22597590:22598091,22599515:22600071,22601628:22604974,22602970:22603209,22604202:22604400,22605866:22606645,22612836:22613102,22615484:22615651,22618248:22618561,22620311:22620443,22622213:22623832,22622216:22623972,22622219:22623077,22622222:22622721,22622224:22623022,22622226:22622546,22628073:22628255,22647477:22649211,22647479:22648914,22647481:22648775,22647483:22648703,22647487:22648960,22647489:22648780,22647491:22648518,22647493:22648648,22647495:22648842,22647497:22648628,22647499:22648399,22647501:22648226,22647503:22647962,22647505:22648193,22647507:2264811', 'assoc_mat': '22578790:metal:4230:22578993,22579462:metal:4230:22579599,22579674:metal:4230:22579731,22580323:metal:4230:22580449,22580324:metal:4230:22580375,22581137:metal:4230:22581431,22582425:metal:4230:22582452,22583452:metal:4230:22583726,22584115:metal:4230:22584258,22584385:metal:4230:22584536,22584699:metal:4230:22584817,22584999:metal:4230:22585050,22585264:metal:4230:22585402,22585496:metal:4230:22585514,22585615:metal:4230:22585661,22585754:metal:4230:22585849,22586169:metal:4230:22586181,22586326:metal:4230:22586674,22586327:metal:4230:22586377,22586328:metal:4230:22586498,22587966:metal:4230:22588084,22588274:metal:4230:22588291,22590392:metal:4230:22590535,22593386:metal:4230:22593917,22595882:metal:4230:22596190,22597590:metal:4230:22598091,22599515:metal:4230:22600071,22601628:metal:4230:22604974,22602970:metal:4230:22603209,22604202:metal:4230:22604400,22605866:metal:4230:22606645,22612836:metal:4230:22613102,22615484:metal:4230:22615651,22618248:metal:4230:22618561,22620311:metal:4230:22620443,22622213:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19724367028975756, 'nb_photo': 206270, 'list_port_cont': '22578991,22579612,22579740,22580382,22580459,22581445,22582444,22583741,22584259,22584514,22584814,22585048,22585403,22585511,22585656,22585847,22586035,22586189,22586394,22586500,22586688,22588087,22588304,22590534,22591758,22593936,22596200,22598095,22600064,22603210,22604396,22604964,22606671,22608647,22610644,22613108,22615642,22618568,22620456,22622557,22622724,22623026,22623088,22623849,22623964,22625327,22628254,22647561,22647743,22647781,22647930,22647968,22648124,22648200,22648237,22648409,22648519,22648618,22648659,22648698,22648782,22648793,22648848,22648924,22648965,22649004,22649108,22649191,22649219,22649556,22652951,22652966,22653021,22653050,22653095,22653119,22653158,22653205,22653244,22653280,22653351,22653388,22653420,22653459,22653480,22653533,22653571,22653595,22653635,22653678,22653710,22653747,22654098,22654785,22697051,22698662,22698705,22698736,22698748,22698812,22698861,22698897,22698947,22699030,22699166,22699199,22699288,22699343,22699398,22699572,22699613,22699642,22699677,2269987', 'assoc_port': '22578790:22578991,22579462:22579612,22579674:22579740,22580323:22580459,22580324:22580382,22581137:22581445,22582425:22582444,22583452:22583741,22584115:22584259,22584385:22584514,22584699:22584814,22584999:22585048,22585264:22585403,22585496:22585511,22585615:22585656,22585754:22585847,22586023:22586035,22586169:22586189,22586326:22586688,22586327:22586394,22586328:22586500,22587966:22588087,22588274:22588304,22590392:22590534,22591352:22591758,22593386:22593936,22595882:22596200,22597590:22598095,22599515:22600064,22601628:22604964,22602970:22603210,22604202:22604396,22605866:22606671,22608185:22608647,22610550:22610644,22612836:22613108,22615484:22615642,22618248:22618568,22620311:22620456,22622213:22623849,22622216:22623964,22622219:22623088,22622222:22622724,22622224:22623026,22622226:22622557,22625259:22625327,22628073:22628254,22647475:22649191,22647477:22649219,22647479:22648924,22647481:22648793,22647483:22648698,22647485:22649004,22647487:22648965,22647489:22648782,22647491:22648519,22647493:2264865', 'assoc_mat': '22578790:papier:4230:22578991,22579462:papier:4230:22579612,22579674:papier:4230:22579740,22580323:papier:4230:22580459,22580324:papier:4230:22580382,22581137:papier:4230:22581445,22582425:papier:4230:22582444,22583452:papier:4230:22583741,22584115:papier:4230:22584259,22584385:papier:4230:22584514,22584699:papier:4230:22584814,22584999:papier:4230:22585048,22585264:papier:4230:22585403,22585496:papier:4230:22585511,22585615:papier:4230:22585656,22585754:papier:4230:22585847,22586023:papier:4230:22586035,22586169:papier:4230:22586189,22586326:papier:4230:22586688,22586327:papier:4230:22586394,22586328:papier:4230:22586500,22587966:papier:4230:22588087,22588274:papier:4230:22588304,22590392:papier:4230:22590534,22591352:papier:4230:22591758,22593386:papier:4230:22593936,22595882:papier:4230:22596200,22597590:papier:4230:22598095,22599515:papier:4230:22600064,22601628:papier:4230:22604964,22602970:papier:4230:22603210,22604202:papier:4230:22604396,22605866:papier:4230:22606671,22608185:papier:4230:22608647,2261'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0038203596601038823, 'nb_photo': 1269, 'list_port_cont': '22578994,22579607,22579737,22580389,22580457,22581446,22582450,22583739,22584260,22584509,22584816,22585038,22585399,22585509,22585657,22585848,22586047,22586188,22586390,22586494,22586687,22588091,22588295,22590543,22591766,22593922,22596193,22598086,22600074,22603213,22604404,22604969,22606644,22608646,22610647,22613105,22618567,22620455,22622558,22622720,22623025,22623082,22623836,22623976,22628258,22647558,22647736,22647771,22647926,22647954,22648128,22648198,22648233,22648410,22648513,22648625,22648655,22648700,22648786,22648789,22648850,22648962,22649000,22649113,22649182,22649221,22649553,22652950,22652965,22653025,22653053,22653087,22653130,22653170,22653202,22653239,22653348,22653422,22653462,22653469,22653526,22653608,22653633,22653670,22653718,22653749,22654117,22697048,22698728,22698758,22698858,22698896,22699023,22699168,22699296,22699394,22699570,22699611,22699651,22699687,22699887,22699926,22700033,22733894,22736997,22737202,22737280,22737421,22737500,22737708,22737767,22737804,22737897,2273793', 'assoc_port': '22578790:22578994,22579462:22579607,22579674:22579737,22580323:22580457,22580324:22580389,22581137:22581446,22582425:22582450,22583452:22583739,22584115:22584260,22584385:22584509,22584699:22584816,22584999:22585038,22585264:22585399,22585496:22585509,22585615:22585657,22585754:22585848,22586023:22586047,22586169:22586188,22586326:22586687,22586327:22586390,22586328:22586494,22587966:22588091,22588274:22588295,22590392:22590543,22591352:22591766,22593386:22593922,22595882:22596193,22597590:22598086,22599515:22600074,22601628:22604969,22602970:22603213,22604202:22604404,22605866:22606644,22608185:22608646,22610550:22610647,22612836:22613105,22618248:22618567,22620311:22620455,22622213:22623836,22622216:22623976,22622219:22623082,22622222:22622720,22622224:22623025,22622226:22622558,22628073:22628258,22647475:22649182,22647477:22649221,22647481:22648789,22647483:22648700,22647485:22649000,22647487:22648962,22647489:22648786,22647491:22648513,22647493:22648655,22647495:22648850,22647497:22648625,22647499:2264841', 'assoc_mat': '22578790:pehd:4230:22578994,22579462:pehd:4230:22579607,22579674:pehd:4230:22579737,22580323:pehd:4230:22580457,22580324:pehd:4230:22580389,22581137:pehd:4230:22581446,22582425:pehd:4230:22582450,22583452:pehd:4230:22583739,22584115:pehd:4230:22584260,22584385:pehd:4230:22584509,22584699:pehd:4230:22584816,22584999:pehd:4230:22585038,22585264:pehd:4230:22585399,22585496:pehd:4230:22585509,22585615:pehd:4230:22585657,22585754:pehd:4230:22585848,22586023:pehd:4230:22586047,22586169:pehd:4230:22586188,22586326:pehd:4230:22586687,22586327:pehd:4230:22586390,22586328:pehd:4230:22586494,22587966:pehd:4230:22588091,22588274:pehd:4230:22588295,22590392:pehd:4230:22590543,22591352:pehd:4230:22591766,22593386:pehd:4230:22593922,22595882:pehd:4230:22596193,22597590:pehd:4230:22598086,22599515:pehd:4230:22600074,22601628:pehd:4230:22604969,22602970:pehd:4230:22603213,22604202:pehd:4230:22604404,22605866:pehd:4230:22606644,22608185:pehd:4230:22608646,22610550:pehd:4230:22610647,22612836:pehd:4230:22613105,22618248:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020426566238101764, 'nb_photo': 12369, 'list_port_cont': '22578982,22579614,22579735,22580385,22580453,22581435,22582453,22583740,22584265,22584530,22584812,22585051,22585397,22585518,22585648,22585852,22586032,22586193,22586384,22586504,22586677,22588094,22588306,22590545,22591756,22593930,22596198,22598093,22600059,22603220,22604403,22604970,22606682,22608636,22610655,22613104,22615641,22618565,22620454,22622551,22622723,22623028,22623089,22623844,22623975,22625323,22628264,22647557,22647740,22647775,22647927,22647966,22648120,22648192,22648225,22648406,22648512,22648623,22648664,22648697,22648784,22648794,22648838,22648926,22648961,22648993,22649118,22649179,22649220,22649558,22652948,22652971,22653026,22653056,22653098,22653134,22653161,22653204,22653241,22653270,22653350,22653381,22653426,22653448,22653481,22653531,22653570,22653604,22653644,22653679,22653712,22653754,22654093,22654793,22697044,22698668,22698703,22698738,22698759,22698813,22698864,22698900,22698948,22699035,22699169,22699202,22699289,22699348,22699401,22699578,22699608,22699645,22699682,2269988', 'assoc_port': '22578790:22578982,22579462:22579614,22579674:22579735,22580323:22580453,22580324:22580385,22581137:22581435,22582425:22582453,22583452:22583740,22584115:22584265,22584385:22584530,22584699:22584812,22584999:22585051,22585264:22585397,22585496:22585518,22585615:22585648,22585754:22585852,22586023:22586032,22586169:22586193,22586326:22586677,22586327:22586384,22586328:22586504,22587966:22588094,22588274:22588306,22590392:22590545,22591352:22591756,22593386:22593930,22595882:22596198,22597590:22598093,22599515:22600059,22601628:22604970,22602970:22603220,22604202:22604403,22605866:22606682,22608185:22608636,22610550:22610655,22612836:22613104,22615484:22615641,22618248:22618565,22620311:22620454,22622213:22623844,22622216:22623975,22622219:22623089,22622222:22622723,22622224:22623028,22622226:22622551,22625259:22625323,22628073:22628264,22647475:22649179,22647477:22649220,22647479:22648926,22647481:22648794,22647483:22648697,22647485:22648993,22647487:22648961,22647489:22648784,22647491:22648512,22647493:2264866', 'assoc_mat': '22578790:pet_clair:4230:22578982,22579462:pet_clair:4230:22579614,22579674:pet_clair:4230:22579735,22580323:pet_clair:4230:22580453,22580324:pet_clair:4230:22580385,22581137:pet_clair:4230:22581435,22582425:pet_clair:4230:22582453,22583452:pet_clair:4230:22583740,22584115:pet_clair:4230:22584265,22584385:pet_clair:4230:22584530,22584699:pet_clair:4230:22584812,22584999:pet_clair:4230:22585051,22585264:pet_clair:4230:22585397,22585496:pet_clair:4230:22585518,22585615:pet_clair:4230:22585648,22585754:pet_clair:4230:22585852,22586023:pet_clair:4230:22586032,22586169:pet_clair:4230:22586193,22586326:pet_clair:4230:22586677,22586327:pet_clair:4230:22586384,22586328:pet_clair:4230:22586504,22587966:pet_clair:4230:22588094,22588274:pet_clair:4230:22588306,22590392:pet_clair:4230:22590545,22591352:pet_clair:4230:22591756,22593386:pet_clair:4230:22593930,22595882:pet_clair:4230:22596198,22597590:pet_clair:4230:22598093,22599515:pet_clair:4230:22600059,22601628:pet_clair:4230:22604970,22602970:pet_clair:4230:22603220,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024297152544737154, 'nb_photo': 490, 'list_port_cont': '22578988,22579609,22583743,22584264,22584534,22584813,22585044,22585405,22585508,22585851,22586041,22586187,22586388,22586499,22586679,22590544,22591762,22593923,22600066,22603215,22604405,22604972,22606666,22608641,22613113,22618557,22622559,22622718,22623085,22623841,22623962,22647778,22647928,22647956,22648196,22648234,22648405,22648626,22648660,22648695,22648766,22648849,22648927,22648968,22649115,22649228,22649547,22653019,22653088,22653470,22653534,22653605,22653639,22653675,22653713,22654116,22654792,22698661,22698696,22698745,22698805,22698857,22698895,22699033,22699293,22699345,22699566,22699648,22699681,22699882,22699921,22700030,22733889,22737009,22737197,22737420,22737503,22737713,22737798,22737862,22737894,22737937,22738690,22738758,22740103,22749038,22755830,22758422,22759864,22762679,22766378,22771911,22774759,22777565,22784712,22789171,22789401,22791685,22791749,22805016,22805346,22805388,22805426,22805605,22805662,22805774,22805928,22805961,22806046,22844695,22844876,22844917,22845041,2284512', 'assoc_port': '22578790:22578988,22579462:22579609,22583452:22583743,22584115:22584264,22584385:22584534,22584699:22584813,22584999:22585044,22585264:22585405,22585496:22585508,22585754:22585851,22586023:22586041,22586169:22586187,22586326:22586679,22586327:22586388,22586328:22586499,22590392:22590544,22591352:22591762,22593386:22593923,22599515:22600066,22601628:22604972,22602970:22603215,22604202:22604405,22605866:22606666,22608185:22608641,22612836:22613113,22618248:22618557,22622213:22623841,22622216:22623962,22622219:22623085,22622222:22622718,22622226:22622559,22647477:22649228,22647479:22648927,22647483:22648695,22647487:22648968,22647489:22648766,22647493:22648660,22647495:22648849,22647497:22648626,22647499:22648405,22647501:22648234,22647503:22647956,22647505:22648196,22647509:22647928,22647511:22647778,22648869:22649115,22649536:22649547,22652908:22653605,22652911:22653675,22652915:22653534,22652917:22653639,22652918:22653019,22652920:22653713,22652923:22653470,22652927:22653088,22653931:22654116,22654769:2265479', 'assoc_mat': '22578790:pet_fonce:4230:22578988,22579462:pet_fonce:4230:22579609,22583452:pet_fonce:4230:22583743,22584115:pet_fonce:4230:22584264,22584385:pet_fonce:4230:22584534,22584699:pet_fonce:4230:22584813,22584999:pet_fonce:4230:22585044,22585264:pet_fonce:4230:22585405,22585496:pet_fonce:4230:22585508,22585754:pet_fonce:4230:22585851,22586023:pet_fonce:4230:22586041,22586169:pet_fonce:4230:22586187,22586326:pet_fonce:4230:22586679,22586327:pet_fonce:4230:22586388,22586328:pet_fonce:4230:22586499,22590392:pet_fonce:4230:22590544,22591352:pet_fonce:4230:22591762,22593386:pet_fonce:4230:22593923,22599515:pet_fonce:4230:22600066,22601628:pet_fonce:4230:22604972,22602970:pet_fonce:4230:22603215,22604202:pet_fonce:4230:22604405,22605866:pet_fonce:4230:22606666,22608185:pet_fonce:4230:22608641,22612836:pet_fonce:4230:22613113,22618248:pet_fonce:4230:22618557,22622213:pet_fonce:4230:22623841,22622216:pet_fonce:4230:22623962,22622219:pet_fonce:4230:22623085,22622222:pet_fonce:4230:22622718,22622226:pet_fonce:4230:22622559,2'}), 'main_stat': {'nb_photos': 1067}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-05', 0.7410048471317923),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1067,),), 'unwanted_material_monthly_percentage': ((0.7410048471317923,),), 'material_repartition': (('incineration', 923),), 'material_dict': {'incineration': 923}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 5, 1), 0.7026687661485111, 55), (datetime.date(2025, 5, 2), 0.694357362448783, 64), (datetime.date(2025, 5, 3), 0.6682129923970126, 59), (datetime.date(2025, 5, 4), 0.765418700190385, 64), (datetime.date(2025, 5, 5), 0.7849458312091068, 64), (datetime.date(2025, 5, 6), 0.750477607100669, 53), (datetime.date(2025, 5, 7), 0.7071179027592335, 62), (datetime.date(2025, 5, 8), 0.7575394384389879, 61), (datetime.date(2025, 5, 9), 0.7308899383214942, 62), (datetime.date(2025, 5, 10), 0.6887540486617323, 64), (datetime.date(2025, 5, 11), 0.8305347567057803, 58), (datetime.date(2025, 5, 12), 0.7985411903158902, 57), (datetime.date(2025, 5, 13), 0.7833158476058157, 50), (datetime.date(2025, 5, 14), 0.728985463254641, 71), (datetime.date(2025, 5, 15), 0.7182723922496408, 79)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 5, 1), 0.7026687661485111, 55), (datetime.date(2025, 5, 2), 0.694357362448783, 64), (datetime.date(2025, 5, 3), 0.6682129923970126, 59), (datetime.date(2025, 5, 4), 0.765418700190385, 64), (datetime.date(2025, 5, 5), 0.7849458312091068, 64), (datetime.date(2025, 5, 6), 0.750477607100669, 53), (datetime.date(2025, 5, 7), 0.7071179027592335, 62), (datetime.date(2025, 5, 8), 0.7575394384389879, 61), (datetime.date(2025, 5, 9), 0.7308899383214942, 62), (datetime.date(2025, 5, 10), 0.6887540486617323, 64), (datetime.date(2025, 5, 11), 0.8305347567057803, 58), (datetime.date(2025, 5, 12), 0.7985411903158902, 57), (datetime.date(2025, 5, 13), 0.7833158476058157, 50), (datetime.date(2025, 5, 14), 0.728985463254641, 71), (datetime.date(2025, 5, 15), 0.7182723922496408, 79))}, 'quality_array': [['-8.577716647958058', '01052025'], ['-7.850816761531449', '02052025'], ['-8.047937271877997', '03052025'], ['-8.11474272464865', '04052025'], ['-6.9411703055565415', '05052025'], ['-7.454609825692585', '06052025'], ['-8.032992837054683', '07052025'], ['-8.358527367741935', '08052025'], ['-7.609637365447718', '09052025'], ['-7.716549215579906', '10052025'], ['-7.415189102953197', '11052025'], ['-6.875554923679928', '12052025'], ['-7.3946309661926435', '13052025'], ['-8.099335085524572', '14052025'], ['-8.149725812461625', '15052025'], ['-8.15680995776548', '16052025']], 'number_of_batch': ((385,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.016577012796638327, 'nb_photo': 9950, 'list_port_cont': '22578983,22579608,22579742,22580381,22580454,22581442,22582454,22583742,22584252,22584510,22584815,22585052,22585390,22585504,22585645,22585845,22586036,22586183,22586393,22586502,22586672,22588095,22588296,22590542,22591753,22593924,22596188,22598096,22600068,22603204,22604398,22604960,22606642,22608643,22610639,22613107,22615637,22618569,22620440,22622541,22622712,22623013,22623086,22623845,22623969,22625318,22628253,22647556,22647730,22647780,22647931,22647967,22648112,22648201,22648220,22648393,22648508,22648612,22648653,22648699,22648763,22648788,22648843,22648918,22648956,22648996,22649103,22649185,22649215,22649541,22652954,22652970,22653016,22653059,22653083,22653133,22653163,22653198,22653236,22653277,22653343,22653387,22653415,22653446,22653474,22653530,22653563,22653596,22653645,22653676,22653716,22653744,22654114,22654779,22697047,22698657,22698704,22698741,22698750,22698811,22698850,22698885,22698939,22699034,22699172,22699197,22699291,22699347,22699400,22699571,22699614,22699635,22699685,2269989', 'assoc_port': '22578790:22578983,22579462:22579608,22579674:22579742,22580323:22580454,22580324:22580381,22581137:22581442,22582425:22582454,22583452:22583742,22584115:22584252,22584385:22584510,22584699:22584815,22584999:22585052,22585264:22585390,22585496:22585504,22585615:22585645,22585754:22585845,22586023:22586036,22586169:22586183,22586326:22586672,22586327:22586393,22586328:22586502,22587966:22588095,22588274:22588296,22590392:22590542,22591352:22591753,22593386:22593924,22595882:22596188,22597590:22598096,22599515:22600068,22601628:22604960,22602970:22603204,22604202:22604398,22605866:22606642,22608185:22608643,22610550:22610639,22612836:22613107,22615484:22615637,22618248:22618569,22620311:22620440,22622213:22623845,22622216:22623969,22622219:22623086,22622222:22622712,22622224:22623013,22622226:22622541,22625259:22625318,22628073:22628253,22647475:22649185,22647477:22649215,22647479:22648918,22647481:22648763,22647483:22648699,22647485:22648996,22647487:22648956,22647489:22648788,22647491:22648508,22647493:2264865', 'assoc_mat': '22578790:autre:4230:22578983,22579462:autre:4230:22579608,22579674:autre:4230:22579742,22580323:autre:4230:22580454,22580324:autre:4230:22580381,22581137:autre:4230:22581442,22582425:autre:4230:22582454,22583452:autre:4230:22583742,22584115:autre:4230:22584252,22584385:autre:4230:22584510,22584699:autre:4230:22584815,22584999:autre:4230:22585052,22585264:autre:4230:22585390,22585496:autre:4230:22585504,22585615:autre:4230:22585645,22585754:autre:4230:22585845,22586023:autre:4230:22586036,22586169:autre:4230:22586183,22586326:autre:4230:22586672,22586327:autre:4230:22586393,22586328:autre:4230:22586502,22587966:autre:4230:22588095,22588274:autre:4230:22588296,22590392:autre:4230:22590542,22591352:autre:4230:22591753,22593386:autre:4230:22593924,22595882:autre:4230:22596188,22597590:autre:4230:22598096,22599515:autre:4230:22600068,22601628:autre:4230:22604960,22602970:autre:4230:22603204,22604202:autre:4230:22604398,22605866:autre:4230:22606642,22608185:autre:4230:22608643,22610550:autre:4230:22610639,22612836:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.046606890208362534, 'nb_photo': 41922, 'list_port_cont': '22578989,22579615,22579732,22580376,22580452,22581447,22582446,22583732,22584253,22584532,22584818,22585049,22585401,22585515,22585649,22585846,22586045,22586185,22586391,22586496,22586684,22588097,22588307,22590539,22591760,22593940,22596196,22598099,22600070,22603208,22604410,22604973,22606648,22608648,22610649,22613103,22615652,22618563,22620444,22622550,22622725,22623021,22623091,22623847,22623970,22625319,22628263,22647554,22647744,22647773,22647923,22647965,22648115,22648199,22648229,22648396,22648516,22648627,22648661,22648704,22648777,22648778,22648845,22648931,22648964,22648994,22649116,22649187,22649222,22649550,22652952,22652960,22653015,22653060,22653097,22653132,22653167,22653207,22653240,22653274,22653353,22653383,22653421,22653455,22653478,22653525,22653561,22653602,22653646,22653682,22653704,22653752,22654112,22654784,22697049,22698658,22698693,22698735,22698756,22698808,22698859,22698899,22698944,22699024,22699164,22699203,22699292,22699349,22699399,22699575,22699604,22699647,22699671,2269989', 'assoc_port': '22578790:22578989,22579462:22579615,22579674:22579732,22580323:22580452,22580324:22580376,22581137:22581447,22582425:22582446,22583452:22583732,22584115:22584253,22584385:22584532,22584699:22584818,22584999:22585049,22585264:22585401,22585496:22585515,22585615:22585649,22585754:22585846,22586023:22586045,22586169:22586185,22586326:22586684,22586327:22586391,22586328:22586496,22587966:22588097,22588274:22588307,22590392:22590539,22591352:22591760,22593386:22593940,22595882:22596196,22597590:22598099,22599515:22600070,22601628:22604973,22602970:22603208,22604202:22604410,22605866:22606648,22608185:22608648,22610550:22610649,22612836:22613103,22615484:22615652,22618248:22618563,22620311:22620444,22622213:22623847,22622216:22623970,22622219:22623091,22622222:22622725,22622224:22623021,22622226:22622550,22625259:22625319,22628073:22628263,22647475:22649187,22647477:22649222,22647479:22648931,22647481:22648777,22647483:22648704,22647485:22648994,22647487:22648964,22647489:22648778,22647491:22648516,22647493:2264866', 'assoc_mat': '22578790:carton:4230:22578989,22579462:carton:4230:22579615,22579674:carton:4230:22579732,22580323:carton:4230:22580452,22580324:carton:4230:22580376,22581137:carton:4230:22581447,22582425:carton:4230:22582446,22583452:carton:4230:22583732,22584115:carton:4230:22584253,22584385:carton:4230:22584532,22584699:carton:4230:22584818,22584999:carton:4230:22585049,22585264:carton:4230:22585401,22585496:carton:4230:22585515,22585615:carton:4230:22585649,22585754:carton:4230:22585846,22586023:carton:4230:22586045,22586169:carton:4230:22586185,22586326:carton:4230:22586684,22586327:carton:4230:22586391,22586328:carton:4230:22586496,22587966:carton:4230:22588097,22588274:carton:4230:22588307,22590392:carton:4230:22590539,22591352:carton:4230:22591760,22593386:carton:4230:22593940,22595882:carton:4230:22596196,22597590:carton:4230:22598099,22599515:carton:4230:22600070,22601628:carton:4230:22604973,22602970:carton:4230:22603208,22604202:carton:4230:22604410,22605866:carton:4230:22606648,22608185:carton:4230:22608648,2261'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001173833047087899, 'nb_photo': 866, 'list_port_cont': '22578993,22579599,22579731,22580375,22580449,22581431,22582452,22583726,22584258,22584536,22584817,22585050,22585402,22585514,22585661,22585849,22586181,22586377,22586498,22586674,22588084,22588291,22590535,22593917,22596190,22598091,22600071,22603209,22604400,22604974,22606645,22613102,22615651,22618561,22620443,22622546,22622721,22623022,22623077,22623832,22623972,22628255,22647745,22647779,22647916,22647962,22648111,22648193,22648226,22648399,22648518,22648628,22648648,22648703,22648775,22648780,22648842,22648914,22648960,22649114,22649211,22649554,22652947,22653009,22653049,22653091,22653125,22653169,22653233,22653340,22653386,22653424,22653464,22653532,22653569,22653607,22653640,22653681,22653717,22653745,22654096,22654789,22697042,22698695,22698729,22698804,22698847,22698898,22698933,22699162,22699194,22699279,22699332,22699574,22699638,22699683,22699880,22699925,22700034,22700265,22733893,22737010,22737200,22737277,22737410,22737493,22737715,22737766,22737787,22737863,22737899,22737922,22738199,2273844', 'assoc_port': '22578790:22578993,22579462:22579599,22579674:22579731,22580323:22580449,22580324:22580375,22581137:22581431,22582425:22582452,22583452:22583726,22584115:22584258,22584385:22584536,22584699:22584817,22584999:22585050,22585264:22585402,22585496:22585514,22585615:22585661,22585754:22585849,22586169:22586181,22586326:22586674,22586327:22586377,22586328:22586498,22587966:22588084,22588274:22588291,22590392:22590535,22593386:22593917,22595882:22596190,22597590:22598091,22599515:22600071,22601628:22604974,22602970:22603209,22604202:22604400,22605866:22606645,22612836:22613102,22615484:22615651,22618248:22618561,22620311:22620443,22622213:22623832,22622216:22623972,22622219:22623077,22622222:22622721,22622224:22623022,22622226:22622546,22628073:22628255,22647477:22649211,22647479:22648914,22647481:22648775,22647483:22648703,22647487:22648960,22647489:22648780,22647491:22648518,22647493:22648648,22647495:22648842,22647497:22648628,22647499:22648399,22647501:22648226,22647503:22647962,22647505:22648193,22647507:2264811', 'assoc_mat': '22578790:metal:4230:22578993,22579462:metal:4230:22579599,22579674:metal:4230:22579731,22580323:metal:4230:22580449,22580324:metal:4230:22580375,22581137:metal:4230:22581431,22582425:metal:4230:22582452,22583452:metal:4230:22583726,22584115:metal:4230:22584258,22584385:metal:4230:22584536,22584699:metal:4230:22584817,22584999:metal:4230:22585050,22585264:metal:4230:22585402,22585496:metal:4230:22585514,22585615:metal:4230:22585661,22585754:metal:4230:22585849,22586169:metal:4230:22586181,22586326:metal:4230:22586674,22586327:metal:4230:22586377,22586328:metal:4230:22586498,22587966:metal:4230:22588084,22588274:metal:4230:22588291,22590392:metal:4230:22590535,22593386:metal:4230:22593917,22595882:metal:4230:22596190,22597590:metal:4230:22598091,22599515:metal:4230:22600071,22601628:metal:4230:22604974,22602970:metal:4230:22603209,22604202:metal:4230:22604400,22605866:metal:4230:22606645,22612836:metal:4230:22613102,22615484:metal:4230:22615651,22618248:metal:4230:22618561,22620311:metal:4230:22620443,22622213:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19724367028975756, 'nb_photo': 206270, 'list_port_cont': '22578991,22579612,22579740,22580382,22580459,22581445,22582444,22583741,22584259,22584514,22584814,22585048,22585403,22585511,22585656,22585847,22586035,22586189,22586394,22586500,22586688,22588087,22588304,22590534,22591758,22593936,22596200,22598095,22600064,22603210,22604396,22604964,22606671,22608647,22610644,22613108,22615642,22618568,22620456,22622557,22622724,22623026,22623088,22623849,22623964,22625327,22628254,22647561,22647743,22647781,22647930,22647968,22648124,22648200,22648237,22648409,22648519,22648618,22648659,22648698,22648782,22648793,22648848,22648924,22648965,22649004,22649108,22649191,22649219,22649556,22652951,22652966,22653021,22653050,22653095,22653119,22653158,22653205,22653244,22653280,22653351,22653388,22653420,22653459,22653480,22653533,22653571,22653595,22653635,22653678,22653710,22653747,22654098,22654785,22697051,22698662,22698705,22698736,22698748,22698812,22698861,22698897,22698947,22699030,22699166,22699199,22699288,22699343,22699398,22699572,22699613,22699642,22699677,2269987', 'assoc_port': '22578790:22578991,22579462:22579612,22579674:22579740,22580323:22580459,22580324:22580382,22581137:22581445,22582425:22582444,22583452:22583741,22584115:22584259,22584385:22584514,22584699:22584814,22584999:22585048,22585264:22585403,22585496:22585511,22585615:22585656,22585754:22585847,22586023:22586035,22586169:22586189,22586326:22586688,22586327:22586394,22586328:22586500,22587966:22588087,22588274:22588304,22590392:22590534,22591352:22591758,22593386:22593936,22595882:22596200,22597590:22598095,22599515:22600064,22601628:22604964,22602970:22603210,22604202:22604396,22605866:22606671,22608185:22608647,22610550:22610644,22612836:22613108,22615484:22615642,22618248:22618568,22620311:22620456,22622213:22623849,22622216:22623964,22622219:22623088,22622222:22622724,22622224:22623026,22622226:22622557,22625259:22625327,22628073:22628254,22647475:22649191,22647477:22649219,22647479:22648924,22647481:22648793,22647483:22648698,22647485:22649004,22647487:22648965,22647489:22648782,22647491:22648519,22647493:2264865', 'assoc_mat': '22578790:papier:4230:22578991,22579462:papier:4230:22579612,22579674:papier:4230:22579740,22580323:papier:4230:22580459,22580324:papier:4230:22580382,22581137:papier:4230:22581445,22582425:papier:4230:22582444,22583452:papier:4230:22583741,22584115:papier:4230:22584259,22584385:papier:4230:22584514,22584699:papier:4230:22584814,22584999:papier:4230:22585048,22585264:papier:4230:22585403,22585496:papier:4230:22585511,22585615:papier:4230:22585656,22585754:papier:4230:22585847,22586023:papier:4230:22586035,22586169:papier:4230:22586189,22586326:papier:4230:22586688,22586327:papier:4230:22586394,22586328:papier:4230:22586500,22587966:papier:4230:22588087,22588274:papier:4230:22588304,22590392:papier:4230:22590534,22591352:papier:4230:22591758,22593386:papier:4230:22593936,22595882:papier:4230:22596200,22597590:papier:4230:22598095,22599515:papier:4230:22600064,22601628:papier:4230:22604964,22602970:papier:4230:22603210,22604202:papier:4230:22604396,22605866:papier:4230:22606671,22608185:papier:4230:22608647,2261'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0038203596601038823, 'nb_photo': 1269, 'list_port_cont': '22578994,22579607,22579737,22580389,22580457,22581446,22582450,22583739,22584260,22584509,22584816,22585038,22585399,22585509,22585657,22585848,22586047,22586188,22586390,22586494,22586687,22588091,22588295,22590543,22591766,22593922,22596193,22598086,22600074,22603213,22604404,22604969,22606644,22608646,22610647,22613105,22618567,22620455,22622558,22622720,22623025,22623082,22623836,22623976,22628258,22647558,22647736,22647771,22647926,22647954,22648128,22648198,22648233,22648410,22648513,22648625,22648655,22648700,22648786,22648789,22648850,22648962,22649000,22649113,22649182,22649221,22649553,22652950,22652965,22653025,22653053,22653087,22653130,22653170,22653202,22653239,22653348,22653422,22653462,22653469,22653526,22653608,22653633,22653670,22653718,22653749,22654117,22697048,22698728,22698758,22698858,22698896,22699023,22699168,22699296,22699394,22699570,22699611,22699651,22699687,22699887,22699926,22700033,22733894,22736997,22737202,22737280,22737421,22737500,22737708,22737767,22737804,22737897,2273793', 'assoc_port': '22578790:22578994,22579462:22579607,22579674:22579737,22580323:22580457,22580324:22580389,22581137:22581446,22582425:22582450,22583452:22583739,22584115:22584260,22584385:22584509,22584699:22584816,22584999:22585038,22585264:22585399,22585496:22585509,22585615:22585657,22585754:22585848,22586023:22586047,22586169:22586188,22586326:22586687,22586327:22586390,22586328:22586494,22587966:22588091,22588274:22588295,22590392:22590543,22591352:22591766,22593386:22593922,22595882:22596193,22597590:22598086,22599515:22600074,22601628:22604969,22602970:22603213,22604202:22604404,22605866:22606644,22608185:22608646,22610550:22610647,22612836:22613105,22618248:22618567,22620311:22620455,22622213:22623836,22622216:22623976,22622219:22623082,22622222:22622720,22622224:22623025,22622226:22622558,22628073:22628258,22647475:22649182,22647477:22649221,22647481:22648789,22647483:22648700,22647485:22649000,22647487:22648962,22647489:22648786,22647491:22648513,22647493:22648655,22647495:22648850,22647497:22648625,22647499:2264841', 'assoc_mat': '22578790:pehd:4230:22578994,22579462:pehd:4230:22579607,22579674:pehd:4230:22579737,22580323:pehd:4230:22580457,22580324:pehd:4230:22580389,22581137:pehd:4230:22581446,22582425:pehd:4230:22582450,22583452:pehd:4230:22583739,22584115:pehd:4230:22584260,22584385:pehd:4230:22584509,22584699:pehd:4230:22584816,22584999:pehd:4230:22585038,22585264:pehd:4230:22585399,22585496:pehd:4230:22585509,22585615:pehd:4230:22585657,22585754:pehd:4230:22585848,22586023:pehd:4230:22586047,22586169:pehd:4230:22586188,22586326:pehd:4230:22586687,22586327:pehd:4230:22586390,22586328:pehd:4230:22586494,22587966:pehd:4230:22588091,22588274:pehd:4230:22588295,22590392:pehd:4230:22590543,22591352:pehd:4230:22591766,22593386:pehd:4230:22593922,22595882:pehd:4230:22596193,22597590:pehd:4230:22598086,22599515:pehd:4230:22600074,22601628:pehd:4230:22604969,22602970:pehd:4230:22603213,22604202:pehd:4230:22604404,22605866:pehd:4230:22606644,22608185:pehd:4230:22608646,22610550:pehd:4230:22610647,22612836:pehd:4230:22613105,22618248:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020426566238101764, 'nb_photo': 12369, 'list_port_cont': '22578982,22579614,22579735,22580385,22580453,22581435,22582453,22583740,22584265,22584530,22584812,22585051,22585397,22585518,22585648,22585852,22586032,22586193,22586384,22586504,22586677,22588094,22588306,22590545,22591756,22593930,22596198,22598093,22600059,22603220,22604403,22604970,22606682,22608636,22610655,22613104,22615641,22618565,22620454,22622551,22622723,22623028,22623089,22623844,22623975,22625323,22628264,22647557,22647740,22647775,22647927,22647966,22648120,22648192,22648225,22648406,22648512,22648623,22648664,22648697,22648784,22648794,22648838,22648926,22648961,22648993,22649118,22649179,22649220,22649558,22652948,22652971,22653026,22653056,22653098,22653134,22653161,22653204,22653241,22653270,22653350,22653381,22653426,22653448,22653481,22653531,22653570,22653604,22653644,22653679,22653712,22653754,22654093,22654793,22697044,22698668,22698703,22698738,22698759,22698813,22698864,22698900,22698948,22699035,22699169,22699202,22699289,22699348,22699401,22699578,22699608,22699645,22699682,2269988', 'assoc_port': '22578790:22578982,22579462:22579614,22579674:22579735,22580323:22580453,22580324:22580385,22581137:22581435,22582425:22582453,22583452:22583740,22584115:22584265,22584385:22584530,22584699:22584812,22584999:22585051,22585264:22585397,22585496:22585518,22585615:22585648,22585754:22585852,22586023:22586032,22586169:22586193,22586326:22586677,22586327:22586384,22586328:22586504,22587966:22588094,22588274:22588306,22590392:22590545,22591352:22591756,22593386:22593930,22595882:22596198,22597590:22598093,22599515:22600059,22601628:22604970,22602970:22603220,22604202:22604403,22605866:22606682,22608185:22608636,22610550:22610655,22612836:22613104,22615484:22615641,22618248:22618565,22620311:22620454,22622213:22623844,22622216:22623975,22622219:22623089,22622222:22622723,22622224:22623028,22622226:22622551,22625259:22625323,22628073:22628264,22647475:22649179,22647477:22649220,22647479:22648926,22647481:22648794,22647483:22648697,22647485:22648993,22647487:22648961,22647489:22648784,22647491:22648512,22647493:2264866', 'assoc_mat': '22578790:pet_clair:4230:22578982,22579462:pet_clair:4230:22579614,22579674:pet_clair:4230:22579735,22580323:pet_clair:4230:22580453,22580324:pet_clair:4230:22580385,22581137:pet_clair:4230:22581435,22582425:pet_clair:4230:22582453,22583452:pet_clair:4230:22583740,22584115:pet_clair:4230:22584265,22584385:pet_clair:4230:22584530,22584699:pet_clair:4230:22584812,22584999:pet_clair:4230:22585051,22585264:pet_clair:4230:22585397,22585496:pet_clair:4230:22585518,22585615:pet_clair:4230:22585648,22585754:pet_clair:4230:22585852,22586023:pet_clair:4230:22586032,22586169:pet_clair:4230:22586193,22586326:pet_clair:4230:22586677,22586327:pet_clair:4230:22586384,22586328:pet_clair:4230:22586504,22587966:pet_clair:4230:22588094,22588274:pet_clair:4230:22588306,22590392:pet_clair:4230:22590545,22591352:pet_clair:4230:22591756,22593386:pet_clair:4230:22593930,22595882:pet_clair:4230:22596198,22597590:pet_clair:4230:22598093,22599515:pet_clair:4230:22600059,22601628:pet_clair:4230:22604970,22602970:pet_clair:4230:22603220,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024297152544737154, 'nb_photo': 490, 'list_port_cont': '22578988,22579609,22583743,22584264,22584534,22584813,22585044,22585405,22585508,22585851,22586041,22586187,22586388,22586499,22586679,22590544,22591762,22593923,22600066,22603215,22604405,22604972,22606666,22608641,22613113,22618557,22622559,22622718,22623085,22623841,22623962,22647778,22647928,22647956,22648196,22648234,22648405,22648626,22648660,22648695,22648766,22648849,22648927,22648968,22649115,22649228,22649547,22653019,22653088,22653470,22653534,22653605,22653639,22653675,22653713,22654116,22654792,22698661,22698696,22698745,22698805,22698857,22698895,22699033,22699293,22699345,22699566,22699648,22699681,22699882,22699921,22700030,22733889,22737009,22737197,22737420,22737503,22737713,22737798,22737862,22737894,22737937,22738690,22738758,22740103,22749038,22755830,22758422,22759864,22762679,22766378,22771911,22774759,22777565,22784712,22789171,22789401,22791685,22791749,22805016,22805346,22805388,22805426,22805605,22805662,22805774,22805928,22805961,22806046,22844695,22844876,22844917,22845041,2284512', 'assoc_port': '22578790:22578988,22579462:22579609,22583452:22583743,22584115:22584264,22584385:22584534,22584699:22584813,22584999:22585044,22585264:22585405,22585496:22585508,22585754:22585851,22586023:22586041,22586169:22586187,22586326:22586679,22586327:22586388,22586328:22586499,22590392:22590544,22591352:22591762,22593386:22593923,22599515:22600066,22601628:22604972,22602970:22603215,22604202:22604405,22605866:22606666,22608185:22608641,22612836:22613113,22618248:22618557,22622213:22623841,22622216:22623962,22622219:22623085,22622222:22622718,22622226:22622559,22647477:22649228,22647479:22648927,22647483:22648695,22647487:22648968,22647489:22648766,22647493:22648660,22647495:22648849,22647497:22648626,22647499:22648405,22647501:22648234,22647503:22647956,22647505:22648196,22647509:22647928,22647511:22647778,22648869:22649115,22649536:22649547,22652908:22653605,22652911:22653675,22652915:22653534,22652917:22653639,22652918:22653019,22652920:22653713,22652923:22653470,22652927:22653088,22653931:22654116,22654769:2265479', 'assoc_mat': '22578790:pet_fonce:4230:22578988,22579462:pet_fonce:4230:22579609,22583452:pet_fonce:4230:22583743,22584115:pet_fonce:4230:22584264,22584385:pet_fonce:4230:22584534,22584699:pet_fonce:4230:22584813,22584999:pet_fonce:4230:22585044,22585264:pet_fonce:4230:22585405,22585496:pet_fonce:4230:22585508,22585754:pet_fonce:4230:22585851,22586023:pet_fonce:4230:22586041,22586169:pet_fonce:4230:22586187,22586326:pet_fonce:4230:22586679,22586327:pet_fonce:4230:22586388,22586328:pet_fonce:4230:22586499,22590392:pet_fonce:4230:22590544,22591352:pet_fonce:4230:22591762,22593386:pet_fonce:4230:22593923,22599515:pet_fonce:4230:22600066,22601628:pet_fonce:4230:22604972,22602970:pet_fonce:4230:22603215,22604202:pet_fonce:4230:22604405,22605866:pet_fonce:4230:22606666,22608185:pet_fonce:4230:22608641,22612836:pet_fonce:4230:22613113,22618248:pet_fonce:4230:22618557,22622213:pet_fonce:4230:22623841,22622216:pet_fonce:4230:22623962,22622219:pet_fonce:4230:22623085,22622222:pet_fonce:4230:22622718,22622226:pet_fonce:4230:22622559,2'}), 'main_stat': {'nb_photos': 1067}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-05', 0.7410048471317923),)]} filepath : /data_2/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_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.66%', 9950], 'carton': ['carton', '4.66%', 41922], 'metal': ['metal', '0.12%', 866], 'papier': ['papier', '19.72%', 206270], 'pehd': ['pehd', '0.38%', 1269], 'pet_clair': ['pet_clair', '2.04%', 12369], 'pet_fonce': ['pet_fonce', '0.24%', 490]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_05_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/SCCU_cam6 2.65user 2.70system 0:07.26elapsed 73%CPU (0avgtext+0avgdata 193312maxresident)k 125976inputs+280outputs (551major+68773minor)pagefaults 0swaps