python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_2/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-02 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (5, 28) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (5, 28) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 02 mtr_id : dashboard_places : SCCU_cam7 date : 2025-02 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam7' and date like '%2025-02%') and created_at like '%2025-02%'))); nb_day : (5, 28) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 204 and month(ded.date) = 02 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______incineration' and ded.dashboard_place_id = 204 and month(ded.date) = 02 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 204 and mp.name like '%022025%' and cps.thcl = 1533 GROUP BY sbstr ; Erreur dans le nom de portfolio du batch invalid literal for int() with base 10: 'SCCU' after number_of_batch date_start : 2025-02-01 : dt_date_just_month_year : 2025-02-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-02-01" AND ded.date <= "2025-02-28" 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 (1579378,1582576,1585758,1589017,1592058,1595265,1597080,1597815,1600964,1604004,1606868,1609738,1612863,1614266,1614515,1616886,1619381,1621050,1622569,1625882,1627601,1627892,1629321,1631850,1634491,1636897,1639903) 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.015488056479864435, 'nb_photo': 12942, 'list_port_cont': '20128441,20194098,20194864,20232059,20232779,20241302,20243257,20247549,20249735,20250044,20251580,20261965,20264135,20270271,20276054,20277369,20277433,20278526,20281585,20283723,20289062,20290387,20292733,20295584,20296234,20297373,20297411,20303664,20306239,20310858,20313810,20324445,20324820,20325053,20325930,20326311,20326843,20326965,20327164,20327810,20328483,20328713,20329357,20329624,20329908,20330390,20330560,20331042,20331229,20331613,20350894,20352760,20355662,20355702,20355841,20355928,20356060,20356130,20356324,20356358,20356594,20356695,20356926,20357508,20357751,20358198,20358409,20358442,20358607,20359061,20359473,20361372,20361869,20362359,20363650,20365896,20366384,20366420,20366655,20366762,20366983,20367170,20367432,20367584,20367632,20367841,20367970,20368213,20368421,20368465,20369213,20369967,20370462,20370550,20370892,20374161,20374230,20374276,20376715,20378564,20381283,20381540,20381647,20381693,20381722,20381961,20382078,20382153,20382268,20382379,20382539,20382586,20382722,2038278', 'assoc_port': '20127880:20128441,20193046:20409538,20193048:20324445,20193050:20324820,20193052:20325053,20193054:20410221,20193056:20325930,20193058:20326311,20193060:20326843,20193062:20327164,20193064:20411647,20193066:20327810,20193068:20328483,20193070:20328713,20193072:20329357,20193074:20329624,20193076:20329908,20193078:20330390,20193080:20330560,20193082:20331042,20193084:20331229,20193086:20331613,20193774:20194098,20194485:20194864,20228786:20355662,20228799:20355702,20228802:20355841,20228805:20355928,20228808:20356060,20228811:20356130,20228814:20356324,20228817:20356594,20228820:20356695,20228823:20356926,20228826:20427173,20228829:20357508,20228832:20427622,20228835:20357751,20228838:20428463,20228841:20426887,20228844:20429386,20228847:20358198,20228849:20358409,20228853:20358442,20228856:20358607,20231321:20232059,20232599:20232779,20236364:20359061,20238848:20359473,20240728:20241302,20242596:20243257,20244663:20250044,20246689:20247549,20248228:20249735,20250670:20251580,20252702:20362359,20255470:2036137', 'assoc_mat': '20127880:autre:4230:20128441,20193046:autre:4230:20409538,20193048:autre:4230:20324445,20193050:autre:4230:20324820,20193052:autre:4230:20325053,20193054:autre:4230:20410221,20193056:autre:4230:20325930,20193058:autre:4230:20326311,20193060:autre:4230:20326843,20193062:autre:4230:20327164,20193064:autre:4230:20411647,20193066:autre:4230:20327810,20193068:autre:4230:20328483,20193070:autre:4230:20328713,20193072:autre:4230:20329357,20193074:autre:4230:20329624,20193076:autre:4230:20329908,20193078:autre:4230:20330390,20193080:autre:4230:20330560,20193082:autre:4230:20331042,20193084:autre:4230:20331229,20193086:autre:4230:20331613,20193774:autre:4230:20194098,20194485:autre:4230:20194864,20228786:autre:4230:20355662,20228799:autre:4230:20355702,20228802:autre:4230:20355841,20228805:autre:4230:20355928,20228808:autre:4230:20356060,20228811:autre:4230:20356130,20228814:autre:4230:20356324,20228817:autre:4230:20356594,20228820:autre:4230:20356695,20228823:autre:4230:20356926,20228826:autre:4230:20427173,20228829:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05669243683901649, 'nb_photo': 69582, 'list_port_cont': '20128437,20194103,20194881,20232067,20232794,20241293,20243269,20247559,20249744,20250042,20251593,20261973,20264146,20270272,20276047,20277360,20277435,20278537,20281592,20283733,20289063,20290390,20292729,20295588,20296238,20297385,20297422,20303674,20306243,20310848,20313809,20324443,20324825,20325054,20325923,20326304,20326847,20326974,20327174,20327805,20328487,20328722,20329354,20329617,20329913,20330394,20330562,20331044,20331243,20331608,20350903,20352773,20355667,20355699,20355840,20355934,20356064,20356140,20356323,20356368,20356593,20356699,20356918,20357512,20357746,20358194,20358407,20358449,20358615,20359063,20359469,20361378,20361873,20362363,20363657,20365902,20366382,20366419,20366664,20366773,20366995,20367166,20367439,20367596,20367636,20367830,20367973,20368217,20368425,20368481,20369210,20369971,20370459,20370545,20370893,20374152,20374229,20374280,20376713,20378569,20381281,20381548,20381653,20381694,20381729,20381973,20382076,20382149,20382270,20382381,20382545,20382577,20382729,2038280', 'assoc_port': '20127880:20128437,20193046:20409544,20193048:20324443,20193050:20324825,20193052:20325054,20193054:20410224,20193056:20325923,20193058:20326304,20193060:20326847,20193062:20327174,20193064:20411640,20193066:20327805,20193068:20328487,20193070:20328722,20193072:20329354,20193074:20329617,20193076:20329913,20193078:20330394,20193080:20330562,20193082:20331044,20193084:20331243,20193086:20331608,20193774:20194103,20194485:20194881,20228786:20355667,20228799:20355699,20228802:20355840,20228805:20355934,20228808:20356064,20228811:20356140,20228814:20356323,20228817:20356593,20228820:20356699,20228823:20356918,20228826:20427178,20228829:20357512,20228832:20427624,20228835:20357746,20228838:20428465,20228841:20426880,20228844:20429390,20228847:20358194,20228849:20358407,20228853:20358449,20228856:20358615,20231321:20232067,20232599:20232794,20236364:20359063,20238848:20359469,20240728:20241293,20242596:20243269,20244663:20250042,20246689:20247559,20248228:20249744,20250670:20251593,20252702:20362363,20255470:2036137', 'assoc_mat': '20127880:carton:4230:20128437,20193046:carton:4230:20409544,20193048:carton:4230:20324443,20193050:carton:4230:20324825,20193052:carton:4230:20325054,20193054:carton:4230:20410224,20193056:carton:4230:20325923,20193058:carton:4230:20326304,20193060:carton:4230:20326847,20193062:carton:4230:20327174,20193064:carton:4230:20411640,20193066:carton:4230:20327805,20193068:carton:4230:20328487,20193070:carton:4230:20328722,20193072:carton:4230:20329354,20193074:carton:4230:20329617,20193076:carton:4230:20329913,20193078:carton:4230:20330394,20193080:carton:4230:20330562,20193082:carton:4230:20331044,20193084:carton:4230:20331243,20193086:carton:4230:20331608,20193774:carton:4230:20194103,20194485:carton:4230:20194881,20228786:carton:4230:20355667,20228799:carton:4230:20355699,20228802:carton:4230:20355840,20228805:carton:4230:20355934,20228808:carton:4230:20356064,20228811:carton:4230:20356140,20228814:carton:4230:20356323,20228817:carton:4230:20356593,20228820:carton:4230:20356699,20228823:carton:4230:20356918,2022'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001432885805165281, 'nb_photo': 1383, 'list_port_cont': '20128444,20194102,20194869,20232068,20232789,20241297,20243267,20247556,20249739,20250045,20251582,20261968,20264143,20270276,20276056,20277354,20277427,20278539,20281584,20283720,20289058,20290384,20292721,20295578,20296232,20297378,20297409,20303673,20306233,20310857,20313806,20324440,20324823,20325044,20326300,20326964,20327176,20327808,20328492,20328727,20329351,20329630,20329912,20330379,20330548,20331056,20331225,20331614,20350911,20352764,20355655,20355705,20355837,20355933,20356055,20356128,20356330,20356354,20356579,20356708,20356929,20357520,20357752,20358193,20358404,20358440,20358608,20359053,20359470,20361374,20361860,20362367,20363647,20366380,20366409,20366654,20366758,20366986,20367162,20367446,20367592,20367630,20367837,20367969,20368219,20368416,20368468,20369214,20369970,20370465,20370879,20374151,20374242,20374273,20376706,20378554,20381648,20381682,20381735,20381968,20382145,20382259,20382544,20382574,20382723,20382801,20382839,20382920,20383092,20383140,20383468,20383539,20384004,2038403', 'assoc_port': '20127880:20128444,20193046:20409520,20193048:20324440,20193050:20324823,20193052:20325044,20193058:20326300,20193062:20327176,20193064:20411633,20193066:20327808,20193068:20328492,20193070:20328727,20193072:20329351,20193074:20329630,20193076:20329912,20193078:20330379,20193080:20330548,20193082:20331056,20193084:20331225,20193086:20331614,20193774:20194102,20194485:20194869,20228786:20355655,20228799:20355705,20228802:20355837,20228805:20355933,20228808:20356055,20228811:20356128,20228814:20356330,20228817:20356579,20228820:20356708,20228823:20356929,20228826:20427182,20228829:20357520,20228832:20427630,20228835:20357752,20228838:20428469,20228841:20426872,20228847:20358193,20228849:20358404,20228853:20358440,20228856:20358608,20231321:20232068,20232599:20232789,20236364:20359053,20238848:20359470,20240728:20241297,20242596:20243267,20244663:20250045,20246689:20247556,20248228:20249739,20250670:20251582,20252702:20362367,20255470:20361374,20257027:20361860,20260953:20261968,20263377:20264143,20265877:2036364', 'assoc_mat': '20127880:metal:4230:20128444,20193046:metal:4230:20409520,20193048:metal:4230:20324440,20193050:metal:4230:20324823,20193052:metal:4230:20325044,20193058:metal:4230:20326300,20193062:metal:4230:20327176,20193064:metal:4230:20411633,20193066:metal:4230:20327808,20193068:metal:4230:20328492,20193070:metal:4230:20328727,20193072:metal:4230:20329351,20193074:metal:4230:20329630,20193076:metal:4230:20329912,20193078:metal:4230:20330379,20193080:metal:4230:20330548,20193082:metal:4230:20331056,20193084:metal:4230:20331225,20193086:metal:4230:20331614,20193774:metal:4230:20194102,20194485:metal:4230:20194869,20228786:metal:4230:20355655,20228799:metal:4230:20355705,20228802:metal:4230:20355837,20228805:metal:4230:20355933,20228808:metal:4230:20356055,20228811:metal:4230:20356128,20228814:metal:4230:20356330,20228817:metal:4230:20356579,20228820:metal:4230:20356708,20228823:metal:4230:20356929,20228826:metal:4230:20427182,20228829:metal:4230:20357520,20228832:metal:4230:20427630,20228835:metal:4230:20357752,20228838:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19111389778375176, 'nb_photo': 261552, 'list_port_cont': '20128438,20194105,20194880,20232066,20232790,20241300,20243255,20247551,20249738,20250041,20251586,20261977,20264145,20270263,20276051,20277368,20277420,20278534,20281582,20283727,20289072,20290386,20292730,20295581,20296237,20297374,20297418,20303658,20306242,20310849,20313807,20324457,20324818,20325055,20325928,20326296,20326851,20326969,20327168,20327813,20328490,20328717,20329347,20329625,20329909,20330393,20330561,20331048,20331242,20331600,20350906,20352770,20355669,20355707,20355827,20355926,20356068,20356139,20356328,20356361,20356583,20356693,20356922,20357511,20357753,20358187,20358416,20358457,20358610,20359057,20359476,20361377,20361865,20362365,20363652,20365897,20366376,20366417,20366665,20366772,20366990,20367164,20367440,20367597,20367631,20367838,20367971,20368214,20368427,20368475,20369220,20369975,20370467,20370546,20370884,20374164,20374241,20374284,20376718,20378571,20381293,20381544,20381661,20381683,20381728,20381976,20382079,20382155,20382266,20382377,20382550,20382575,20382724,2038280', 'assoc_port': '20127880:20128438,20193046:20409541,20193048:20324457,20193050:20324818,20193052:20325055,20193054:20410220,20193056:20325928,20193058:20326296,20193060:20326851,20193062:20327168,20193064:20411638,20193066:20327813,20193068:20328490,20193070:20328717,20193072:20329347,20193074:20329625,20193076:20329909,20193078:20330393,20193080:20330561,20193082:20331048,20193084:20331242,20193086:20331600,20193774:20194105,20194485:20194880,20228786:20355669,20228799:20355707,20228802:20355827,20228805:20355926,20228808:20356068,20228811:20356139,20228814:20356328,20228817:20356583,20228820:20356693,20228823:20356922,20228826:20427177,20228829:20357511,20228832:20427625,20228835:20357753,20228838:20428467,20228841:20426878,20228844:20429388,20228847:20358187,20228849:20358416,20228853:20358457,20228856:20358610,20231321:20232066,20232599:20232790,20236364:20359057,20238848:20359476,20240728:20241300,20242596:20243255,20244663:20250041,20246689:20247551,20248228:20249738,20250670:20251586,20252702:20362365,20255470:2036137', 'assoc_mat': '20127880:papier:4230:20128438,20193046:papier:4230:20409541,20193048:papier:4230:20324457,20193050:papier:4230:20324818,20193052:papier:4230:20325055,20193054:papier:4230:20410220,20193056:papier:4230:20325928,20193058:papier:4230:20326296,20193060:papier:4230:20326851,20193062:papier:4230:20327168,20193064:papier:4230:20411638,20193066:papier:4230:20327813,20193068:papier:4230:20328490,20193070:papier:4230:20328717,20193072:papier:4230:20329347,20193074:papier:4230:20329625,20193076:papier:4230:20329909,20193078:papier:4230:20330393,20193080:papier:4230:20330561,20193082:papier:4230:20331048,20193084:papier:4230:20331242,20193086:papier:4230:20331600,20193774:papier:4230:20194105,20194485:papier:4230:20194880,20228786:papier:4230:20355669,20228799:papier:4230:20355707,20228802:papier:4230:20355827,20228805:papier:4230:20355926,20228808:papier:4230:20356068,20228811:papier:4230:20356139,20228814:papier:4230:20356328,20228817:papier:4230:20356583,20228820:papier:4230:20356693,20228823:papier:4230:20356922,2022'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0036544564619346727, 'nb_photo': 1539, 'list_port_cont': '20128435,20232058,20232793,20241291,20243266,20247554,20249742,20250033,20251596,20261976,20264149,20270274,20276060,20277362,20277429,20278542,20289059,20290393,20292732,20295586,20296231,20297384,20297415,20303667,20306245,20310859,20313813,20324449,20324821,20325041,20325924,20326308,20326841,20326968,20327177,20327809,20328479,20328719,20329352,20329627,20329904,20330389,20330555,20331052,20331238,20331610,20352768,20355660,20355839,20356066,20356142,20356365,20356590,20356703,20356931,20357519,20357756,20358199,20358414,20358451,20358604,20359050,20359479,20361387,20361862,20362357,20363660,20365903,20366387,20366412,20366661,20366765,20367445,20367583,20367627,20367839,20368220,20368426,20368473,20369216,20369969,20370548,20370887,20374160,20374243,20374272,20376716,20378570,20381696,20382726,20382799,20382921,20383097,20383359,20383482,20383553,20384002,20384041,20390736,20392970,20396451,20400015,20401229,20401773,20402735,20403297,20404431,20408128,20409534,20410212,20411642,20415796,20420769,2042356', 'assoc_port': '20127880:20128435,20193046:20409534,20193048:20324449,20193050:20324821,20193052:20325041,20193054:20410212,20193056:20325924,20193058:20326308,20193060:20326841,20193062:20327177,20193064:20411642,20193066:20327809,20193068:20328479,20193070:20328719,20193072:20329352,20193074:20329627,20193076:20329904,20193078:20330389,20193080:20330555,20193082:20331052,20193084:20331238,20193086:20331610,20228786:20355660,20228802:20355839,20228808:20356066,20228811:20356142,20228817:20356590,20228820:20356703,20228823:20356931,20228826:20427183,20228829:20357519,20228832:20427628,20228835:20357756,20228838:20428473,20228841:20426885,20228844:20429391,20228847:20358199,20228849:20358414,20228853:20358451,20228856:20358604,20231321:20232058,20232599:20232793,20236364:20359050,20238848:20359479,20240728:20241291,20242596:20243266,20244663:20250033,20246689:20247554,20248228:20249742,20250670:20251596,20252702:20362357,20255470:20361387,20257027:20361862,20260953:20261976,20263377:20264149,20265877:20363660,20268249:2027027', 'assoc_mat': '20127880:pehd:4230:20128435,20193046:pehd:4230:20409534,20193048:pehd:4230:20324449,20193050:pehd:4230:20324821,20193052:pehd:4230:20325041,20193054:pehd:4230:20410212,20193056:pehd:4230:20325924,20193058:pehd:4230:20326308,20193060:pehd:4230:20326841,20193062:pehd:4230:20327177,20193064:pehd:4230:20411642,20193066:pehd:4230:20327809,20193068:pehd:4230:20328479,20193070:pehd:4230:20328719,20193072:pehd:4230:20329352,20193074:pehd:4230:20329627,20193076:pehd:4230:20329904,20193078:pehd:4230:20330389,20193080:pehd:4230:20330555,20193082:pehd:4230:20331052,20193084:pehd:4230:20331238,20193086:pehd:4230:20331610,20228786:pehd:4230:20355660,20228802:pehd:4230:20355839,20228808:pehd:4230:20356066,20228811:pehd:4230:20356142,20228817:pehd:4230:20356590,20228820:pehd:4230:20356703,20228823:pehd:4230:20356931,20228826:pehd:4230:20427183,20228829:pehd:4230:20357519,20228832:pehd:4230:20427628,20228835:pehd:4230:20357756,20228838:pehd:4230:20428473,20228841:pehd:4230:20426885,20228844:pehd:4230:20429391,20228847:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.009567241633589867, 'nb_photo': 14879, 'list_port_cont': '20128440,20194106,20194872,20232053,20232784,20241301,20243264,20247561,20249747,20250037,20251594,20261961,20264142,20270277,20276053,20277370,20277425,20278538,20281587,20283730,20289066,20290394,20292723,20295577,20296235,20297383,20297417,20303663,20306240,20310853,20313821,20324450,20324826,20325050,20325925,20326310,20326854,20326963,20327175,20327812,20328489,20328729,20329349,20329626,20329914,20330380,20330552,20331045,20331241,20331602,20350909,20352772,20355672,20355700,20355835,20355931,20356053,20356143,20356321,20356366,20356585,20356705,20356930,20357516,20357755,20358185,20358406,20358455,20358612,20359051,20359477,20361386,20361876,20362366,20363649,20365890,20366385,20366422,20366670,20366771,20366985,20367168,20367443,20367594,20367625,20367840,20367967,20368216,20368419,20368476,20369221,20369973,20370461,20370543,20370891,20374157,20374237,20374286,20376708,20378568,20381292,20381547,20381657,20381697,20381727,20381975,20382066,20382148,20382262,20382382,20382546,20382580,20382730,2038279', 'assoc_port': '20127880:20128440,20193046:20409540,20193048:20324450,20193050:20324826,20193052:20325050,20193054:20410223,20193056:20325925,20193058:20326310,20193060:20326854,20193062:20327175,20193064:20411646,20193066:20327812,20193068:20328489,20193070:20328729,20193072:20329349,20193074:20329626,20193076:20329914,20193078:20330380,20193080:20330552,20193082:20331045,20193084:20331241,20193086:20331602,20193774:20194106,20194485:20194872,20228786:20355672,20228799:20355700,20228802:20355835,20228805:20355931,20228808:20356053,20228811:20356143,20228814:20356321,20228817:20356585,20228820:20356705,20228823:20356930,20228826:20427179,20228829:20357516,20228832:20427626,20228835:20357755,20228838:20428472,20228841:20426874,20228844:20429379,20228847:20358185,20228849:20358406,20228853:20358455,20228856:20358612,20231321:20232053,20232599:20232784,20236364:20359051,20238848:20359477,20240728:20241301,20242596:20243264,20244663:20250037,20246689:20247561,20248228:20249747,20250670:20251594,20252702:20362366,20255470:2036138', 'assoc_mat': '20127880:pet_clair:4230:20128440,20193046:pet_clair:4230:20409540,20193048:pet_clair:4230:20324450,20193050:pet_clair:4230:20324826,20193052:pet_clair:4230:20325050,20193054:pet_clair:4230:20410223,20193056:pet_clair:4230:20325925,20193058:pet_clair:4230:20326310,20193060:pet_clair:4230:20326854,20193062:pet_clair:4230:20327175,20193064:pet_clair:4230:20411646,20193066:pet_clair:4230:20327812,20193068:pet_clair:4230:20328489,20193070:pet_clair:4230:20328729,20193072:pet_clair:4230:20329349,20193074:pet_clair:4230:20329626,20193076:pet_clair:4230:20329914,20193078:pet_clair:4230:20330380,20193080:pet_clair:4230:20330552,20193082:pet_clair:4230:20331045,20193084:pet_clair:4230:20331241,20193086:pet_clair:4230:20331602,20193774:pet_clair:4230:20194106,20194485:pet_clair:4230:20194872,20228786:pet_clair:4230:20355672,20228799:pet_clair:4230:20355700,20228802:pet_clair:4230:20355835,20228805:pet_clair:4230:20355931,20228808:pet_clair:4230:20356053,20228811:pet_clair:4230:20356143,20228814:pet_clair:4230:20356321,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028515111621246, 'nb_photo': 594, 'list_port_cont': '20194107,20241296,20243265,20249745,20250043,20251591,20264138,20270269,20277366,20277436,20278536,20281589,20283722,20289069,20290398,20292724,20297380,20297421,20324454,20324822,20326306,20326853,20326972,20327165,20328726,20329356,20329620,20329903,20330387,20330557,20331046,20331236,20331612,20352774,20355664,20356059,20356325,20356369,20356591,20356707,20356921,20357510,20357758,20358408,20358456,20358601,20359060,20359475,20361388,20361871,20362355,20366424,20366669,20367593,20367629,20367834,20368211,20368428,20369217,20370553,20374231,20381285,20381549,20382548,20382841,20382912,20384001,20390737,20394361,20400028,20401235,20401777,20402740,20404436,20408129,20420777,20422833,20424277,20424537,20424665,20424759,20424931,20425018,20426888,20427635,20428462,20463144,20463794,20464555,20465559,20467904,20468683,20469865,20470455,20470640,20471785,20474488,20494133,20494421,20494494,20494552,20494900,20495008,20495034,20495535,20495828,20499174,20534300,20536879,20537673,20538282,20538612,20538976,2053940', 'assoc_port': '20193048:20324454,20193050:20324822,20193058:20326306,20193060:20326853,20193062:20327165,20193070:20328726,20193072:20329356,20193074:20329620,20193076:20329903,20193078:20330387,20193080:20330557,20193082:20331046,20193084:20331236,20193086:20331612,20193774:20194107,20228786:20355664,20228808:20356059,20228814:20356325,20228817:20356591,20228820:20356707,20228823:20356921,20228829:20357510,20228832:20427635,20228835:20357758,20228838:20428462,20228841:20426888,20228849:20358408,20228853:20358456,20228856:20358601,20236364:20359060,20238848:20359475,20240728:20241296,20242596:20243265,20244663:20250043,20248228:20249745,20250670:20251591,20252702:20362355,20255470:20361388,20257027:20361871,20263377:20264138,20268249:20270269,20273933:20374231,20275772:20277366,20276892:20277436,20278378:20278536,20280539:20281589,20283351:20283722,20287698:20289069,20290104:20290398,20292433:20292724,20296450:20297421,20296972:20297380,20297618:20382912,20300685:20384001,20312871:20326972,20351397:20424277,20351402:2042453', 'assoc_mat': '20193048:pet_fonce:4230:20324454,20193050:pet_fonce:4230:20324822,20193058:pet_fonce:4230:20326306,20193060:pet_fonce:4230:20326853,20193062:pet_fonce:4230:20327165,20193070:pet_fonce:4230:20328726,20193072:pet_fonce:4230:20329356,20193074:pet_fonce:4230:20329620,20193076:pet_fonce:4230:20329903,20193078:pet_fonce:4230:20330387,20193080:pet_fonce:4230:20330557,20193082:pet_fonce:4230:20331046,20193084:pet_fonce:4230:20331236,20193086:pet_fonce:4230:20331612,20193774:pet_fonce:4230:20194107,20228786:pet_fonce:4230:20355664,20228808:pet_fonce:4230:20356059,20228814:pet_fonce:4230:20356325,20228817:pet_fonce:4230:20356591,20228820:pet_fonce:4230:20356707,20228823:pet_fonce:4230:20356921,20228829:pet_fonce:4230:20357510,20228832:pet_fonce:4230:20427635,20228835:pet_fonce:4230:20357758,20228838:pet_fonce:4230:20428462,20228841:pet_fonce:4230:20426888,20228849:pet_fonce:4230:20358408,20228853:pet_fonce:4230:20358456,20228856:pet_fonce:4230:20358601,20236364:pet_fonce:4230:20359060,20238848:pet_fonce:4230:20359475,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(1579378,1582576,1585758,1589017,1592058,1595265,1597080,1597815,1600964,1604004,1606868,1609738,1612863,1614266,1614515,1616886,1619381,1621050,1622569,1625882,1627601,1627892,1629321,1631850,1634491,1636897,1639903)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2025-02-01' and date <= '2025-02-28') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1271,),), 'unwanted_material_monthly_percentage': ((0.7489724881500968,),), 'material_repartition': (('incineration', 1271),), 'material_dict': {'incineration': 1271}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 2, 1), 0.6725372053473075, 3), (datetime.date(2025, 2, 3), 0.7471249323756989, 66), (datetime.date(2025, 2, 4), 0.7007033486168995, 62), (datetime.date(2025, 2, 5), 0.683042943995002, 61), (datetime.date(2025, 2, 6), 0.6383819350997628, 35), (datetime.date(2025, 2, 7), 0.6436606626450949, 37), (datetime.date(2025, 2, 8), 0.6551154027635547, 40), (datetime.date(2025, 2, 9), 0.808625722814196, 33), (datetime.date(2025, 2, 10), 0.7805001281376271, 54), (datetime.date(2025, 2, 11), 0.7377688007665555, 44), (datetime.date(2025, 2, 12), 0.7977346152477232, 41), (datetime.date(2025, 2, 13), 0.7223707216638832, 49), (datetime.date(2025, 2, 14), 0.7458083080285252, 40), (datetime.date(2025, 2, 15), 0.829518412091649, 33), (datetime.date(2025, 2, 16), 0.8748911960680454, 28), (datetime.date(2025, 2, 17), 0.7869336826906949, 52), (datetime.date(2025, 2, 18), 0.7704880122285273, 43), (datetime.date(2025, 2, 19), 0.7677553477005744, 46), (datetime.date(2025, 2, 20), 0.7276309273808395, 33), (datetime.date(2025, 2, 21), 0.6628752071329629, 38), (datetime.date(2025, 2, 22), 0.7564603761429957, 65), (datetime.date(2025, 2, 23), 0.8315555022978478, 66), (datetime.date(2025, 2, 24), 0.772196682077399, 65), (datetime.date(2025, 2, 25), 0.7249139879272692, 55), (datetime.date(2025, 2, 26), 0.7759401279912336, 65), (datetime.date(2025, 2, 27), 0.7345303157309089, 61), (datetime.date(2025, 2, 28), 0.739714231387429, 56)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 2, 1), 0.6725372053473075, 3), (datetime.date(2025, 2, 3), 0.7471249323756989, 66), (datetime.date(2025, 2, 4), 0.7007033486168995, 62), (datetime.date(2025, 2, 5), 0.683042943995002, 61), (datetime.date(2025, 2, 6), 0.6383819350997628, 35), (datetime.date(2025, 2, 7), 0.6436606626450949, 37), (datetime.date(2025, 2, 8), 0.6551154027635547, 40), (datetime.date(2025, 2, 9), 0.808625722814196, 33), (datetime.date(2025, 2, 10), 0.7805001281376271, 54), (datetime.date(2025, 2, 11), 0.7377688007665555, 44), (datetime.date(2025, 2, 12), 0.7977346152477232, 41), (datetime.date(2025, 2, 13), 0.7223707216638832, 49), (datetime.date(2025, 2, 14), 0.7458083080285252, 40), (datetime.date(2025, 2, 15), 0.829518412091649, 33), (datetime.date(2025, 2, 16), 0.8748911960680454, 28), (datetime.date(2025, 2, 17), 0.7869336826906949, 52), (datetime.date(2025, 2, 18), 0.7704880122285273, 43), (datetime.date(2025, 2, 19), 0.7677553477005744, 46), (datetime.date(2025, 2, 20), 0.7276309273808395, 33), (datetime.date(2025, 2, 21), 0.6628752071329629, 38), (datetime.date(2025, 2, 22), 0.7564603761429957, 65), (datetime.date(2025, 2, 23), 0.8315555022978478, 66), (datetime.date(2025, 2, 24), 0.772196682077399, 65), (datetime.date(2025, 2, 25), 0.7249139879272692, 55), (datetime.date(2025, 2, 26), 0.7759401279912336, 65), (datetime.date(2025, 2, 27), 0.7345303157309089, 61), (datetime.date(2025, 2, 28), 0.739714231387429, 56))}, 'quality_array': [['-9.365853258538428', '01022025'], ['-8.531821352166412', '03022025'], ['-8.802074702614567', '04022025'], ['-9.057553381259595', '05022025'], ['-9.033589440733198', '06022025'], ['-9.0993338300804', '07022025'], ['-9.011581284897101', '08022025'], ['-8.866424419206453', '09022025'], ['-8.670564792540109', '10022025'], ['-8.680934649290329', '11022025'], ['-8.102037743443546', '12022025'], ['-8.097230314161013', '13022025'], ['-8.461069816854422', '14022025'], ['-8.368869207878749', '15022025'], ['-8.282423391639062', '16022025'], ['-8.175418623239793', '17022025'], ['-8.073881932319818', '18022025'], ['-8.076738408115276', '19022025'], ['-8.199257898988929', '20022025'], ['-8.16508665430097', '21022025'], ['-8.35461017136855', '22022025'], ['-8.265163695508091', '23022025'], ['-7.994786671728289', '24022025'], ['-8.119656558007904', '25022025'], ['-8.311056379990271', '26022025'], ['-8.283238999246235', '27022025'], ['-8.255721730068872', '28022025']], 'number_of_batch': ((550,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015488056479864435, 'nb_photo': 12942, 'list_port_cont': '20128441,20194098,20194864,20232059,20232779,20241302,20243257,20247549,20249735,20250044,20251580,20261965,20264135,20270271,20276054,20277369,20277433,20278526,20281585,20283723,20289062,20290387,20292733,20295584,20296234,20297373,20297411,20303664,20306239,20310858,20313810,20324445,20324820,20325053,20325930,20326311,20326843,20326965,20327164,20327810,20328483,20328713,20329357,20329624,20329908,20330390,20330560,20331042,20331229,20331613,20350894,20352760,20355662,20355702,20355841,20355928,20356060,20356130,20356324,20356358,20356594,20356695,20356926,20357508,20357751,20358198,20358409,20358442,20358607,20359061,20359473,20361372,20361869,20362359,20363650,20365896,20366384,20366420,20366655,20366762,20366983,20367170,20367432,20367584,20367632,20367841,20367970,20368213,20368421,20368465,20369213,20369967,20370462,20370550,20370892,20374161,20374230,20374276,20376715,20378564,20381283,20381540,20381647,20381693,20381722,20381961,20382078,20382153,20382268,20382379,20382539,20382586,20382722,2038278', 'assoc_port': '20127880:20128441,20193046:20409538,20193048:20324445,20193050:20324820,20193052:20325053,20193054:20410221,20193056:20325930,20193058:20326311,20193060:20326843,20193062:20327164,20193064:20411647,20193066:20327810,20193068:20328483,20193070:20328713,20193072:20329357,20193074:20329624,20193076:20329908,20193078:20330390,20193080:20330560,20193082:20331042,20193084:20331229,20193086:20331613,20193774:20194098,20194485:20194864,20228786:20355662,20228799:20355702,20228802:20355841,20228805:20355928,20228808:20356060,20228811:20356130,20228814:20356324,20228817:20356594,20228820:20356695,20228823:20356926,20228826:20427173,20228829:20357508,20228832:20427622,20228835:20357751,20228838:20428463,20228841:20426887,20228844:20429386,20228847:20358198,20228849:20358409,20228853:20358442,20228856:20358607,20231321:20232059,20232599:20232779,20236364:20359061,20238848:20359473,20240728:20241302,20242596:20243257,20244663:20250044,20246689:20247549,20248228:20249735,20250670:20251580,20252702:20362359,20255470:2036137', 'assoc_mat': '20127880:autre:4230:20128441,20193046:autre:4230:20409538,20193048:autre:4230:20324445,20193050:autre:4230:20324820,20193052:autre:4230:20325053,20193054:autre:4230:20410221,20193056:autre:4230:20325930,20193058:autre:4230:20326311,20193060:autre:4230:20326843,20193062:autre:4230:20327164,20193064:autre:4230:20411647,20193066:autre:4230:20327810,20193068:autre:4230:20328483,20193070:autre:4230:20328713,20193072:autre:4230:20329357,20193074:autre:4230:20329624,20193076:autre:4230:20329908,20193078:autre:4230:20330390,20193080:autre:4230:20330560,20193082:autre:4230:20331042,20193084:autre:4230:20331229,20193086:autre:4230:20331613,20193774:autre:4230:20194098,20194485:autre:4230:20194864,20228786:autre:4230:20355662,20228799:autre:4230:20355702,20228802:autre:4230:20355841,20228805:autre:4230:20355928,20228808:autre:4230:20356060,20228811:autre:4230:20356130,20228814:autre:4230:20356324,20228817:autre:4230:20356594,20228820:autre:4230:20356695,20228823:autre:4230:20356926,20228826:autre:4230:20427173,20228829:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05669243683901649, 'nb_photo': 69582, 'list_port_cont': '20128437,20194103,20194881,20232067,20232794,20241293,20243269,20247559,20249744,20250042,20251593,20261973,20264146,20270272,20276047,20277360,20277435,20278537,20281592,20283733,20289063,20290390,20292729,20295588,20296238,20297385,20297422,20303674,20306243,20310848,20313809,20324443,20324825,20325054,20325923,20326304,20326847,20326974,20327174,20327805,20328487,20328722,20329354,20329617,20329913,20330394,20330562,20331044,20331243,20331608,20350903,20352773,20355667,20355699,20355840,20355934,20356064,20356140,20356323,20356368,20356593,20356699,20356918,20357512,20357746,20358194,20358407,20358449,20358615,20359063,20359469,20361378,20361873,20362363,20363657,20365902,20366382,20366419,20366664,20366773,20366995,20367166,20367439,20367596,20367636,20367830,20367973,20368217,20368425,20368481,20369210,20369971,20370459,20370545,20370893,20374152,20374229,20374280,20376713,20378569,20381281,20381548,20381653,20381694,20381729,20381973,20382076,20382149,20382270,20382381,20382545,20382577,20382729,2038280', 'assoc_port': '20127880:20128437,20193046:20409544,20193048:20324443,20193050:20324825,20193052:20325054,20193054:20410224,20193056:20325923,20193058:20326304,20193060:20326847,20193062:20327174,20193064:20411640,20193066:20327805,20193068:20328487,20193070:20328722,20193072:20329354,20193074:20329617,20193076:20329913,20193078:20330394,20193080:20330562,20193082:20331044,20193084:20331243,20193086:20331608,20193774:20194103,20194485:20194881,20228786:20355667,20228799:20355699,20228802:20355840,20228805:20355934,20228808:20356064,20228811:20356140,20228814:20356323,20228817:20356593,20228820:20356699,20228823:20356918,20228826:20427178,20228829:20357512,20228832:20427624,20228835:20357746,20228838:20428465,20228841:20426880,20228844:20429390,20228847:20358194,20228849:20358407,20228853:20358449,20228856:20358615,20231321:20232067,20232599:20232794,20236364:20359063,20238848:20359469,20240728:20241293,20242596:20243269,20244663:20250042,20246689:20247559,20248228:20249744,20250670:20251593,20252702:20362363,20255470:2036137', 'assoc_mat': '20127880:carton:4230:20128437,20193046:carton:4230:20409544,20193048:carton:4230:20324443,20193050:carton:4230:20324825,20193052:carton:4230:20325054,20193054:carton:4230:20410224,20193056:carton:4230:20325923,20193058:carton:4230:20326304,20193060:carton:4230:20326847,20193062:carton:4230:20327174,20193064:carton:4230:20411640,20193066:carton:4230:20327805,20193068:carton:4230:20328487,20193070:carton:4230:20328722,20193072:carton:4230:20329354,20193074:carton:4230:20329617,20193076:carton:4230:20329913,20193078:carton:4230:20330394,20193080:carton:4230:20330562,20193082:carton:4230:20331044,20193084:carton:4230:20331243,20193086:carton:4230:20331608,20193774:carton:4230:20194103,20194485:carton:4230:20194881,20228786:carton:4230:20355667,20228799:carton:4230:20355699,20228802:carton:4230:20355840,20228805:carton:4230:20355934,20228808:carton:4230:20356064,20228811:carton:4230:20356140,20228814:carton:4230:20356323,20228817:carton:4230:20356593,20228820:carton:4230:20356699,20228823:carton:4230:20356918,2022'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001432885805165281, 'nb_photo': 1383, 'list_port_cont': '20128444,20194102,20194869,20232068,20232789,20241297,20243267,20247556,20249739,20250045,20251582,20261968,20264143,20270276,20276056,20277354,20277427,20278539,20281584,20283720,20289058,20290384,20292721,20295578,20296232,20297378,20297409,20303673,20306233,20310857,20313806,20324440,20324823,20325044,20326300,20326964,20327176,20327808,20328492,20328727,20329351,20329630,20329912,20330379,20330548,20331056,20331225,20331614,20350911,20352764,20355655,20355705,20355837,20355933,20356055,20356128,20356330,20356354,20356579,20356708,20356929,20357520,20357752,20358193,20358404,20358440,20358608,20359053,20359470,20361374,20361860,20362367,20363647,20366380,20366409,20366654,20366758,20366986,20367162,20367446,20367592,20367630,20367837,20367969,20368219,20368416,20368468,20369214,20369970,20370465,20370879,20374151,20374242,20374273,20376706,20378554,20381648,20381682,20381735,20381968,20382145,20382259,20382544,20382574,20382723,20382801,20382839,20382920,20383092,20383140,20383468,20383539,20384004,2038403', 'assoc_port': '20127880:20128444,20193046:20409520,20193048:20324440,20193050:20324823,20193052:20325044,20193058:20326300,20193062:20327176,20193064:20411633,20193066:20327808,20193068:20328492,20193070:20328727,20193072:20329351,20193074:20329630,20193076:20329912,20193078:20330379,20193080:20330548,20193082:20331056,20193084:20331225,20193086:20331614,20193774:20194102,20194485:20194869,20228786:20355655,20228799:20355705,20228802:20355837,20228805:20355933,20228808:20356055,20228811:20356128,20228814:20356330,20228817:20356579,20228820:20356708,20228823:20356929,20228826:20427182,20228829:20357520,20228832:20427630,20228835:20357752,20228838:20428469,20228841:20426872,20228847:20358193,20228849:20358404,20228853:20358440,20228856:20358608,20231321:20232068,20232599:20232789,20236364:20359053,20238848:20359470,20240728:20241297,20242596:20243267,20244663:20250045,20246689:20247556,20248228:20249739,20250670:20251582,20252702:20362367,20255470:20361374,20257027:20361860,20260953:20261968,20263377:20264143,20265877:2036364', 'assoc_mat': '20127880:metal:4230:20128444,20193046:metal:4230:20409520,20193048:metal:4230:20324440,20193050:metal:4230:20324823,20193052:metal:4230:20325044,20193058:metal:4230:20326300,20193062:metal:4230:20327176,20193064:metal:4230:20411633,20193066:metal:4230:20327808,20193068:metal:4230:20328492,20193070:metal:4230:20328727,20193072:metal:4230:20329351,20193074:metal:4230:20329630,20193076:metal:4230:20329912,20193078:metal:4230:20330379,20193080:metal:4230:20330548,20193082:metal:4230:20331056,20193084:metal:4230:20331225,20193086:metal:4230:20331614,20193774:metal:4230:20194102,20194485:metal:4230:20194869,20228786:metal:4230:20355655,20228799:metal:4230:20355705,20228802:metal:4230:20355837,20228805:metal:4230:20355933,20228808:metal:4230:20356055,20228811:metal:4230:20356128,20228814:metal:4230:20356330,20228817:metal:4230:20356579,20228820:metal:4230:20356708,20228823:metal:4230:20356929,20228826:metal:4230:20427182,20228829:metal:4230:20357520,20228832:metal:4230:20427630,20228835:metal:4230:20357752,20228838:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19111389778375176, 'nb_photo': 261552, 'list_port_cont': '20128438,20194105,20194880,20232066,20232790,20241300,20243255,20247551,20249738,20250041,20251586,20261977,20264145,20270263,20276051,20277368,20277420,20278534,20281582,20283727,20289072,20290386,20292730,20295581,20296237,20297374,20297418,20303658,20306242,20310849,20313807,20324457,20324818,20325055,20325928,20326296,20326851,20326969,20327168,20327813,20328490,20328717,20329347,20329625,20329909,20330393,20330561,20331048,20331242,20331600,20350906,20352770,20355669,20355707,20355827,20355926,20356068,20356139,20356328,20356361,20356583,20356693,20356922,20357511,20357753,20358187,20358416,20358457,20358610,20359057,20359476,20361377,20361865,20362365,20363652,20365897,20366376,20366417,20366665,20366772,20366990,20367164,20367440,20367597,20367631,20367838,20367971,20368214,20368427,20368475,20369220,20369975,20370467,20370546,20370884,20374164,20374241,20374284,20376718,20378571,20381293,20381544,20381661,20381683,20381728,20381976,20382079,20382155,20382266,20382377,20382550,20382575,20382724,2038280', 'assoc_port': '20127880:20128438,20193046:20409541,20193048:20324457,20193050:20324818,20193052:20325055,20193054:20410220,20193056:20325928,20193058:20326296,20193060:20326851,20193062:20327168,20193064:20411638,20193066:20327813,20193068:20328490,20193070:20328717,20193072:20329347,20193074:20329625,20193076:20329909,20193078:20330393,20193080:20330561,20193082:20331048,20193084:20331242,20193086:20331600,20193774:20194105,20194485:20194880,20228786:20355669,20228799:20355707,20228802:20355827,20228805:20355926,20228808:20356068,20228811:20356139,20228814:20356328,20228817:20356583,20228820:20356693,20228823:20356922,20228826:20427177,20228829:20357511,20228832:20427625,20228835:20357753,20228838:20428467,20228841:20426878,20228844:20429388,20228847:20358187,20228849:20358416,20228853:20358457,20228856:20358610,20231321:20232066,20232599:20232790,20236364:20359057,20238848:20359476,20240728:20241300,20242596:20243255,20244663:20250041,20246689:20247551,20248228:20249738,20250670:20251586,20252702:20362365,20255470:2036137', 'assoc_mat': '20127880:papier:4230:20128438,20193046:papier:4230:20409541,20193048:papier:4230:20324457,20193050:papier:4230:20324818,20193052:papier:4230:20325055,20193054:papier:4230:20410220,20193056:papier:4230:20325928,20193058:papier:4230:20326296,20193060:papier:4230:20326851,20193062:papier:4230:20327168,20193064:papier:4230:20411638,20193066:papier:4230:20327813,20193068:papier:4230:20328490,20193070:papier:4230:20328717,20193072:papier:4230:20329347,20193074:papier:4230:20329625,20193076:papier:4230:20329909,20193078:papier:4230:20330393,20193080:papier:4230:20330561,20193082:papier:4230:20331048,20193084:papier:4230:20331242,20193086:papier:4230:20331600,20193774:papier:4230:20194105,20194485:papier:4230:20194880,20228786:papier:4230:20355669,20228799:papier:4230:20355707,20228802:papier:4230:20355827,20228805:papier:4230:20355926,20228808:papier:4230:20356068,20228811:papier:4230:20356139,20228814:papier:4230:20356328,20228817:papier:4230:20356583,20228820:papier:4230:20356693,20228823:papier:4230:20356922,2022'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0036544564619346727, 'nb_photo': 1539, 'list_port_cont': '20128435,20232058,20232793,20241291,20243266,20247554,20249742,20250033,20251596,20261976,20264149,20270274,20276060,20277362,20277429,20278542,20289059,20290393,20292732,20295586,20296231,20297384,20297415,20303667,20306245,20310859,20313813,20324449,20324821,20325041,20325924,20326308,20326841,20326968,20327177,20327809,20328479,20328719,20329352,20329627,20329904,20330389,20330555,20331052,20331238,20331610,20352768,20355660,20355839,20356066,20356142,20356365,20356590,20356703,20356931,20357519,20357756,20358199,20358414,20358451,20358604,20359050,20359479,20361387,20361862,20362357,20363660,20365903,20366387,20366412,20366661,20366765,20367445,20367583,20367627,20367839,20368220,20368426,20368473,20369216,20369969,20370548,20370887,20374160,20374243,20374272,20376716,20378570,20381696,20382726,20382799,20382921,20383097,20383359,20383482,20383553,20384002,20384041,20390736,20392970,20396451,20400015,20401229,20401773,20402735,20403297,20404431,20408128,20409534,20410212,20411642,20415796,20420769,2042356', 'assoc_port': '20127880:20128435,20193046:20409534,20193048:20324449,20193050:20324821,20193052:20325041,20193054:20410212,20193056:20325924,20193058:20326308,20193060:20326841,20193062:20327177,20193064:20411642,20193066:20327809,20193068:20328479,20193070:20328719,20193072:20329352,20193074:20329627,20193076:20329904,20193078:20330389,20193080:20330555,20193082:20331052,20193084:20331238,20193086:20331610,20228786:20355660,20228802:20355839,20228808:20356066,20228811:20356142,20228817:20356590,20228820:20356703,20228823:20356931,20228826:20427183,20228829:20357519,20228832:20427628,20228835:20357756,20228838:20428473,20228841:20426885,20228844:20429391,20228847:20358199,20228849:20358414,20228853:20358451,20228856:20358604,20231321:20232058,20232599:20232793,20236364:20359050,20238848:20359479,20240728:20241291,20242596:20243266,20244663:20250033,20246689:20247554,20248228:20249742,20250670:20251596,20252702:20362357,20255470:20361387,20257027:20361862,20260953:20261976,20263377:20264149,20265877:20363660,20268249:2027027', 'assoc_mat': '20127880:pehd:4230:20128435,20193046:pehd:4230:20409534,20193048:pehd:4230:20324449,20193050:pehd:4230:20324821,20193052:pehd:4230:20325041,20193054:pehd:4230:20410212,20193056:pehd:4230:20325924,20193058:pehd:4230:20326308,20193060:pehd:4230:20326841,20193062:pehd:4230:20327177,20193064:pehd:4230:20411642,20193066:pehd:4230:20327809,20193068:pehd:4230:20328479,20193070:pehd:4230:20328719,20193072:pehd:4230:20329352,20193074:pehd:4230:20329627,20193076:pehd:4230:20329904,20193078:pehd:4230:20330389,20193080:pehd:4230:20330555,20193082:pehd:4230:20331052,20193084:pehd:4230:20331238,20193086:pehd:4230:20331610,20228786:pehd:4230:20355660,20228802:pehd:4230:20355839,20228808:pehd:4230:20356066,20228811:pehd:4230:20356142,20228817:pehd:4230:20356590,20228820:pehd:4230:20356703,20228823:pehd:4230:20356931,20228826:pehd:4230:20427183,20228829:pehd:4230:20357519,20228832:pehd:4230:20427628,20228835:pehd:4230:20357756,20228838:pehd:4230:20428473,20228841:pehd:4230:20426885,20228844:pehd:4230:20429391,20228847:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.009567241633589867, 'nb_photo': 14879, 'list_port_cont': '20128440,20194106,20194872,20232053,20232784,20241301,20243264,20247561,20249747,20250037,20251594,20261961,20264142,20270277,20276053,20277370,20277425,20278538,20281587,20283730,20289066,20290394,20292723,20295577,20296235,20297383,20297417,20303663,20306240,20310853,20313821,20324450,20324826,20325050,20325925,20326310,20326854,20326963,20327175,20327812,20328489,20328729,20329349,20329626,20329914,20330380,20330552,20331045,20331241,20331602,20350909,20352772,20355672,20355700,20355835,20355931,20356053,20356143,20356321,20356366,20356585,20356705,20356930,20357516,20357755,20358185,20358406,20358455,20358612,20359051,20359477,20361386,20361876,20362366,20363649,20365890,20366385,20366422,20366670,20366771,20366985,20367168,20367443,20367594,20367625,20367840,20367967,20368216,20368419,20368476,20369221,20369973,20370461,20370543,20370891,20374157,20374237,20374286,20376708,20378568,20381292,20381547,20381657,20381697,20381727,20381975,20382066,20382148,20382262,20382382,20382546,20382580,20382730,2038279', 'assoc_port': '20127880:20128440,20193046:20409540,20193048:20324450,20193050:20324826,20193052:20325050,20193054:20410223,20193056:20325925,20193058:20326310,20193060:20326854,20193062:20327175,20193064:20411646,20193066:20327812,20193068:20328489,20193070:20328729,20193072:20329349,20193074:20329626,20193076:20329914,20193078:20330380,20193080:20330552,20193082:20331045,20193084:20331241,20193086:20331602,20193774:20194106,20194485:20194872,20228786:20355672,20228799:20355700,20228802:20355835,20228805:20355931,20228808:20356053,20228811:20356143,20228814:20356321,20228817:20356585,20228820:20356705,20228823:20356930,20228826:20427179,20228829:20357516,20228832:20427626,20228835:20357755,20228838:20428472,20228841:20426874,20228844:20429379,20228847:20358185,20228849:20358406,20228853:20358455,20228856:20358612,20231321:20232053,20232599:20232784,20236364:20359051,20238848:20359477,20240728:20241301,20242596:20243264,20244663:20250037,20246689:20247561,20248228:20249747,20250670:20251594,20252702:20362366,20255470:2036138', 'assoc_mat': '20127880:pet_clair:4230:20128440,20193046:pet_clair:4230:20409540,20193048:pet_clair:4230:20324450,20193050:pet_clair:4230:20324826,20193052:pet_clair:4230:20325050,20193054:pet_clair:4230:20410223,20193056:pet_clair:4230:20325925,20193058:pet_clair:4230:20326310,20193060:pet_clair:4230:20326854,20193062:pet_clair:4230:20327175,20193064:pet_clair:4230:20411646,20193066:pet_clair:4230:20327812,20193068:pet_clair:4230:20328489,20193070:pet_clair:4230:20328729,20193072:pet_clair:4230:20329349,20193074:pet_clair:4230:20329626,20193076:pet_clair:4230:20329914,20193078:pet_clair:4230:20330380,20193080:pet_clair:4230:20330552,20193082:pet_clair:4230:20331045,20193084:pet_clair:4230:20331241,20193086:pet_clair:4230:20331602,20193774:pet_clair:4230:20194106,20194485:pet_clair:4230:20194872,20228786:pet_clair:4230:20355672,20228799:pet_clair:4230:20355700,20228802:pet_clair:4230:20355835,20228805:pet_clair:4230:20355931,20228808:pet_clair:4230:20356053,20228811:pet_clair:4230:20356143,20228814:pet_clair:4230:20356321,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028515111621246, 'nb_photo': 594, 'list_port_cont': '20194107,20241296,20243265,20249745,20250043,20251591,20264138,20270269,20277366,20277436,20278536,20281589,20283722,20289069,20290398,20292724,20297380,20297421,20324454,20324822,20326306,20326853,20326972,20327165,20328726,20329356,20329620,20329903,20330387,20330557,20331046,20331236,20331612,20352774,20355664,20356059,20356325,20356369,20356591,20356707,20356921,20357510,20357758,20358408,20358456,20358601,20359060,20359475,20361388,20361871,20362355,20366424,20366669,20367593,20367629,20367834,20368211,20368428,20369217,20370553,20374231,20381285,20381549,20382548,20382841,20382912,20384001,20390737,20394361,20400028,20401235,20401777,20402740,20404436,20408129,20420777,20422833,20424277,20424537,20424665,20424759,20424931,20425018,20426888,20427635,20428462,20463144,20463794,20464555,20465559,20467904,20468683,20469865,20470455,20470640,20471785,20474488,20494133,20494421,20494494,20494552,20494900,20495008,20495034,20495535,20495828,20499174,20534300,20536879,20537673,20538282,20538612,20538976,2053940', 'assoc_port': '20193048:20324454,20193050:20324822,20193058:20326306,20193060:20326853,20193062:20327165,20193070:20328726,20193072:20329356,20193074:20329620,20193076:20329903,20193078:20330387,20193080:20330557,20193082:20331046,20193084:20331236,20193086:20331612,20193774:20194107,20228786:20355664,20228808:20356059,20228814:20356325,20228817:20356591,20228820:20356707,20228823:20356921,20228829:20357510,20228832:20427635,20228835:20357758,20228838:20428462,20228841:20426888,20228849:20358408,20228853:20358456,20228856:20358601,20236364:20359060,20238848:20359475,20240728:20241296,20242596:20243265,20244663:20250043,20248228:20249745,20250670:20251591,20252702:20362355,20255470:20361388,20257027:20361871,20263377:20264138,20268249:20270269,20273933:20374231,20275772:20277366,20276892:20277436,20278378:20278536,20280539:20281589,20283351:20283722,20287698:20289069,20290104:20290398,20292433:20292724,20296450:20297421,20296972:20297380,20297618:20382912,20300685:20384001,20312871:20326972,20351397:20424277,20351402:2042453', 'assoc_mat': '20193048:pet_fonce:4230:20324454,20193050:pet_fonce:4230:20324822,20193058:pet_fonce:4230:20326306,20193060:pet_fonce:4230:20326853,20193062:pet_fonce:4230:20327165,20193070:pet_fonce:4230:20328726,20193072:pet_fonce:4230:20329356,20193074:pet_fonce:4230:20329620,20193076:pet_fonce:4230:20329903,20193078:pet_fonce:4230:20330387,20193080:pet_fonce:4230:20330557,20193082:pet_fonce:4230:20331046,20193084:pet_fonce:4230:20331236,20193086:pet_fonce:4230:20331612,20193774:pet_fonce:4230:20194107,20228786:pet_fonce:4230:20355664,20228808:pet_fonce:4230:20356059,20228814:pet_fonce:4230:20356325,20228817:pet_fonce:4230:20356591,20228820:pet_fonce:4230:20356707,20228823:pet_fonce:4230:20356921,20228829:pet_fonce:4230:20357510,20228832:pet_fonce:4230:20427635,20228835:pet_fonce:4230:20357758,20228838:pet_fonce:4230:20428462,20228841:pet_fonce:4230:20426888,20228849:pet_fonce:4230:20358408,20228853:pet_fonce:4230:20358456,20228856:pet_fonce:4230:20358601,20236364:pet_fonce:4230:20359060,20238848:pet_fonce:4230:20359475,2'}), 'main_stat': {'nb_photos': 1271}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-02', 0.7489724881500968),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1271,),), 'unwanted_material_monthly_percentage': ((0.7489724881500968,),), 'material_repartition': (('incineration', 1271),), 'material_dict': {'incineration': 1271}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 2, 1), 0.6725372053473075, 3), (datetime.date(2025, 2, 3), 0.7471249323756989, 66), (datetime.date(2025, 2, 4), 0.7007033486168995, 62), (datetime.date(2025, 2, 5), 0.683042943995002, 61), (datetime.date(2025, 2, 6), 0.6383819350997628, 35), (datetime.date(2025, 2, 7), 0.6436606626450949, 37), (datetime.date(2025, 2, 8), 0.6551154027635547, 40), (datetime.date(2025, 2, 9), 0.808625722814196, 33), (datetime.date(2025, 2, 10), 0.7805001281376271, 54), (datetime.date(2025, 2, 11), 0.7377688007665555, 44), (datetime.date(2025, 2, 12), 0.7977346152477232, 41), (datetime.date(2025, 2, 13), 0.7223707216638832, 49), (datetime.date(2025, 2, 14), 0.7458083080285252, 40), (datetime.date(2025, 2, 15), 0.829518412091649, 33), (datetime.date(2025, 2, 16), 0.8748911960680454, 28), (datetime.date(2025, 2, 17), 0.7869336826906949, 52), (datetime.date(2025, 2, 18), 0.7704880122285273, 43), (datetime.date(2025, 2, 19), 0.7677553477005744, 46), (datetime.date(2025, 2, 20), 0.7276309273808395, 33), (datetime.date(2025, 2, 21), 0.6628752071329629, 38), (datetime.date(2025, 2, 22), 0.7564603761429957, 65), (datetime.date(2025, 2, 23), 0.8315555022978478, 66), (datetime.date(2025, 2, 24), 0.772196682077399, 65), (datetime.date(2025, 2, 25), 0.7249139879272692, 55), (datetime.date(2025, 2, 26), 0.7759401279912336, 65), (datetime.date(2025, 2, 27), 0.7345303157309089, 61), (datetime.date(2025, 2, 28), 0.739714231387429, 56)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 2, 1), 0.6725372053473075, 3), (datetime.date(2025, 2, 3), 0.7471249323756989, 66), (datetime.date(2025, 2, 4), 0.7007033486168995, 62), (datetime.date(2025, 2, 5), 0.683042943995002, 61), (datetime.date(2025, 2, 6), 0.6383819350997628, 35), (datetime.date(2025, 2, 7), 0.6436606626450949, 37), (datetime.date(2025, 2, 8), 0.6551154027635547, 40), (datetime.date(2025, 2, 9), 0.808625722814196, 33), (datetime.date(2025, 2, 10), 0.7805001281376271, 54), (datetime.date(2025, 2, 11), 0.7377688007665555, 44), (datetime.date(2025, 2, 12), 0.7977346152477232, 41), (datetime.date(2025, 2, 13), 0.7223707216638832, 49), (datetime.date(2025, 2, 14), 0.7458083080285252, 40), (datetime.date(2025, 2, 15), 0.829518412091649, 33), (datetime.date(2025, 2, 16), 0.8748911960680454, 28), (datetime.date(2025, 2, 17), 0.7869336826906949, 52), (datetime.date(2025, 2, 18), 0.7704880122285273, 43), (datetime.date(2025, 2, 19), 0.7677553477005744, 46), (datetime.date(2025, 2, 20), 0.7276309273808395, 33), (datetime.date(2025, 2, 21), 0.6628752071329629, 38), (datetime.date(2025, 2, 22), 0.7564603761429957, 65), (datetime.date(2025, 2, 23), 0.8315555022978478, 66), (datetime.date(2025, 2, 24), 0.772196682077399, 65), (datetime.date(2025, 2, 25), 0.7249139879272692, 55), (datetime.date(2025, 2, 26), 0.7759401279912336, 65), (datetime.date(2025, 2, 27), 0.7345303157309089, 61), (datetime.date(2025, 2, 28), 0.739714231387429, 56))}, 'quality_array': [['-9.365853258538428', '01022025'], ['-8.531821352166412', '03022025'], ['-8.802074702614567', '04022025'], ['-9.057553381259595', '05022025'], ['-9.033589440733198', '06022025'], ['-9.0993338300804', '07022025'], ['-9.011581284897101', '08022025'], ['-8.866424419206453', '09022025'], ['-8.670564792540109', '10022025'], ['-8.680934649290329', '11022025'], ['-8.102037743443546', '12022025'], ['-8.097230314161013', '13022025'], ['-8.461069816854422', '14022025'], ['-8.368869207878749', '15022025'], ['-8.282423391639062', '16022025'], ['-8.175418623239793', '17022025'], ['-8.073881932319818', '18022025'], ['-8.076738408115276', '19022025'], ['-8.199257898988929', '20022025'], ['-8.16508665430097', '21022025'], ['-8.35461017136855', '22022025'], ['-8.265163695508091', '23022025'], ['-7.994786671728289', '24022025'], ['-8.119656558007904', '25022025'], ['-8.311056379990271', '26022025'], ['-8.283238999246235', '27022025'], ['-8.255721730068872', '28022025']], 'number_of_batch': ((550,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015488056479864435, 'nb_photo': 12942, 'list_port_cont': '20128441,20194098,20194864,20232059,20232779,20241302,20243257,20247549,20249735,20250044,20251580,20261965,20264135,20270271,20276054,20277369,20277433,20278526,20281585,20283723,20289062,20290387,20292733,20295584,20296234,20297373,20297411,20303664,20306239,20310858,20313810,20324445,20324820,20325053,20325930,20326311,20326843,20326965,20327164,20327810,20328483,20328713,20329357,20329624,20329908,20330390,20330560,20331042,20331229,20331613,20350894,20352760,20355662,20355702,20355841,20355928,20356060,20356130,20356324,20356358,20356594,20356695,20356926,20357508,20357751,20358198,20358409,20358442,20358607,20359061,20359473,20361372,20361869,20362359,20363650,20365896,20366384,20366420,20366655,20366762,20366983,20367170,20367432,20367584,20367632,20367841,20367970,20368213,20368421,20368465,20369213,20369967,20370462,20370550,20370892,20374161,20374230,20374276,20376715,20378564,20381283,20381540,20381647,20381693,20381722,20381961,20382078,20382153,20382268,20382379,20382539,20382586,20382722,2038278', 'assoc_port': '20127880:20128441,20193046:20409538,20193048:20324445,20193050:20324820,20193052:20325053,20193054:20410221,20193056:20325930,20193058:20326311,20193060:20326843,20193062:20327164,20193064:20411647,20193066:20327810,20193068:20328483,20193070:20328713,20193072:20329357,20193074:20329624,20193076:20329908,20193078:20330390,20193080:20330560,20193082:20331042,20193084:20331229,20193086:20331613,20193774:20194098,20194485:20194864,20228786:20355662,20228799:20355702,20228802:20355841,20228805:20355928,20228808:20356060,20228811:20356130,20228814:20356324,20228817:20356594,20228820:20356695,20228823:20356926,20228826:20427173,20228829:20357508,20228832:20427622,20228835:20357751,20228838:20428463,20228841:20426887,20228844:20429386,20228847:20358198,20228849:20358409,20228853:20358442,20228856:20358607,20231321:20232059,20232599:20232779,20236364:20359061,20238848:20359473,20240728:20241302,20242596:20243257,20244663:20250044,20246689:20247549,20248228:20249735,20250670:20251580,20252702:20362359,20255470:2036137', 'assoc_mat': '20127880:autre:4230:20128441,20193046:autre:4230:20409538,20193048:autre:4230:20324445,20193050:autre:4230:20324820,20193052:autre:4230:20325053,20193054:autre:4230:20410221,20193056:autre:4230:20325930,20193058:autre:4230:20326311,20193060:autre:4230:20326843,20193062:autre:4230:20327164,20193064:autre:4230:20411647,20193066:autre:4230:20327810,20193068:autre:4230:20328483,20193070:autre:4230:20328713,20193072:autre:4230:20329357,20193074:autre:4230:20329624,20193076:autre:4230:20329908,20193078:autre:4230:20330390,20193080:autre:4230:20330560,20193082:autre:4230:20331042,20193084:autre:4230:20331229,20193086:autre:4230:20331613,20193774:autre:4230:20194098,20194485:autre:4230:20194864,20228786:autre:4230:20355662,20228799:autre:4230:20355702,20228802:autre:4230:20355841,20228805:autre:4230:20355928,20228808:autre:4230:20356060,20228811:autre:4230:20356130,20228814:autre:4230:20356324,20228817:autre:4230:20356594,20228820:autre:4230:20356695,20228823:autre:4230:20356926,20228826:autre:4230:20427173,20228829:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05669243683901649, 'nb_photo': 69582, 'list_port_cont': '20128437,20194103,20194881,20232067,20232794,20241293,20243269,20247559,20249744,20250042,20251593,20261973,20264146,20270272,20276047,20277360,20277435,20278537,20281592,20283733,20289063,20290390,20292729,20295588,20296238,20297385,20297422,20303674,20306243,20310848,20313809,20324443,20324825,20325054,20325923,20326304,20326847,20326974,20327174,20327805,20328487,20328722,20329354,20329617,20329913,20330394,20330562,20331044,20331243,20331608,20350903,20352773,20355667,20355699,20355840,20355934,20356064,20356140,20356323,20356368,20356593,20356699,20356918,20357512,20357746,20358194,20358407,20358449,20358615,20359063,20359469,20361378,20361873,20362363,20363657,20365902,20366382,20366419,20366664,20366773,20366995,20367166,20367439,20367596,20367636,20367830,20367973,20368217,20368425,20368481,20369210,20369971,20370459,20370545,20370893,20374152,20374229,20374280,20376713,20378569,20381281,20381548,20381653,20381694,20381729,20381973,20382076,20382149,20382270,20382381,20382545,20382577,20382729,2038280', 'assoc_port': '20127880:20128437,20193046:20409544,20193048:20324443,20193050:20324825,20193052:20325054,20193054:20410224,20193056:20325923,20193058:20326304,20193060:20326847,20193062:20327174,20193064:20411640,20193066:20327805,20193068:20328487,20193070:20328722,20193072:20329354,20193074:20329617,20193076:20329913,20193078:20330394,20193080:20330562,20193082:20331044,20193084:20331243,20193086:20331608,20193774:20194103,20194485:20194881,20228786:20355667,20228799:20355699,20228802:20355840,20228805:20355934,20228808:20356064,20228811:20356140,20228814:20356323,20228817:20356593,20228820:20356699,20228823:20356918,20228826:20427178,20228829:20357512,20228832:20427624,20228835:20357746,20228838:20428465,20228841:20426880,20228844:20429390,20228847:20358194,20228849:20358407,20228853:20358449,20228856:20358615,20231321:20232067,20232599:20232794,20236364:20359063,20238848:20359469,20240728:20241293,20242596:20243269,20244663:20250042,20246689:20247559,20248228:20249744,20250670:20251593,20252702:20362363,20255470:2036137', 'assoc_mat': '20127880:carton:4230:20128437,20193046:carton:4230:20409544,20193048:carton:4230:20324443,20193050:carton:4230:20324825,20193052:carton:4230:20325054,20193054:carton:4230:20410224,20193056:carton:4230:20325923,20193058:carton:4230:20326304,20193060:carton:4230:20326847,20193062:carton:4230:20327174,20193064:carton:4230:20411640,20193066:carton:4230:20327805,20193068:carton:4230:20328487,20193070:carton:4230:20328722,20193072:carton:4230:20329354,20193074:carton:4230:20329617,20193076:carton:4230:20329913,20193078:carton:4230:20330394,20193080:carton:4230:20330562,20193082:carton:4230:20331044,20193084:carton:4230:20331243,20193086:carton:4230:20331608,20193774:carton:4230:20194103,20194485:carton:4230:20194881,20228786:carton:4230:20355667,20228799:carton:4230:20355699,20228802:carton:4230:20355840,20228805:carton:4230:20355934,20228808:carton:4230:20356064,20228811:carton:4230:20356140,20228814:carton:4230:20356323,20228817:carton:4230:20356593,20228820:carton:4230:20356699,20228823:carton:4230:20356918,2022'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001432885805165281, 'nb_photo': 1383, 'list_port_cont': '20128444,20194102,20194869,20232068,20232789,20241297,20243267,20247556,20249739,20250045,20251582,20261968,20264143,20270276,20276056,20277354,20277427,20278539,20281584,20283720,20289058,20290384,20292721,20295578,20296232,20297378,20297409,20303673,20306233,20310857,20313806,20324440,20324823,20325044,20326300,20326964,20327176,20327808,20328492,20328727,20329351,20329630,20329912,20330379,20330548,20331056,20331225,20331614,20350911,20352764,20355655,20355705,20355837,20355933,20356055,20356128,20356330,20356354,20356579,20356708,20356929,20357520,20357752,20358193,20358404,20358440,20358608,20359053,20359470,20361374,20361860,20362367,20363647,20366380,20366409,20366654,20366758,20366986,20367162,20367446,20367592,20367630,20367837,20367969,20368219,20368416,20368468,20369214,20369970,20370465,20370879,20374151,20374242,20374273,20376706,20378554,20381648,20381682,20381735,20381968,20382145,20382259,20382544,20382574,20382723,20382801,20382839,20382920,20383092,20383140,20383468,20383539,20384004,2038403', 'assoc_port': '20127880:20128444,20193046:20409520,20193048:20324440,20193050:20324823,20193052:20325044,20193058:20326300,20193062:20327176,20193064:20411633,20193066:20327808,20193068:20328492,20193070:20328727,20193072:20329351,20193074:20329630,20193076:20329912,20193078:20330379,20193080:20330548,20193082:20331056,20193084:20331225,20193086:20331614,20193774:20194102,20194485:20194869,20228786:20355655,20228799:20355705,20228802:20355837,20228805:20355933,20228808:20356055,20228811:20356128,20228814:20356330,20228817:20356579,20228820:20356708,20228823:20356929,20228826:20427182,20228829:20357520,20228832:20427630,20228835:20357752,20228838:20428469,20228841:20426872,20228847:20358193,20228849:20358404,20228853:20358440,20228856:20358608,20231321:20232068,20232599:20232789,20236364:20359053,20238848:20359470,20240728:20241297,20242596:20243267,20244663:20250045,20246689:20247556,20248228:20249739,20250670:20251582,20252702:20362367,20255470:20361374,20257027:20361860,20260953:20261968,20263377:20264143,20265877:2036364', 'assoc_mat': '20127880:metal:4230:20128444,20193046:metal:4230:20409520,20193048:metal:4230:20324440,20193050:metal:4230:20324823,20193052:metal:4230:20325044,20193058:metal:4230:20326300,20193062:metal:4230:20327176,20193064:metal:4230:20411633,20193066:metal:4230:20327808,20193068:metal:4230:20328492,20193070:metal:4230:20328727,20193072:metal:4230:20329351,20193074:metal:4230:20329630,20193076:metal:4230:20329912,20193078:metal:4230:20330379,20193080:metal:4230:20330548,20193082:metal:4230:20331056,20193084:metal:4230:20331225,20193086:metal:4230:20331614,20193774:metal:4230:20194102,20194485:metal:4230:20194869,20228786:metal:4230:20355655,20228799:metal:4230:20355705,20228802:metal:4230:20355837,20228805:metal:4230:20355933,20228808:metal:4230:20356055,20228811:metal:4230:20356128,20228814:metal:4230:20356330,20228817:metal:4230:20356579,20228820:metal:4230:20356708,20228823:metal:4230:20356929,20228826:metal:4230:20427182,20228829:metal:4230:20357520,20228832:metal:4230:20427630,20228835:metal:4230:20357752,20228838:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19111389778375176, 'nb_photo': 261552, 'list_port_cont': '20128438,20194105,20194880,20232066,20232790,20241300,20243255,20247551,20249738,20250041,20251586,20261977,20264145,20270263,20276051,20277368,20277420,20278534,20281582,20283727,20289072,20290386,20292730,20295581,20296237,20297374,20297418,20303658,20306242,20310849,20313807,20324457,20324818,20325055,20325928,20326296,20326851,20326969,20327168,20327813,20328490,20328717,20329347,20329625,20329909,20330393,20330561,20331048,20331242,20331600,20350906,20352770,20355669,20355707,20355827,20355926,20356068,20356139,20356328,20356361,20356583,20356693,20356922,20357511,20357753,20358187,20358416,20358457,20358610,20359057,20359476,20361377,20361865,20362365,20363652,20365897,20366376,20366417,20366665,20366772,20366990,20367164,20367440,20367597,20367631,20367838,20367971,20368214,20368427,20368475,20369220,20369975,20370467,20370546,20370884,20374164,20374241,20374284,20376718,20378571,20381293,20381544,20381661,20381683,20381728,20381976,20382079,20382155,20382266,20382377,20382550,20382575,20382724,2038280', 'assoc_port': '20127880:20128438,20193046:20409541,20193048:20324457,20193050:20324818,20193052:20325055,20193054:20410220,20193056:20325928,20193058:20326296,20193060:20326851,20193062:20327168,20193064:20411638,20193066:20327813,20193068:20328490,20193070:20328717,20193072:20329347,20193074:20329625,20193076:20329909,20193078:20330393,20193080:20330561,20193082:20331048,20193084:20331242,20193086:20331600,20193774:20194105,20194485:20194880,20228786:20355669,20228799:20355707,20228802:20355827,20228805:20355926,20228808:20356068,20228811:20356139,20228814:20356328,20228817:20356583,20228820:20356693,20228823:20356922,20228826:20427177,20228829:20357511,20228832:20427625,20228835:20357753,20228838:20428467,20228841:20426878,20228844:20429388,20228847:20358187,20228849:20358416,20228853:20358457,20228856:20358610,20231321:20232066,20232599:20232790,20236364:20359057,20238848:20359476,20240728:20241300,20242596:20243255,20244663:20250041,20246689:20247551,20248228:20249738,20250670:20251586,20252702:20362365,20255470:2036137', 'assoc_mat': '20127880:papier:4230:20128438,20193046:papier:4230:20409541,20193048:papier:4230:20324457,20193050:papier:4230:20324818,20193052:papier:4230:20325055,20193054:papier:4230:20410220,20193056:papier:4230:20325928,20193058:papier:4230:20326296,20193060:papier:4230:20326851,20193062:papier:4230:20327168,20193064:papier:4230:20411638,20193066:papier:4230:20327813,20193068:papier:4230:20328490,20193070:papier:4230:20328717,20193072:papier:4230:20329347,20193074:papier:4230:20329625,20193076:papier:4230:20329909,20193078:papier:4230:20330393,20193080:papier:4230:20330561,20193082:papier:4230:20331048,20193084:papier:4230:20331242,20193086:papier:4230:20331600,20193774:papier:4230:20194105,20194485:papier:4230:20194880,20228786:papier:4230:20355669,20228799:papier:4230:20355707,20228802:papier:4230:20355827,20228805:papier:4230:20355926,20228808:papier:4230:20356068,20228811:papier:4230:20356139,20228814:papier:4230:20356328,20228817:papier:4230:20356583,20228820:papier:4230:20356693,20228823:papier:4230:20356922,2022'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0036544564619346727, 'nb_photo': 1539, 'list_port_cont': '20128435,20232058,20232793,20241291,20243266,20247554,20249742,20250033,20251596,20261976,20264149,20270274,20276060,20277362,20277429,20278542,20289059,20290393,20292732,20295586,20296231,20297384,20297415,20303667,20306245,20310859,20313813,20324449,20324821,20325041,20325924,20326308,20326841,20326968,20327177,20327809,20328479,20328719,20329352,20329627,20329904,20330389,20330555,20331052,20331238,20331610,20352768,20355660,20355839,20356066,20356142,20356365,20356590,20356703,20356931,20357519,20357756,20358199,20358414,20358451,20358604,20359050,20359479,20361387,20361862,20362357,20363660,20365903,20366387,20366412,20366661,20366765,20367445,20367583,20367627,20367839,20368220,20368426,20368473,20369216,20369969,20370548,20370887,20374160,20374243,20374272,20376716,20378570,20381696,20382726,20382799,20382921,20383097,20383359,20383482,20383553,20384002,20384041,20390736,20392970,20396451,20400015,20401229,20401773,20402735,20403297,20404431,20408128,20409534,20410212,20411642,20415796,20420769,2042356', 'assoc_port': '20127880:20128435,20193046:20409534,20193048:20324449,20193050:20324821,20193052:20325041,20193054:20410212,20193056:20325924,20193058:20326308,20193060:20326841,20193062:20327177,20193064:20411642,20193066:20327809,20193068:20328479,20193070:20328719,20193072:20329352,20193074:20329627,20193076:20329904,20193078:20330389,20193080:20330555,20193082:20331052,20193084:20331238,20193086:20331610,20228786:20355660,20228802:20355839,20228808:20356066,20228811:20356142,20228817:20356590,20228820:20356703,20228823:20356931,20228826:20427183,20228829:20357519,20228832:20427628,20228835:20357756,20228838:20428473,20228841:20426885,20228844:20429391,20228847:20358199,20228849:20358414,20228853:20358451,20228856:20358604,20231321:20232058,20232599:20232793,20236364:20359050,20238848:20359479,20240728:20241291,20242596:20243266,20244663:20250033,20246689:20247554,20248228:20249742,20250670:20251596,20252702:20362357,20255470:20361387,20257027:20361862,20260953:20261976,20263377:20264149,20265877:20363660,20268249:2027027', 'assoc_mat': '20127880:pehd:4230:20128435,20193046:pehd:4230:20409534,20193048:pehd:4230:20324449,20193050:pehd:4230:20324821,20193052:pehd:4230:20325041,20193054:pehd:4230:20410212,20193056:pehd:4230:20325924,20193058:pehd:4230:20326308,20193060:pehd:4230:20326841,20193062:pehd:4230:20327177,20193064:pehd:4230:20411642,20193066:pehd:4230:20327809,20193068:pehd:4230:20328479,20193070:pehd:4230:20328719,20193072:pehd:4230:20329352,20193074:pehd:4230:20329627,20193076:pehd:4230:20329904,20193078:pehd:4230:20330389,20193080:pehd:4230:20330555,20193082:pehd:4230:20331052,20193084:pehd:4230:20331238,20193086:pehd:4230:20331610,20228786:pehd:4230:20355660,20228802:pehd:4230:20355839,20228808:pehd:4230:20356066,20228811:pehd:4230:20356142,20228817:pehd:4230:20356590,20228820:pehd:4230:20356703,20228823:pehd:4230:20356931,20228826:pehd:4230:20427183,20228829:pehd:4230:20357519,20228832:pehd:4230:20427628,20228835:pehd:4230:20357756,20228838:pehd:4230:20428473,20228841:pehd:4230:20426885,20228844:pehd:4230:20429391,20228847:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.009567241633589867, 'nb_photo': 14879, 'list_port_cont': '20128440,20194106,20194872,20232053,20232784,20241301,20243264,20247561,20249747,20250037,20251594,20261961,20264142,20270277,20276053,20277370,20277425,20278538,20281587,20283730,20289066,20290394,20292723,20295577,20296235,20297383,20297417,20303663,20306240,20310853,20313821,20324450,20324826,20325050,20325925,20326310,20326854,20326963,20327175,20327812,20328489,20328729,20329349,20329626,20329914,20330380,20330552,20331045,20331241,20331602,20350909,20352772,20355672,20355700,20355835,20355931,20356053,20356143,20356321,20356366,20356585,20356705,20356930,20357516,20357755,20358185,20358406,20358455,20358612,20359051,20359477,20361386,20361876,20362366,20363649,20365890,20366385,20366422,20366670,20366771,20366985,20367168,20367443,20367594,20367625,20367840,20367967,20368216,20368419,20368476,20369221,20369973,20370461,20370543,20370891,20374157,20374237,20374286,20376708,20378568,20381292,20381547,20381657,20381697,20381727,20381975,20382066,20382148,20382262,20382382,20382546,20382580,20382730,2038279', 'assoc_port': '20127880:20128440,20193046:20409540,20193048:20324450,20193050:20324826,20193052:20325050,20193054:20410223,20193056:20325925,20193058:20326310,20193060:20326854,20193062:20327175,20193064:20411646,20193066:20327812,20193068:20328489,20193070:20328729,20193072:20329349,20193074:20329626,20193076:20329914,20193078:20330380,20193080:20330552,20193082:20331045,20193084:20331241,20193086:20331602,20193774:20194106,20194485:20194872,20228786:20355672,20228799:20355700,20228802:20355835,20228805:20355931,20228808:20356053,20228811:20356143,20228814:20356321,20228817:20356585,20228820:20356705,20228823:20356930,20228826:20427179,20228829:20357516,20228832:20427626,20228835:20357755,20228838:20428472,20228841:20426874,20228844:20429379,20228847:20358185,20228849:20358406,20228853:20358455,20228856:20358612,20231321:20232053,20232599:20232784,20236364:20359051,20238848:20359477,20240728:20241301,20242596:20243264,20244663:20250037,20246689:20247561,20248228:20249747,20250670:20251594,20252702:20362366,20255470:2036138', 'assoc_mat': '20127880:pet_clair:4230:20128440,20193046:pet_clair:4230:20409540,20193048:pet_clair:4230:20324450,20193050:pet_clair:4230:20324826,20193052:pet_clair:4230:20325050,20193054:pet_clair:4230:20410223,20193056:pet_clair:4230:20325925,20193058:pet_clair:4230:20326310,20193060:pet_clair:4230:20326854,20193062:pet_clair:4230:20327175,20193064:pet_clair:4230:20411646,20193066:pet_clair:4230:20327812,20193068:pet_clair:4230:20328489,20193070:pet_clair:4230:20328729,20193072:pet_clair:4230:20329349,20193074:pet_clair:4230:20329626,20193076:pet_clair:4230:20329914,20193078:pet_clair:4230:20330380,20193080:pet_clair:4230:20330552,20193082:pet_clair:4230:20331045,20193084:pet_clair:4230:20331241,20193086:pet_clair:4230:20331602,20193774:pet_clair:4230:20194106,20194485:pet_clair:4230:20194872,20228786:pet_clair:4230:20355672,20228799:pet_clair:4230:20355700,20228802:pet_clair:4230:20355835,20228805:pet_clair:4230:20355931,20228808:pet_clair:4230:20356053,20228811:pet_clair:4230:20356143,20228814:pet_clair:4230:20356321,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028515111621246, 'nb_photo': 594, 'list_port_cont': '20194107,20241296,20243265,20249745,20250043,20251591,20264138,20270269,20277366,20277436,20278536,20281589,20283722,20289069,20290398,20292724,20297380,20297421,20324454,20324822,20326306,20326853,20326972,20327165,20328726,20329356,20329620,20329903,20330387,20330557,20331046,20331236,20331612,20352774,20355664,20356059,20356325,20356369,20356591,20356707,20356921,20357510,20357758,20358408,20358456,20358601,20359060,20359475,20361388,20361871,20362355,20366424,20366669,20367593,20367629,20367834,20368211,20368428,20369217,20370553,20374231,20381285,20381549,20382548,20382841,20382912,20384001,20390737,20394361,20400028,20401235,20401777,20402740,20404436,20408129,20420777,20422833,20424277,20424537,20424665,20424759,20424931,20425018,20426888,20427635,20428462,20463144,20463794,20464555,20465559,20467904,20468683,20469865,20470455,20470640,20471785,20474488,20494133,20494421,20494494,20494552,20494900,20495008,20495034,20495535,20495828,20499174,20534300,20536879,20537673,20538282,20538612,20538976,2053940', 'assoc_port': '20193048:20324454,20193050:20324822,20193058:20326306,20193060:20326853,20193062:20327165,20193070:20328726,20193072:20329356,20193074:20329620,20193076:20329903,20193078:20330387,20193080:20330557,20193082:20331046,20193084:20331236,20193086:20331612,20193774:20194107,20228786:20355664,20228808:20356059,20228814:20356325,20228817:20356591,20228820:20356707,20228823:20356921,20228829:20357510,20228832:20427635,20228835:20357758,20228838:20428462,20228841:20426888,20228849:20358408,20228853:20358456,20228856:20358601,20236364:20359060,20238848:20359475,20240728:20241296,20242596:20243265,20244663:20250043,20248228:20249745,20250670:20251591,20252702:20362355,20255470:20361388,20257027:20361871,20263377:20264138,20268249:20270269,20273933:20374231,20275772:20277366,20276892:20277436,20278378:20278536,20280539:20281589,20283351:20283722,20287698:20289069,20290104:20290398,20292433:20292724,20296450:20297421,20296972:20297380,20297618:20382912,20300685:20384001,20312871:20326972,20351397:20424277,20351402:2042453', 'assoc_mat': '20193048:pet_fonce:4230:20324454,20193050:pet_fonce:4230:20324822,20193058:pet_fonce:4230:20326306,20193060:pet_fonce:4230:20326853,20193062:pet_fonce:4230:20327165,20193070:pet_fonce:4230:20328726,20193072:pet_fonce:4230:20329356,20193074:pet_fonce:4230:20329620,20193076:pet_fonce:4230:20329903,20193078:pet_fonce:4230:20330387,20193080:pet_fonce:4230:20330557,20193082:pet_fonce:4230:20331046,20193084:pet_fonce:4230:20331236,20193086:pet_fonce:4230:20331612,20193774:pet_fonce:4230:20194107,20228786:pet_fonce:4230:20355664,20228808:pet_fonce:4230:20356059,20228814:pet_fonce:4230:20356325,20228817:pet_fonce:4230:20356591,20228820:pet_fonce:4230:20356707,20228823:pet_fonce:4230:20356921,20228829:pet_fonce:4230:20357510,20228832:pet_fonce:4230:20427635,20228835:pet_fonce:4230:20357758,20228838:pet_fonce:4230:20428462,20228841:pet_fonce:4230:20426888,20228849:pet_fonce:4230:20358408,20228853:pet_fonce:4230:20358456,20228856:pet_fonce:4230:20358601,20236364:pet_fonce:4230:20359060,20238848:pet_fonce:4230:20359475,2'}), 'main_stat': {'nb_photos': 1271}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-02', 0.7489724881500968),)]} filepath : /data_2/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_02_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.55%', 12942], 'carton': ['carton', '5.67%', 69582], 'metal': ['metal', '0.14%', 1383], 'papier': ['papier', '19.11%', 261552], 'pehd': ['pehd', '0.37%', 1539], 'pet_clair': ['pet_clair', '0.96%', 14879], 'pet_fonce': ['pet_fonce', '0.29%', 594]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_02_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/SCCU_cam7 2.70user 2.50system 0:07.73elapsed 67%CPU (0avgtext+0avgdata 193812maxresident)k 59496inputs+272outputs (413major+67686minor)pagefaults 0swaps