python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_2/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-04 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (1, 30) 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 : (1, 30) 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 : 04 mtr_id : dashboard_places : SCCU_cam6 date : 2025-04 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-04%') and created_at like '%2025-04%'))); nb_day : (1, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 202 and month(ded.date) = 04 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) = 04 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 '%042025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-04-01 : dt_date_just_month_year : 2025-04-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-04-01" AND ded.date <= "2025-04-30" apple3 {'incineration': {'mat': 'incineration', 'pht': 4230, 'datou_carac_id': 4234, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1716892,1719584,1721912,1724720,1728625,1732673,1737099,1739966,1740374,1743248,1747174,1751189,1755044,1757999,1760300,1764573,1769008) 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.020208634750010127, 'nb_photo': 12772, 'list_port_cont': '21959705,21959795,21959876,21959955,21960420,21960454,21960561,21960596,21960661,21960963,21961050,21961087,21961164,21961254,21961384,21961418,21961449,21961522,21961779,21961979,21962076,21962193,21962278,21962529,21990196,21991954,21992062,21992120,21992210,21992803,21992841,21992989,21993127,21993232,21993413,21993518,21993560,21993601,21993724,21994100,21994369,21994534,21994688,21994800,21994907,21995088,21996119,21999588,22000440,22002811,22004812,22005354,22005923,22007469,22009844,22012256,22015260,22017857,22020164,22022981,22023624,22024837,22051429,22051809,22051931,22052159,22052254,22052493,22052686,22052749,22052843,22052902,22053098,22053173,22053556,22054597,22056694,22104895,22107369,22107506,22107579,22107612,22107648,22107682,22107715,22107759,22107808,22107863,22107898,22107940,22107965,22107991,22108040,22108183,22108224,22108250,22108285,22108499,22109642,22112655,22114179,22116184,22118924,22120710,22120947,22121930,22123449,22125206,22127394,22129811,22132145,22133055,22135209,2213790', 'assoc_port': '21959002:21962278,21959004:21962076,21959006:21962193,21959008:21961779,21959010:21961418,21959012:21961522,21959014:21961979,21959016:21961384,21959018:21961164,21959020:21961254,21959022:21961050,21959024:21961449,21959027:21960561,21959029:21960963,21959032:21960454,21959034:21960596,21959037:21960420,21959039:21960661,21959042:21959955,21959044:21959795,21959047:21959705,21959049:21959876,21960915:21961087,21962450:21962529,21989938:21994907,21989939:21994688,21989940:21994800,21989941:21995088,21989942:21994369,21989943:21994534,21989944:21993518,21989945:21994100,21989946:21993724,21989947:21993413,21989950:21993601,21989951:21992989,21989954:21993127,21989955:21992841,21989958:21999588,21989959:21993560,21989962:21992803,21989963:21992210,21989966:21992062,21989967:21991954,21989969:21990196,21989971:21992120,21992871:21993232,21995873:21996119,22000331:22000440,22000332:22005354,22002451:22002811,22004597:22004812,22005794:22005923,22007307:22007469,22009332:22009844,22012050:22012256,22014782:2201526', 'assoc_mat': '21959002:autre:4230:21962278,21959004:autre:4230:21962076,21959006:autre:4230:21962193,21959008:autre:4230:21961779,21959010:autre:4230:21961418,21959012:autre:4230:21961522,21959014:autre:4230:21961979,21959016:autre:4230:21961384,21959018:autre:4230:21961164,21959020:autre:4230:21961254,21959022:autre:4230:21961050,21959024:autre:4230:21961449,21959027:autre:4230:21960561,21959029:autre:4230:21960963,21959032:autre:4230:21960454,21959034:autre:4230:21960596,21959037:autre:4230:21960420,21959039:autre:4230:21960661,21959042:autre:4230:21959955,21959044:autre:4230:21959795,21959047:autre:4230:21959705,21959049:autre:4230:21959876,21960915:autre:4230:21961087,21962450:autre:4230:21962529,21989938:autre:4230:21994907,21989939:autre:4230:21994688,21989940:autre:4230:21994800,21989941:autre:4230:21995088,21989942:autre:4230:21994369,21989943:autre:4230:21994534,21989944:autre:4230:21993518,21989945:autre:4230:21994100,21989946:autre:4230:21993724,21989947:autre:4230:21993413,21989950:autre:4230:21993601,21989951:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06450354029798254, 'nb_photo': 58805, 'list_port_cont': '21959692,21959801,21959881,21959964,21960415,21960456,21960577,21960612,21960663,21960966,21961051,21961086,21961167,21961269,21961369,21961415,21961450,21961521,21961782,21961974,21962079,21962197,21962284,21962523,21990195,21991951,21992064,21992158,21992211,21992804,21992843,21992995,21993134,21993235,21993411,21993517,21993564,21993599,21993737,21994112,21994371,21994540,21994685,21994798,21994917,21995094,21996127,21999582,22000443,22002812,22004811,22005369,22005929,22007468,22009845,22012252,22015267,22017866,22020168,22022970,22023625,22024844,22051441,22051812,22051930,22052136,22052261,22052494,22052688,22052760,22052844,22052903,22053099,22053175,22053569,22054592,22056698,22104899,22107356,22107513,22107582,22107617,22107650,22107696,22107728,22107765,22107815,22107857,22107900,22107933,22107974,22107992,22108044,22108180,22108217,22108255,22108292,22108512,22109643,22112648,22114176,22116190,22118917,22120726,22120953,22121934,22123461,22125217,22127392,22129814,22132144,22133064,22135211,2213790', 'assoc_port': '21959002:21962284,21959004:21962079,21959006:21962197,21959008:21961782,21959010:21961415,21959012:21961521,21959014:21961974,21959016:21961369,21959018:21961167,21959020:21961269,21959022:21961051,21959024:21961450,21959027:21960577,21959029:21960966,21959032:21960456,21959034:21960612,21959037:21960415,21959039:21960663,21959042:21959964,21959044:21959801,21959047:21959692,21959049:21959881,21960915:21961086,21962450:21962523,21989938:21994917,21989939:21994685,21989940:21994798,21989941:21995094,21989942:21994371,21989943:21994540,21989944:21993517,21989945:21994112,21989946:21993737,21989947:21993411,21989950:21993599,21989951:21992995,21989954:21993134,21989955:21992843,21989958:21999582,21989959:21993564,21989962:21992804,21989963:21992211,21989966:21992064,21989967:21991951,21989969:21990195,21989971:21992158,21992871:21993235,21995873:21996127,22000331:22000443,22000332:22005369,22002451:22002812,22004597:22004811,22005794:22005929,22007307:22007468,22009332:22009845,22012050:22012252,22014782:2201526', 'assoc_mat': '21959002:carton:4230:21962284,21959004:carton:4230:21962079,21959006:carton:4230:21962197,21959008:carton:4230:21961782,21959010:carton:4230:21961415,21959012:carton:4230:21961521,21959014:carton:4230:21961974,21959016:carton:4230:21961369,21959018:carton:4230:21961167,21959020:carton:4230:21961269,21959022:carton:4230:21961051,21959024:carton:4230:21961450,21959027:carton:4230:21960577,21959029:carton:4230:21960966,21959032:carton:4230:21960456,21959034:carton:4230:21960612,21959037:carton:4230:21960415,21959039:carton:4230:21960663,21959042:carton:4230:21959964,21959044:carton:4230:21959801,21959047:carton:4230:21959692,21959049:carton:4230:21959881,21960915:carton:4230:21961086,21962450:carton:4230:21962523,21989938:carton:4230:21994917,21989939:carton:4230:21994685,21989940:carton:4230:21994798,21989941:carton:4230:21995094,21989942:carton:4230:21994371,21989943:carton:4230:21994540,21989944:carton:4230:21993517,21989945:carton:4230:21994112,21989946:carton:4230:21993737,21989947:carton:4230:21993411,2198'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017094124681816569, 'nb_photo': 1120, 'list_port_cont': '21959691,21959798,21959868,21960413,21960576,21960603,21960656,21960964,21961045,21961154,21961255,21961407,21961453,21961516,21961775,21961975,21962067,21962194,21962281,21990194,21992065,21992110,21992212,21992806,21992844,21992997,21993140,21993225,21993400,21993505,21993559,21993594,21993739,21994096,21994360,21994536,21994686,21994784,21994922,21995085,21999589,22000441,22002820,22005368,22007462,22009837,22015262,22017872,22020154,22022980,22023616,22024841,22051807,22051925,22052146,22052256,22052497,22052675,22052754,22052845,22052898,22053087,22053176,22054598,22056697,22104888,22107357,22107584,22107623,22107655,22107679,22107732,22107755,22107812,22107860,22107906,22107936,22107977,22107984,22108189,22108216,22108260,22108290,22108513,22109638,22112643,22114173,22116197,22118908,22120727,22120951,22121937,22125207,22127391,22129808,22132134,22133071,22135206,22137903,22140455,22143305,22147028,22151336,22156098,22156396,22160183,22163024,22225397,22225640,22225738,22225807,22226409,22226661,2222673', 'assoc_port': '21959002:21962281,21959004:21962067,21959006:21962194,21959008:21961775,21959010:21961407,21959012:21961516,21959014:21961975,21959018:21961154,21959020:21961255,21959022:21961045,21959024:21961453,21959027:21960576,21959029:21960964,21959034:21960603,21959037:21960413,21959039:21960656,21959044:21959798,21959047:21959691,21959049:21959868,21989938:21994922,21989939:21994686,21989940:21994784,21989941:21995085,21989942:21994360,21989943:21994536,21989944:21993505,21989945:21994096,21989946:21993739,21989947:21993400,21989950:21993594,21989951:21992997,21989954:21993140,21989955:21992844,21989958:21999589,21989959:21993559,21989962:21992806,21989963:21992212,21989966:21992065,21989969:21990194,21989971:21992110,21992871:21993225,22000331:22000441,22000332:22005368,22002451:22002820,22007307:22007462,22009332:22009837,22014782:22015262,22017243:22017872,22019574:22020154,22022110:22022980,22023320:22023616,22024543:22024841,22051176:22053087,22051179:22053176,22051182:22052898,22051185:22052675,22051188:2205275', 'assoc_mat': '21959002:metal:4230:21962281,21959004:metal:4230:21962067,21959006:metal:4230:21962194,21959008:metal:4230:21961775,21959010:metal:4230:21961407,21959012:metal:4230:21961516,21959014:metal:4230:21961975,21959018:metal:4230:21961154,21959020:metal:4230:21961255,21959022:metal:4230:21961045,21959024:metal:4230:21961453,21959027:metal:4230:21960576,21959029:metal:4230:21960964,21959034:metal:4230:21960603,21959037:metal:4230:21960413,21959039:metal:4230:21960656,21959044:metal:4230:21959798,21959047:metal:4230:21959691,21959049:metal:4230:21959868,21989938:metal:4230:21994922,21989939:metal:4230:21994686,21989940:metal:4230:21994784,21989941:metal:4230:21995085,21989942:metal:4230:21994360,21989943:metal:4230:21994536,21989944:metal:4230:21993505,21989945:metal:4230:21994096,21989946:metal:4230:21993739,21989947:metal:4230:21993400,21989950:metal:4230:21993594,21989951:metal:4230:21992997,21989954:metal:4230:21993140,21989955:metal:4230:21992844,21989958:metal:4230:21999589,21989959:metal:4230:21993559,21989962:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.23257658784009455, 'nb_photo': 261402, 'list_port_cont': '21959698,21959806,21959879,21959965,21960412,21960469,21960570,21960606,21960668,21960979,21961056,21961092,21961169,21961263,21961382,21961417,21961456,21961513,21961769,21961968,21962083,21962198,21962275,21962530,21990193,21991957,21992061,21992136,21992206,21992811,21992845,21992990,21993139,21993240,21993415,21993506,21993562,21993593,21993730,21994110,21994364,21994546,21994683,21994796,21994919,21995090,21996124,21999590,22000445,22002815,22004816,22005363,22005930,22007459,22009842,22012258,22015266,22017874,22020162,22022985,22023628,22024849,22051443,22051823,22051929,22052153,22052258,22052495,22052682,22052752,22052853,22052914,22053097,22053162,22053559,22054595,22056692,22104902,22107366,22107514,22107587,22107616,22107657,22107693,22107724,22107766,22107813,22107859,22107893,22107942,22107976,22107996,22108051,22108194,22108230,22108253,22108301,22108509,22109635,22112656,22114186,22116199,22118920,22120724,22120958,22121929,22123464,22125218,22127393,22129821,22132143,22133068,22135218,2213791', 'assoc_port': '21959002:21962275,21959004:21962083,21959006:21962198,21959008:21961769,21959010:21961417,21959012:21961513,21959014:21961968,21959016:21961382,21959018:21961169,21959020:21961263,21959022:21961056,21959024:21961456,21959027:21960570,21959029:21960979,21959032:21960469,21959034:21960606,21959037:21960412,21959039:21960668,21959042:21959965,21959044:21959806,21959047:21959698,21959049:21959879,21960915:21961092,21962450:21962530,21989938:21994919,21989939:21994683,21989940:21994796,21989941:21995090,21989942:21994364,21989943:21994546,21989944:21993506,21989945:21994110,21989946:21993730,21989947:21993415,21989950:21993593,21989951:21992990,21989954:21993139,21989955:21992845,21989958:21999590,21989959:21993562,21989962:21992811,21989963:21992206,21989966:21992061,21989967:21991957,21989969:21990193,21989971:21992136,21992871:21993240,21995873:21996124,22000331:22000445,22000332:22005363,22002451:22002815,22004597:22004816,22005794:22005930,22007307:22007459,22009332:22009842,22012050:22012258,22014782:2201526', 'assoc_mat': '21959002:papier:4230:21962275,21959004:papier:4230:21962083,21959006:papier:4230:21962198,21959008:papier:4230:21961769,21959010:papier:4230:21961417,21959012:papier:4230:21961513,21959014:papier:4230:21961968,21959016:papier:4230:21961382,21959018:papier:4230:21961169,21959020:papier:4230:21961263,21959022:papier:4230:21961056,21959024:papier:4230:21961456,21959027:papier:4230:21960570,21959029:papier:4230:21960979,21959032:papier:4230:21960469,21959034:papier:4230:21960606,21959037:papier:4230:21960412,21959039:papier:4230:21960668,21959042:papier:4230:21959965,21959044:papier:4230:21959806,21959047:papier:4230:21959698,21959049:papier:4230:21959879,21960915:papier:4230:21961092,21962450:papier:4230:21962530,21989938:papier:4230:21994919,21989939:papier:4230:21994683,21989940:papier:4230:21994796,21989941:papier:4230:21995090,21989942:papier:4230:21994364,21989943:papier:4230:21994546,21989944:papier:4230:21993506,21989945:papier:4230:21994110,21989946:papier:4230:21993730,21989947:papier:4230:21993415,2198'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005402041913163402, 'nb_photo': 2168, 'list_port_cont': '21959706,21959805,21959966,21960421,21960466,21960608,21960654,21960970,21961048,21961161,21961265,21961371,21961420,21961445,21961525,21961776,21962081,21962195,21962288,21962524,21990187,21991958,21992063,21992142,21992207,21992813,21992846,21992988,21993130,21993230,21993404,21993510,21993561,21993598,21993734,21994109,21994374,21994543,21994681,21994792,21994915,21995095,21996128,21999585,22000436,22002821,22004814,22005360,22005931,22007467,22009835,22012262,22015269,22017864,22020161,22022982,22023620,22024847,22051435,22051818,22051933,22052155,22052260,22052491,22052685,22052761,22052856,22052916,22053085,22053170,22053571,22054594,22056690,22104891,22107365,22107511,22107572,22107614,22107656,22107686,22107723,22107768,22107817,22107907,22107938,22107995,22108052,22108188,22108225,22108264,22108297,22108516,22109633,22112651,22114188,22116194,22118921,22120725,22120949,22121931,22123452,22125215,22127381,22129824,22132142,22133069,22135216,22137911,22140460,22143297,22147033,22150477,22151345,2215610', 'assoc_port': '21959002:21962288,21959004:21962081,21959006:21962195,21959008:21961776,21959010:21961420,21959012:21961525,21959016:21961371,21959018:21961161,21959020:21961265,21959022:21961048,21959024:21961445,21959029:21960970,21959032:21960466,21959034:21960608,21959037:21960421,21959039:21960654,21959042:21959966,21959044:21959805,21959047:21959706,21962450:21962524,21989938:21994915,21989939:21994681,21989940:21994792,21989941:21995095,21989942:21994374,21989943:21994543,21989944:21993510,21989945:21994109,21989946:21993734,21989947:21993404,21989950:21993598,21989951:21992988,21989954:21993130,21989955:21992846,21989958:21999585,21989959:21993561,21989962:21992813,21989963:21992207,21989966:21992063,21989967:21991958,21989969:21990187,21989971:21992142,21992871:21993230,21995873:21996128,22000331:22000436,22000332:22005360,22002451:22002821,22004597:22004814,22005794:22005931,22007307:22007467,22009332:22009835,22012050:22012262,22014782:22015269,22017243:22017864,22019574:22020161,22022110:22022982,22023320:2202362', 'assoc_mat': '21959002:pehd:4230:21962288,21959004:pehd:4230:21962081,21959006:pehd:4230:21962195,21959008:pehd:4230:21961776,21959010:pehd:4230:21961420,21959012:pehd:4230:21961525,21959016:pehd:4230:21961371,21959018:pehd:4230:21961161,21959020:pehd:4230:21961265,21959022:pehd:4230:21961048,21959024:pehd:4230:21961445,21959029:pehd:4230:21960970,21959032:pehd:4230:21960466,21959034:pehd:4230:21960608,21959037:pehd:4230:21960421,21959039:pehd:4230:21960654,21959042:pehd:4230:21959966,21959044:pehd:4230:21959805,21959047:pehd:4230:21959706,21962450:pehd:4230:21962524,21989938:pehd:4230:21994915,21989939:pehd:4230:21994681,21989940:pehd:4230:21994792,21989941:pehd:4230:21995095,21989942:pehd:4230:21994374,21989943:pehd:4230:21994543,21989944:pehd:4230:21993510,21989945:pehd:4230:21994109,21989946:pehd:4230:21993734,21989947:pehd:4230:21993404,21989950:pehd:4230:21993598,21989951:pehd:4230:21992988,21989954:pehd:4230:21993130,21989955:pehd:4230:21992846,21989958:pehd:4230:21999585,21989959:pehd:4230:21993561,21989962:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015857065877296298, 'nb_photo': 13206, 'list_port_cont': '21959704,21959797,21959882,21959961,21960419,21960470,21960566,21960611,21960664,21960971,21961049,21961089,21961160,21961267,21961383,21961419,21961451,21961512,21961777,21961980,21962078,21962191,21962289,21962536,21990191,21991953,21992068,21992156,21992213,21992812,21992847,21992991,21993135,21993238,21993410,21993516,21993563,21993602,21993733,21994107,21994370,21994535,21994691,21994801,21994921,21995087,21996129,21999581,22000448,22002816,22004806,22005370,22005936,22007464,22009846,22012263,22015272,22017867,22020165,22022983,22023622,22024846,22051442,22051820,22051935,22052157,22052252,22052488,22052691,22052756,22052852,22052909,22053091,22053174,22053572,22054600,22056699,22104900,22107362,22107510,22107578,22107615,22107647,22107690,22107730,22107764,22107811,22107868,22107896,22107934,22107973,22107985,22108047,22108192,22108228,22108263,22108302,22108508,22109636,22112649,22114178,22116193,22118925,22120712,22120956,22121925,22123466,22125212,22127387,22129820,22132141,22133070,22135217,2213790', 'assoc_port': '21959002:21962289,21959004:21962078,21959006:21962191,21959008:21961777,21959010:21961419,21959012:21961512,21959014:21961980,21959016:21961383,21959018:21961160,21959020:21961267,21959022:21961049,21959024:21961451,21959027:21960566,21959029:21960971,21959032:21960470,21959034:21960611,21959037:21960419,21959039:21960664,21959042:21959961,21959044:21959797,21959047:21959704,21959049:21959882,21960915:21961089,21962450:21962536,21989938:21994921,21989939:21994691,21989940:21994801,21989941:21995087,21989942:21994370,21989943:21994535,21989944:21993516,21989945:21994107,21989946:21993733,21989947:21993410,21989950:21993602,21989951:21992991,21989954:21993135,21989955:21992847,21989958:21999581,21989959:21993563,21989962:21992812,21989963:21992213,21989966:21992068,21989967:21991953,21989969:21990191,21989971:21992156,21992871:21993238,21995873:21996129,22000331:22000448,22000332:22005370,22002451:22002816,22004597:22004806,22005794:22005936,22007307:22007464,22009332:22009846,22012050:22012263,22014782:2201527', 'assoc_mat': '21959002:pet_clair:4230:21962289,21959004:pet_clair:4230:21962078,21959006:pet_clair:4230:21962191,21959008:pet_clair:4230:21961777,21959010:pet_clair:4230:21961419,21959012:pet_clair:4230:21961512,21959014:pet_clair:4230:21961980,21959016:pet_clair:4230:21961383,21959018:pet_clair:4230:21961160,21959020:pet_clair:4230:21961267,21959022:pet_clair:4230:21961049,21959024:pet_clair:4230:21961451,21959027:pet_clair:4230:21960566,21959029:pet_clair:4230:21960971,21959032:pet_clair:4230:21960470,21959034:pet_clair:4230:21960611,21959037:pet_clair:4230:21960419,21959039:pet_clair:4230:21960664,21959042:pet_clair:4230:21959961,21959044:pet_clair:4230:21959797,21959047:pet_clair:4230:21959704,21959049:pet_clair:4230:21959882,21960915:pet_clair:4230:21961089,21962450:pet_clair:4230:21962536,21989938:pet_clair:4230:21994921,21989939:pet_clair:4230:21994691,21989940:pet_clair:4230:21994801,21989941:pet_clair:4230:21995087,21989942:pet_clair:4230:21994370,21989943:pet_clair:4230:21994535,21989944:pet_clair:4230:21993516,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0035071705812720773, 'nb_photo': 820, 'list_port_cont': '21959700,21959809,21959878,21959959,21960409,21960465,21960600,21960666,21960972,21961047,21961270,21961380,21961412,21961452,21961976,21962071,21962187,21962285,21990188,21991955,21992059,21992154,21992201,21992805,21992850,21992996,21993131,21993233,21993412,21993558,21993597,21993736,21994105,21994362,21994545,21994916,21995091,21999587,22002822,22005366,22005935,22007466,22009847,22017865,22020160,22022984,22023626,22024851,22051436,22051822,22051921,22052161,22052255,22052496,22052678,22052859,22052908,22053171,22054602,22056696,22104896,22107508,22107577,22107654,22107694,22107731,22107767,22107818,22107943,22107979,22107998,22108043,22108191,22108226,22108266,22108298,22108511,22109640,22112652,22114183,22118922,22120722,22120954,22121933,22125219,22127388,22129822,22132136,22133067,22135215,22137912,22140450,22143294,22147041,22150470,22151339,22156107,22156395,22160192,22225405,22225439,22225644,22225737,22225805,22226660,22226735,22226862,22226942,22227049,22227122,22227191,22227303,22227376,2222741', 'assoc_port': '21959002:21962285,21959004:21962071,21959006:21962187,21959010:21961412,21959014:21961976,21959016:21961380,21959020:21961270,21959022:21961047,21959024:21961452,21959029:21960972,21959032:21960465,21959034:21960600,21959037:21960409,21959039:21960666,21959042:21959959,21959044:21959809,21959047:21959700,21959049:21959878,21989938:21994916,21989941:21995091,21989942:21994362,21989943:21994545,21989945:21994105,21989946:21993736,21989947:21993412,21989950:21993597,21989951:21992996,21989954:21993131,21989955:21992850,21989958:21999587,21989959:21993558,21989962:21992805,21989963:21992201,21989966:21992059,21989967:21991955,21989969:21990188,21989971:21992154,21992871:21993233,22000332:22005366,22002451:22002822,22005794:22005935,22007307:22007466,22009332:22009847,22017243:22017865,22019574:22020160,22022110:22022984,22023320:22023626,22024543:22024851,22051179:22053171,22051182:22052908,22051185:22052678,22051190:22052859,22051194:22052161,22051197:22052496,22051199:22052255,22051202:22051921,22051205:2205182', 'assoc_mat': '21959002:pet_fonce:4230:21962285,21959004:pet_fonce:4230:21962071,21959006:pet_fonce:4230:21962187,21959010:pet_fonce:4230:21961412,21959014:pet_fonce:4230:21961976,21959016:pet_fonce:4230:21961380,21959020:pet_fonce:4230:21961270,21959022:pet_fonce:4230:21961047,21959024:pet_fonce:4230:21961452,21959029:pet_fonce:4230:21960972,21959032:pet_fonce:4230:21960465,21959034:pet_fonce:4230:21960600,21959037:pet_fonce:4230:21960409,21959039:pet_fonce:4230:21960666,21959042:pet_fonce:4230:21959959,21959044:pet_fonce:4230:21959809,21959047:pet_fonce:4230:21959700,21959049:pet_fonce:4230:21959878,21989938:pet_fonce:4230:21994916,21989941:pet_fonce:4230:21995091,21989942:pet_fonce:4230:21994362,21989943:pet_fonce:4230:21994545,21989945:pet_fonce:4230:21994105,21989946:pet_fonce:4230:21993736,21989947:pet_fonce:4230:21993412,21989950:pet_fonce:4230:21993597,21989951:pet_fonce:4230:21992996,21989954:pet_fonce:4230:21993131,21989955:pet_fonce:4230:21992850,21989958:pet_fonce:4230:21999587,21989959:pet_fonce:4230:21993558,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(1716892,1719584,1721912,1724720,1728625,1732673,1737099,1739966,1740374,1743248,1747174,1751189,1755044,1757999,1760300,1764573,1769008)); 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-04-01' and date <= '2025-04-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((953,),), 'unwanted_material_monthly_percentage': ((0.6830654218474096,),), 'material_repartition': (('incineration', 953),), 'material_dict': {'incineration': 953}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 4, 1), 0.6693817221225653, 64), (datetime.date(2025, 4, 2), 0.6277550985462367, 70), (datetime.date(2025, 4, 3), 0.6840826891380833, 32), (datetime.date(2025, 4, 15), 0.6294066407037463, 36), (datetime.date(2025, 4, 16), 0.6586427016841536, 69), (datetime.date(2025, 4, 17), 0.6167191240978727, 63), (datetime.date(2025, 4, 18), 0.6715538561764586, 64), (datetime.date(2025, 4, 19), 0.670068042295024, 57), (datetime.date(2025, 4, 20), 0.74469988228047, 48), (datetime.date(2025, 4, 21), 0.7984497664745278, 53), (datetime.date(2025, 4, 22), 0.7522339057181453, 57), (datetime.date(2025, 4, 23), 0.690666832845602, 61), (datetime.date(2025, 4, 24), 0.7027076193683486, 76), (datetime.date(2025, 4, 25), 0.6647607942001998, 45), (datetime.date(2025, 4, 28), 0.755259254023848, 37), (datetime.date(2025, 4, 29), 0.6651020106618949, 61), (datetime.date(2025, 4, 30), 0.6348422724767369, 60)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 4, 1), 0.6693817221225653, 64), (datetime.date(2025, 4, 2), 0.6277550985462367, 70), (datetime.date(2025, 4, 3), 0.6840826891380833, 32), (datetime.date(2025, 4, 15), 0.6294066407037463, 36), (datetime.date(2025, 4, 16), 0.6586427016841536, 69), (datetime.date(2025, 4, 17), 0.6167191240978727, 63), (datetime.date(2025, 4, 18), 0.6715538561764586, 64), (datetime.date(2025, 4, 19), 0.670068042295024, 57), (datetime.date(2025, 4, 20), 0.74469988228047, 48), (datetime.date(2025, 4, 21), 0.7984497664745278, 53), (datetime.date(2025, 4, 22), 0.7522339057181453, 57), (datetime.date(2025, 4, 23), 0.690666832845602, 61), (datetime.date(2025, 4, 24), 0.7027076193683486, 76), (datetime.date(2025, 4, 25), 0.6647607942001998, 45), (datetime.date(2025, 4, 28), 0.755259254023848, 37), (datetime.date(2025, 4, 29), 0.6651020106618949, 61), (datetime.date(2025, 4, 30), 0.6348422724767369, 60))}, 'quality_array': [['-8.225213085701165', '01042025'], ['-8.248765197707527', '02042025'], ['-8.027065993300244', '03042025'], ['-8.608513217146388', '15042025'], ['-8.765633526298567', '16042025'], ['-8.663061029559225', '17042025'], ['-8.80351639332288', '18042025'], ['-8.721490188872462', '19042025'], ['-8.599066986412383', '20042025'], ['-8.03512959176092', '21042025'], ['-7.856702379726083', '22042025'], ['-7.868833252833706', '23042025'], ['-8.275981207864366', '24042025'], ['-8.496581777976182', '25042025'], ['-7.786963053627799', '28042025'], ['-8.158787035372631', '29042025'], ['-8.36413727794473', '30042025']], 'number_of_batch': ((364,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020208634750010127, 'nb_photo': 12772, 'list_port_cont': '21959705,21959795,21959876,21959955,21960420,21960454,21960561,21960596,21960661,21960963,21961050,21961087,21961164,21961254,21961384,21961418,21961449,21961522,21961779,21961979,21962076,21962193,21962278,21962529,21990196,21991954,21992062,21992120,21992210,21992803,21992841,21992989,21993127,21993232,21993413,21993518,21993560,21993601,21993724,21994100,21994369,21994534,21994688,21994800,21994907,21995088,21996119,21999588,22000440,22002811,22004812,22005354,22005923,22007469,22009844,22012256,22015260,22017857,22020164,22022981,22023624,22024837,22051429,22051809,22051931,22052159,22052254,22052493,22052686,22052749,22052843,22052902,22053098,22053173,22053556,22054597,22056694,22104895,22107369,22107506,22107579,22107612,22107648,22107682,22107715,22107759,22107808,22107863,22107898,22107940,22107965,22107991,22108040,22108183,22108224,22108250,22108285,22108499,22109642,22112655,22114179,22116184,22118924,22120710,22120947,22121930,22123449,22125206,22127394,22129811,22132145,22133055,22135209,2213790', 'assoc_port': '21959002:21962278,21959004:21962076,21959006:21962193,21959008:21961779,21959010:21961418,21959012:21961522,21959014:21961979,21959016:21961384,21959018:21961164,21959020:21961254,21959022:21961050,21959024:21961449,21959027:21960561,21959029:21960963,21959032:21960454,21959034:21960596,21959037:21960420,21959039:21960661,21959042:21959955,21959044:21959795,21959047:21959705,21959049:21959876,21960915:21961087,21962450:21962529,21989938:21994907,21989939:21994688,21989940:21994800,21989941:21995088,21989942:21994369,21989943:21994534,21989944:21993518,21989945:21994100,21989946:21993724,21989947:21993413,21989950:21993601,21989951:21992989,21989954:21993127,21989955:21992841,21989958:21999588,21989959:21993560,21989962:21992803,21989963:21992210,21989966:21992062,21989967:21991954,21989969:21990196,21989971:21992120,21992871:21993232,21995873:21996119,22000331:22000440,22000332:22005354,22002451:22002811,22004597:22004812,22005794:22005923,22007307:22007469,22009332:22009844,22012050:22012256,22014782:2201526', 'assoc_mat': '21959002:autre:4230:21962278,21959004:autre:4230:21962076,21959006:autre:4230:21962193,21959008:autre:4230:21961779,21959010:autre:4230:21961418,21959012:autre:4230:21961522,21959014:autre:4230:21961979,21959016:autre:4230:21961384,21959018:autre:4230:21961164,21959020:autre:4230:21961254,21959022:autre:4230:21961050,21959024:autre:4230:21961449,21959027:autre:4230:21960561,21959029:autre:4230:21960963,21959032:autre:4230:21960454,21959034:autre:4230:21960596,21959037:autre:4230:21960420,21959039:autre:4230:21960661,21959042:autre:4230:21959955,21959044:autre:4230:21959795,21959047:autre:4230:21959705,21959049:autre:4230:21959876,21960915:autre:4230:21961087,21962450:autre:4230:21962529,21989938:autre:4230:21994907,21989939:autre:4230:21994688,21989940:autre:4230:21994800,21989941:autre:4230:21995088,21989942:autre:4230:21994369,21989943:autre:4230:21994534,21989944:autre:4230:21993518,21989945:autre:4230:21994100,21989946:autre:4230:21993724,21989947:autre:4230:21993413,21989950:autre:4230:21993601,21989951:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06450354029798254, 'nb_photo': 58805, 'list_port_cont': '21959692,21959801,21959881,21959964,21960415,21960456,21960577,21960612,21960663,21960966,21961051,21961086,21961167,21961269,21961369,21961415,21961450,21961521,21961782,21961974,21962079,21962197,21962284,21962523,21990195,21991951,21992064,21992158,21992211,21992804,21992843,21992995,21993134,21993235,21993411,21993517,21993564,21993599,21993737,21994112,21994371,21994540,21994685,21994798,21994917,21995094,21996127,21999582,22000443,22002812,22004811,22005369,22005929,22007468,22009845,22012252,22015267,22017866,22020168,22022970,22023625,22024844,22051441,22051812,22051930,22052136,22052261,22052494,22052688,22052760,22052844,22052903,22053099,22053175,22053569,22054592,22056698,22104899,22107356,22107513,22107582,22107617,22107650,22107696,22107728,22107765,22107815,22107857,22107900,22107933,22107974,22107992,22108044,22108180,22108217,22108255,22108292,22108512,22109643,22112648,22114176,22116190,22118917,22120726,22120953,22121934,22123461,22125217,22127392,22129814,22132144,22133064,22135211,2213790', 'assoc_port': '21959002:21962284,21959004:21962079,21959006:21962197,21959008:21961782,21959010:21961415,21959012:21961521,21959014:21961974,21959016:21961369,21959018:21961167,21959020:21961269,21959022:21961051,21959024:21961450,21959027:21960577,21959029:21960966,21959032:21960456,21959034:21960612,21959037:21960415,21959039:21960663,21959042:21959964,21959044:21959801,21959047:21959692,21959049:21959881,21960915:21961086,21962450:21962523,21989938:21994917,21989939:21994685,21989940:21994798,21989941:21995094,21989942:21994371,21989943:21994540,21989944:21993517,21989945:21994112,21989946:21993737,21989947:21993411,21989950:21993599,21989951:21992995,21989954:21993134,21989955:21992843,21989958:21999582,21989959:21993564,21989962:21992804,21989963:21992211,21989966:21992064,21989967:21991951,21989969:21990195,21989971:21992158,21992871:21993235,21995873:21996127,22000331:22000443,22000332:22005369,22002451:22002812,22004597:22004811,22005794:22005929,22007307:22007468,22009332:22009845,22012050:22012252,22014782:2201526', 'assoc_mat': '21959002:carton:4230:21962284,21959004:carton:4230:21962079,21959006:carton:4230:21962197,21959008:carton:4230:21961782,21959010:carton:4230:21961415,21959012:carton:4230:21961521,21959014:carton:4230:21961974,21959016:carton:4230:21961369,21959018:carton:4230:21961167,21959020:carton:4230:21961269,21959022:carton:4230:21961051,21959024:carton:4230:21961450,21959027:carton:4230:21960577,21959029:carton:4230:21960966,21959032:carton:4230:21960456,21959034:carton:4230:21960612,21959037:carton:4230:21960415,21959039:carton:4230:21960663,21959042:carton:4230:21959964,21959044:carton:4230:21959801,21959047:carton:4230:21959692,21959049:carton:4230:21959881,21960915:carton:4230:21961086,21962450:carton:4230:21962523,21989938:carton:4230:21994917,21989939:carton:4230:21994685,21989940:carton:4230:21994798,21989941:carton:4230:21995094,21989942:carton:4230:21994371,21989943:carton:4230:21994540,21989944:carton:4230:21993517,21989945:carton:4230:21994112,21989946:carton:4230:21993737,21989947:carton:4230:21993411,2198'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017094124681816569, 'nb_photo': 1120, 'list_port_cont': '21959691,21959798,21959868,21960413,21960576,21960603,21960656,21960964,21961045,21961154,21961255,21961407,21961453,21961516,21961775,21961975,21962067,21962194,21962281,21990194,21992065,21992110,21992212,21992806,21992844,21992997,21993140,21993225,21993400,21993505,21993559,21993594,21993739,21994096,21994360,21994536,21994686,21994784,21994922,21995085,21999589,22000441,22002820,22005368,22007462,22009837,22015262,22017872,22020154,22022980,22023616,22024841,22051807,22051925,22052146,22052256,22052497,22052675,22052754,22052845,22052898,22053087,22053176,22054598,22056697,22104888,22107357,22107584,22107623,22107655,22107679,22107732,22107755,22107812,22107860,22107906,22107936,22107977,22107984,22108189,22108216,22108260,22108290,22108513,22109638,22112643,22114173,22116197,22118908,22120727,22120951,22121937,22125207,22127391,22129808,22132134,22133071,22135206,22137903,22140455,22143305,22147028,22151336,22156098,22156396,22160183,22163024,22225397,22225640,22225738,22225807,22226409,22226661,2222673', 'assoc_port': '21959002:21962281,21959004:21962067,21959006:21962194,21959008:21961775,21959010:21961407,21959012:21961516,21959014:21961975,21959018:21961154,21959020:21961255,21959022:21961045,21959024:21961453,21959027:21960576,21959029:21960964,21959034:21960603,21959037:21960413,21959039:21960656,21959044:21959798,21959047:21959691,21959049:21959868,21989938:21994922,21989939:21994686,21989940:21994784,21989941:21995085,21989942:21994360,21989943:21994536,21989944:21993505,21989945:21994096,21989946:21993739,21989947:21993400,21989950:21993594,21989951:21992997,21989954:21993140,21989955:21992844,21989958:21999589,21989959:21993559,21989962:21992806,21989963:21992212,21989966:21992065,21989969:21990194,21989971:21992110,21992871:21993225,22000331:22000441,22000332:22005368,22002451:22002820,22007307:22007462,22009332:22009837,22014782:22015262,22017243:22017872,22019574:22020154,22022110:22022980,22023320:22023616,22024543:22024841,22051176:22053087,22051179:22053176,22051182:22052898,22051185:22052675,22051188:2205275', 'assoc_mat': '21959002:metal:4230:21962281,21959004:metal:4230:21962067,21959006:metal:4230:21962194,21959008:metal:4230:21961775,21959010:metal:4230:21961407,21959012:metal:4230:21961516,21959014:metal:4230:21961975,21959018:metal:4230:21961154,21959020:metal:4230:21961255,21959022:metal:4230:21961045,21959024:metal:4230:21961453,21959027:metal:4230:21960576,21959029:metal:4230:21960964,21959034:metal:4230:21960603,21959037:metal:4230:21960413,21959039:metal:4230:21960656,21959044:metal:4230:21959798,21959047:metal:4230:21959691,21959049:metal:4230:21959868,21989938:metal:4230:21994922,21989939:metal:4230:21994686,21989940:metal:4230:21994784,21989941:metal:4230:21995085,21989942:metal:4230:21994360,21989943:metal:4230:21994536,21989944:metal:4230:21993505,21989945:metal:4230:21994096,21989946:metal:4230:21993739,21989947:metal:4230:21993400,21989950:metal:4230:21993594,21989951:metal:4230:21992997,21989954:metal:4230:21993140,21989955:metal:4230:21992844,21989958:metal:4230:21999589,21989959:metal:4230:21993559,21989962:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.23257658784009455, 'nb_photo': 261402, 'list_port_cont': '21959698,21959806,21959879,21959965,21960412,21960469,21960570,21960606,21960668,21960979,21961056,21961092,21961169,21961263,21961382,21961417,21961456,21961513,21961769,21961968,21962083,21962198,21962275,21962530,21990193,21991957,21992061,21992136,21992206,21992811,21992845,21992990,21993139,21993240,21993415,21993506,21993562,21993593,21993730,21994110,21994364,21994546,21994683,21994796,21994919,21995090,21996124,21999590,22000445,22002815,22004816,22005363,22005930,22007459,22009842,22012258,22015266,22017874,22020162,22022985,22023628,22024849,22051443,22051823,22051929,22052153,22052258,22052495,22052682,22052752,22052853,22052914,22053097,22053162,22053559,22054595,22056692,22104902,22107366,22107514,22107587,22107616,22107657,22107693,22107724,22107766,22107813,22107859,22107893,22107942,22107976,22107996,22108051,22108194,22108230,22108253,22108301,22108509,22109635,22112656,22114186,22116199,22118920,22120724,22120958,22121929,22123464,22125218,22127393,22129821,22132143,22133068,22135218,2213791', 'assoc_port': '21959002:21962275,21959004:21962083,21959006:21962198,21959008:21961769,21959010:21961417,21959012:21961513,21959014:21961968,21959016:21961382,21959018:21961169,21959020:21961263,21959022:21961056,21959024:21961456,21959027:21960570,21959029:21960979,21959032:21960469,21959034:21960606,21959037:21960412,21959039:21960668,21959042:21959965,21959044:21959806,21959047:21959698,21959049:21959879,21960915:21961092,21962450:21962530,21989938:21994919,21989939:21994683,21989940:21994796,21989941:21995090,21989942:21994364,21989943:21994546,21989944:21993506,21989945:21994110,21989946:21993730,21989947:21993415,21989950:21993593,21989951:21992990,21989954:21993139,21989955:21992845,21989958:21999590,21989959:21993562,21989962:21992811,21989963:21992206,21989966:21992061,21989967:21991957,21989969:21990193,21989971:21992136,21992871:21993240,21995873:21996124,22000331:22000445,22000332:22005363,22002451:22002815,22004597:22004816,22005794:22005930,22007307:22007459,22009332:22009842,22012050:22012258,22014782:2201526', 'assoc_mat': '21959002:papier:4230:21962275,21959004:papier:4230:21962083,21959006:papier:4230:21962198,21959008:papier:4230:21961769,21959010:papier:4230:21961417,21959012:papier:4230:21961513,21959014:papier:4230:21961968,21959016:papier:4230:21961382,21959018:papier:4230:21961169,21959020:papier:4230:21961263,21959022:papier:4230:21961056,21959024:papier:4230:21961456,21959027:papier:4230:21960570,21959029:papier:4230:21960979,21959032:papier:4230:21960469,21959034:papier:4230:21960606,21959037:papier:4230:21960412,21959039:papier:4230:21960668,21959042:papier:4230:21959965,21959044:papier:4230:21959806,21959047:papier:4230:21959698,21959049:papier:4230:21959879,21960915:papier:4230:21961092,21962450:papier:4230:21962530,21989938:papier:4230:21994919,21989939:papier:4230:21994683,21989940:papier:4230:21994796,21989941:papier:4230:21995090,21989942:papier:4230:21994364,21989943:papier:4230:21994546,21989944:papier:4230:21993506,21989945:papier:4230:21994110,21989946:papier:4230:21993730,21989947:papier:4230:21993415,2198'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005402041913163402, 'nb_photo': 2168, 'list_port_cont': '21959706,21959805,21959966,21960421,21960466,21960608,21960654,21960970,21961048,21961161,21961265,21961371,21961420,21961445,21961525,21961776,21962081,21962195,21962288,21962524,21990187,21991958,21992063,21992142,21992207,21992813,21992846,21992988,21993130,21993230,21993404,21993510,21993561,21993598,21993734,21994109,21994374,21994543,21994681,21994792,21994915,21995095,21996128,21999585,22000436,22002821,22004814,22005360,22005931,22007467,22009835,22012262,22015269,22017864,22020161,22022982,22023620,22024847,22051435,22051818,22051933,22052155,22052260,22052491,22052685,22052761,22052856,22052916,22053085,22053170,22053571,22054594,22056690,22104891,22107365,22107511,22107572,22107614,22107656,22107686,22107723,22107768,22107817,22107907,22107938,22107995,22108052,22108188,22108225,22108264,22108297,22108516,22109633,22112651,22114188,22116194,22118921,22120725,22120949,22121931,22123452,22125215,22127381,22129824,22132142,22133069,22135216,22137911,22140460,22143297,22147033,22150477,22151345,2215610', 'assoc_port': '21959002:21962288,21959004:21962081,21959006:21962195,21959008:21961776,21959010:21961420,21959012:21961525,21959016:21961371,21959018:21961161,21959020:21961265,21959022:21961048,21959024:21961445,21959029:21960970,21959032:21960466,21959034:21960608,21959037:21960421,21959039:21960654,21959042:21959966,21959044:21959805,21959047:21959706,21962450:21962524,21989938:21994915,21989939:21994681,21989940:21994792,21989941:21995095,21989942:21994374,21989943:21994543,21989944:21993510,21989945:21994109,21989946:21993734,21989947:21993404,21989950:21993598,21989951:21992988,21989954:21993130,21989955:21992846,21989958:21999585,21989959:21993561,21989962:21992813,21989963:21992207,21989966:21992063,21989967:21991958,21989969:21990187,21989971:21992142,21992871:21993230,21995873:21996128,22000331:22000436,22000332:22005360,22002451:22002821,22004597:22004814,22005794:22005931,22007307:22007467,22009332:22009835,22012050:22012262,22014782:22015269,22017243:22017864,22019574:22020161,22022110:22022982,22023320:2202362', 'assoc_mat': '21959002:pehd:4230:21962288,21959004:pehd:4230:21962081,21959006:pehd:4230:21962195,21959008:pehd:4230:21961776,21959010:pehd:4230:21961420,21959012:pehd:4230:21961525,21959016:pehd:4230:21961371,21959018:pehd:4230:21961161,21959020:pehd:4230:21961265,21959022:pehd:4230:21961048,21959024:pehd:4230:21961445,21959029:pehd:4230:21960970,21959032:pehd:4230:21960466,21959034:pehd:4230:21960608,21959037:pehd:4230:21960421,21959039:pehd:4230:21960654,21959042:pehd:4230:21959966,21959044:pehd:4230:21959805,21959047:pehd:4230:21959706,21962450:pehd:4230:21962524,21989938:pehd:4230:21994915,21989939:pehd:4230:21994681,21989940:pehd:4230:21994792,21989941:pehd:4230:21995095,21989942:pehd:4230:21994374,21989943:pehd:4230:21994543,21989944:pehd:4230:21993510,21989945:pehd:4230:21994109,21989946:pehd:4230:21993734,21989947:pehd:4230:21993404,21989950:pehd:4230:21993598,21989951:pehd:4230:21992988,21989954:pehd:4230:21993130,21989955:pehd:4230:21992846,21989958:pehd:4230:21999585,21989959:pehd:4230:21993561,21989962:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015857065877296298, 'nb_photo': 13206, 'list_port_cont': '21959704,21959797,21959882,21959961,21960419,21960470,21960566,21960611,21960664,21960971,21961049,21961089,21961160,21961267,21961383,21961419,21961451,21961512,21961777,21961980,21962078,21962191,21962289,21962536,21990191,21991953,21992068,21992156,21992213,21992812,21992847,21992991,21993135,21993238,21993410,21993516,21993563,21993602,21993733,21994107,21994370,21994535,21994691,21994801,21994921,21995087,21996129,21999581,22000448,22002816,22004806,22005370,22005936,22007464,22009846,22012263,22015272,22017867,22020165,22022983,22023622,22024846,22051442,22051820,22051935,22052157,22052252,22052488,22052691,22052756,22052852,22052909,22053091,22053174,22053572,22054600,22056699,22104900,22107362,22107510,22107578,22107615,22107647,22107690,22107730,22107764,22107811,22107868,22107896,22107934,22107973,22107985,22108047,22108192,22108228,22108263,22108302,22108508,22109636,22112649,22114178,22116193,22118925,22120712,22120956,22121925,22123466,22125212,22127387,22129820,22132141,22133070,22135217,2213790', 'assoc_port': '21959002:21962289,21959004:21962078,21959006:21962191,21959008:21961777,21959010:21961419,21959012:21961512,21959014:21961980,21959016:21961383,21959018:21961160,21959020:21961267,21959022:21961049,21959024:21961451,21959027:21960566,21959029:21960971,21959032:21960470,21959034:21960611,21959037:21960419,21959039:21960664,21959042:21959961,21959044:21959797,21959047:21959704,21959049:21959882,21960915:21961089,21962450:21962536,21989938:21994921,21989939:21994691,21989940:21994801,21989941:21995087,21989942:21994370,21989943:21994535,21989944:21993516,21989945:21994107,21989946:21993733,21989947:21993410,21989950:21993602,21989951:21992991,21989954:21993135,21989955:21992847,21989958:21999581,21989959:21993563,21989962:21992812,21989963:21992213,21989966:21992068,21989967:21991953,21989969:21990191,21989971:21992156,21992871:21993238,21995873:21996129,22000331:22000448,22000332:22005370,22002451:22002816,22004597:22004806,22005794:22005936,22007307:22007464,22009332:22009846,22012050:22012263,22014782:2201527', 'assoc_mat': '21959002:pet_clair:4230:21962289,21959004:pet_clair:4230:21962078,21959006:pet_clair:4230:21962191,21959008:pet_clair:4230:21961777,21959010:pet_clair:4230:21961419,21959012:pet_clair:4230:21961512,21959014:pet_clair:4230:21961980,21959016:pet_clair:4230:21961383,21959018:pet_clair:4230:21961160,21959020:pet_clair:4230:21961267,21959022:pet_clair:4230:21961049,21959024:pet_clair:4230:21961451,21959027:pet_clair:4230:21960566,21959029:pet_clair:4230:21960971,21959032:pet_clair:4230:21960470,21959034:pet_clair:4230:21960611,21959037:pet_clair:4230:21960419,21959039:pet_clair:4230:21960664,21959042:pet_clair:4230:21959961,21959044:pet_clair:4230:21959797,21959047:pet_clair:4230:21959704,21959049:pet_clair:4230:21959882,21960915:pet_clair:4230:21961089,21962450:pet_clair:4230:21962536,21989938:pet_clair:4230:21994921,21989939:pet_clair:4230:21994691,21989940:pet_clair:4230:21994801,21989941:pet_clair:4230:21995087,21989942:pet_clair:4230:21994370,21989943:pet_clair:4230:21994535,21989944:pet_clair:4230:21993516,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0035071705812720773, 'nb_photo': 820, 'list_port_cont': '21959700,21959809,21959878,21959959,21960409,21960465,21960600,21960666,21960972,21961047,21961270,21961380,21961412,21961452,21961976,21962071,21962187,21962285,21990188,21991955,21992059,21992154,21992201,21992805,21992850,21992996,21993131,21993233,21993412,21993558,21993597,21993736,21994105,21994362,21994545,21994916,21995091,21999587,22002822,22005366,22005935,22007466,22009847,22017865,22020160,22022984,22023626,22024851,22051436,22051822,22051921,22052161,22052255,22052496,22052678,22052859,22052908,22053171,22054602,22056696,22104896,22107508,22107577,22107654,22107694,22107731,22107767,22107818,22107943,22107979,22107998,22108043,22108191,22108226,22108266,22108298,22108511,22109640,22112652,22114183,22118922,22120722,22120954,22121933,22125219,22127388,22129822,22132136,22133067,22135215,22137912,22140450,22143294,22147041,22150470,22151339,22156107,22156395,22160192,22225405,22225439,22225644,22225737,22225805,22226660,22226735,22226862,22226942,22227049,22227122,22227191,22227303,22227376,2222741', 'assoc_port': '21959002:21962285,21959004:21962071,21959006:21962187,21959010:21961412,21959014:21961976,21959016:21961380,21959020:21961270,21959022:21961047,21959024:21961452,21959029:21960972,21959032:21960465,21959034:21960600,21959037:21960409,21959039:21960666,21959042:21959959,21959044:21959809,21959047:21959700,21959049:21959878,21989938:21994916,21989941:21995091,21989942:21994362,21989943:21994545,21989945:21994105,21989946:21993736,21989947:21993412,21989950:21993597,21989951:21992996,21989954:21993131,21989955:21992850,21989958:21999587,21989959:21993558,21989962:21992805,21989963:21992201,21989966:21992059,21989967:21991955,21989969:21990188,21989971:21992154,21992871:21993233,22000332:22005366,22002451:22002822,22005794:22005935,22007307:22007466,22009332:22009847,22017243:22017865,22019574:22020160,22022110:22022984,22023320:22023626,22024543:22024851,22051179:22053171,22051182:22052908,22051185:22052678,22051190:22052859,22051194:22052161,22051197:22052496,22051199:22052255,22051202:22051921,22051205:2205182', 'assoc_mat': '21959002:pet_fonce:4230:21962285,21959004:pet_fonce:4230:21962071,21959006:pet_fonce:4230:21962187,21959010:pet_fonce:4230:21961412,21959014:pet_fonce:4230:21961976,21959016:pet_fonce:4230:21961380,21959020:pet_fonce:4230:21961270,21959022:pet_fonce:4230:21961047,21959024:pet_fonce:4230:21961452,21959029:pet_fonce:4230:21960972,21959032:pet_fonce:4230:21960465,21959034:pet_fonce:4230:21960600,21959037:pet_fonce:4230:21960409,21959039:pet_fonce:4230:21960666,21959042:pet_fonce:4230:21959959,21959044:pet_fonce:4230:21959809,21959047:pet_fonce:4230:21959700,21959049:pet_fonce:4230:21959878,21989938:pet_fonce:4230:21994916,21989941:pet_fonce:4230:21995091,21989942:pet_fonce:4230:21994362,21989943:pet_fonce:4230:21994545,21989945:pet_fonce:4230:21994105,21989946:pet_fonce:4230:21993736,21989947:pet_fonce:4230:21993412,21989950:pet_fonce:4230:21993597,21989951:pet_fonce:4230:21992996,21989954:pet_fonce:4230:21993131,21989955:pet_fonce:4230:21992850,21989958:pet_fonce:4230:21999587,21989959:pet_fonce:4230:21993558,2'}), 'main_stat': {'nb_photos': 953}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-04', 0.6830654218474096),)]} 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': ((953,),), 'unwanted_material_monthly_percentage': ((0.6830654218474096,),), 'material_repartition': (('incineration', 953),), 'material_dict': {'incineration': 953}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 4, 1), 0.6693817221225653, 64), (datetime.date(2025, 4, 2), 0.6277550985462367, 70), (datetime.date(2025, 4, 3), 0.6840826891380833, 32), (datetime.date(2025, 4, 15), 0.6294066407037463, 36), (datetime.date(2025, 4, 16), 0.6586427016841536, 69), (datetime.date(2025, 4, 17), 0.6167191240978727, 63), (datetime.date(2025, 4, 18), 0.6715538561764586, 64), (datetime.date(2025, 4, 19), 0.670068042295024, 57), (datetime.date(2025, 4, 20), 0.74469988228047, 48), (datetime.date(2025, 4, 21), 0.7984497664745278, 53), (datetime.date(2025, 4, 22), 0.7522339057181453, 57), (datetime.date(2025, 4, 23), 0.690666832845602, 61), (datetime.date(2025, 4, 24), 0.7027076193683486, 76), (datetime.date(2025, 4, 25), 0.6647607942001998, 45), (datetime.date(2025, 4, 28), 0.755259254023848, 37), (datetime.date(2025, 4, 29), 0.6651020106618949, 61), (datetime.date(2025, 4, 30), 0.6348422724767369, 60)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 4, 1), 0.6693817221225653, 64), (datetime.date(2025, 4, 2), 0.6277550985462367, 70), (datetime.date(2025, 4, 3), 0.6840826891380833, 32), (datetime.date(2025, 4, 15), 0.6294066407037463, 36), (datetime.date(2025, 4, 16), 0.6586427016841536, 69), (datetime.date(2025, 4, 17), 0.6167191240978727, 63), (datetime.date(2025, 4, 18), 0.6715538561764586, 64), (datetime.date(2025, 4, 19), 0.670068042295024, 57), (datetime.date(2025, 4, 20), 0.74469988228047, 48), (datetime.date(2025, 4, 21), 0.7984497664745278, 53), (datetime.date(2025, 4, 22), 0.7522339057181453, 57), (datetime.date(2025, 4, 23), 0.690666832845602, 61), (datetime.date(2025, 4, 24), 0.7027076193683486, 76), (datetime.date(2025, 4, 25), 0.6647607942001998, 45), (datetime.date(2025, 4, 28), 0.755259254023848, 37), (datetime.date(2025, 4, 29), 0.6651020106618949, 61), (datetime.date(2025, 4, 30), 0.6348422724767369, 60))}, 'quality_array': [['-8.225213085701165', '01042025'], ['-8.248765197707527', '02042025'], ['-8.027065993300244', '03042025'], ['-8.608513217146388', '15042025'], ['-8.765633526298567', '16042025'], ['-8.663061029559225', '17042025'], ['-8.80351639332288', '18042025'], ['-8.721490188872462', '19042025'], ['-8.599066986412383', '20042025'], ['-8.03512959176092', '21042025'], ['-7.856702379726083', '22042025'], ['-7.868833252833706', '23042025'], ['-8.275981207864366', '24042025'], ['-8.496581777976182', '25042025'], ['-7.786963053627799', '28042025'], ['-8.158787035372631', '29042025'], ['-8.36413727794473', '30042025']], 'number_of_batch': ((364,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020208634750010127, 'nb_photo': 12772, 'list_port_cont': '21959705,21959795,21959876,21959955,21960420,21960454,21960561,21960596,21960661,21960963,21961050,21961087,21961164,21961254,21961384,21961418,21961449,21961522,21961779,21961979,21962076,21962193,21962278,21962529,21990196,21991954,21992062,21992120,21992210,21992803,21992841,21992989,21993127,21993232,21993413,21993518,21993560,21993601,21993724,21994100,21994369,21994534,21994688,21994800,21994907,21995088,21996119,21999588,22000440,22002811,22004812,22005354,22005923,22007469,22009844,22012256,22015260,22017857,22020164,22022981,22023624,22024837,22051429,22051809,22051931,22052159,22052254,22052493,22052686,22052749,22052843,22052902,22053098,22053173,22053556,22054597,22056694,22104895,22107369,22107506,22107579,22107612,22107648,22107682,22107715,22107759,22107808,22107863,22107898,22107940,22107965,22107991,22108040,22108183,22108224,22108250,22108285,22108499,22109642,22112655,22114179,22116184,22118924,22120710,22120947,22121930,22123449,22125206,22127394,22129811,22132145,22133055,22135209,2213790', 'assoc_port': '21959002:21962278,21959004:21962076,21959006:21962193,21959008:21961779,21959010:21961418,21959012:21961522,21959014:21961979,21959016:21961384,21959018:21961164,21959020:21961254,21959022:21961050,21959024:21961449,21959027:21960561,21959029:21960963,21959032:21960454,21959034:21960596,21959037:21960420,21959039:21960661,21959042:21959955,21959044:21959795,21959047:21959705,21959049:21959876,21960915:21961087,21962450:21962529,21989938:21994907,21989939:21994688,21989940:21994800,21989941:21995088,21989942:21994369,21989943:21994534,21989944:21993518,21989945:21994100,21989946:21993724,21989947:21993413,21989950:21993601,21989951:21992989,21989954:21993127,21989955:21992841,21989958:21999588,21989959:21993560,21989962:21992803,21989963:21992210,21989966:21992062,21989967:21991954,21989969:21990196,21989971:21992120,21992871:21993232,21995873:21996119,22000331:22000440,22000332:22005354,22002451:22002811,22004597:22004812,22005794:22005923,22007307:22007469,22009332:22009844,22012050:22012256,22014782:2201526', 'assoc_mat': '21959002:autre:4230:21962278,21959004:autre:4230:21962076,21959006:autre:4230:21962193,21959008:autre:4230:21961779,21959010:autre:4230:21961418,21959012:autre:4230:21961522,21959014:autre:4230:21961979,21959016:autre:4230:21961384,21959018:autre:4230:21961164,21959020:autre:4230:21961254,21959022:autre:4230:21961050,21959024:autre:4230:21961449,21959027:autre:4230:21960561,21959029:autre:4230:21960963,21959032:autre:4230:21960454,21959034:autre:4230:21960596,21959037:autre:4230:21960420,21959039:autre:4230:21960661,21959042:autre:4230:21959955,21959044:autre:4230:21959795,21959047:autre:4230:21959705,21959049:autre:4230:21959876,21960915:autre:4230:21961087,21962450:autre:4230:21962529,21989938:autre:4230:21994907,21989939:autre:4230:21994688,21989940:autre:4230:21994800,21989941:autre:4230:21995088,21989942:autre:4230:21994369,21989943:autre:4230:21994534,21989944:autre:4230:21993518,21989945:autre:4230:21994100,21989946:autre:4230:21993724,21989947:autre:4230:21993413,21989950:autre:4230:21993601,21989951:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06450354029798254, 'nb_photo': 58805, 'list_port_cont': '21959692,21959801,21959881,21959964,21960415,21960456,21960577,21960612,21960663,21960966,21961051,21961086,21961167,21961269,21961369,21961415,21961450,21961521,21961782,21961974,21962079,21962197,21962284,21962523,21990195,21991951,21992064,21992158,21992211,21992804,21992843,21992995,21993134,21993235,21993411,21993517,21993564,21993599,21993737,21994112,21994371,21994540,21994685,21994798,21994917,21995094,21996127,21999582,22000443,22002812,22004811,22005369,22005929,22007468,22009845,22012252,22015267,22017866,22020168,22022970,22023625,22024844,22051441,22051812,22051930,22052136,22052261,22052494,22052688,22052760,22052844,22052903,22053099,22053175,22053569,22054592,22056698,22104899,22107356,22107513,22107582,22107617,22107650,22107696,22107728,22107765,22107815,22107857,22107900,22107933,22107974,22107992,22108044,22108180,22108217,22108255,22108292,22108512,22109643,22112648,22114176,22116190,22118917,22120726,22120953,22121934,22123461,22125217,22127392,22129814,22132144,22133064,22135211,2213790', 'assoc_port': '21959002:21962284,21959004:21962079,21959006:21962197,21959008:21961782,21959010:21961415,21959012:21961521,21959014:21961974,21959016:21961369,21959018:21961167,21959020:21961269,21959022:21961051,21959024:21961450,21959027:21960577,21959029:21960966,21959032:21960456,21959034:21960612,21959037:21960415,21959039:21960663,21959042:21959964,21959044:21959801,21959047:21959692,21959049:21959881,21960915:21961086,21962450:21962523,21989938:21994917,21989939:21994685,21989940:21994798,21989941:21995094,21989942:21994371,21989943:21994540,21989944:21993517,21989945:21994112,21989946:21993737,21989947:21993411,21989950:21993599,21989951:21992995,21989954:21993134,21989955:21992843,21989958:21999582,21989959:21993564,21989962:21992804,21989963:21992211,21989966:21992064,21989967:21991951,21989969:21990195,21989971:21992158,21992871:21993235,21995873:21996127,22000331:22000443,22000332:22005369,22002451:22002812,22004597:22004811,22005794:22005929,22007307:22007468,22009332:22009845,22012050:22012252,22014782:2201526', 'assoc_mat': '21959002:carton:4230:21962284,21959004:carton:4230:21962079,21959006:carton:4230:21962197,21959008:carton:4230:21961782,21959010:carton:4230:21961415,21959012:carton:4230:21961521,21959014:carton:4230:21961974,21959016:carton:4230:21961369,21959018:carton:4230:21961167,21959020:carton:4230:21961269,21959022:carton:4230:21961051,21959024:carton:4230:21961450,21959027:carton:4230:21960577,21959029:carton:4230:21960966,21959032:carton:4230:21960456,21959034:carton:4230:21960612,21959037:carton:4230:21960415,21959039:carton:4230:21960663,21959042:carton:4230:21959964,21959044:carton:4230:21959801,21959047:carton:4230:21959692,21959049:carton:4230:21959881,21960915:carton:4230:21961086,21962450:carton:4230:21962523,21989938:carton:4230:21994917,21989939:carton:4230:21994685,21989940:carton:4230:21994798,21989941:carton:4230:21995094,21989942:carton:4230:21994371,21989943:carton:4230:21994540,21989944:carton:4230:21993517,21989945:carton:4230:21994112,21989946:carton:4230:21993737,21989947:carton:4230:21993411,2198'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017094124681816569, 'nb_photo': 1120, 'list_port_cont': '21959691,21959798,21959868,21960413,21960576,21960603,21960656,21960964,21961045,21961154,21961255,21961407,21961453,21961516,21961775,21961975,21962067,21962194,21962281,21990194,21992065,21992110,21992212,21992806,21992844,21992997,21993140,21993225,21993400,21993505,21993559,21993594,21993739,21994096,21994360,21994536,21994686,21994784,21994922,21995085,21999589,22000441,22002820,22005368,22007462,22009837,22015262,22017872,22020154,22022980,22023616,22024841,22051807,22051925,22052146,22052256,22052497,22052675,22052754,22052845,22052898,22053087,22053176,22054598,22056697,22104888,22107357,22107584,22107623,22107655,22107679,22107732,22107755,22107812,22107860,22107906,22107936,22107977,22107984,22108189,22108216,22108260,22108290,22108513,22109638,22112643,22114173,22116197,22118908,22120727,22120951,22121937,22125207,22127391,22129808,22132134,22133071,22135206,22137903,22140455,22143305,22147028,22151336,22156098,22156396,22160183,22163024,22225397,22225640,22225738,22225807,22226409,22226661,2222673', 'assoc_port': '21959002:21962281,21959004:21962067,21959006:21962194,21959008:21961775,21959010:21961407,21959012:21961516,21959014:21961975,21959018:21961154,21959020:21961255,21959022:21961045,21959024:21961453,21959027:21960576,21959029:21960964,21959034:21960603,21959037:21960413,21959039:21960656,21959044:21959798,21959047:21959691,21959049:21959868,21989938:21994922,21989939:21994686,21989940:21994784,21989941:21995085,21989942:21994360,21989943:21994536,21989944:21993505,21989945:21994096,21989946:21993739,21989947:21993400,21989950:21993594,21989951:21992997,21989954:21993140,21989955:21992844,21989958:21999589,21989959:21993559,21989962:21992806,21989963:21992212,21989966:21992065,21989969:21990194,21989971:21992110,21992871:21993225,22000331:22000441,22000332:22005368,22002451:22002820,22007307:22007462,22009332:22009837,22014782:22015262,22017243:22017872,22019574:22020154,22022110:22022980,22023320:22023616,22024543:22024841,22051176:22053087,22051179:22053176,22051182:22052898,22051185:22052675,22051188:2205275', 'assoc_mat': '21959002:metal:4230:21962281,21959004:metal:4230:21962067,21959006:metal:4230:21962194,21959008:metal:4230:21961775,21959010:metal:4230:21961407,21959012:metal:4230:21961516,21959014:metal:4230:21961975,21959018:metal:4230:21961154,21959020:metal:4230:21961255,21959022:metal:4230:21961045,21959024:metal:4230:21961453,21959027:metal:4230:21960576,21959029:metal:4230:21960964,21959034:metal:4230:21960603,21959037:metal:4230:21960413,21959039:metal:4230:21960656,21959044:metal:4230:21959798,21959047:metal:4230:21959691,21959049:metal:4230:21959868,21989938:metal:4230:21994922,21989939:metal:4230:21994686,21989940:metal:4230:21994784,21989941:metal:4230:21995085,21989942:metal:4230:21994360,21989943:metal:4230:21994536,21989944:metal:4230:21993505,21989945:metal:4230:21994096,21989946:metal:4230:21993739,21989947:metal:4230:21993400,21989950:metal:4230:21993594,21989951:metal:4230:21992997,21989954:metal:4230:21993140,21989955:metal:4230:21992844,21989958:metal:4230:21999589,21989959:metal:4230:21993559,21989962:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.23257658784009455, 'nb_photo': 261402, 'list_port_cont': '21959698,21959806,21959879,21959965,21960412,21960469,21960570,21960606,21960668,21960979,21961056,21961092,21961169,21961263,21961382,21961417,21961456,21961513,21961769,21961968,21962083,21962198,21962275,21962530,21990193,21991957,21992061,21992136,21992206,21992811,21992845,21992990,21993139,21993240,21993415,21993506,21993562,21993593,21993730,21994110,21994364,21994546,21994683,21994796,21994919,21995090,21996124,21999590,22000445,22002815,22004816,22005363,22005930,22007459,22009842,22012258,22015266,22017874,22020162,22022985,22023628,22024849,22051443,22051823,22051929,22052153,22052258,22052495,22052682,22052752,22052853,22052914,22053097,22053162,22053559,22054595,22056692,22104902,22107366,22107514,22107587,22107616,22107657,22107693,22107724,22107766,22107813,22107859,22107893,22107942,22107976,22107996,22108051,22108194,22108230,22108253,22108301,22108509,22109635,22112656,22114186,22116199,22118920,22120724,22120958,22121929,22123464,22125218,22127393,22129821,22132143,22133068,22135218,2213791', 'assoc_port': '21959002:21962275,21959004:21962083,21959006:21962198,21959008:21961769,21959010:21961417,21959012:21961513,21959014:21961968,21959016:21961382,21959018:21961169,21959020:21961263,21959022:21961056,21959024:21961456,21959027:21960570,21959029:21960979,21959032:21960469,21959034:21960606,21959037:21960412,21959039:21960668,21959042:21959965,21959044:21959806,21959047:21959698,21959049:21959879,21960915:21961092,21962450:21962530,21989938:21994919,21989939:21994683,21989940:21994796,21989941:21995090,21989942:21994364,21989943:21994546,21989944:21993506,21989945:21994110,21989946:21993730,21989947:21993415,21989950:21993593,21989951:21992990,21989954:21993139,21989955:21992845,21989958:21999590,21989959:21993562,21989962:21992811,21989963:21992206,21989966:21992061,21989967:21991957,21989969:21990193,21989971:21992136,21992871:21993240,21995873:21996124,22000331:22000445,22000332:22005363,22002451:22002815,22004597:22004816,22005794:22005930,22007307:22007459,22009332:22009842,22012050:22012258,22014782:2201526', 'assoc_mat': '21959002:papier:4230:21962275,21959004:papier:4230:21962083,21959006:papier:4230:21962198,21959008:papier:4230:21961769,21959010:papier:4230:21961417,21959012:papier:4230:21961513,21959014:papier:4230:21961968,21959016:papier:4230:21961382,21959018:papier:4230:21961169,21959020:papier:4230:21961263,21959022:papier:4230:21961056,21959024:papier:4230:21961456,21959027:papier:4230:21960570,21959029:papier:4230:21960979,21959032:papier:4230:21960469,21959034:papier:4230:21960606,21959037:papier:4230:21960412,21959039:papier:4230:21960668,21959042:papier:4230:21959965,21959044:papier:4230:21959806,21959047:papier:4230:21959698,21959049:papier:4230:21959879,21960915:papier:4230:21961092,21962450:papier:4230:21962530,21989938:papier:4230:21994919,21989939:papier:4230:21994683,21989940:papier:4230:21994796,21989941:papier:4230:21995090,21989942:papier:4230:21994364,21989943:papier:4230:21994546,21989944:papier:4230:21993506,21989945:papier:4230:21994110,21989946:papier:4230:21993730,21989947:papier:4230:21993415,2198'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005402041913163402, 'nb_photo': 2168, 'list_port_cont': '21959706,21959805,21959966,21960421,21960466,21960608,21960654,21960970,21961048,21961161,21961265,21961371,21961420,21961445,21961525,21961776,21962081,21962195,21962288,21962524,21990187,21991958,21992063,21992142,21992207,21992813,21992846,21992988,21993130,21993230,21993404,21993510,21993561,21993598,21993734,21994109,21994374,21994543,21994681,21994792,21994915,21995095,21996128,21999585,22000436,22002821,22004814,22005360,22005931,22007467,22009835,22012262,22015269,22017864,22020161,22022982,22023620,22024847,22051435,22051818,22051933,22052155,22052260,22052491,22052685,22052761,22052856,22052916,22053085,22053170,22053571,22054594,22056690,22104891,22107365,22107511,22107572,22107614,22107656,22107686,22107723,22107768,22107817,22107907,22107938,22107995,22108052,22108188,22108225,22108264,22108297,22108516,22109633,22112651,22114188,22116194,22118921,22120725,22120949,22121931,22123452,22125215,22127381,22129824,22132142,22133069,22135216,22137911,22140460,22143297,22147033,22150477,22151345,2215610', 'assoc_port': '21959002:21962288,21959004:21962081,21959006:21962195,21959008:21961776,21959010:21961420,21959012:21961525,21959016:21961371,21959018:21961161,21959020:21961265,21959022:21961048,21959024:21961445,21959029:21960970,21959032:21960466,21959034:21960608,21959037:21960421,21959039:21960654,21959042:21959966,21959044:21959805,21959047:21959706,21962450:21962524,21989938:21994915,21989939:21994681,21989940:21994792,21989941:21995095,21989942:21994374,21989943:21994543,21989944:21993510,21989945:21994109,21989946:21993734,21989947:21993404,21989950:21993598,21989951:21992988,21989954:21993130,21989955:21992846,21989958:21999585,21989959:21993561,21989962:21992813,21989963:21992207,21989966:21992063,21989967:21991958,21989969:21990187,21989971:21992142,21992871:21993230,21995873:21996128,22000331:22000436,22000332:22005360,22002451:22002821,22004597:22004814,22005794:22005931,22007307:22007467,22009332:22009835,22012050:22012262,22014782:22015269,22017243:22017864,22019574:22020161,22022110:22022982,22023320:2202362', 'assoc_mat': '21959002:pehd:4230:21962288,21959004:pehd:4230:21962081,21959006:pehd:4230:21962195,21959008:pehd:4230:21961776,21959010:pehd:4230:21961420,21959012:pehd:4230:21961525,21959016:pehd:4230:21961371,21959018:pehd:4230:21961161,21959020:pehd:4230:21961265,21959022:pehd:4230:21961048,21959024:pehd:4230:21961445,21959029:pehd:4230:21960970,21959032:pehd:4230:21960466,21959034:pehd:4230:21960608,21959037:pehd:4230:21960421,21959039:pehd:4230:21960654,21959042:pehd:4230:21959966,21959044:pehd:4230:21959805,21959047:pehd:4230:21959706,21962450:pehd:4230:21962524,21989938:pehd:4230:21994915,21989939:pehd:4230:21994681,21989940:pehd:4230:21994792,21989941:pehd:4230:21995095,21989942:pehd:4230:21994374,21989943:pehd:4230:21994543,21989944:pehd:4230:21993510,21989945:pehd:4230:21994109,21989946:pehd:4230:21993734,21989947:pehd:4230:21993404,21989950:pehd:4230:21993598,21989951:pehd:4230:21992988,21989954:pehd:4230:21993130,21989955:pehd:4230:21992846,21989958:pehd:4230:21999585,21989959:pehd:4230:21993561,21989962:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015857065877296298, 'nb_photo': 13206, 'list_port_cont': '21959704,21959797,21959882,21959961,21960419,21960470,21960566,21960611,21960664,21960971,21961049,21961089,21961160,21961267,21961383,21961419,21961451,21961512,21961777,21961980,21962078,21962191,21962289,21962536,21990191,21991953,21992068,21992156,21992213,21992812,21992847,21992991,21993135,21993238,21993410,21993516,21993563,21993602,21993733,21994107,21994370,21994535,21994691,21994801,21994921,21995087,21996129,21999581,22000448,22002816,22004806,22005370,22005936,22007464,22009846,22012263,22015272,22017867,22020165,22022983,22023622,22024846,22051442,22051820,22051935,22052157,22052252,22052488,22052691,22052756,22052852,22052909,22053091,22053174,22053572,22054600,22056699,22104900,22107362,22107510,22107578,22107615,22107647,22107690,22107730,22107764,22107811,22107868,22107896,22107934,22107973,22107985,22108047,22108192,22108228,22108263,22108302,22108508,22109636,22112649,22114178,22116193,22118925,22120712,22120956,22121925,22123466,22125212,22127387,22129820,22132141,22133070,22135217,2213790', 'assoc_port': '21959002:21962289,21959004:21962078,21959006:21962191,21959008:21961777,21959010:21961419,21959012:21961512,21959014:21961980,21959016:21961383,21959018:21961160,21959020:21961267,21959022:21961049,21959024:21961451,21959027:21960566,21959029:21960971,21959032:21960470,21959034:21960611,21959037:21960419,21959039:21960664,21959042:21959961,21959044:21959797,21959047:21959704,21959049:21959882,21960915:21961089,21962450:21962536,21989938:21994921,21989939:21994691,21989940:21994801,21989941:21995087,21989942:21994370,21989943:21994535,21989944:21993516,21989945:21994107,21989946:21993733,21989947:21993410,21989950:21993602,21989951:21992991,21989954:21993135,21989955:21992847,21989958:21999581,21989959:21993563,21989962:21992812,21989963:21992213,21989966:21992068,21989967:21991953,21989969:21990191,21989971:21992156,21992871:21993238,21995873:21996129,22000331:22000448,22000332:22005370,22002451:22002816,22004597:22004806,22005794:22005936,22007307:22007464,22009332:22009846,22012050:22012263,22014782:2201527', 'assoc_mat': '21959002:pet_clair:4230:21962289,21959004:pet_clair:4230:21962078,21959006:pet_clair:4230:21962191,21959008:pet_clair:4230:21961777,21959010:pet_clair:4230:21961419,21959012:pet_clair:4230:21961512,21959014:pet_clair:4230:21961980,21959016:pet_clair:4230:21961383,21959018:pet_clair:4230:21961160,21959020:pet_clair:4230:21961267,21959022:pet_clair:4230:21961049,21959024:pet_clair:4230:21961451,21959027:pet_clair:4230:21960566,21959029:pet_clair:4230:21960971,21959032:pet_clair:4230:21960470,21959034:pet_clair:4230:21960611,21959037:pet_clair:4230:21960419,21959039:pet_clair:4230:21960664,21959042:pet_clair:4230:21959961,21959044:pet_clair:4230:21959797,21959047:pet_clair:4230:21959704,21959049:pet_clair:4230:21959882,21960915:pet_clair:4230:21961089,21962450:pet_clair:4230:21962536,21989938:pet_clair:4230:21994921,21989939:pet_clair:4230:21994691,21989940:pet_clair:4230:21994801,21989941:pet_clair:4230:21995087,21989942:pet_clair:4230:21994370,21989943:pet_clair:4230:21994535,21989944:pet_clair:4230:21993516,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0035071705812720773, 'nb_photo': 820, 'list_port_cont': '21959700,21959809,21959878,21959959,21960409,21960465,21960600,21960666,21960972,21961047,21961270,21961380,21961412,21961452,21961976,21962071,21962187,21962285,21990188,21991955,21992059,21992154,21992201,21992805,21992850,21992996,21993131,21993233,21993412,21993558,21993597,21993736,21994105,21994362,21994545,21994916,21995091,21999587,22002822,22005366,22005935,22007466,22009847,22017865,22020160,22022984,22023626,22024851,22051436,22051822,22051921,22052161,22052255,22052496,22052678,22052859,22052908,22053171,22054602,22056696,22104896,22107508,22107577,22107654,22107694,22107731,22107767,22107818,22107943,22107979,22107998,22108043,22108191,22108226,22108266,22108298,22108511,22109640,22112652,22114183,22118922,22120722,22120954,22121933,22125219,22127388,22129822,22132136,22133067,22135215,22137912,22140450,22143294,22147041,22150470,22151339,22156107,22156395,22160192,22225405,22225439,22225644,22225737,22225805,22226660,22226735,22226862,22226942,22227049,22227122,22227191,22227303,22227376,2222741', 'assoc_port': '21959002:21962285,21959004:21962071,21959006:21962187,21959010:21961412,21959014:21961976,21959016:21961380,21959020:21961270,21959022:21961047,21959024:21961452,21959029:21960972,21959032:21960465,21959034:21960600,21959037:21960409,21959039:21960666,21959042:21959959,21959044:21959809,21959047:21959700,21959049:21959878,21989938:21994916,21989941:21995091,21989942:21994362,21989943:21994545,21989945:21994105,21989946:21993736,21989947:21993412,21989950:21993597,21989951:21992996,21989954:21993131,21989955:21992850,21989958:21999587,21989959:21993558,21989962:21992805,21989963:21992201,21989966:21992059,21989967:21991955,21989969:21990188,21989971:21992154,21992871:21993233,22000332:22005366,22002451:22002822,22005794:22005935,22007307:22007466,22009332:22009847,22017243:22017865,22019574:22020160,22022110:22022984,22023320:22023626,22024543:22024851,22051179:22053171,22051182:22052908,22051185:22052678,22051190:22052859,22051194:22052161,22051197:22052496,22051199:22052255,22051202:22051921,22051205:2205182', 'assoc_mat': '21959002:pet_fonce:4230:21962285,21959004:pet_fonce:4230:21962071,21959006:pet_fonce:4230:21962187,21959010:pet_fonce:4230:21961412,21959014:pet_fonce:4230:21961976,21959016:pet_fonce:4230:21961380,21959020:pet_fonce:4230:21961270,21959022:pet_fonce:4230:21961047,21959024:pet_fonce:4230:21961452,21959029:pet_fonce:4230:21960972,21959032:pet_fonce:4230:21960465,21959034:pet_fonce:4230:21960600,21959037:pet_fonce:4230:21960409,21959039:pet_fonce:4230:21960666,21959042:pet_fonce:4230:21959959,21959044:pet_fonce:4230:21959809,21959047:pet_fonce:4230:21959700,21959049:pet_fonce:4230:21959878,21989938:pet_fonce:4230:21994916,21989941:pet_fonce:4230:21995091,21989942:pet_fonce:4230:21994362,21989943:pet_fonce:4230:21994545,21989945:pet_fonce:4230:21994105,21989946:pet_fonce:4230:21993736,21989947:pet_fonce:4230:21993412,21989950:pet_fonce:4230:21993597,21989951:pet_fonce:4230:21992996,21989954:pet_fonce:4230:21993131,21989955:pet_fonce:4230:21992850,21989958:pet_fonce:4230:21999587,21989959:pet_fonce:4230:21993558,2'}), 'main_stat': {'nb_photos': 953}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-04', 0.6830654218474096),)]} filepath : /data_2/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_04_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '2.02%', 12772], 'carton': ['carton', '6.45%', 58805], 'metal': ['metal', '0.17%', 1120], 'papier': ['papier', '23.26%', 261402], 'pehd': ['pehd', '0.54%', 2168], 'pet_clair': ['pet_clair', '1.59%', 13206], 'pet_fonce': ['pet_fonce', '0.35%', 820]}} 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_04_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/SCCU_cam6 2.81user 3.13system 0:07.52elapsed 79%CPU (0avgtext+0avgdata 192880maxresident)k 170224inputs+272outputs (744major+67531minor)pagefaults 0swaps