python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --job=sla_mensuel --raspi=20092 --dashboard_places=refus_amiens --rootfolder_sla=/data_2/data_log/job/memo/refus_amiens -v --mtr_id=983 --date=`date -d"$nowdate 1 day ago" +%Y-%m` ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : 20092, Date : 2025-04 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (1, 30) 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 TWARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used SQL: SELECT ms.id, ms.name, mst.name as type, ms.test_group, ms.test_name, ms.server, ms.version_code, ms.result_str, ms.result_bool, ms.result_float, ms.lien, ms.created_at FROM MTRAdmin.monitor_sys ms INNER JOIN MTRAdmin.monitor_sys_type mst on mst.id = ms.type WHERE ms.test_name like '%20092%' AND ms.result_str like '%2025/04%'ORDER BY ms.id desc LIMIT 0, 1000000; Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! We will need to call the sla_per_day for these missing days : 2025-04-01 00:00:00,2025-04-02 00:00:00,2025-04-03 00:00:00,2025-04-04 00:00:00,2025-04-05 00:00:00,2025-04-06 00:00:00,2025-04-07 00:00:00,2025-04-08 00:00:00,2025-04-09 00:00:00,2025-04-10 00:00:00,2025-04-11 00:00:00,2025-04-12 00:00:00,2025-04-13 00:00:00,2025-04-14 00:00:00,2025-04-15 00:00:00,2025-04-16 00:00:00,2025-04-17 00:00:00,2025-04-18 00:00:00,2025-04-19 00:00:00,2025-04-20 00:00:00,2025-04-21 00:00:00,2025-04-22 00:00:00,2025-04-23 00:00:00,2025-04-24 00:00:00,2025-04-25 00:00:00,2025-04-26 00:00:00,2025-04-27 00:00:00,2025-04-28 00:00:00,2025-04-29 00:00:00,2025-04-30 00:00:00 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 = 15 and month(ded.date) = 04 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______refus' and ded.dashboard_place_id = 15 and month(ded.date) = 04 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 15 and mp.name like '%042025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-04-01 : dt_date_just_month_year : 2025-04-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "refus_amiens" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-04-01" AND ded.date <= "2025-04-30" apple3 {'refus': {'mat': 'refus', 'pht': 4213, 'datou_carac_id': 3996, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus,textiles_sanitaires'}} 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 (1717453,1720479,1723798,1727107,1731438,1737644,1730602,1732874,1736986,1741841,1746198,1748712) 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': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0036259514391729967, 'nb_photo': 1464, 'list_port_cont': '21937821,21939162,21939746,21941786,21942286,21942545,21942710,21943656,21944041,21944452,21944820,21944855,21944892,21948133,21948695,21951644,21954467,21954496,21956205,21956628,21958502,21960306,21962713,21963637,21967999,21969915,21973608,21975500,21975800,21977007,21979024,21979274,21979535,21979655,21983684,21985983,21987573,21987720,21987872,21987946,21990023,21991769,21992349,21996567,21999338,22010235,22011237,22012691,22014637,22015182,22015551,22017043,22017719,22018831,22019753,22020338,22023199,22023576,22026668,22027911,22028244,22029160,22029547,22030585,22032219,22034518,22045009,22045689,22046693,22058371,22060010,22060506,22064295,22065836,22070523,22074309,22074597,22075130,22077647,22079377,22080316,22084405,22084634,22084988,22085191,22085969,22086025,22086284,22086482,22086650,22090031,22091707,22093507,22094152,22094324,22094865,22094927,22095329,22097423,22098375,22100503,22102638,22102822,22103160,22103411,22109929,22112127,22113927,22116306,22121011,22121552,22122289,22122747,2212308', 'assoc_port': '21936862:21944855,21936863:21944892,21936864:21944041,21936865:21942286,21936890:21937821,21936891:21942710,21938118:21939162,21939370:21939746,21941592:21941786,21942442:21942545,21943568:21943656,21944347:21944452,21944620:21944820,21947409:21948133,21947410:21956205,21948383:21948695,21951418:21951644,21954280:21954496,21954281:21954467,21956389:21956628,21958293:21958502,21960222:21960306,21962610:21962713,21963434:21963637,21967261:21979274,21967262:21979535,21967263:21967999,21967264:21979655,21967265:21987573,21967266:21987720,21967267:21987872,21969569:21969915,21972738:21975500,21972739:21973608,21975410:21991769,21975411:21990023,21975412:21977007,21975413:21979024,21975414:21975800,21980179:21987946,21982976:21983684,21985604:21985983,21991685:21992349,21996082:21996567,21998719:21999338,22009703:22017043,22009706:22019753,22009708:22015182,22009713:22011237,22009717:22014637,22009719:22010235,22009721:22018831,22012335:22012691,22015078:22015551,22017423:22017719,22019959:22020338,22023102:2202319', 'assoc_mat': '21936862:barquette_opaque:4213:21944855,21936863:barquette_opaque:4213:21944892,21936864:barquette_opaque:4213:21944041,21936865:barquette_opaque:4213:21942286,21936890:barquette_opaque:4213:21937821,21936891:barquette_opaque:4213:21942710,21938118:barquette_opaque:4213:21939162,21939370:barquette_opaque:4213:21939746,21941592:barquette_opaque:4213:21941786,21942442:barquette_opaque:4213:21942545,21943568:barquette_opaque:4213:21943656,21944347:barquette_opaque:4213:21944452,21944620:barquette_opaque:4213:21944820,21947409:barquette_opaque:4213:21948133,21947410:barquette_opaque:4213:21956205,21948383:barquette_opaque:4213:21948695,21951418:barquette_opaque:4213:21951644,21954280:barquette_opaque:4213:21954496,21954281:barquette_opaque:4213:21954467,21956389:barquette_opaque:4213:21956628,21958293:barquette_opaque:4213:21958502,21960222:barquette_opaque:4213:21960306,21962610:barquette_opaque:4213:21962713,21963434:barquette_opaque:4213:21963637,21967261:barquette_opaque:4213:21979274,21967262:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.010611299225962283, 'nb_photo': 3251, 'list_port_cont': '21937830,21939168,21939750,21941788,21942278,21942544,21942711,21943655,21944049,21944463,21944830,21944861,21944898,21948138,21948691,21951655,21954462,21954502,21956215,21956639,21958505,21960307,21962715,21963635,21967984,21969920,21973605,21975504,21975796,21977012,21979016,21979286,21979525,21979650,21983680,21985984,21987572,21987721,21987808,21987865,21987945,21990018,21991772,21992341,21996561,21999339,22010228,22011231,22012680,22014638,22015191,22017045,22017718,22018818,22019740,22020336,22023201,22023573,22026654,22027917,22028253,22029172,22029553,22030579,22032221,22034508,22045008,22045687,22046694,22058370,22059996,22060492,22064306,22065831,22070508,22074313,22074584,22075101,22077645,22079381,22080314,22084398,22084620,22084996,22085177,22085973,22086020,22086298,22086494,22086638,22090030,22091694,22093519,22094146,22094320,22094872,22094922,22095336,22097432,22098376,22100498,22102625,22102829,22103156,22103409,22112131,22113937,22114925,22116305,22119486,22121002,22121546,22122288,2212274', 'assoc_port': '21936862:21944861,21936863:21944898,21936864:21944049,21936865:21942278,21936890:21937830,21936891:21942711,21938118:21939168,21939370:21939750,21941592:21941788,21942442:21942544,21943568:21943655,21944347:21944463,21944620:21944830,21947409:21948138,21947410:21956215,21948383:21948691,21951418:21951655,21954280:21954502,21954281:21954462,21956389:21956639,21958293:21958505,21960222:21960307,21962610:21962715,21963434:21963635,21967261:21979286,21967262:21979525,21967263:21967984,21967264:21979650,21967265:21987572,21967266:21987721,21967267:21987865,21969569:21969920,21972738:21975504,21972739:21973605,21975410:21991772,21975411:21990018,21975412:21977012,21975413:21979016,21975414:21975796,21980179:21987945,21982976:21983680,21982979:21987808,21985604:21985984,21991685:21992341,21996082:21996561,21998719:21999339,22009703:22017045,22009706:22019740,22009708:22015191,22009713:22011231,22009717:22014638,22009719:22010228,22009721:22018818,22012335:22012680,22017423:22017718,22019959:22020336,22023102:2202320', 'assoc_mat': '21936862:carton:4213:21944861,21936863:carton:4213:21944898,21936864:carton:4213:21944049,21936865:carton:4213:21942278,21936890:carton:4213:21937830,21936891:carton:4213:21942711,21938118:carton:4213:21939168,21939370:carton:4213:21939750,21941592:carton:4213:21941788,21942442:carton:4213:21942544,21943568:carton:4213:21943655,21944347:carton:4213:21944463,21944620:carton:4213:21944830,21947409:carton:4213:21948138,21947410:carton:4213:21956215,21948383:carton:4213:21948691,21951418:carton:4213:21951655,21954280:carton:4213:21954502,21954281:carton:4213:21954462,21956389:carton:4213:21956639,21958293:carton:4213:21958505,21960222:carton:4213:21960307,21962610:carton:4213:21962715,21963434:carton:4213:21963635,21967261:carton:4213:21979286,21967262:carton:4213:21979525,21967263:carton:4213:21967984,21967264:carton:4213:21979650,21967265:carton:4213:21987572,21967266:carton:4213:21987721,21967267:carton:4213:21987865,21969569:carton:4213:21969920,21972738:carton:4213:21975504,21972739:carton:4213:21973605,2197'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004372334062955059, 'nb_photo': 604, 'list_port_cont': '21937831,21941796,21942272,21942537,21942703,21943662,21944052,21944458,21944822,21944854,21948129,21948689,21951651,21954503,21956208,21956635,21960314,21963647,21967988,21969913,21973614,21975505,21976999,21979279,21979536,21979646,21983690,21985981,21987578,21987867,21987935,21990017,21991770,21996565,21999346,22011243,22012678,22014630,22015180,22015560,22017033,22018822,22020328,22023196,22023575,22026665,22027913,22028257,22029170,22029557,22030582,22032209,22045010,22045686,22046701,22058376,22059998,22060503,22064292,22065827,22070515,22074324,22074595,22075134,22077650,22080318,22084401,22084631,22084985,22085180,22085984,22086019,22086293,22086480,22086634,22090027,22091701,22093514,22094153,22094332,22094864,22094926,22095342,22097420,22098380,22100495,22102624,22102832,22103165,22103410,22113928,22116309,22119484,22121014,22121559,22122285,22123086,22124873,22125554,22126584,22126690,22126845,22126961,22127652,22128291,22129044,22129626,22129869,22130939,22131812,22133803,22134655,22138672,2213914', 'assoc_port': '21936862:21944854,21936864:21944052,21936865:21942272,21936890:21937831,21936891:21942703,21941592:21941796,21942442:21942537,21943568:21943662,21944347:21944458,21944620:21944822,21947409:21948129,21947410:21956208,21948383:21948689,21951418:21951651,21954280:21954503,21956389:21956635,21960222:21960314,21963434:21963647,21967261:21979279,21967262:21979536,21967263:21967988,21967264:21979646,21967265:21987578,21967267:21987867,21969569:21969913,21972738:21975505,21972739:21973614,21975410:21991770,21975411:21990017,21975412:21976999,21980179:21987935,21982976:21983690,21985604:21985981,21996082:21996565,21998719:21999346,22009703:22017033,22009708:22015180,22009713:22011243,22009717:22014630,22009721:22018822,22012335:22012678,22015078:22015560,22019959:22020328,22023102:22023196,22023491:22023575,22025447:22026665,22026971:22027913,22028031:22029170,22028058:22028257,22029001:22030582,22029003:22029557,22031589:22032209,22042891:22046701,22042893:22045010,22045451:22045686,22057724:22086293,22057727:2208648', 'assoc_mat': '21936862:ela:4213:21944854,21936864:ela:4213:21944052,21936865:ela:4213:21942272,21936890:ela:4213:21937831,21936891:ela:4213:21942703,21941592:ela:4213:21941796,21942442:ela:4213:21942537,21943568:ela:4213:21943662,21944347:ela:4213:21944458,21944620:ela:4213:21944822,21947409:ela:4213:21948129,21947410:ela:4213:21956208,21948383:ela:4213:21948689,21951418:ela:4213:21951651,21954280:ela:4213:21954503,21956389:ela:4213:21956635,21960222:ela:4213:21960314,21963434:ela:4213:21963647,21967261:ela:4213:21979279,21967262:ela:4213:21979536,21967263:ela:4213:21967988,21967264:ela:4213:21979646,21967265:ela:4213:21987578,21967267:ela:4213:21987867,21969569:ela:4213:21969913,21972738:ela:4213:21975505,21972739:ela:4213:21973614,21975410:ela:4213:21991770,21975411:ela:4213:21990017,21975412:ela:4213:21976999,21980179:ela:4213:21987935,21982976:ela:4213:21983690,21985604:ela:4213:21985981,21996082:ela:4213:21996565,21998719:ela:4213:21999346,22009703:ela:4213:22017033,22009708:ela:4213:22015180,22009713:ela:4213:2201124'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0032912216512682177, 'nb_photo': 2323, 'list_port_cont': '21937832,21939163,21939737,21941797,21942271,21942543,21942714,21943657,21944045,21944459,21944829,21944866,21944889,21948137,21948682,21951643,21954468,21954505,21956210,21956629,21958503,21960317,21962726,21963646,21967993,21969912,21973603,21975499,21975794,21977009,21979027,21979287,21979521,21979647,21983235,21983683,21985972,21987576,21987718,21987859,21987931,21988184,21990028,21991774,21992347,21996570,21999347,22010232,22011229,22012692,22014636,22015186,22015549,22017041,22017725,22018819,22019747,22020332,22023191,22023569,22026667,22027922,22028246,22029158,22029558,22030590,22032218,22034519,22045012,22045693,22046695,22058361,22060000,22060494,22064296,22065830,22070524,22074314,22074600,22075097,22077644,22079375,22080315,22084402,22084627,22084990,22085185,22085982,22086029,22086294,22086495,22086637,22090022,22091700,22093522,22094150,22094318,22094869,22094925,22095338,22097435,22098368,22100494,22102630,22102821,22103161,22103405,22105542,22109942,22112132,22113938,22114921,22116301,2211949', 'assoc_port': '21936862:21944866,21936863:21944889,21936864:21944045,21936865:21942271,21936890:21937832,21936891:21942714,21938118:21939163,21939370:21939737,21941592:21941797,21942442:21942543,21943568:21943657,21944347:21944459,21944620:21944829,21947409:21948137,21947410:21956210,21948383:21948682,21951418:21951643,21954280:21954505,21954281:21954468,21956389:21956629,21958293:21958503,21960222:21960317,21962610:21962726,21963434:21963646,21967261:21979287,21967262:21979521,21967263:21967993,21967264:21979647,21967265:21987576,21967266:21987718,21967267:21987859,21969569:21969912,21972738:21975499,21972739:21973603,21975410:21991774,21975411:21990028,21975412:21977009,21975413:21979027,21975414:21975794,21980179:21987931,21982976:21983683,21982980:21983235,21985604:21985972,21987906:21988184,21991685:21992347,21996082:21996570,21998719:21999347,22009703:22017041,22009706:22019747,22009708:22015186,22009713:22011229,22009717:22014636,22009719:22010232,22009721:22018819,22012335:22012692,22015078:22015549,22017423:2201772', 'assoc_mat': '21936862:etiquette:4213:21944866,21936863:etiquette:4213:21944889,21936864:etiquette:4213:21944045,21936865:etiquette:4213:21942271,21936890:etiquette:4213:21937832,21936891:etiquette:4213:21942714,21938118:etiquette:4213:21939163,21939370:etiquette:4213:21939737,21941592:etiquette:4213:21941797,21942442:etiquette:4213:21942543,21943568:etiquette:4213:21943657,21944347:etiquette:4213:21944459,21944620:etiquette:4213:21944829,21947409:etiquette:4213:21948137,21947410:etiquette:4213:21956210,21948383:etiquette:4213:21948682,21951418:etiquette:4213:21951643,21954280:etiquette:4213:21954505,21954281:etiquette:4213:21954468,21956389:etiquette:4213:21956629,21958293:etiquette:4213:21958503,21960222:etiquette:4213:21960317,21962610:etiquette:4213:21962726,21963434:etiquette:4213:21963646,21967261:etiquette:4213:21979287,21967262:etiquette:4213:21979521,21967263:etiquette:4213:21967993,21967264:etiquette:4213:21979647,21967265:etiquette:4213:21987576,21967266:etiquette:4213:21987718,21967267:etiquette:4213:21987859,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.030953954960344525, 'nb_photo': 5515, 'list_port_cont': '21937818,21939175,21939740,21941790,21942276,21942534,21942712,21943653,21944044,21944468,21944823,21944853,21944888,21948124,21948693,21951647,21954463,21954509,21956213,21956627,21958510,21960322,21962720,21963644,21967985,21969910,21973618,21975498,21975790,21977000,21979018,21979275,21979534,21979651,21983681,21985975,21987570,21987715,21987869,21987944,21988183,21990029,21991760,21992348,21996564,21999336,22010236,22011230,22012677,22014626,22015181,22015557,22017038,22017717,22018823,22019748,22020339,22023185,22023578,22026660,22027910,22028259,22029156,22029548,22030581,22032222,22034504,22045004,22045697,22046692,22058377,22059997,22060495,22064308,22065842,22070511,22074318,22074591,22075114,22077649,22079385,22080321,22084413,22084626,22084984,22085181,22085983,22086021,22086297,22086493,22086636,22090018,22091697,22093521,22094147,22094330,22094866,22094935,22095339,22097424,22098377,22100501,22102629,22102818,22103159,22103399,22105538,22109933,22112116,22113931,22114919,22116315,22119498,2212101', 'assoc_port': '21936862:21944853,21936863:21944888,21936864:21944044,21936865:21942276,21936890:21937818,21936891:21942712,21938118:21939175,21939370:21939740,21941592:21941790,21942442:21942534,21943568:21943653,21944347:21944468,21944620:21944823,21947409:21948124,21947410:21956213,21948383:21948693,21951418:21951647,21954280:21954509,21954281:21954463,21956389:21956627,21958293:21958510,21960222:21960322,21962610:21962720,21963434:21963644,21967261:21979275,21967262:21979534,21967263:21967985,21967264:21979651,21967265:21987570,21967266:21987715,21967267:21987869,21969569:21969910,21972738:21975498,21972739:21973618,21975410:21991760,21975411:21990029,21975412:21977000,21975413:21979018,21975414:21975790,21980179:21987944,21982976:21983681,21985604:21985975,21987906:21988183,21991685:21992348,21996082:21996564,21998719:21999336,22009703:22017038,22009706:22019748,22009708:22015181,22009713:22011230,22009717:22014626,22009719:22010236,22009721:22018823,22012335:22012677,22015078:22015557,22017423:22017717,22019959:2202033', 'assoc_mat': '21936862:film_plastique:4213:21944853,21936863:film_plastique:4213:21944888,21936864:film_plastique:4213:21944044,21936865:film_plastique:4213:21942276,21936890:film_plastique:4213:21937818,21936891:film_plastique:4213:21942712,21938118:film_plastique:4213:21939175,21939370:film_plastique:4213:21939740,21941592:film_plastique:4213:21941790,21942442:film_plastique:4213:21942534,21943568:film_plastique:4213:21943653,21944347:film_plastique:4213:21944468,21944620:film_plastique:4213:21944823,21947409:film_plastique:4213:21948124,21947410:film_plastique:4213:21956213,21948383:film_plastique:4213:21948693,21951418:film_plastique:4213:21951647,21954280:film_plastique:4213:21954509,21954281:film_plastique:4213:21954463,21956389:film_plastique:4213:21956627,21958293:film_plastique:4213:21958510,21960222:film_plastique:4213:21960322,21962610:film_plastique:4213:21962720,21963434:film_plastique:4213:21963644,21967261:film_plastique:4213:21979275,21967262:film_plastique:4213:21979534,21967263:film_plastique:4213:2196798'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0006862562981866272, 'nb_photo': 17, 'list_port_cont': '21942277,21944864,21969916,21977011,22029157,22060502,22070520,22086299,22133800,22153448,22180796,22247645,22280370,22304598,22305928,22320011', 'assoc_port': '21936862:21944864,21936865:21942277,21969569:21969916,21975412:21977011,22028031:22029157,22057724:22086299,22057734:22060502,22070160:22070520,22092709:22133800,22138971:22180796,22153105:22153448,22247247:22247645,22279708:22280370,22304053:22304598,22305532:22305928,22319955:22320011', 'assoc_mat': '21936862:kraft:4213:21944864,21936865:kraft:4213:21942277,21969569:kraft:4213:21969916,21975412:kraft:4213:21977011,22028031:kraft:4213:22029157,22057724:kraft:4213:22086299,22057734:kraft:4213:22060502,22070160:kraft:4213:22070520,22092709:kraft:4213:22133800,22138971:kraft:4213:22180796,22153105:kraft:4213:22153448,22247247:kraft:4213:22247645,22279708:kraft:4213:22280370,22304053:kraft:4213:22304598,22305532:kraft:4213:22305928,22319955:kraft:4213:22320011'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.005094020948897741, 'nb_photo': 4185, 'list_port_cont': '21937823,21939172,21939743,21941800,21942284,21942538,21942715,21943658,21944046,21944467,21944818,21944867,21944903,21948132,21948687,21951656,21954476,21954497,21956207,21956640,21958507,21960308,21962716,21963642,21967989,21969909,21973613,21975490,21975798,21977010,21979020,21979280,21979527,21979658,21983688,21985969,21987565,21987729,21987875,21987941,21988187,21990016,21991766,21992355,21996563,21999334,22010225,22011232,22012682,22014625,22015189,22015556,22017035,22017721,22018816,22019743,22020331,22023198,22023570,22026658,22027914,22028250,22029162,22029545,22030586,22032211,22034515,22045015,22045695,22046690,22058373,22059995,22060496,22064297,22065832,22070518,22074320,22074593,22075132,22077657,22079383,22080324,22084403,22084633,22084989,22085176,22085975,22086028,22086283,22086484,22086642,22090024,22091698,22094143,22094326,22094871,22094934,22095344,22097430,22100496,22102633,22102831,22103154,22103401,22105540,22109937,22112130,22113940,22114920,22116307,22119495,22121006,22121251,2212228', 'assoc_port': '21936862:21944867,21936863:21944903,21936864:21944046,21936865:21942284,21936890:21937823,21936891:21942715,21938118:21939172,21939370:21939743,21941592:21941800,21942442:21942538,21943568:21943658,21944347:21944467,21944620:21944818,21947409:21948132,21947410:21956207,21948383:21948687,21951418:21951656,21954280:21954497,21954281:21954476,21956389:21956640,21958293:21958507,21960222:21960308,21962610:21962716,21963434:21963642,21967261:21979280,21967262:21979527,21967263:21967989,21967264:21979658,21967265:21987565,21967266:21987729,21967267:21987875,21969569:21969909,21972738:21975490,21972739:21973613,21975410:21991766,21975411:21990016,21975412:21977010,21975413:21979020,21975414:21975798,21980179:21987941,21982976:21983688,21985604:21985969,21987906:21988187,21991685:21992355,21996082:21996563,21998719:21999334,22009703:22017035,22009706:22019743,22009708:22015189,22009713:22011232,22009717:22014625,22009719:22010225,22009721:22018816,22012335:22012682,22015078:22015556,22017423:22017721,22019959:2202033', 'assoc_mat': '21936862:metal:4213:21944867,21936863:metal:4213:21944903,21936864:metal:4213:21944046,21936865:metal:4213:21942284,21936890:metal:4213:21937823,21936891:metal:4213:21942715,21938118:metal:4213:21939172,21939370:metal:4213:21939743,21941592:metal:4213:21941800,21942442:metal:4213:21942538,21943568:metal:4213:21943658,21944347:metal:4213:21944467,21944620:metal:4213:21944818,21947409:metal:4213:21948132,21947410:metal:4213:21956207,21948383:metal:4213:21948687,21951418:metal:4213:21951656,21954280:metal:4213:21954497,21954281:metal:4213:21954476,21956389:metal:4213:21956640,21958293:metal:4213:21958507,21960222:metal:4213:21960308,21962610:metal:4213:21962716,21963434:metal:4213:21963642,21967261:metal:4213:21979280,21967262:metal:4213:21979527,21967263:metal:4213:21967989,21967264:metal:4213:21979658,21967265:metal:4213:21987565,21967266:metal:4213:21987729,21967267:metal:4213:21987875,21969569:metal:4213:21969909,21972738:metal:4213:21975490,21972739:metal:4213:21973613,21975410:metal:4213:21991766,21975411:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03365947343582914, 'nb_photo': 12093, 'list_port_cont': '21937822,21939165,21939738,21941792,21942279,21942547,21942706,21943659,21944047,21944457,21944833,21944865,21944896,21948130,21948698,21951653,21954469,21954494,21956211,21956633,21958512,21960309,21962723,21963643,21967986,21969908,21973610,21975502,21975799,21977008,21979021,21979288,21979528,21979659,21983231,21983676,21985982,21987571,21987717,21987870,21987943,21988179,21990024,21991767,21992345,21996566,21999332,22010233,22011235,22012684,22014623,22015185,22015550,22017034,22017729,22018827,22019749,22020333,22023187,22023580,22026662,22027915,22028247,22029163,22029544,22030576,22032213,22034513,22045011,22045690,22046686,22058367,22060005,22060505,22064298,22065837,22070516,22074323,22074598,22075099,22077648,22079380,22080317,22084397,22084628,22084999,22085179,22085970,22086022,22086288,22086492,22086644,22090025,22091708,22093510,22094145,22094323,22094870,22094921,22095333,22097436,22098372,22100507,22102639,22102824,22103163,22103403,22105539,22109941,22112129,22113936,22114911,22116314,2211948', 'assoc_port': '21936862:21944865,21936863:21944896,21936864:21944047,21936865:21942279,21936890:21937822,21936891:21942706,21938118:21939165,21939370:21939738,21941592:21941792,21942442:21942547,21943568:21943659,21944347:21944457,21944620:21944833,21947409:21948130,21947410:21956211,21948383:21948698,21951418:21951653,21954280:21954494,21954281:21954469,21956389:21956633,21958293:21958512,21960222:21960309,21962610:21962723,21963434:21963643,21967261:21979288,21967262:21979528,21967263:21967986,21967264:21979659,21967265:21987571,21967266:21987717,21967267:21987870,21969569:21969908,21972738:21975502,21972739:21973610,21975410:21991767,21975411:21990024,21975412:21977008,21975413:21979021,21975414:21975799,21980179:21987943,21982976:21983676,21982980:21983231,21985604:21985982,21987906:21988179,21991685:21992345,21996082:21996566,21998719:21999332,22009703:22017034,22009706:22019749,22009708:22015185,22009713:22011235,22009717:22014623,22009719:22010233,22009721:22018827,22012335:22012684,22015078:22015550,22017423:2201772', 'assoc_mat': '21936862:papier:4213:21944865,21936863:papier:4213:21944896,21936864:papier:4213:21944047,21936865:papier:4213:21942279,21936890:papier:4213:21937822,21936891:papier:4213:21942706,21938118:papier:4213:21939165,21939370:papier:4213:21939738,21941592:papier:4213:21941792,21942442:papier:4213:21942547,21943568:papier:4213:21943659,21944347:papier:4213:21944457,21944620:papier:4213:21944833,21947409:papier:4213:21948130,21947410:papier:4213:21956211,21948383:papier:4213:21948698,21951418:papier:4213:21951653,21954280:papier:4213:21954494,21954281:papier:4213:21954469,21956389:papier:4213:21956633,21958293:papier:4213:21958512,21960222:papier:4213:21960309,21962610:papier:4213:21962723,21963434:papier:4213:21963643,21967261:papier:4213:21979288,21967262:papier:4213:21979528,21967263:papier:4213:21967986,21967264:papier:4213:21979659,21967265:papier:4213:21987571,21967266:papier:4213:21987717,21967267:papier:4213:21987870,21969569:papier:4213:21969908,21972738:papier:4213:21975502,21972739:papier:4213:21973610,2197'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0034273046877817564, 'nb_photo': 138, 'list_port_cont': '21937819,21939177,21942285,21942708,21944042,21944460,21944824,21948683,21951658,21956637,21962714,21963648,21975495,21975795,21979028,21979276,21979520,21985980,21987569,21987860,21987938,21990020,21996571,21999343,22015179,22015558,22017040,22018824,22023197,22028248,22029554,22045002,22064305,22065834,22070519,22074585,22075118,22080312,22084410,22085976,22086646,22091705,22098370,22100504,22105544,22109945,22119494,22128280,22131797,22133798,22134653,22139142,22139287,22141188,22146531,22148592,22165361,22179875,22182761,22188749,22190217,22193013,22194136,22195219,22202474,22213935,22214774,22217663,22223555,22225012,22228414,22230367,22236729,22246588,22254922,22256179,22257473,22263609,22269177,22269622,22284189,22290489,22307661,22313645,22313900,22315449,22316516,22318071,22319246,22325769', 'assoc_port': '21936864:21944042,21936865:21942285,21936890:21937819,21936891:21942708,21938118:21939177,21944347:21944460,21944620:21944824,21948383:21948683,21951418:21951658,21956389:21956637,21962610:21962714,21963434:21963648,21967261:21979276,21967262:21979520,21967265:21987569,21967267:21987860,21972738:21975495,21975411:21990020,21975413:21979028,21975414:21975795,21980179:21987938,21985604:21985980,21996082:21996571,21998719:21999343,22009703:22017040,22009708:22015179,22009721:22018824,22015078:22015558,22023102:22023197,22028058:22028248,22029003:22029554,22042893:22045002,22057731:22086646,22063485:22064305,22063486:22065834,22070160:22070519,22074228:22074585,22074777:22075118,22079656:22080312,22084255:22084410,22085752:22085976,22089599:22091705,22092708:22202474,22092709:22133798,22094020:22131797,22094044:22128280,22094629:22119494,22095493:22098370,22100172:22100504,22105374:22105544,22109636:22109945,22134348:22134653,22138964:22193013,22138966:22194136,22138968:22195219,22138969:22190217,22138970:2218874', 'assoc_mat': '21936864:pehd:4213:21944042,21936865:pehd:4213:21942285,21936890:pehd:4213:21937819,21936891:pehd:4213:21942708,21938118:pehd:4213:21939177,21944347:pehd:4213:21944460,21944620:pehd:4213:21944824,21948383:pehd:4213:21948683,21951418:pehd:4213:21951658,21956389:pehd:4213:21956637,21962610:pehd:4213:21962714,21963434:pehd:4213:21963648,21967261:pehd:4213:21979276,21967262:pehd:4213:21979520,21967265:pehd:4213:21987569,21967267:pehd:4213:21987860,21972738:pehd:4213:21975495,21975411:pehd:4213:21990020,21975413:pehd:4213:21979028,21975414:pehd:4213:21975795,21980179:pehd:4213:21987938,21985604:pehd:4213:21985980,21996082:pehd:4213:21996571,21998719:pehd:4213:21999343,22009703:pehd:4213:22017040,22009708:pehd:4213:22015179,22009721:pehd:4213:22018824,22015078:pehd:4213:22015558,22023102:pehd:4213:22023197,22028058:pehd:4213:22028248,22029003:pehd:4213:22029554,22042893:pehd:4213:22045002,22057731:pehd:4213:22086646,22063485:pehd:4213:22064305,22063486:pehd:4213:22065834,22070160:pehd:4213:22070519,22074228:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.019399044389187704, 'nb_photo': 7680, 'list_port_cont': '21937820,21939161,21939748,21941791,21942280,21942542,21942704,21943650,21944048,21944455,21944821,21944862,21944900,21948131,21948688,21951650,21954464,21954501,21956216,21956632,21958499,21960320,21962725,21963649,21967987,21969911,21973612,21975491,21975786,21977001,21979025,21979278,21979529,21979652,21983675,21985970,21987575,21987719,21987868,21987934,21988188,21990021,21991771,21992352,21996576,21999335,22010222,22011233,22012685,22014633,22015192,22015564,22017044,22017720,22018829,22019751,22020327,22023193,22023577,22026666,22027908,22028254,22029167,22029559,22030584,22032208,22034510,22045013,22045691,22046685,22058375,22060001,22060491,22064301,22065843,22070513,22074321,22074587,22075098,22077654,22079387,22080313,22084406,22084624,22084998,22085175,22085974,22086024,22086295,22086481,22086651,22090016,22091704,22093520,22094144,22094329,22094878,22094930,22095341,22097425,22098378,22100497,22102634,22102830,22103152,22103396,22105553,22109935,22112121,22113929,22114914,22116313,22119497,2212101', 'assoc_port': '21936862:21944862,21936863:21944900,21936864:21944048,21936865:21942280,21936890:21937820,21936891:21942704,21938118:21939161,21939370:21939748,21941592:21941791,21942442:21942542,21943568:21943650,21944347:21944455,21944620:21944821,21947409:21948131,21947410:21956216,21948383:21948688,21951418:21951650,21954280:21954501,21954281:21954464,21956389:21956632,21958293:21958499,21960222:21960320,21962610:21962725,21963434:21963649,21967261:21979278,21967262:21979529,21967263:21967987,21967264:21979652,21967265:21987575,21967266:21987719,21967267:21987868,21969569:21969911,21972738:21975491,21972739:21973612,21975410:21991771,21975411:21990021,21975412:21977001,21975413:21979025,21975414:21975786,21980179:21987934,21982976:21983675,21985604:21985970,21987906:21988188,21991685:21992352,21996082:21996576,21998719:21999335,22009703:22017044,22009706:22019751,22009708:22015192,22009713:22011233,22009717:22014633,22009719:22010222,22009721:22018829,22012335:22012685,22015078:22015564,22017423:22017720,22019959:2202032', 'assoc_mat': '21936862:pet_clair:4213:21944862,21936863:pet_clair:4213:21944900,21936864:pet_clair:4213:21944048,21936865:pet_clair:4213:21942280,21936890:pet_clair:4213:21937820,21936891:pet_clair:4213:21942704,21938118:pet_clair:4213:21939161,21939370:pet_clair:4213:21939748,21941592:pet_clair:4213:21941791,21942442:pet_clair:4213:21942542,21943568:pet_clair:4213:21943650,21944347:pet_clair:4213:21944455,21944620:pet_clair:4213:21944821,21947409:pet_clair:4213:21948131,21947410:pet_clair:4213:21956216,21948383:pet_clair:4213:21948688,21951418:pet_clair:4213:21951650,21954280:pet_clair:4213:21954501,21954281:pet_clair:4213:21954464,21956389:pet_clair:4213:21956632,21958293:pet_clair:4213:21958499,21960222:pet_clair:4213:21960320,21962610:pet_clair:4213:21962725,21963434:pet_clair:4213:21963649,21967261:pet_clair:4213:21979278,21967262:pet_clair:4213:21979529,21967263:pet_clair:4213:21967987,21967264:pet_clair:4213:21979652,21967265:pet_clair:4213:21987575,21967266:pet_clair:4213:21987719,21967267:pet_clair:4213:21987868,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0003673053480226979, 'nb_photo': 92, 'list_port_cont': '21941793,21942281,21942540,21954471,21954510,21956214,21962722,21963636,21967998,21973602,21975493,21975791,21979277,21979531,21987874,21996562,22020330,22029165,22045692,22060004,22060490,22079382,22086292,22091695,22094867,22094932,22095343,22098379,22121004,22122287,22123081,22125547,22126485,22126687,22128284,22129858,22130942,22133790,22135745,22139279,22140060,22141185,22145262,22160867,22162288,22167602,22168100,22169757,22182148,22188738,22199558,22211210,22216112,22236400,22239198,22239627,22241361,22242405,22247637,22260368,22263619,22264724,22290496,22291014,22297913,22305929,22313890,22314015,22314666,22318075,22319239,22323369,22325803', 'assoc_port': '21936865:21942281,21941592:21941793,21942442:21942540,21947410:21956214,21954280:21954510,21954281:21954471,21962610:21962722,21963434:21963636,21967261:21979277,21967262:21979531,21967263:21967998,21967267:21987874,21972738:21975493,21972739:21973602,21975414:21975791,21996082:21996562,22019959:22020330,22028031:22029165,22045451:22045692,22057724:22086292,22057734:22060490,22057755:22060004,22057757:22079382,22089599:22091695,22092709:22133790,22094022:22130942,22094023:22129858,22094044:22128284,22094047:22125547,22094625:22122287,22094627:22123081,22094628:22095343,22094631:22094867,22094632:22094932,22095493:22098379,22120872:22121004,22126300:22126687,22126302:22126485,22134336:22199558,22135490:22135745,22138970:22188738,22138972:22182148,22139004:22145262,22139005:22139279,22139818:22141185,22139820:22140060,22154430:22169757,22154432:22162288,22154433:22167602,22160729:22160867,22167880:22168100,22207453:22242405,22210764:22211210,22214430:22239627,22214455:22236400,22215256:22216112,22239054:2223919', 'assoc_mat': '21936865:pet_fonce:4213:21942281,21941592:pet_fonce:4213:21941793,21942442:pet_fonce:4213:21942540,21947410:pet_fonce:4213:21956214,21954280:pet_fonce:4213:21954510,21954281:pet_fonce:4213:21954471,21962610:pet_fonce:4213:21962722,21963434:pet_fonce:4213:21963636,21967261:pet_fonce:4213:21979277,21967262:pet_fonce:4213:21979531,21967263:pet_fonce:4213:21967998,21967267:pet_fonce:4213:21987874,21972738:pet_fonce:4213:21975493,21972739:pet_fonce:4213:21973602,21975414:pet_fonce:4213:21975791,21996082:pet_fonce:4213:21996562,22019959:pet_fonce:4213:22020330,22028031:pet_fonce:4213:22029165,22045451:pet_fonce:4213:22045692,22057724:pet_fonce:4213:22086292,22057734:pet_fonce:4213:22060490,22057755:pet_fonce:4213:22060004,22057757:pet_fonce:4213:22079382,22089599:pet_fonce:4213:22091695,22092709:pet_fonce:4213:22133790,22094022:pet_fonce:4213:22130942,22094023:pet_fonce:4213:22129858,22094044:pet_fonce:4213:22128284,22094047:pet_fonce:4213:22125547,22094625:pet_fonce:4213:22122287,22094627:pet_fonce:4213:22123081,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.011049132982557445, 'nb_photo': 3567, 'list_port_cont': '21937824,21939173,21939741,21941801,21942287,21942536,21942709,21943654,21944054,21944465,21944826,21944860,21944902,21948127,21948692,21951659,21954465,21954504,21956206,21956630,21958508,21960315,21962721,21963638,21967991,21969907,21973611,21975503,21975797,21977002,21979015,21979283,21979530,21979656,21983689,21985971,21987564,21987728,21987863,21987937,21988181,21990015,21991761,21992343,21996578,21999345,22010234,22011236,22012688,22014635,22015187,22015548,22017031,22017728,22018820,22019741,22020323,22023190,22023568,22026652,22027920,22028243,22029168,22029546,22030574,22032214,22034514,22045014,22045683,22046697,22058365,22060011,22060501,22064302,22065838,22070522,22074315,22074588,22075115,22077651,22079388,22080309,22084404,22084621,22084986,22085186,22085968,22086027,22086290,22086487,22086648,22090032,22091710,22094140,22094319,22094874,22094937,22095330,22098366,22100502,22102636,22102833,22103155,22103398,22105547,22109938,22112126,22113941,22114924,22116303,22119485,22121009,22121254,2212156', 'assoc_port': '21936862:21944860,21936863:21944902,21936864:21944054,21936865:21942287,21936890:21937824,21936891:21942709,21938118:21939173,21939370:21939741,21941592:21941801,21942442:21942536,21943568:21943654,21944347:21944465,21944620:21944826,21947409:21948127,21947410:21956206,21948383:21948692,21951418:21951659,21954280:21954504,21954281:21954465,21956389:21956630,21958293:21958508,21960222:21960315,21962610:21962721,21963434:21963638,21967261:21979283,21967262:21979530,21967263:21967991,21967264:21979656,21967265:21987564,21967266:21987728,21967267:21987863,21969569:21969907,21972738:21975503,21972739:21973611,21975410:21991761,21975411:21990015,21975412:21977002,21975413:21979015,21975414:21975797,21980179:21987937,21982976:21983689,21985604:21985971,21987906:21988181,21991685:21992343,21996082:21996578,21998719:21999345,22009703:22017031,22009706:22019741,22009708:22015187,22009713:22011236,22009717:22014635,22009719:22010234,22009721:22018820,22012335:22012688,22015078:22015548,22017423:22017728,22019959:2202032', 'assoc_mat': '21936862:pet_opaque:4213:21944860,21936863:pet_opaque:4213:21944902,21936864:pet_opaque:4213:21944054,21936865:pet_opaque:4213:21942287,21936890:pet_opaque:4213:21937824,21936891:pet_opaque:4213:21942709,21938118:pet_opaque:4213:21939173,21939370:pet_opaque:4213:21939741,21941592:pet_opaque:4213:21941801,21942442:pet_opaque:4213:21942536,21943568:pet_opaque:4213:21943654,21944347:pet_opaque:4213:21944465,21944620:pet_opaque:4213:21944826,21947409:pet_opaque:4213:21948127,21947410:pet_opaque:4213:21956206,21948383:pet_opaque:4213:21948692,21951418:pet_opaque:4213:21951659,21954280:pet_opaque:4213:21954504,21954281:pet_opaque:4213:21954465,21956389:pet_opaque:4213:21956630,21958293:pet_opaque:4213:21958508,21960222:pet_opaque:4213:21960315,21962610:pet_opaque:4213:21962721,21963434:pet_opaque:4213:21963638,21967261:pet_opaque:4213:21979283,21967262:pet_opaque:4213:21979530,21967263:pet_opaque:4213:21967991,21967264:pet_opaque:4213:21979656,21967265:pet_opaque:4213:21987564,21967266:pet_opaque:4213:21987728,2196'}) 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(1717453,1720479,1723798,1727107,1731438,1737644,1730602,1732874,1736986,1741841,1746198,1748712)); after get_hostname_from_raspi hasthag : refus hasthag that could be used but not yet : _______refus,textiles_sanitaires SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______refus' and mtr_portfolio_id in (select id FROM MTRUser.mtr_portfolios where mtr_user_id=983) and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=15 and date >='2025-04-01' and date <= '2025-04-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((9115,),), 'unwanted_material_monthly_percentage': ((0.09802385868001988,),), 'material_repartition': (('refus', 9115),), 'material_dict': {'refus': 9115}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 4, 1), 0.11460468725305437, 894), (datetime.date(2025, 4, 2), 0.11726475064195395, 1019), (datetime.date(2025, 4, 3), 0.1317384532765198, 599), (datetime.date(2025, 4, 4), 0.12057144704154915, 1027), (datetime.date(2025, 4, 5), 0.09638440804617232, 1164), (datetime.date(2025, 4, 6), 0.1089726231847114, 956), (datetime.date(2025, 4, 7), 0.08678144971511317, 790), (datetime.date(2025, 4, 8), 0.036396656068685904, 559), (datetime.date(2025, 4, 9), 0.03423259228417762, 518), (datetime.date(2025, 4, 10), 0.07760782828571101, 513), (datetime.date(2025, 4, 11), 0.11073619879711863, 634), (datetime.date(2025, 4, 12), 0.10553332424530643, 442)), 'impurety_average_data_per_hashtag': {'refus': ((datetime.date(2025, 4, 1), 0.11460468725305437, 894), (datetime.date(2025, 4, 2), 0.11726475064195395, 1019), (datetime.date(2025, 4, 3), 0.1317384532765198, 599), (datetime.date(2025, 4, 4), 0.12057144704154915, 1027), (datetime.date(2025, 4, 5), 0.09638440804617232, 1164), (datetime.date(2025, 4, 6), 0.1089726231847114, 956), (datetime.date(2025, 4, 7), 0.08678144971511317, 790), (datetime.date(2025, 4, 8), 0.036396656068685904, 559), (datetime.date(2025, 4, 9), 0.03423259228417762, 518), (datetime.date(2025, 4, 10), 0.07760782828571101, 513), (datetime.date(2025, 4, 11), 0.11073619879711863, 634), (datetime.date(2025, 4, 12), 0.10553332424530643, 442))}, 'quality_array': [['-2.4864147866338886', '01042025'], ['-2.472981252729084', '02042025'], ['-2.7700361824268755', '03042025'], ['-2.605520389538448', '04042025'], ['-1.6193297500421593', '05042025'], ['-2.143904061309393', '06042025'], ['-0.36412533426635646', '07042025'], ['1.7057616252768741', '08042025'], ['1.3326938767179237', '09042025'], ['-1.2052653772527304', '10042025'], ['-2.457757518443133', '11042025'], ['-2.4692444355529712', '12042025']], 'number_of_batch': ((285,),), 'datou_id_sts': 3142, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0036259514391729967, 'nb_photo': 1464, 'list_port_cont': '21937821,21939162,21939746,21941786,21942286,21942545,21942710,21943656,21944041,21944452,21944820,21944855,21944892,21948133,21948695,21951644,21954467,21954496,21956205,21956628,21958502,21960306,21962713,21963637,21967999,21969915,21973608,21975500,21975800,21977007,21979024,21979274,21979535,21979655,21983684,21985983,21987573,21987720,21987872,21987946,21990023,21991769,21992349,21996567,21999338,22010235,22011237,22012691,22014637,22015182,22015551,22017043,22017719,22018831,22019753,22020338,22023199,22023576,22026668,22027911,22028244,22029160,22029547,22030585,22032219,22034518,22045009,22045689,22046693,22058371,22060010,22060506,22064295,22065836,22070523,22074309,22074597,22075130,22077647,22079377,22080316,22084405,22084634,22084988,22085191,22085969,22086025,22086284,22086482,22086650,22090031,22091707,22093507,22094152,22094324,22094865,22094927,22095329,22097423,22098375,22100503,22102638,22102822,22103160,22103411,22109929,22112127,22113927,22116306,22121011,22121552,22122289,22122747,2212308', 'assoc_port': '21936862:21944855,21936863:21944892,21936864:21944041,21936865:21942286,21936890:21937821,21936891:21942710,21938118:21939162,21939370:21939746,21941592:21941786,21942442:21942545,21943568:21943656,21944347:21944452,21944620:21944820,21947409:21948133,21947410:21956205,21948383:21948695,21951418:21951644,21954280:21954496,21954281:21954467,21956389:21956628,21958293:21958502,21960222:21960306,21962610:21962713,21963434:21963637,21967261:21979274,21967262:21979535,21967263:21967999,21967264:21979655,21967265:21987573,21967266:21987720,21967267:21987872,21969569:21969915,21972738:21975500,21972739:21973608,21975410:21991769,21975411:21990023,21975412:21977007,21975413:21979024,21975414:21975800,21980179:21987946,21982976:21983684,21985604:21985983,21991685:21992349,21996082:21996567,21998719:21999338,22009703:22017043,22009706:22019753,22009708:22015182,22009713:22011237,22009717:22014637,22009719:22010235,22009721:22018831,22012335:22012691,22015078:22015551,22017423:22017719,22019959:22020338,22023102:2202319', 'assoc_mat': '21936862:barquette_opaque:4213:21944855,21936863:barquette_opaque:4213:21944892,21936864:barquette_opaque:4213:21944041,21936865:barquette_opaque:4213:21942286,21936890:barquette_opaque:4213:21937821,21936891:barquette_opaque:4213:21942710,21938118:barquette_opaque:4213:21939162,21939370:barquette_opaque:4213:21939746,21941592:barquette_opaque:4213:21941786,21942442:barquette_opaque:4213:21942545,21943568:barquette_opaque:4213:21943656,21944347:barquette_opaque:4213:21944452,21944620:barquette_opaque:4213:21944820,21947409:barquette_opaque:4213:21948133,21947410:barquette_opaque:4213:21956205,21948383:barquette_opaque:4213:21948695,21951418:barquette_opaque:4213:21951644,21954280:barquette_opaque:4213:21954496,21954281:barquette_opaque:4213:21954467,21956389:barquette_opaque:4213:21956628,21958293:barquette_opaque:4213:21958502,21960222:barquette_opaque:4213:21960306,21962610:barquette_opaque:4213:21962713,21963434:barquette_opaque:4213:21963637,21967261:barquette_opaque:4213:21979274,21967262:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.010611299225962283, 'nb_photo': 3251, 'list_port_cont': '21937830,21939168,21939750,21941788,21942278,21942544,21942711,21943655,21944049,21944463,21944830,21944861,21944898,21948138,21948691,21951655,21954462,21954502,21956215,21956639,21958505,21960307,21962715,21963635,21967984,21969920,21973605,21975504,21975796,21977012,21979016,21979286,21979525,21979650,21983680,21985984,21987572,21987721,21987808,21987865,21987945,21990018,21991772,21992341,21996561,21999339,22010228,22011231,22012680,22014638,22015191,22017045,22017718,22018818,22019740,22020336,22023201,22023573,22026654,22027917,22028253,22029172,22029553,22030579,22032221,22034508,22045008,22045687,22046694,22058370,22059996,22060492,22064306,22065831,22070508,22074313,22074584,22075101,22077645,22079381,22080314,22084398,22084620,22084996,22085177,22085973,22086020,22086298,22086494,22086638,22090030,22091694,22093519,22094146,22094320,22094872,22094922,22095336,22097432,22098376,22100498,22102625,22102829,22103156,22103409,22112131,22113937,22114925,22116305,22119486,22121002,22121546,22122288,2212274', 'assoc_port': '21936862:21944861,21936863:21944898,21936864:21944049,21936865:21942278,21936890:21937830,21936891:21942711,21938118:21939168,21939370:21939750,21941592:21941788,21942442:21942544,21943568:21943655,21944347:21944463,21944620:21944830,21947409:21948138,21947410:21956215,21948383:21948691,21951418:21951655,21954280:21954502,21954281:21954462,21956389:21956639,21958293:21958505,21960222:21960307,21962610:21962715,21963434:21963635,21967261:21979286,21967262:21979525,21967263:21967984,21967264:21979650,21967265:21987572,21967266:21987721,21967267:21987865,21969569:21969920,21972738:21975504,21972739:21973605,21975410:21991772,21975411:21990018,21975412:21977012,21975413:21979016,21975414:21975796,21980179:21987945,21982976:21983680,21982979:21987808,21985604:21985984,21991685:21992341,21996082:21996561,21998719:21999339,22009703:22017045,22009706:22019740,22009708:22015191,22009713:22011231,22009717:22014638,22009719:22010228,22009721:22018818,22012335:22012680,22017423:22017718,22019959:22020336,22023102:2202320', 'assoc_mat': '21936862:carton:4213:21944861,21936863:carton:4213:21944898,21936864:carton:4213:21944049,21936865:carton:4213:21942278,21936890:carton:4213:21937830,21936891:carton:4213:21942711,21938118:carton:4213:21939168,21939370:carton:4213:21939750,21941592:carton:4213:21941788,21942442:carton:4213:21942544,21943568:carton:4213:21943655,21944347:carton:4213:21944463,21944620:carton:4213:21944830,21947409:carton:4213:21948138,21947410:carton:4213:21956215,21948383:carton:4213:21948691,21951418:carton:4213:21951655,21954280:carton:4213:21954502,21954281:carton:4213:21954462,21956389:carton:4213:21956639,21958293:carton:4213:21958505,21960222:carton:4213:21960307,21962610:carton:4213:21962715,21963434:carton:4213:21963635,21967261:carton:4213:21979286,21967262:carton:4213:21979525,21967263:carton:4213:21967984,21967264:carton:4213:21979650,21967265:carton:4213:21987572,21967266:carton:4213:21987721,21967267:carton:4213:21987865,21969569:carton:4213:21969920,21972738:carton:4213:21975504,21972739:carton:4213:21973605,2197'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004372334062955059, 'nb_photo': 604, 'list_port_cont': '21937831,21941796,21942272,21942537,21942703,21943662,21944052,21944458,21944822,21944854,21948129,21948689,21951651,21954503,21956208,21956635,21960314,21963647,21967988,21969913,21973614,21975505,21976999,21979279,21979536,21979646,21983690,21985981,21987578,21987867,21987935,21990017,21991770,21996565,21999346,22011243,22012678,22014630,22015180,22015560,22017033,22018822,22020328,22023196,22023575,22026665,22027913,22028257,22029170,22029557,22030582,22032209,22045010,22045686,22046701,22058376,22059998,22060503,22064292,22065827,22070515,22074324,22074595,22075134,22077650,22080318,22084401,22084631,22084985,22085180,22085984,22086019,22086293,22086480,22086634,22090027,22091701,22093514,22094153,22094332,22094864,22094926,22095342,22097420,22098380,22100495,22102624,22102832,22103165,22103410,22113928,22116309,22119484,22121014,22121559,22122285,22123086,22124873,22125554,22126584,22126690,22126845,22126961,22127652,22128291,22129044,22129626,22129869,22130939,22131812,22133803,22134655,22138672,2213914', 'assoc_port': '21936862:21944854,21936864:21944052,21936865:21942272,21936890:21937831,21936891:21942703,21941592:21941796,21942442:21942537,21943568:21943662,21944347:21944458,21944620:21944822,21947409:21948129,21947410:21956208,21948383:21948689,21951418:21951651,21954280:21954503,21956389:21956635,21960222:21960314,21963434:21963647,21967261:21979279,21967262:21979536,21967263:21967988,21967264:21979646,21967265:21987578,21967267:21987867,21969569:21969913,21972738:21975505,21972739:21973614,21975410:21991770,21975411:21990017,21975412:21976999,21980179:21987935,21982976:21983690,21985604:21985981,21996082:21996565,21998719:21999346,22009703:22017033,22009708:22015180,22009713:22011243,22009717:22014630,22009721:22018822,22012335:22012678,22015078:22015560,22019959:22020328,22023102:22023196,22023491:22023575,22025447:22026665,22026971:22027913,22028031:22029170,22028058:22028257,22029001:22030582,22029003:22029557,22031589:22032209,22042891:22046701,22042893:22045010,22045451:22045686,22057724:22086293,22057727:2208648', 'assoc_mat': '21936862:ela:4213:21944854,21936864:ela:4213:21944052,21936865:ela:4213:21942272,21936890:ela:4213:21937831,21936891:ela:4213:21942703,21941592:ela:4213:21941796,21942442:ela:4213:21942537,21943568:ela:4213:21943662,21944347:ela:4213:21944458,21944620:ela:4213:21944822,21947409:ela:4213:21948129,21947410:ela:4213:21956208,21948383:ela:4213:21948689,21951418:ela:4213:21951651,21954280:ela:4213:21954503,21956389:ela:4213:21956635,21960222:ela:4213:21960314,21963434:ela:4213:21963647,21967261:ela:4213:21979279,21967262:ela:4213:21979536,21967263:ela:4213:21967988,21967264:ela:4213:21979646,21967265:ela:4213:21987578,21967267:ela:4213:21987867,21969569:ela:4213:21969913,21972738:ela:4213:21975505,21972739:ela:4213:21973614,21975410:ela:4213:21991770,21975411:ela:4213:21990017,21975412:ela:4213:21976999,21980179:ela:4213:21987935,21982976:ela:4213:21983690,21985604:ela:4213:21985981,21996082:ela:4213:21996565,21998719:ela:4213:21999346,22009703:ela:4213:22017033,22009708:ela:4213:22015180,22009713:ela:4213:2201124'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0032912216512682177, 'nb_photo': 2323, 'list_port_cont': '21937832,21939163,21939737,21941797,21942271,21942543,21942714,21943657,21944045,21944459,21944829,21944866,21944889,21948137,21948682,21951643,21954468,21954505,21956210,21956629,21958503,21960317,21962726,21963646,21967993,21969912,21973603,21975499,21975794,21977009,21979027,21979287,21979521,21979647,21983235,21983683,21985972,21987576,21987718,21987859,21987931,21988184,21990028,21991774,21992347,21996570,21999347,22010232,22011229,22012692,22014636,22015186,22015549,22017041,22017725,22018819,22019747,22020332,22023191,22023569,22026667,22027922,22028246,22029158,22029558,22030590,22032218,22034519,22045012,22045693,22046695,22058361,22060000,22060494,22064296,22065830,22070524,22074314,22074600,22075097,22077644,22079375,22080315,22084402,22084627,22084990,22085185,22085982,22086029,22086294,22086495,22086637,22090022,22091700,22093522,22094150,22094318,22094869,22094925,22095338,22097435,22098368,22100494,22102630,22102821,22103161,22103405,22105542,22109942,22112132,22113938,22114921,22116301,2211949', 'assoc_port': '21936862:21944866,21936863:21944889,21936864:21944045,21936865:21942271,21936890:21937832,21936891:21942714,21938118:21939163,21939370:21939737,21941592:21941797,21942442:21942543,21943568:21943657,21944347:21944459,21944620:21944829,21947409:21948137,21947410:21956210,21948383:21948682,21951418:21951643,21954280:21954505,21954281:21954468,21956389:21956629,21958293:21958503,21960222:21960317,21962610:21962726,21963434:21963646,21967261:21979287,21967262:21979521,21967263:21967993,21967264:21979647,21967265:21987576,21967266:21987718,21967267:21987859,21969569:21969912,21972738:21975499,21972739:21973603,21975410:21991774,21975411:21990028,21975412:21977009,21975413:21979027,21975414:21975794,21980179:21987931,21982976:21983683,21982980:21983235,21985604:21985972,21987906:21988184,21991685:21992347,21996082:21996570,21998719:21999347,22009703:22017041,22009706:22019747,22009708:22015186,22009713:22011229,22009717:22014636,22009719:22010232,22009721:22018819,22012335:22012692,22015078:22015549,22017423:2201772', 'assoc_mat': '21936862:etiquette:4213:21944866,21936863:etiquette:4213:21944889,21936864:etiquette:4213:21944045,21936865:etiquette:4213:21942271,21936890:etiquette:4213:21937832,21936891:etiquette:4213:21942714,21938118:etiquette:4213:21939163,21939370:etiquette:4213:21939737,21941592:etiquette:4213:21941797,21942442:etiquette:4213:21942543,21943568:etiquette:4213:21943657,21944347:etiquette:4213:21944459,21944620:etiquette:4213:21944829,21947409:etiquette:4213:21948137,21947410:etiquette:4213:21956210,21948383:etiquette:4213:21948682,21951418:etiquette:4213:21951643,21954280:etiquette:4213:21954505,21954281:etiquette:4213:21954468,21956389:etiquette:4213:21956629,21958293:etiquette:4213:21958503,21960222:etiquette:4213:21960317,21962610:etiquette:4213:21962726,21963434:etiquette:4213:21963646,21967261:etiquette:4213:21979287,21967262:etiquette:4213:21979521,21967263:etiquette:4213:21967993,21967264:etiquette:4213:21979647,21967265:etiquette:4213:21987576,21967266:etiquette:4213:21987718,21967267:etiquette:4213:21987859,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.030953954960344525, 'nb_photo': 5515, 'list_port_cont': '21937818,21939175,21939740,21941790,21942276,21942534,21942712,21943653,21944044,21944468,21944823,21944853,21944888,21948124,21948693,21951647,21954463,21954509,21956213,21956627,21958510,21960322,21962720,21963644,21967985,21969910,21973618,21975498,21975790,21977000,21979018,21979275,21979534,21979651,21983681,21985975,21987570,21987715,21987869,21987944,21988183,21990029,21991760,21992348,21996564,21999336,22010236,22011230,22012677,22014626,22015181,22015557,22017038,22017717,22018823,22019748,22020339,22023185,22023578,22026660,22027910,22028259,22029156,22029548,22030581,22032222,22034504,22045004,22045697,22046692,22058377,22059997,22060495,22064308,22065842,22070511,22074318,22074591,22075114,22077649,22079385,22080321,22084413,22084626,22084984,22085181,22085983,22086021,22086297,22086493,22086636,22090018,22091697,22093521,22094147,22094330,22094866,22094935,22095339,22097424,22098377,22100501,22102629,22102818,22103159,22103399,22105538,22109933,22112116,22113931,22114919,22116315,22119498,2212101', 'assoc_port': '21936862:21944853,21936863:21944888,21936864:21944044,21936865:21942276,21936890:21937818,21936891:21942712,21938118:21939175,21939370:21939740,21941592:21941790,21942442:21942534,21943568:21943653,21944347:21944468,21944620:21944823,21947409:21948124,21947410:21956213,21948383:21948693,21951418:21951647,21954280:21954509,21954281:21954463,21956389:21956627,21958293:21958510,21960222:21960322,21962610:21962720,21963434:21963644,21967261:21979275,21967262:21979534,21967263:21967985,21967264:21979651,21967265:21987570,21967266:21987715,21967267:21987869,21969569:21969910,21972738:21975498,21972739:21973618,21975410:21991760,21975411:21990029,21975412:21977000,21975413:21979018,21975414:21975790,21980179:21987944,21982976:21983681,21985604:21985975,21987906:21988183,21991685:21992348,21996082:21996564,21998719:21999336,22009703:22017038,22009706:22019748,22009708:22015181,22009713:22011230,22009717:22014626,22009719:22010236,22009721:22018823,22012335:22012677,22015078:22015557,22017423:22017717,22019959:2202033', 'assoc_mat': '21936862:film_plastique:4213:21944853,21936863:film_plastique:4213:21944888,21936864:film_plastique:4213:21944044,21936865:film_plastique:4213:21942276,21936890:film_plastique:4213:21937818,21936891:film_plastique:4213:21942712,21938118:film_plastique:4213:21939175,21939370:film_plastique:4213:21939740,21941592:film_plastique:4213:21941790,21942442:film_plastique:4213:21942534,21943568:film_plastique:4213:21943653,21944347:film_plastique:4213:21944468,21944620:film_plastique:4213:21944823,21947409:film_plastique:4213:21948124,21947410:film_plastique:4213:21956213,21948383:film_plastique:4213:21948693,21951418:film_plastique:4213:21951647,21954280:film_plastique:4213:21954509,21954281:film_plastique:4213:21954463,21956389:film_plastique:4213:21956627,21958293:film_plastique:4213:21958510,21960222:film_plastique:4213:21960322,21962610:film_plastique:4213:21962720,21963434:film_plastique:4213:21963644,21967261:film_plastique:4213:21979275,21967262:film_plastique:4213:21979534,21967263:film_plastique:4213:2196798'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0006862562981866272, 'nb_photo': 17, 'list_port_cont': '21942277,21944864,21969916,21977011,22029157,22060502,22070520,22086299,22133800,22153448,22180796,22247645,22280370,22304598,22305928,22320011', 'assoc_port': '21936862:21944864,21936865:21942277,21969569:21969916,21975412:21977011,22028031:22029157,22057724:22086299,22057734:22060502,22070160:22070520,22092709:22133800,22138971:22180796,22153105:22153448,22247247:22247645,22279708:22280370,22304053:22304598,22305532:22305928,22319955:22320011', 'assoc_mat': '21936862:kraft:4213:21944864,21936865:kraft:4213:21942277,21969569:kraft:4213:21969916,21975412:kraft:4213:21977011,22028031:kraft:4213:22029157,22057724:kraft:4213:22086299,22057734:kraft:4213:22060502,22070160:kraft:4213:22070520,22092709:kraft:4213:22133800,22138971:kraft:4213:22180796,22153105:kraft:4213:22153448,22247247:kraft:4213:22247645,22279708:kraft:4213:22280370,22304053:kraft:4213:22304598,22305532:kraft:4213:22305928,22319955:kraft:4213:22320011'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.005094020948897741, 'nb_photo': 4185, 'list_port_cont': '21937823,21939172,21939743,21941800,21942284,21942538,21942715,21943658,21944046,21944467,21944818,21944867,21944903,21948132,21948687,21951656,21954476,21954497,21956207,21956640,21958507,21960308,21962716,21963642,21967989,21969909,21973613,21975490,21975798,21977010,21979020,21979280,21979527,21979658,21983688,21985969,21987565,21987729,21987875,21987941,21988187,21990016,21991766,21992355,21996563,21999334,22010225,22011232,22012682,22014625,22015189,22015556,22017035,22017721,22018816,22019743,22020331,22023198,22023570,22026658,22027914,22028250,22029162,22029545,22030586,22032211,22034515,22045015,22045695,22046690,22058373,22059995,22060496,22064297,22065832,22070518,22074320,22074593,22075132,22077657,22079383,22080324,22084403,22084633,22084989,22085176,22085975,22086028,22086283,22086484,22086642,22090024,22091698,22094143,22094326,22094871,22094934,22095344,22097430,22100496,22102633,22102831,22103154,22103401,22105540,22109937,22112130,22113940,22114920,22116307,22119495,22121006,22121251,2212228', 'assoc_port': '21936862:21944867,21936863:21944903,21936864:21944046,21936865:21942284,21936890:21937823,21936891:21942715,21938118:21939172,21939370:21939743,21941592:21941800,21942442:21942538,21943568:21943658,21944347:21944467,21944620:21944818,21947409:21948132,21947410:21956207,21948383:21948687,21951418:21951656,21954280:21954497,21954281:21954476,21956389:21956640,21958293:21958507,21960222:21960308,21962610:21962716,21963434:21963642,21967261:21979280,21967262:21979527,21967263:21967989,21967264:21979658,21967265:21987565,21967266:21987729,21967267:21987875,21969569:21969909,21972738:21975490,21972739:21973613,21975410:21991766,21975411:21990016,21975412:21977010,21975413:21979020,21975414:21975798,21980179:21987941,21982976:21983688,21985604:21985969,21987906:21988187,21991685:21992355,21996082:21996563,21998719:21999334,22009703:22017035,22009706:22019743,22009708:22015189,22009713:22011232,22009717:22014625,22009719:22010225,22009721:22018816,22012335:22012682,22015078:22015556,22017423:22017721,22019959:2202033', 'assoc_mat': '21936862:metal:4213:21944867,21936863:metal:4213:21944903,21936864:metal:4213:21944046,21936865:metal:4213:21942284,21936890:metal:4213:21937823,21936891:metal:4213:21942715,21938118:metal:4213:21939172,21939370:metal:4213:21939743,21941592:metal:4213:21941800,21942442:metal:4213:21942538,21943568:metal:4213:21943658,21944347:metal:4213:21944467,21944620:metal:4213:21944818,21947409:metal:4213:21948132,21947410:metal:4213:21956207,21948383:metal:4213:21948687,21951418:metal:4213:21951656,21954280:metal:4213:21954497,21954281:metal:4213:21954476,21956389:metal:4213:21956640,21958293:metal:4213:21958507,21960222:metal:4213:21960308,21962610:metal:4213:21962716,21963434:metal:4213:21963642,21967261:metal:4213:21979280,21967262:metal:4213:21979527,21967263:metal:4213:21967989,21967264:metal:4213:21979658,21967265:metal:4213:21987565,21967266:metal:4213:21987729,21967267:metal:4213:21987875,21969569:metal:4213:21969909,21972738:metal:4213:21975490,21972739:metal:4213:21973613,21975410:metal:4213:21991766,21975411:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03365947343582914, 'nb_photo': 12093, 'list_port_cont': '21937822,21939165,21939738,21941792,21942279,21942547,21942706,21943659,21944047,21944457,21944833,21944865,21944896,21948130,21948698,21951653,21954469,21954494,21956211,21956633,21958512,21960309,21962723,21963643,21967986,21969908,21973610,21975502,21975799,21977008,21979021,21979288,21979528,21979659,21983231,21983676,21985982,21987571,21987717,21987870,21987943,21988179,21990024,21991767,21992345,21996566,21999332,22010233,22011235,22012684,22014623,22015185,22015550,22017034,22017729,22018827,22019749,22020333,22023187,22023580,22026662,22027915,22028247,22029163,22029544,22030576,22032213,22034513,22045011,22045690,22046686,22058367,22060005,22060505,22064298,22065837,22070516,22074323,22074598,22075099,22077648,22079380,22080317,22084397,22084628,22084999,22085179,22085970,22086022,22086288,22086492,22086644,22090025,22091708,22093510,22094145,22094323,22094870,22094921,22095333,22097436,22098372,22100507,22102639,22102824,22103163,22103403,22105539,22109941,22112129,22113936,22114911,22116314,2211948', 'assoc_port': '21936862:21944865,21936863:21944896,21936864:21944047,21936865:21942279,21936890:21937822,21936891:21942706,21938118:21939165,21939370:21939738,21941592:21941792,21942442:21942547,21943568:21943659,21944347:21944457,21944620:21944833,21947409:21948130,21947410:21956211,21948383:21948698,21951418:21951653,21954280:21954494,21954281:21954469,21956389:21956633,21958293:21958512,21960222:21960309,21962610:21962723,21963434:21963643,21967261:21979288,21967262:21979528,21967263:21967986,21967264:21979659,21967265:21987571,21967266:21987717,21967267:21987870,21969569:21969908,21972738:21975502,21972739:21973610,21975410:21991767,21975411:21990024,21975412:21977008,21975413:21979021,21975414:21975799,21980179:21987943,21982976:21983676,21982980:21983231,21985604:21985982,21987906:21988179,21991685:21992345,21996082:21996566,21998719:21999332,22009703:22017034,22009706:22019749,22009708:22015185,22009713:22011235,22009717:22014623,22009719:22010233,22009721:22018827,22012335:22012684,22015078:22015550,22017423:2201772', 'assoc_mat': '21936862:papier:4213:21944865,21936863:papier:4213:21944896,21936864:papier:4213:21944047,21936865:papier:4213:21942279,21936890:papier:4213:21937822,21936891:papier:4213:21942706,21938118:papier:4213:21939165,21939370:papier:4213:21939738,21941592:papier:4213:21941792,21942442:papier:4213:21942547,21943568:papier:4213:21943659,21944347:papier:4213:21944457,21944620:papier:4213:21944833,21947409:papier:4213:21948130,21947410:papier:4213:21956211,21948383:papier:4213:21948698,21951418:papier:4213:21951653,21954280:papier:4213:21954494,21954281:papier:4213:21954469,21956389:papier:4213:21956633,21958293:papier:4213:21958512,21960222:papier:4213:21960309,21962610:papier:4213:21962723,21963434:papier:4213:21963643,21967261:papier:4213:21979288,21967262:papier:4213:21979528,21967263:papier:4213:21967986,21967264:papier:4213:21979659,21967265:papier:4213:21987571,21967266:papier:4213:21987717,21967267:papier:4213:21987870,21969569:papier:4213:21969908,21972738:papier:4213:21975502,21972739:papier:4213:21973610,2197'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0034273046877817564, 'nb_photo': 138, 'list_port_cont': '21937819,21939177,21942285,21942708,21944042,21944460,21944824,21948683,21951658,21956637,21962714,21963648,21975495,21975795,21979028,21979276,21979520,21985980,21987569,21987860,21987938,21990020,21996571,21999343,22015179,22015558,22017040,22018824,22023197,22028248,22029554,22045002,22064305,22065834,22070519,22074585,22075118,22080312,22084410,22085976,22086646,22091705,22098370,22100504,22105544,22109945,22119494,22128280,22131797,22133798,22134653,22139142,22139287,22141188,22146531,22148592,22165361,22179875,22182761,22188749,22190217,22193013,22194136,22195219,22202474,22213935,22214774,22217663,22223555,22225012,22228414,22230367,22236729,22246588,22254922,22256179,22257473,22263609,22269177,22269622,22284189,22290489,22307661,22313645,22313900,22315449,22316516,22318071,22319246,22325769', 'assoc_port': '21936864:21944042,21936865:21942285,21936890:21937819,21936891:21942708,21938118:21939177,21944347:21944460,21944620:21944824,21948383:21948683,21951418:21951658,21956389:21956637,21962610:21962714,21963434:21963648,21967261:21979276,21967262:21979520,21967265:21987569,21967267:21987860,21972738:21975495,21975411:21990020,21975413:21979028,21975414:21975795,21980179:21987938,21985604:21985980,21996082:21996571,21998719:21999343,22009703:22017040,22009708:22015179,22009721:22018824,22015078:22015558,22023102:22023197,22028058:22028248,22029003:22029554,22042893:22045002,22057731:22086646,22063485:22064305,22063486:22065834,22070160:22070519,22074228:22074585,22074777:22075118,22079656:22080312,22084255:22084410,22085752:22085976,22089599:22091705,22092708:22202474,22092709:22133798,22094020:22131797,22094044:22128280,22094629:22119494,22095493:22098370,22100172:22100504,22105374:22105544,22109636:22109945,22134348:22134653,22138964:22193013,22138966:22194136,22138968:22195219,22138969:22190217,22138970:2218874', 'assoc_mat': '21936864:pehd:4213:21944042,21936865:pehd:4213:21942285,21936890:pehd:4213:21937819,21936891:pehd:4213:21942708,21938118:pehd:4213:21939177,21944347:pehd:4213:21944460,21944620:pehd:4213:21944824,21948383:pehd:4213:21948683,21951418:pehd:4213:21951658,21956389:pehd:4213:21956637,21962610:pehd:4213:21962714,21963434:pehd:4213:21963648,21967261:pehd:4213:21979276,21967262:pehd:4213:21979520,21967265:pehd:4213:21987569,21967267:pehd:4213:21987860,21972738:pehd:4213:21975495,21975411:pehd:4213:21990020,21975413:pehd:4213:21979028,21975414:pehd:4213:21975795,21980179:pehd:4213:21987938,21985604:pehd:4213:21985980,21996082:pehd:4213:21996571,21998719:pehd:4213:21999343,22009703:pehd:4213:22017040,22009708:pehd:4213:22015179,22009721:pehd:4213:22018824,22015078:pehd:4213:22015558,22023102:pehd:4213:22023197,22028058:pehd:4213:22028248,22029003:pehd:4213:22029554,22042893:pehd:4213:22045002,22057731:pehd:4213:22086646,22063485:pehd:4213:22064305,22063486:pehd:4213:22065834,22070160:pehd:4213:22070519,22074228:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.019399044389187704, 'nb_photo': 7680, 'list_port_cont': '21937820,21939161,21939748,21941791,21942280,21942542,21942704,21943650,21944048,21944455,21944821,21944862,21944900,21948131,21948688,21951650,21954464,21954501,21956216,21956632,21958499,21960320,21962725,21963649,21967987,21969911,21973612,21975491,21975786,21977001,21979025,21979278,21979529,21979652,21983675,21985970,21987575,21987719,21987868,21987934,21988188,21990021,21991771,21992352,21996576,21999335,22010222,22011233,22012685,22014633,22015192,22015564,22017044,22017720,22018829,22019751,22020327,22023193,22023577,22026666,22027908,22028254,22029167,22029559,22030584,22032208,22034510,22045013,22045691,22046685,22058375,22060001,22060491,22064301,22065843,22070513,22074321,22074587,22075098,22077654,22079387,22080313,22084406,22084624,22084998,22085175,22085974,22086024,22086295,22086481,22086651,22090016,22091704,22093520,22094144,22094329,22094878,22094930,22095341,22097425,22098378,22100497,22102634,22102830,22103152,22103396,22105553,22109935,22112121,22113929,22114914,22116313,22119497,2212101', 'assoc_port': '21936862:21944862,21936863:21944900,21936864:21944048,21936865:21942280,21936890:21937820,21936891:21942704,21938118:21939161,21939370:21939748,21941592:21941791,21942442:21942542,21943568:21943650,21944347:21944455,21944620:21944821,21947409:21948131,21947410:21956216,21948383:21948688,21951418:21951650,21954280:21954501,21954281:21954464,21956389:21956632,21958293:21958499,21960222:21960320,21962610:21962725,21963434:21963649,21967261:21979278,21967262:21979529,21967263:21967987,21967264:21979652,21967265:21987575,21967266:21987719,21967267:21987868,21969569:21969911,21972738:21975491,21972739:21973612,21975410:21991771,21975411:21990021,21975412:21977001,21975413:21979025,21975414:21975786,21980179:21987934,21982976:21983675,21985604:21985970,21987906:21988188,21991685:21992352,21996082:21996576,21998719:21999335,22009703:22017044,22009706:22019751,22009708:22015192,22009713:22011233,22009717:22014633,22009719:22010222,22009721:22018829,22012335:22012685,22015078:22015564,22017423:22017720,22019959:2202032', 'assoc_mat': '21936862:pet_clair:4213:21944862,21936863:pet_clair:4213:21944900,21936864:pet_clair:4213:21944048,21936865:pet_clair:4213:21942280,21936890:pet_clair:4213:21937820,21936891:pet_clair:4213:21942704,21938118:pet_clair:4213:21939161,21939370:pet_clair:4213:21939748,21941592:pet_clair:4213:21941791,21942442:pet_clair:4213:21942542,21943568:pet_clair:4213:21943650,21944347:pet_clair:4213:21944455,21944620:pet_clair:4213:21944821,21947409:pet_clair:4213:21948131,21947410:pet_clair:4213:21956216,21948383:pet_clair:4213:21948688,21951418:pet_clair:4213:21951650,21954280:pet_clair:4213:21954501,21954281:pet_clair:4213:21954464,21956389:pet_clair:4213:21956632,21958293:pet_clair:4213:21958499,21960222:pet_clair:4213:21960320,21962610:pet_clair:4213:21962725,21963434:pet_clair:4213:21963649,21967261:pet_clair:4213:21979278,21967262:pet_clair:4213:21979529,21967263:pet_clair:4213:21967987,21967264:pet_clair:4213:21979652,21967265:pet_clair:4213:21987575,21967266:pet_clair:4213:21987719,21967267:pet_clair:4213:21987868,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0003673053480226979, 'nb_photo': 92, 'list_port_cont': '21941793,21942281,21942540,21954471,21954510,21956214,21962722,21963636,21967998,21973602,21975493,21975791,21979277,21979531,21987874,21996562,22020330,22029165,22045692,22060004,22060490,22079382,22086292,22091695,22094867,22094932,22095343,22098379,22121004,22122287,22123081,22125547,22126485,22126687,22128284,22129858,22130942,22133790,22135745,22139279,22140060,22141185,22145262,22160867,22162288,22167602,22168100,22169757,22182148,22188738,22199558,22211210,22216112,22236400,22239198,22239627,22241361,22242405,22247637,22260368,22263619,22264724,22290496,22291014,22297913,22305929,22313890,22314015,22314666,22318075,22319239,22323369,22325803', 'assoc_port': '21936865:21942281,21941592:21941793,21942442:21942540,21947410:21956214,21954280:21954510,21954281:21954471,21962610:21962722,21963434:21963636,21967261:21979277,21967262:21979531,21967263:21967998,21967267:21987874,21972738:21975493,21972739:21973602,21975414:21975791,21996082:21996562,22019959:22020330,22028031:22029165,22045451:22045692,22057724:22086292,22057734:22060490,22057755:22060004,22057757:22079382,22089599:22091695,22092709:22133790,22094022:22130942,22094023:22129858,22094044:22128284,22094047:22125547,22094625:22122287,22094627:22123081,22094628:22095343,22094631:22094867,22094632:22094932,22095493:22098379,22120872:22121004,22126300:22126687,22126302:22126485,22134336:22199558,22135490:22135745,22138970:22188738,22138972:22182148,22139004:22145262,22139005:22139279,22139818:22141185,22139820:22140060,22154430:22169757,22154432:22162288,22154433:22167602,22160729:22160867,22167880:22168100,22207453:22242405,22210764:22211210,22214430:22239627,22214455:22236400,22215256:22216112,22239054:2223919', 'assoc_mat': '21936865:pet_fonce:4213:21942281,21941592:pet_fonce:4213:21941793,21942442:pet_fonce:4213:21942540,21947410:pet_fonce:4213:21956214,21954280:pet_fonce:4213:21954510,21954281:pet_fonce:4213:21954471,21962610:pet_fonce:4213:21962722,21963434:pet_fonce:4213:21963636,21967261:pet_fonce:4213:21979277,21967262:pet_fonce:4213:21979531,21967263:pet_fonce:4213:21967998,21967267:pet_fonce:4213:21987874,21972738:pet_fonce:4213:21975493,21972739:pet_fonce:4213:21973602,21975414:pet_fonce:4213:21975791,21996082:pet_fonce:4213:21996562,22019959:pet_fonce:4213:22020330,22028031:pet_fonce:4213:22029165,22045451:pet_fonce:4213:22045692,22057724:pet_fonce:4213:22086292,22057734:pet_fonce:4213:22060490,22057755:pet_fonce:4213:22060004,22057757:pet_fonce:4213:22079382,22089599:pet_fonce:4213:22091695,22092709:pet_fonce:4213:22133790,22094022:pet_fonce:4213:22130942,22094023:pet_fonce:4213:22129858,22094044:pet_fonce:4213:22128284,22094047:pet_fonce:4213:22125547,22094625:pet_fonce:4213:22122287,22094627:pet_fonce:4213:22123081,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.011049132982557445, 'nb_photo': 3567, 'list_port_cont': '21937824,21939173,21939741,21941801,21942287,21942536,21942709,21943654,21944054,21944465,21944826,21944860,21944902,21948127,21948692,21951659,21954465,21954504,21956206,21956630,21958508,21960315,21962721,21963638,21967991,21969907,21973611,21975503,21975797,21977002,21979015,21979283,21979530,21979656,21983689,21985971,21987564,21987728,21987863,21987937,21988181,21990015,21991761,21992343,21996578,21999345,22010234,22011236,22012688,22014635,22015187,22015548,22017031,22017728,22018820,22019741,22020323,22023190,22023568,22026652,22027920,22028243,22029168,22029546,22030574,22032214,22034514,22045014,22045683,22046697,22058365,22060011,22060501,22064302,22065838,22070522,22074315,22074588,22075115,22077651,22079388,22080309,22084404,22084621,22084986,22085186,22085968,22086027,22086290,22086487,22086648,22090032,22091710,22094140,22094319,22094874,22094937,22095330,22098366,22100502,22102636,22102833,22103155,22103398,22105547,22109938,22112126,22113941,22114924,22116303,22119485,22121009,22121254,2212156', 'assoc_port': '21936862:21944860,21936863:21944902,21936864:21944054,21936865:21942287,21936890:21937824,21936891:21942709,21938118:21939173,21939370:21939741,21941592:21941801,21942442:21942536,21943568:21943654,21944347:21944465,21944620:21944826,21947409:21948127,21947410:21956206,21948383:21948692,21951418:21951659,21954280:21954504,21954281:21954465,21956389:21956630,21958293:21958508,21960222:21960315,21962610:21962721,21963434:21963638,21967261:21979283,21967262:21979530,21967263:21967991,21967264:21979656,21967265:21987564,21967266:21987728,21967267:21987863,21969569:21969907,21972738:21975503,21972739:21973611,21975410:21991761,21975411:21990015,21975412:21977002,21975413:21979015,21975414:21975797,21980179:21987937,21982976:21983689,21985604:21985971,21987906:21988181,21991685:21992343,21996082:21996578,21998719:21999345,22009703:22017031,22009706:22019741,22009708:22015187,22009713:22011236,22009717:22014635,22009719:22010234,22009721:22018820,22012335:22012688,22015078:22015548,22017423:22017728,22019959:2202032', 'assoc_mat': '21936862:pet_opaque:4213:21944860,21936863:pet_opaque:4213:21944902,21936864:pet_opaque:4213:21944054,21936865:pet_opaque:4213:21942287,21936890:pet_opaque:4213:21937824,21936891:pet_opaque:4213:21942709,21938118:pet_opaque:4213:21939173,21939370:pet_opaque:4213:21939741,21941592:pet_opaque:4213:21941801,21942442:pet_opaque:4213:21942536,21943568:pet_opaque:4213:21943654,21944347:pet_opaque:4213:21944465,21944620:pet_opaque:4213:21944826,21947409:pet_opaque:4213:21948127,21947410:pet_opaque:4213:21956206,21948383:pet_opaque:4213:21948692,21951418:pet_opaque:4213:21951659,21954280:pet_opaque:4213:21954504,21954281:pet_opaque:4213:21954465,21956389:pet_opaque:4213:21956630,21958293:pet_opaque:4213:21958508,21960222:pet_opaque:4213:21960315,21962610:pet_opaque:4213:21962721,21963434:pet_opaque:4213:21963638,21967261:pet_opaque:4213:21979283,21967262:pet_opaque:4213:21979530,21967263:pet_opaque:4213:21967991,21967264:pet_opaque:4213:21979656,21967265:pet_opaque:4213:21987564,21967266:pet_opaque:4213:21987728,2196'}), 'main_stat': {'nb_photos': 9115}}, 'hostname': (), 'impurety_average_per_hashtag': [(('refus', '2025-04', 0.09802385868001988),)]} 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 ! 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 ! 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 ! 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 ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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=3996 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=3996 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= 3996 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=3996 # 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 ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="refus_amiens"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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=3996 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=3996 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= 3996 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=3996 # 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 ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((9115,),), 'unwanted_material_monthly_percentage': ((0.09802385868001988,),), 'material_repartition': (('refus', 9115),), 'material_dict': {'refus': 9115}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 4, 1), 0.11460468725305437, 894), (datetime.date(2025, 4, 2), 0.11726475064195395, 1019), (datetime.date(2025, 4, 3), 0.1317384532765198, 599), (datetime.date(2025, 4, 4), 0.12057144704154915, 1027), (datetime.date(2025, 4, 5), 0.09638440804617232, 1164), (datetime.date(2025, 4, 6), 0.1089726231847114, 956), (datetime.date(2025, 4, 7), 0.08678144971511317, 790), (datetime.date(2025, 4, 8), 0.036396656068685904, 559), (datetime.date(2025, 4, 9), 0.03423259228417762, 518), (datetime.date(2025, 4, 10), 0.07760782828571101, 513), (datetime.date(2025, 4, 11), 0.11073619879711863, 634), (datetime.date(2025, 4, 12), 0.10553332424530643, 442)), 'impurety_average_data_per_hashtag': {'refus': ((datetime.date(2025, 4, 1), 0.11460468725305437, 894), (datetime.date(2025, 4, 2), 0.11726475064195395, 1019), (datetime.date(2025, 4, 3), 0.1317384532765198, 599), (datetime.date(2025, 4, 4), 0.12057144704154915, 1027), (datetime.date(2025, 4, 5), 0.09638440804617232, 1164), (datetime.date(2025, 4, 6), 0.1089726231847114, 956), (datetime.date(2025, 4, 7), 0.08678144971511317, 790), (datetime.date(2025, 4, 8), 0.036396656068685904, 559), (datetime.date(2025, 4, 9), 0.03423259228417762, 518), (datetime.date(2025, 4, 10), 0.07760782828571101, 513), (datetime.date(2025, 4, 11), 0.11073619879711863, 634), (datetime.date(2025, 4, 12), 0.10553332424530643, 442))}, 'quality_array': [['-2.4864147866338886', '01042025'], ['-2.472981252729084', '02042025'], ['-2.7700361824268755', '03042025'], ['-2.605520389538448', '04042025'], ['-1.6193297500421593', '05042025'], ['-2.143904061309393', '06042025'], ['-0.36412533426635646', '07042025'], ['1.7057616252768741', '08042025'], ['1.3326938767179237', '09042025'], ['-1.2052653772527304', '10042025'], ['-2.457757518443133', '11042025'], ['-2.4692444355529712', '12042025']], 'number_of_batch': ((285,),), 'datou_id_sts': 3142, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0036259514391729967, 'nb_photo': 1464, 'list_port_cont': '21937821,21939162,21939746,21941786,21942286,21942545,21942710,21943656,21944041,21944452,21944820,21944855,21944892,21948133,21948695,21951644,21954467,21954496,21956205,21956628,21958502,21960306,21962713,21963637,21967999,21969915,21973608,21975500,21975800,21977007,21979024,21979274,21979535,21979655,21983684,21985983,21987573,21987720,21987872,21987946,21990023,21991769,21992349,21996567,21999338,22010235,22011237,22012691,22014637,22015182,22015551,22017043,22017719,22018831,22019753,22020338,22023199,22023576,22026668,22027911,22028244,22029160,22029547,22030585,22032219,22034518,22045009,22045689,22046693,22058371,22060010,22060506,22064295,22065836,22070523,22074309,22074597,22075130,22077647,22079377,22080316,22084405,22084634,22084988,22085191,22085969,22086025,22086284,22086482,22086650,22090031,22091707,22093507,22094152,22094324,22094865,22094927,22095329,22097423,22098375,22100503,22102638,22102822,22103160,22103411,22109929,22112127,22113927,22116306,22121011,22121552,22122289,22122747,2212308', 'assoc_port': '21936862:21944855,21936863:21944892,21936864:21944041,21936865:21942286,21936890:21937821,21936891:21942710,21938118:21939162,21939370:21939746,21941592:21941786,21942442:21942545,21943568:21943656,21944347:21944452,21944620:21944820,21947409:21948133,21947410:21956205,21948383:21948695,21951418:21951644,21954280:21954496,21954281:21954467,21956389:21956628,21958293:21958502,21960222:21960306,21962610:21962713,21963434:21963637,21967261:21979274,21967262:21979535,21967263:21967999,21967264:21979655,21967265:21987573,21967266:21987720,21967267:21987872,21969569:21969915,21972738:21975500,21972739:21973608,21975410:21991769,21975411:21990023,21975412:21977007,21975413:21979024,21975414:21975800,21980179:21987946,21982976:21983684,21985604:21985983,21991685:21992349,21996082:21996567,21998719:21999338,22009703:22017043,22009706:22019753,22009708:22015182,22009713:22011237,22009717:22014637,22009719:22010235,22009721:22018831,22012335:22012691,22015078:22015551,22017423:22017719,22019959:22020338,22023102:2202319', 'assoc_mat': '21936862:barquette_opaque:4213:21944855,21936863:barquette_opaque:4213:21944892,21936864:barquette_opaque:4213:21944041,21936865:barquette_opaque:4213:21942286,21936890:barquette_opaque:4213:21937821,21936891:barquette_opaque:4213:21942710,21938118:barquette_opaque:4213:21939162,21939370:barquette_opaque:4213:21939746,21941592:barquette_opaque:4213:21941786,21942442:barquette_opaque:4213:21942545,21943568:barquette_opaque:4213:21943656,21944347:barquette_opaque:4213:21944452,21944620:barquette_opaque:4213:21944820,21947409:barquette_opaque:4213:21948133,21947410:barquette_opaque:4213:21956205,21948383:barquette_opaque:4213:21948695,21951418:barquette_opaque:4213:21951644,21954280:barquette_opaque:4213:21954496,21954281:barquette_opaque:4213:21954467,21956389:barquette_opaque:4213:21956628,21958293:barquette_opaque:4213:21958502,21960222:barquette_opaque:4213:21960306,21962610:barquette_opaque:4213:21962713,21963434:barquette_opaque:4213:21963637,21967261:barquette_opaque:4213:21979274,21967262:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.010611299225962283, 'nb_photo': 3251, 'list_port_cont': '21937830,21939168,21939750,21941788,21942278,21942544,21942711,21943655,21944049,21944463,21944830,21944861,21944898,21948138,21948691,21951655,21954462,21954502,21956215,21956639,21958505,21960307,21962715,21963635,21967984,21969920,21973605,21975504,21975796,21977012,21979016,21979286,21979525,21979650,21983680,21985984,21987572,21987721,21987808,21987865,21987945,21990018,21991772,21992341,21996561,21999339,22010228,22011231,22012680,22014638,22015191,22017045,22017718,22018818,22019740,22020336,22023201,22023573,22026654,22027917,22028253,22029172,22029553,22030579,22032221,22034508,22045008,22045687,22046694,22058370,22059996,22060492,22064306,22065831,22070508,22074313,22074584,22075101,22077645,22079381,22080314,22084398,22084620,22084996,22085177,22085973,22086020,22086298,22086494,22086638,22090030,22091694,22093519,22094146,22094320,22094872,22094922,22095336,22097432,22098376,22100498,22102625,22102829,22103156,22103409,22112131,22113937,22114925,22116305,22119486,22121002,22121546,22122288,2212274', 'assoc_port': '21936862:21944861,21936863:21944898,21936864:21944049,21936865:21942278,21936890:21937830,21936891:21942711,21938118:21939168,21939370:21939750,21941592:21941788,21942442:21942544,21943568:21943655,21944347:21944463,21944620:21944830,21947409:21948138,21947410:21956215,21948383:21948691,21951418:21951655,21954280:21954502,21954281:21954462,21956389:21956639,21958293:21958505,21960222:21960307,21962610:21962715,21963434:21963635,21967261:21979286,21967262:21979525,21967263:21967984,21967264:21979650,21967265:21987572,21967266:21987721,21967267:21987865,21969569:21969920,21972738:21975504,21972739:21973605,21975410:21991772,21975411:21990018,21975412:21977012,21975413:21979016,21975414:21975796,21980179:21987945,21982976:21983680,21982979:21987808,21985604:21985984,21991685:21992341,21996082:21996561,21998719:21999339,22009703:22017045,22009706:22019740,22009708:22015191,22009713:22011231,22009717:22014638,22009719:22010228,22009721:22018818,22012335:22012680,22017423:22017718,22019959:22020336,22023102:2202320', 'assoc_mat': '21936862:carton:4213:21944861,21936863:carton:4213:21944898,21936864:carton:4213:21944049,21936865:carton:4213:21942278,21936890:carton:4213:21937830,21936891:carton:4213:21942711,21938118:carton:4213:21939168,21939370:carton:4213:21939750,21941592:carton:4213:21941788,21942442:carton:4213:21942544,21943568:carton:4213:21943655,21944347:carton:4213:21944463,21944620:carton:4213:21944830,21947409:carton:4213:21948138,21947410:carton:4213:21956215,21948383:carton:4213:21948691,21951418:carton:4213:21951655,21954280:carton:4213:21954502,21954281:carton:4213:21954462,21956389:carton:4213:21956639,21958293:carton:4213:21958505,21960222:carton:4213:21960307,21962610:carton:4213:21962715,21963434:carton:4213:21963635,21967261:carton:4213:21979286,21967262:carton:4213:21979525,21967263:carton:4213:21967984,21967264:carton:4213:21979650,21967265:carton:4213:21987572,21967266:carton:4213:21987721,21967267:carton:4213:21987865,21969569:carton:4213:21969920,21972738:carton:4213:21975504,21972739:carton:4213:21973605,2197'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004372334062955059, 'nb_photo': 604, 'list_port_cont': '21937831,21941796,21942272,21942537,21942703,21943662,21944052,21944458,21944822,21944854,21948129,21948689,21951651,21954503,21956208,21956635,21960314,21963647,21967988,21969913,21973614,21975505,21976999,21979279,21979536,21979646,21983690,21985981,21987578,21987867,21987935,21990017,21991770,21996565,21999346,22011243,22012678,22014630,22015180,22015560,22017033,22018822,22020328,22023196,22023575,22026665,22027913,22028257,22029170,22029557,22030582,22032209,22045010,22045686,22046701,22058376,22059998,22060503,22064292,22065827,22070515,22074324,22074595,22075134,22077650,22080318,22084401,22084631,22084985,22085180,22085984,22086019,22086293,22086480,22086634,22090027,22091701,22093514,22094153,22094332,22094864,22094926,22095342,22097420,22098380,22100495,22102624,22102832,22103165,22103410,22113928,22116309,22119484,22121014,22121559,22122285,22123086,22124873,22125554,22126584,22126690,22126845,22126961,22127652,22128291,22129044,22129626,22129869,22130939,22131812,22133803,22134655,22138672,2213914', 'assoc_port': '21936862:21944854,21936864:21944052,21936865:21942272,21936890:21937831,21936891:21942703,21941592:21941796,21942442:21942537,21943568:21943662,21944347:21944458,21944620:21944822,21947409:21948129,21947410:21956208,21948383:21948689,21951418:21951651,21954280:21954503,21956389:21956635,21960222:21960314,21963434:21963647,21967261:21979279,21967262:21979536,21967263:21967988,21967264:21979646,21967265:21987578,21967267:21987867,21969569:21969913,21972738:21975505,21972739:21973614,21975410:21991770,21975411:21990017,21975412:21976999,21980179:21987935,21982976:21983690,21985604:21985981,21996082:21996565,21998719:21999346,22009703:22017033,22009708:22015180,22009713:22011243,22009717:22014630,22009721:22018822,22012335:22012678,22015078:22015560,22019959:22020328,22023102:22023196,22023491:22023575,22025447:22026665,22026971:22027913,22028031:22029170,22028058:22028257,22029001:22030582,22029003:22029557,22031589:22032209,22042891:22046701,22042893:22045010,22045451:22045686,22057724:22086293,22057727:2208648', 'assoc_mat': '21936862:ela:4213:21944854,21936864:ela:4213:21944052,21936865:ela:4213:21942272,21936890:ela:4213:21937831,21936891:ela:4213:21942703,21941592:ela:4213:21941796,21942442:ela:4213:21942537,21943568:ela:4213:21943662,21944347:ela:4213:21944458,21944620:ela:4213:21944822,21947409:ela:4213:21948129,21947410:ela:4213:21956208,21948383:ela:4213:21948689,21951418:ela:4213:21951651,21954280:ela:4213:21954503,21956389:ela:4213:21956635,21960222:ela:4213:21960314,21963434:ela:4213:21963647,21967261:ela:4213:21979279,21967262:ela:4213:21979536,21967263:ela:4213:21967988,21967264:ela:4213:21979646,21967265:ela:4213:21987578,21967267:ela:4213:21987867,21969569:ela:4213:21969913,21972738:ela:4213:21975505,21972739:ela:4213:21973614,21975410:ela:4213:21991770,21975411:ela:4213:21990017,21975412:ela:4213:21976999,21980179:ela:4213:21987935,21982976:ela:4213:21983690,21985604:ela:4213:21985981,21996082:ela:4213:21996565,21998719:ela:4213:21999346,22009703:ela:4213:22017033,22009708:ela:4213:22015180,22009713:ela:4213:2201124'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0032912216512682177, 'nb_photo': 2323, 'list_port_cont': '21937832,21939163,21939737,21941797,21942271,21942543,21942714,21943657,21944045,21944459,21944829,21944866,21944889,21948137,21948682,21951643,21954468,21954505,21956210,21956629,21958503,21960317,21962726,21963646,21967993,21969912,21973603,21975499,21975794,21977009,21979027,21979287,21979521,21979647,21983235,21983683,21985972,21987576,21987718,21987859,21987931,21988184,21990028,21991774,21992347,21996570,21999347,22010232,22011229,22012692,22014636,22015186,22015549,22017041,22017725,22018819,22019747,22020332,22023191,22023569,22026667,22027922,22028246,22029158,22029558,22030590,22032218,22034519,22045012,22045693,22046695,22058361,22060000,22060494,22064296,22065830,22070524,22074314,22074600,22075097,22077644,22079375,22080315,22084402,22084627,22084990,22085185,22085982,22086029,22086294,22086495,22086637,22090022,22091700,22093522,22094150,22094318,22094869,22094925,22095338,22097435,22098368,22100494,22102630,22102821,22103161,22103405,22105542,22109942,22112132,22113938,22114921,22116301,2211949', 'assoc_port': '21936862:21944866,21936863:21944889,21936864:21944045,21936865:21942271,21936890:21937832,21936891:21942714,21938118:21939163,21939370:21939737,21941592:21941797,21942442:21942543,21943568:21943657,21944347:21944459,21944620:21944829,21947409:21948137,21947410:21956210,21948383:21948682,21951418:21951643,21954280:21954505,21954281:21954468,21956389:21956629,21958293:21958503,21960222:21960317,21962610:21962726,21963434:21963646,21967261:21979287,21967262:21979521,21967263:21967993,21967264:21979647,21967265:21987576,21967266:21987718,21967267:21987859,21969569:21969912,21972738:21975499,21972739:21973603,21975410:21991774,21975411:21990028,21975412:21977009,21975413:21979027,21975414:21975794,21980179:21987931,21982976:21983683,21982980:21983235,21985604:21985972,21987906:21988184,21991685:21992347,21996082:21996570,21998719:21999347,22009703:22017041,22009706:22019747,22009708:22015186,22009713:22011229,22009717:22014636,22009719:22010232,22009721:22018819,22012335:22012692,22015078:22015549,22017423:2201772', 'assoc_mat': '21936862:etiquette:4213:21944866,21936863:etiquette:4213:21944889,21936864:etiquette:4213:21944045,21936865:etiquette:4213:21942271,21936890:etiquette:4213:21937832,21936891:etiquette:4213:21942714,21938118:etiquette:4213:21939163,21939370:etiquette:4213:21939737,21941592:etiquette:4213:21941797,21942442:etiquette:4213:21942543,21943568:etiquette:4213:21943657,21944347:etiquette:4213:21944459,21944620:etiquette:4213:21944829,21947409:etiquette:4213:21948137,21947410:etiquette:4213:21956210,21948383:etiquette:4213:21948682,21951418:etiquette:4213:21951643,21954280:etiquette:4213:21954505,21954281:etiquette:4213:21954468,21956389:etiquette:4213:21956629,21958293:etiquette:4213:21958503,21960222:etiquette:4213:21960317,21962610:etiquette:4213:21962726,21963434:etiquette:4213:21963646,21967261:etiquette:4213:21979287,21967262:etiquette:4213:21979521,21967263:etiquette:4213:21967993,21967264:etiquette:4213:21979647,21967265:etiquette:4213:21987576,21967266:etiquette:4213:21987718,21967267:etiquette:4213:21987859,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.030953954960344525, 'nb_photo': 5515, 'list_port_cont': '21937818,21939175,21939740,21941790,21942276,21942534,21942712,21943653,21944044,21944468,21944823,21944853,21944888,21948124,21948693,21951647,21954463,21954509,21956213,21956627,21958510,21960322,21962720,21963644,21967985,21969910,21973618,21975498,21975790,21977000,21979018,21979275,21979534,21979651,21983681,21985975,21987570,21987715,21987869,21987944,21988183,21990029,21991760,21992348,21996564,21999336,22010236,22011230,22012677,22014626,22015181,22015557,22017038,22017717,22018823,22019748,22020339,22023185,22023578,22026660,22027910,22028259,22029156,22029548,22030581,22032222,22034504,22045004,22045697,22046692,22058377,22059997,22060495,22064308,22065842,22070511,22074318,22074591,22075114,22077649,22079385,22080321,22084413,22084626,22084984,22085181,22085983,22086021,22086297,22086493,22086636,22090018,22091697,22093521,22094147,22094330,22094866,22094935,22095339,22097424,22098377,22100501,22102629,22102818,22103159,22103399,22105538,22109933,22112116,22113931,22114919,22116315,22119498,2212101', 'assoc_port': '21936862:21944853,21936863:21944888,21936864:21944044,21936865:21942276,21936890:21937818,21936891:21942712,21938118:21939175,21939370:21939740,21941592:21941790,21942442:21942534,21943568:21943653,21944347:21944468,21944620:21944823,21947409:21948124,21947410:21956213,21948383:21948693,21951418:21951647,21954280:21954509,21954281:21954463,21956389:21956627,21958293:21958510,21960222:21960322,21962610:21962720,21963434:21963644,21967261:21979275,21967262:21979534,21967263:21967985,21967264:21979651,21967265:21987570,21967266:21987715,21967267:21987869,21969569:21969910,21972738:21975498,21972739:21973618,21975410:21991760,21975411:21990029,21975412:21977000,21975413:21979018,21975414:21975790,21980179:21987944,21982976:21983681,21985604:21985975,21987906:21988183,21991685:21992348,21996082:21996564,21998719:21999336,22009703:22017038,22009706:22019748,22009708:22015181,22009713:22011230,22009717:22014626,22009719:22010236,22009721:22018823,22012335:22012677,22015078:22015557,22017423:22017717,22019959:2202033', 'assoc_mat': '21936862:film_plastique:4213:21944853,21936863:film_plastique:4213:21944888,21936864:film_plastique:4213:21944044,21936865:film_plastique:4213:21942276,21936890:film_plastique:4213:21937818,21936891:film_plastique:4213:21942712,21938118:film_plastique:4213:21939175,21939370:film_plastique:4213:21939740,21941592:film_plastique:4213:21941790,21942442:film_plastique:4213:21942534,21943568:film_plastique:4213:21943653,21944347:film_plastique:4213:21944468,21944620:film_plastique:4213:21944823,21947409:film_plastique:4213:21948124,21947410:film_plastique:4213:21956213,21948383:film_plastique:4213:21948693,21951418:film_plastique:4213:21951647,21954280:film_plastique:4213:21954509,21954281:film_plastique:4213:21954463,21956389:film_plastique:4213:21956627,21958293:film_plastique:4213:21958510,21960222:film_plastique:4213:21960322,21962610:film_plastique:4213:21962720,21963434:film_plastique:4213:21963644,21967261:film_plastique:4213:21979275,21967262:film_plastique:4213:21979534,21967263:film_plastique:4213:2196798'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0006862562981866272, 'nb_photo': 17, 'list_port_cont': '21942277,21944864,21969916,21977011,22029157,22060502,22070520,22086299,22133800,22153448,22180796,22247645,22280370,22304598,22305928,22320011', 'assoc_port': '21936862:21944864,21936865:21942277,21969569:21969916,21975412:21977011,22028031:22029157,22057724:22086299,22057734:22060502,22070160:22070520,22092709:22133800,22138971:22180796,22153105:22153448,22247247:22247645,22279708:22280370,22304053:22304598,22305532:22305928,22319955:22320011', 'assoc_mat': '21936862:kraft:4213:21944864,21936865:kraft:4213:21942277,21969569:kraft:4213:21969916,21975412:kraft:4213:21977011,22028031:kraft:4213:22029157,22057724:kraft:4213:22086299,22057734:kraft:4213:22060502,22070160:kraft:4213:22070520,22092709:kraft:4213:22133800,22138971:kraft:4213:22180796,22153105:kraft:4213:22153448,22247247:kraft:4213:22247645,22279708:kraft:4213:22280370,22304053:kraft:4213:22304598,22305532:kraft:4213:22305928,22319955:kraft:4213:22320011'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.005094020948897741, 'nb_photo': 4185, 'list_port_cont': '21937823,21939172,21939743,21941800,21942284,21942538,21942715,21943658,21944046,21944467,21944818,21944867,21944903,21948132,21948687,21951656,21954476,21954497,21956207,21956640,21958507,21960308,21962716,21963642,21967989,21969909,21973613,21975490,21975798,21977010,21979020,21979280,21979527,21979658,21983688,21985969,21987565,21987729,21987875,21987941,21988187,21990016,21991766,21992355,21996563,21999334,22010225,22011232,22012682,22014625,22015189,22015556,22017035,22017721,22018816,22019743,22020331,22023198,22023570,22026658,22027914,22028250,22029162,22029545,22030586,22032211,22034515,22045015,22045695,22046690,22058373,22059995,22060496,22064297,22065832,22070518,22074320,22074593,22075132,22077657,22079383,22080324,22084403,22084633,22084989,22085176,22085975,22086028,22086283,22086484,22086642,22090024,22091698,22094143,22094326,22094871,22094934,22095344,22097430,22100496,22102633,22102831,22103154,22103401,22105540,22109937,22112130,22113940,22114920,22116307,22119495,22121006,22121251,2212228', 'assoc_port': '21936862:21944867,21936863:21944903,21936864:21944046,21936865:21942284,21936890:21937823,21936891:21942715,21938118:21939172,21939370:21939743,21941592:21941800,21942442:21942538,21943568:21943658,21944347:21944467,21944620:21944818,21947409:21948132,21947410:21956207,21948383:21948687,21951418:21951656,21954280:21954497,21954281:21954476,21956389:21956640,21958293:21958507,21960222:21960308,21962610:21962716,21963434:21963642,21967261:21979280,21967262:21979527,21967263:21967989,21967264:21979658,21967265:21987565,21967266:21987729,21967267:21987875,21969569:21969909,21972738:21975490,21972739:21973613,21975410:21991766,21975411:21990016,21975412:21977010,21975413:21979020,21975414:21975798,21980179:21987941,21982976:21983688,21985604:21985969,21987906:21988187,21991685:21992355,21996082:21996563,21998719:21999334,22009703:22017035,22009706:22019743,22009708:22015189,22009713:22011232,22009717:22014625,22009719:22010225,22009721:22018816,22012335:22012682,22015078:22015556,22017423:22017721,22019959:2202033', 'assoc_mat': '21936862:metal:4213:21944867,21936863:metal:4213:21944903,21936864:metal:4213:21944046,21936865:metal:4213:21942284,21936890:metal:4213:21937823,21936891:metal:4213:21942715,21938118:metal:4213:21939172,21939370:metal:4213:21939743,21941592:metal:4213:21941800,21942442:metal:4213:21942538,21943568:metal:4213:21943658,21944347:metal:4213:21944467,21944620:metal:4213:21944818,21947409:metal:4213:21948132,21947410:metal:4213:21956207,21948383:metal:4213:21948687,21951418:metal:4213:21951656,21954280:metal:4213:21954497,21954281:metal:4213:21954476,21956389:metal:4213:21956640,21958293:metal:4213:21958507,21960222:metal:4213:21960308,21962610:metal:4213:21962716,21963434:metal:4213:21963642,21967261:metal:4213:21979280,21967262:metal:4213:21979527,21967263:metal:4213:21967989,21967264:metal:4213:21979658,21967265:metal:4213:21987565,21967266:metal:4213:21987729,21967267:metal:4213:21987875,21969569:metal:4213:21969909,21972738:metal:4213:21975490,21972739:metal:4213:21973613,21975410:metal:4213:21991766,21975411:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03365947343582914, 'nb_photo': 12093, 'list_port_cont': '21937822,21939165,21939738,21941792,21942279,21942547,21942706,21943659,21944047,21944457,21944833,21944865,21944896,21948130,21948698,21951653,21954469,21954494,21956211,21956633,21958512,21960309,21962723,21963643,21967986,21969908,21973610,21975502,21975799,21977008,21979021,21979288,21979528,21979659,21983231,21983676,21985982,21987571,21987717,21987870,21987943,21988179,21990024,21991767,21992345,21996566,21999332,22010233,22011235,22012684,22014623,22015185,22015550,22017034,22017729,22018827,22019749,22020333,22023187,22023580,22026662,22027915,22028247,22029163,22029544,22030576,22032213,22034513,22045011,22045690,22046686,22058367,22060005,22060505,22064298,22065837,22070516,22074323,22074598,22075099,22077648,22079380,22080317,22084397,22084628,22084999,22085179,22085970,22086022,22086288,22086492,22086644,22090025,22091708,22093510,22094145,22094323,22094870,22094921,22095333,22097436,22098372,22100507,22102639,22102824,22103163,22103403,22105539,22109941,22112129,22113936,22114911,22116314,2211948', 'assoc_port': '21936862:21944865,21936863:21944896,21936864:21944047,21936865:21942279,21936890:21937822,21936891:21942706,21938118:21939165,21939370:21939738,21941592:21941792,21942442:21942547,21943568:21943659,21944347:21944457,21944620:21944833,21947409:21948130,21947410:21956211,21948383:21948698,21951418:21951653,21954280:21954494,21954281:21954469,21956389:21956633,21958293:21958512,21960222:21960309,21962610:21962723,21963434:21963643,21967261:21979288,21967262:21979528,21967263:21967986,21967264:21979659,21967265:21987571,21967266:21987717,21967267:21987870,21969569:21969908,21972738:21975502,21972739:21973610,21975410:21991767,21975411:21990024,21975412:21977008,21975413:21979021,21975414:21975799,21980179:21987943,21982976:21983676,21982980:21983231,21985604:21985982,21987906:21988179,21991685:21992345,21996082:21996566,21998719:21999332,22009703:22017034,22009706:22019749,22009708:22015185,22009713:22011235,22009717:22014623,22009719:22010233,22009721:22018827,22012335:22012684,22015078:22015550,22017423:2201772', 'assoc_mat': '21936862:papier:4213:21944865,21936863:papier:4213:21944896,21936864:papier:4213:21944047,21936865:papier:4213:21942279,21936890:papier:4213:21937822,21936891:papier:4213:21942706,21938118:papier:4213:21939165,21939370:papier:4213:21939738,21941592:papier:4213:21941792,21942442:papier:4213:21942547,21943568:papier:4213:21943659,21944347:papier:4213:21944457,21944620:papier:4213:21944833,21947409:papier:4213:21948130,21947410:papier:4213:21956211,21948383:papier:4213:21948698,21951418:papier:4213:21951653,21954280:papier:4213:21954494,21954281:papier:4213:21954469,21956389:papier:4213:21956633,21958293:papier:4213:21958512,21960222:papier:4213:21960309,21962610:papier:4213:21962723,21963434:papier:4213:21963643,21967261:papier:4213:21979288,21967262:papier:4213:21979528,21967263:papier:4213:21967986,21967264:papier:4213:21979659,21967265:papier:4213:21987571,21967266:papier:4213:21987717,21967267:papier:4213:21987870,21969569:papier:4213:21969908,21972738:papier:4213:21975502,21972739:papier:4213:21973610,2197'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0034273046877817564, 'nb_photo': 138, 'list_port_cont': '21937819,21939177,21942285,21942708,21944042,21944460,21944824,21948683,21951658,21956637,21962714,21963648,21975495,21975795,21979028,21979276,21979520,21985980,21987569,21987860,21987938,21990020,21996571,21999343,22015179,22015558,22017040,22018824,22023197,22028248,22029554,22045002,22064305,22065834,22070519,22074585,22075118,22080312,22084410,22085976,22086646,22091705,22098370,22100504,22105544,22109945,22119494,22128280,22131797,22133798,22134653,22139142,22139287,22141188,22146531,22148592,22165361,22179875,22182761,22188749,22190217,22193013,22194136,22195219,22202474,22213935,22214774,22217663,22223555,22225012,22228414,22230367,22236729,22246588,22254922,22256179,22257473,22263609,22269177,22269622,22284189,22290489,22307661,22313645,22313900,22315449,22316516,22318071,22319246,22325769', 'assoc_port': '21936864:21944042,21936865:21942285,21936890:21937819,21936891:21942708,21938118:21939177,21944347:21944460,21944620:21944824,21948383:21948683,21951418:21951658,21956389:21956637,21962610:21962714,21963434:21963648,21967261:21979276,21967262:21979520,21967265:21987569,21967267:21987860,21972738:21975495,21975411:21990020,21975413:21979028,21975414:21975795,21980179:21987938,21985604:21985980,21996082:21996571,21998719:21999343,22009703:22017040,22009708:22015179,22009721:22018824,22015078:22015558,22023102:22023197,22028058:22028248,22029003:22029554,22042893:22045002,22057731:22086646,22063485:22064305,22063486:22065834,22070160:22070519,22074228:22074585,22074777:22075118,22079656:22080312,22084255:22084410,22085752:22085976,22089599:22091705,22092708:22202474,22092709:22133798,22094020:22131797,22094044:22128280,22094629:22119494,22095493:22098370,22100172:22100504,22105374:22105544,22109636:22109945,22134348:22134653,22138964:22193013,22138966:22194136,22138968:22195219,22138969:22190217,22138970:2218874', 'assoc_mat': '21936864:pehd:4213:21944042,21936865:pehd:4213:21942285,21936890:pehd:4213:21937819,21936891:pehd:4213:21942708,21938118:pehd:4213:21939177,21944347:pehd:4213:21944460,21944620:pehd:4213:21944824,21948383:pehd:4213:21948683,21951418:pehd:4213:21951658,21956389:pehd:4213:21956637,21962610:pehd:4213:21962714,21963434:pehd:4213:21963648,21967261:pehd:4213:21979276,21967262:pehd:4213:21979520,21967265:pehd:4213:21987569,21967267:pehd:4213:21987860,21972738:pehd:4213:21975495,21975411:pehd:4213:21990020,21975413:pehd:4213:21979028,21975414:pehd:4213:21975795,21980179:pehd:4213:21987938,21985604:pehd:4213:21985980,21996082:pehd:4213:21996571,21998719:pehd:4213:21999343,22009703:pehd:4213:22017040,22009708:pehd:4213:22015179,22009721:pehd:4213:22018824,22015078:pehd:4213:22015558,22023102:pehd:4213:22023197,22028058:pehd:4213:22028248,22029003:pehd:4213:22029554,22042893:pehd:4213:22045002,22057731:pehd:4213:22086646,22063485:pehd:4213:22064305,22063486:pehd:4213:22065834,22070160:pehd:4213:22070519,22074228:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.019399044389187704, 'nb_photo': 7680, 'list_port_cont': '21937820,21939161,21939748,21941791,21942280,21942542,21942704,21943650,21944048,21944455,21944821,21944862,21944900,21948131,21948688,21951650,21954464,21954501,21956216,21956632,21958499,21960320,21962725,21963649,21967987,21969911,21973612,21975491,21975786,21977001,21979025,21979278,21979529,21979652,21983675,21985970,21987575,21987719,21987868,21987934,21988188,21990021,21991771,21992352,21996576,21999335,22010222,22011233,22012685,22014633,22015192,22015564,22017044,22017720,22018829,22019751,22020327,22023193,22023577,22026666,22027908,22028254,22029167,22029559,22030584,22032208,22034510,22045013,22045691,22046685,22058375,22060001,22060491,22064301,22065843,22070513,22074321,22074587,22075098,22077654,22079387,22080313,22084406,22084624,22084998,22085175,22085974,22086024,22086295,22086481,22086651,22090016,22091704,22093520,22094144,22094329,22094878,22094930,22095341,22097425,22098378,22100497,22102634,22102830,22103152,22103396,22105553,22109935,22112121,22113929,22114914,22116313,22119497,2212101', 'assoc_port': '21936862:21944862,21936863:21944900,21936864:21944048,21936865:21942280,21936890:21937820,21936891:21942704,21938118:21939161,21939370:21939748,21941592:21941791,21942442:21942542,21943568:21943650,21944347:21944455,21944620:21944821,21947409:21948131,21947410:21956216,21948383:21948688,21951418:21951650,21954280:21954501,21954281:21954464,21956389:21956632,21958293:21958499,21960222:21960320,21962610:21962725,21963434:21963649,21967261:21979278,21967262:21979529,21967263:21967987,21967264:21979652,21967265:21987575,21967266:21987719,21967267:21987868,21969569:21969911,21972738:21975491,21972739:21973612,21975410:21991771,21975411:21990021,21975412:21977001,21975413:21979025,21975414:21975786,21980179:21987934,21982976:21983675,21985604:21985970,21987906:21988188,21991685:21992352,21996082:21996576,21998719:21999335,22009703:22017044,22009706:22019751,22009708:22015192,22009713:22011233,22009717:22014633,22009719:22010222,22009721:22018829,22012335:22012685,22015078:22015564,22017423:22017720,22019959:2202032', 'assoc_mat': '21936862:pet_clair:4213:21944862,21936863:pet_clair:4213:21944900,21936864:pet_clair:4213:21944048,21936865:pet_clair:4213:21942280,21936890:pet_clair:4213:21937820,21936891:pet_clair:4213:21942704,21938118:pet_clair:4213:21939161,21939370:pet_clair:4213:21939748,21941592:pet_clair:4213:21941791,21942442:pet_clair:4213:21942542,21943568:pet_clair:4213:21943650,21944347:pet_clair:4213:21944455,21944620:pet_clair:4213:21944821,21947409:pet_clair:4213:21948131,21947410:pet_clair:4213:21956216,21948383:pet_clair:4213:21948688,21951418:pet_clair:4213:21951650,21954280:pet_clair:4213:21954501,21954281:pet_clair:4213:21954464,21956389:pet_clair:4213:21956632,21958293:pet_clair:4213:21958499,21960222:pet_clair:4213:21960320,21962610:pet_clair:4213:21962725,21963434:pet_clair:4213:21963649,21967261:pet_clair:4213:21979278,21967262:pet_clair:4213:21979529,21967263:pet_clair:4213:21967987,21967264:pet_clair:4213:21979652,21967265:pet_clair:4213:21987575,21967266:pet_clair:4213:21987719,21967267:pet_clair:4213:21987868,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0003673053480226979, 'nb_photo': 92, 'list_port_cont': '21941793,21942281,21942540,21954471,21954510,21956214,21962722,21963636,21967998,21973602,21975493,21975791,21979277,21979531,21987874,21996562,22020330,22029165,22045692,22060004,22060490,22079382,22086292,22091695,22094867,22094932,22095343,22098379,22121004,22122287,22123081,22125547,22126485,22126687,22128284,22129858,22130942,22133790,22135745,22139279,22140060,22141185,22145262,22160867,22162288,22167602,22168100,22169757,22182148,22188738,22199558,22211210,22216112,22236400,22239198,22239627,22241361,22242405,22247637,22260368,22263619,22264724,22290496,22291014,22297913,22305929,22313890,22314015,22314666,22318075,22319239,22323369,22325803', 'assoc_port': '21936865:21942281,21941592:21941793,21942442:21942540,21947410:21956214,21954280:21954510,21954281:21954471,21962610:21962722,21963434:21963636,21967261:21979277,21967262:21979531,21967263:21967998,21967267:21987874,21972738:21975493,21972739:21973602,21975414:21975791,21996082:21996562,22019959:22020330,22028031:22029165,22045451:22045692,22057724:22086292,22057734:22060490,22057755:22060004,22057757:22079382,22089599:22091695,22092709:22133790,22094022:22130942,22094023:22129858,22094044:22128284,22094047:22125547,22094625:22122287,22094627:22123081,22094628:22095343,22094631:22094867,22094632:22094932,22095493:22098379,22120872:22121004,22126300:22126687,22126302:22126485,22134336:22199558,22135490:22135745,22138970:22188738,22138972:22182148,22139004:22145262,22139005:22139279,22139818:22141185,22139820:22140060,22154430:22169757,22154432:22162288,22154433:22167602,22160729:22160867,22167880:22168100,22207453:22242405,22210764:22211210,22214430:22239627,22214455:22236400,22215256:22216112,22239054:2223919', 'assoc_mat': '21936865:pet_fonce:4213:21942281,21941592:pet_fonce:4213:21941793,21942442:pet_fonce:4213:21942540,21947410:pet_fonce:4213:21956214,21954280:pet_fonce:4213:21954510,21954281:pet_fonce:4213:21954471,21962610:pet_fonce:4213:21962722,21963434:pet_fonce:4213:21963636,21967261:pet_fonce:4213:21979277,21967262:pet_fonce:4213:21979531,21967263:pet_fonce:4213:21967998,21967267:pet_fonce:4213:21987874,21972738:pet_fonce:4213:21975493,21972739:pet_fonce:4213:21973602,21975414:pet_fonce:4213:21975791,21996082:pet_fonce:4213:21996562,22019959:pet_fonce:4213:22020330,22028031:pet_fonce:4213:22029165,22045451:pet_fonce:4213:22045692,22057724:pet_fonce:4213:22086292,22057734:pet_fonce:4213:22060490,22057755:pet_fonce:4213:22060004,22057757:pet_fonce:4213:22079382,22089599:pet_fonce:4213:22091695,22092709:pet_fonce:4213:22133790,22094022:pet_fonce:4213:22130942,22094023:pet_fonce:4213:22129858,22094044:pet_fonce:4213:22128284,22094047:pet_fonce:4213:22125547,22094625:pet_fonce:4213:22122287,22094627:pet_fonce:4213:22123081,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.011049132982557445, 'nb_photo': 3567, 'list_port_cont': '21937824,21939173,21939741,21941801,21942287,21942536,21942709,21943654,21944054,21944465,21944826,21944860,21944902,21948127,21948692,21951659,21954465,21954504,21956206,21956630,21958508,21960315,21962721,21963638,21967991,21969907,21973611,21975503,21975797,21977002,21979015,21979283,21979530,21979656,21983689,21985971,21987564,21987728,21987863,21987937,21988181,21990015,21991761,21992343,21996578,21999345,22010234,22011236,22012688,22014635,22015187,22015548,22017031,22017728,22018820,22019741,22020323,22023190,22023568,22026652,22027920,22028243,22029168,22029546,22030574,22032214,22034514,22045014,22045683,22046697,22058365,22060011,22060501,22064302,22065838,22070522,22074315,22074588,22075115,22077651,22079388,22080309,22084404,22084621,22084986,22085186,22085968,22086027,22086290,22086487,22086648,22090032,22091710,22094140,22094319,22094874,22094937,22095330,22098366,22100502,22102636,22102833,22103155,22103398,22105547,22109938,22112126,22113941,22114924,22116303,22119485,22121009,22121254,2212156', 'assoc_port': '21936862:21944860,21936863:21944902,21936864:21944054,21936865:21942287,21936890:21937824,21936891:21942709,21938118:21939173,21939370:21939741,21941592:21941801,21942442:21942536,21943568:21943654,21944347:21944465,21944620:21944826,21947409:21948127,21947410:21956206,21948383:21948692,21951418:21951659,21954280:21954504,21954281:21954465,21956389:21956630,21958293:21958508,21960222:21960315,21962610:21962721,21963434:21963638,21967261:21979283,21967262:21979530,21967263:21967991,21967264:21979656,21967265:21987564,21967266:21987728,21967267:21987863,21969569:21969907,21972738:21975503,21972739:21973611,21975410:21991761,21975411:21990015,21975412:21977002,21975413:21979015,21975414:21975797,21980179:21987937,21982976:21983689,21985604:21985971,21987906:21988181,21991685:21992343,21996082:21996578,21998719:21999345,22009703:22017031,22009706:22019741,22009708:22015187,22009713:22011236,22009717:22014635,22009719:22010234,22009721:22018820,22012335:22012688,22015078:22015548,22017423:22017728,22019959:2202032', 'assoc_mat': '21936862:pet_opaque:4213:21944860,21936863:pet_opaque:4213:21944902,21936864:pet_opaque:4213:21944054,21936865:pet_opaque:4213:21942287,21936890:pet_opaque:4213:21937824,21936891:pet_opaque:4213:21942709,21938118:pet_opaque:4213:21939173,21939370:pet_opaque:4213:21939741,21941592:pet_opaque:4213:21941801,21942442:pet_opaque:4213:21942536,21943568:pet_opaque:4213:21943654,21944347:pet_opaque:4213:21944465,21944620:pet_opaque:4213:21944826,21947409:pet_opaque:4213:21948127,21947410:pet_opaque:4213:21956206,21948383:pet_opaque:4213:21948692,21951418:pet_opaque:4213:21951659,21954280:pet_opaque:4213:21954504,21954281:pet_opaque:4213:21954465,21956389:pet_opaque:4213:21956630,21958293:pet_opaque:4213:21958508,21960222:pet_opaque:4213:21960315,21962610:pet_opaque:4213:21962721,21963434:pet_opaque:4213:21963638,21967261:pet_opaque:4213:21979283,21967262:pet_opaque:4213:21979530,21967263:pet_opaque:4213:21967991,21967264:pet_opaque:4213:21979656,21967265:pet_opaque:4213:21987564,21967266:pet_opaque:4213:21987728,2196'}), 'main_stat': {'nb_photos': 9115}}, 'hostname': (), 'impurety_average_per_hashtag': [(('refus', '2025-04', 0.09802385868001988),)]} filepath : /data_2/data_log/job/memo/refus_amiens/sla_mensuel_refus_amiens_mois_04_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'refus': {'barquette_opaque': ['barquette_opaque', '0.36%', 1464], 'carton': ['carton', '1.06%', 3251], 'ela': ['ela', '0.44%', 604], 'etiquette': ['etiquette', '0.33%', 2323], 'film_plastique': ['film_plastique', '3.1%', 5515], 'kraft': ['kraft', '0.07%', 17], 'metal': ['metal', '0.51%', 4185], 'papier': ['papier', '3.37%', 12093], 'pehd': ['pehd', '0.34%', 138], 'pet_clair': ['pet_clair', '1.94%', 7680], 'pet_fonce': ['pet_fonce', '0.04%', 92], 'pet_opaque': ['pet_opaque', '1.1%', 3567]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/refus_amiens/sla_mensuel_refus_amiens_mois_04_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/refus_amiens 2.89user 2.48system 1:30.75elapsed 5%CPU (0avgtext+0avgdata 194172maxresident)k 70632inputs+520outputs (179major+67150minor)pagefaults 0swaps