== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (59)
+- Project (58)
+- Project (57)
+- Project (56)
+- Project (55)
+- Project (54)
+- Filter (53)
+- Project (52)
+- Project (51)
+- Project (50)
+- Project (49)
+- Project (48)
+- Project (47)
+- Project (46)
+- Join (45)
:- Project (25)
: +- Project (24)
: +- Filter (23)
: +- Project (22)
: +- Project (21)
: +- Project (20)
: +- Project (19)
: +- Project (18)
: +- Project (17)
: +- Project (16)
: +- Project (15)
: +- Project (14)
: +- Project (13)
: +- Project (12)
: +- Project (11)
: +- Project (10)
: +- Project (9)
: +- Project (8)
: +- Project (7)
: +- Project (6)
: +- SubqueryAlias (5)
: +- View (4)
: +- LogicalRelation (3)
+- Project (44)
+- SubqueryAlias (43)
+- View (42)
+- Aggregate (41)
+- Project (40)
+- SubqueryAlias (39)
+- View (38)
+- Project (37)
+- Project (36)
+- Project (35)
+- Project (34)
+- Project (33)
+- Project (32)
+- Project (31)
+- Generate (30)
+- Project (29)
+- Project (28)
+- Project (27)
+- LogicalRelation (26)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `VLIB_JSON_119279167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [DATASETID_119274#54365, FIELDS_119275#54366, GEOMETRY_119276#54367, RECORDID_119278#54368, RECORD_TIMESTAM_119277#54369], false
(4) View
Arguments: `VLIB_JSON_119273167`, true
(5) SubqueryAlias
Arguments: VLIB_JSON_119273167
(6) Project
Arguments: [DATASETID_119274#54365 AS VLIB_JSON_119273_DATASETID_119274#54667, FIELDS_119275#54366 AS VLIB_JSON_119273_FIELDS_119275#54668, GEOMETRY_119276#54367 AS VLIB_JSON_119273_GEOMETRY_119276#54669, RECORDID_119278#54368 AS VLIB_JSON_119273_RECORDID_119278#54670, RECORD_TIMESTAM_119277#54369 AS VLIB_JSON_119273_RECORD_TIMESTAM_119277#54671]
(7) Project
Arguments: [cast(VLIB_JSON_119273_DATASETID_119274#54667 as string) AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54687, cast(VLIB_JSON_119273_FIELDS_119275#54668 as string) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54688, cast(VLIB_JSON_119273_GEOMETRY_119276#54669 as string) AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54689, cast(VLIB_JSON_119273_RECORD_TIMESTAM_119277#54671 as string) AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54690, cast(VLIB_JSON_119273_RECORDID_119278#54670 as string) AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54691]
(8) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54687 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54688 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54689 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54690 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54691 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702]
(9) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.is_installed as string)) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715]
(10) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.is_renting as string)) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732]
(11) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.is_returning as string)) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768]
(12) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.numbikesavailable as string)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797]
(13) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.numdocksavailable as string)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54824]
(14) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54824, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.stationcode as string)) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54854]
(15) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54824, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54854, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.ebike as string)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54887]
(16) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54824, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54854, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54887, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.mechanical as string)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54922]
(17) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54824, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54854, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54887, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54922, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, cast(yyyy-MM-dd'T'HH:mm:ss.SSSXXX as string), cast(Europe/Paris as string), cast(fr_FR as string)) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54948]
(18) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54824, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54854, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54887, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54922, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54948, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.name as string)) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#54989]
(19) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54824, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54854, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54887, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54922, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54948, COL_2F07F797_35B4_491C_8255_10445B86EEB9#54989, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.nom_arrondissement_communes as string)) AS COL_8A096969_1374_4168_B930_C219BC1F0591#55033]
(20) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54824, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54854, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54887, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54922, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54948, COL_2F07F797_35B4_491C_8255_10445B86EEB9#54989, COL_8A096969_1374_4168_B930_C219BC1F0591#55033, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.coordonnees_geo[0] as string)) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55080]
(21) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54824, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54854, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54887, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54922, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54948, COL_2F07F797_35B4_491C_8255_10445B86EEB9#54989, COL_8A096969_1374_4168_B930_C219BC1F0591#55033, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55080, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.coordonnees_geo[1] as string)) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55130]
(22) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54824, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54854, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54887, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54922, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54948, COL_2F07F797_35B4_491C_8255_10445B86EEB9#54989, COL_8A096969_1374_4168_B930_C219BC1F0591#55033, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55080, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55130, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699, cast($.stationcode as string)) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55183]
(23) Filter
Arguments: true
(24) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54854 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55276, COL_8A096969_1374_4168_B930_C219BC1F0591#55033 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55277, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55080 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55278, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55130 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55279, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54948 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55280, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54732 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55281, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54715 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55282, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54768 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55283, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54698 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55284, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54699 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55285, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54700 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55287, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54701 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55289, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54702 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55291, str_to_integer(COL_222816E0_1771_4A96_9C59_DB1900C311FE#54797) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55302, str_to_integer(COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54824) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55304, str_to_integer(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54887) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55307, str_to_integer(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54922) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55311, COL_2F07F797_35B4_491C_8255_10445B86EEB9#54989 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55312, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55183 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55313]
(25) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55276 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55390, COL_8A096969_1374_4168_B930_C219BC1F0591#55277 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55391, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55278 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55392, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55279 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55393, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55280 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55394, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55281 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55395, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55282 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55396, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55283 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55397, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55284 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55398, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55285 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55399, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55287 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55400, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55289 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55401, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55291 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55402, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55302 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55420, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55304 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55423, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55307 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55424, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55311 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55425, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55312 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55426, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55313 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55427]
(26) LogicalRelation
Arguments: text, [value#54392], false
(27) Project
Arguments: [get_json_object(value#54392, $.results) AS data#54395]
(28) Project
Arguments: [data#54395, schema_of_json([{"stationcode":"10206","name":"René Boulanger - Lancry","capacity":33,"coordonnees_geo":{"lon":2.3598745346052,"lat":48.868769331741},"station_opening_hours":null},{"stationcode":"23802","name":"Raymond Poincaré - Allée de la Marche","capacity":23,"coordonnees_geo":{"lon":2.1724102640451,"lat":48.838634069623},"station_opening_hours":null},{"stationcode":"12032","name":"Porte Dorée","capacity":36,"coordonnees_geo":{"lon":2.4077132,"lat":48.8354337},"station_opening_hours":null},{"stationcode":"19040","name":"Belleville - Télégraphe","capacity":41,"coordonnees_geo":{"lon":2.3995549,"lat":48.8756045},"station_opening_hours":null},{"stationcode":"11041","name":"Square Saint-Ambroise","capacity":43,"coordonnees_geo":{"lon":2.375841,"lat":48.860934},"station_opening_hours":null},{"stationcode":"20016","name":"Pyrénées - Maraîchers","capacity":33,"coordonnees_geo":{"lon":2.4043509364128113,"lat":48.85714001395299},"station_opening_hours":null},{"stationcode":"14006","name":"Saint-Jacques - Tombe Issoire","capacity":23,"coordonnees_geo":{"lon":2.3369108140468597,"lat":48.833206330538864},"station_opening_hours":null},{"stationcode":"21114","name":"Gustave Eiffel - Parc des Impressionnistes","capacity":30,"coordonnees_geo":{"lon":2.2946908324956894,"lat":48.90390619651018},"station_opening_hours":null},{"stationcode":"10164","name":"Claude Vellefaux - Sambre et Meuse","capacity":34,"coordonnees_geo":{"lon":2.370478,"lat":48.875022},"station_opening_hours":null},{"stationcode":"20103","name":"Le Vau - Maurice Bertaux","capacity":25,"coordonnees_geo":{"lon":2.411030612453627,"lat":48.86803439043193},"station_opening_hours":null},{"stationcode":"16031","name":"Vignes - Boulainvilliers","capacity":21,"coordonnees_geo":{"lon":2.275240458548069,"lat":48.856399483950504},"station_opening_hours":null},{"stationcode":"48009","name":"République - Auguste Perret","capacity":30,"coordonnees_geo":{"lon":2.3518594354391094,"lat":48.78695280952244},"station_opening_hours":null},{"stationcode":"14127","name":"Odessa - Départ","capacity":39,"coordonnees_geo":{"lon":2.3244281485677,"lat":48.842885590081},"station_opening_hours":null},{"stationcode":"31026","name":"Demi-Lune - Aristide Briand","capacity":20,"coordonnees_geo":{"lon":2.4562818557024,"lat":48.8762638192},"station_opening_hours":null},{"stationcode":"20039","name":"Belleville - Couronnes","capacity":50,"coordonnees_geo":{"lon":2.3809862136841,"lat":48.868831082877},"station_opening_hours":null},{"stationcode":"5034","name":"Censier - Santeuil","capacity":69,"coordonnees_geo":{"lon":2.3537524044513702,"lat":48.840658921385234},"station_opening_hours":null},{"stationcode":"21708","name":"Marcel Yol - Jullien","capacity":30,"coordonnees_geo":{"lon":2.287235018058929,"lat":48.82537611802588},"station_opening_hours":null},{"stationcode":"20108","name":"Jardin de l'Hospice Debrousse","capacity":23,"coordonnees_geo":{"lon":2.40568600595,"lat":48.861451061938},"station_opening_hours":null},{"stationcode":"21219","name":"Amaury Duval - Gabriel Péri","capacity":36,"coordonnees_geo":{"lon":2.323841750621796,"lat":48.81718759671675},"station_opening_hours":null},{"stationcode":"42209","name":"Place de l'Europe - Quai de Bercy","capacity":17,"coordonnees_geo":{"lon":2.3945679143071175,"lat":48.82529858840266},"station_opening_hours":null},{"stationcode":"13044","name":"Place Jeanne d'Arc","capacity":36,"coordonnees_geo":{"lon":2.369126,"lat":48.829575},"station_opening_hours":null},{"stationcode":"22015","name":"Île de la Jatte","capacity":23,"coordonnees_geo":{"lon":2.2666339203715324,"lat":48.894036161302104},"station_opening_hours":null},{"stationcode":"47009","name":"Charentonneau - Maison Alfort","capacity":28,"coordonnees_geo":{"lon":2.443241664773,"lat":48.809972406542},"station_opening_hours":null},{"stationcode":"10033","name":"Gare du Nord - Saint-Vincent de Paul","capacity":24,"coordonnees_geo":{"lon":2.3524305148385,"lat":48.880955741648},"station_opening_hours":null},{"stationcode":"16012","name":"Flandrin - Longchamp","capacity":42,"coordonnees_geo":{"lon":2.274354539176829,"lat":48.86877849178477},"station_opening_hours":null},{"stationcode":"45002","name":"Roger Salengro - Général de Gaulle","capacity":27,"coordonnees_geo":{"lon":2.4846760556101803,"lat":48.820029010376956},"station_opening_hours":null},{"stationcode":"14135","name":"Jourdan - Cité Universitaire","capacity":39,"coordonnees_geo":{"lon":2.3397007964124366,"lat":48.819897343156676},"station_opening_hours":null},{"stationcode":"14132","name":"Bézout - Général Leclerc","capacity":30,"coordonnees_geo":{"lon":2.3285973072052,"lat":48.82884804502439},"station_opening_hours":null},{"stationcode":"6031","name":"Pierre Sarrazin - Saint-Michel","capacity":33,"coordonnees_geo":{"lon":2.342130728066,"lat":48.850908146398},"station_opening_hours":null},{"stationcode":"19130","name":"Place Paul Delouvrier","capacity":42,"coordonnees_geo":{"lon":2.3851288855075836,"lat":48.89197621431365},"station_opening_hours":null},{"stationcode":"6026","name":"Saint-Placide - Cherche Midi","capacity":66,"coordonnees_geo":{"lon":2.325317971408367,"lat":48.8490535919234},"station_opening_hours":null},{"stationcode":"28005","name":"Jean Jaurès - Paul Lafargue","capacity":28,"coordonnees_geo":{"lon":2.2484488785267,"lat":48.884933177666},"station_opening_hours":null},{"stationcode":"23042","name":"André Theuriet - Blagis","capacity":30,"coordonnees_geo":{"lon":2.3130525648593903,"lat":48.77977325745441},"station_opening_hours":null},{"stationcode":"1008","name":"Les Halles - Saint-Eustache","capacity":32,"coordonnees_geo":{"lon":2.342623919248581,"lat":48.86362695901683},"station_opening_hours":null},{"stationcode":"23301","name":"Les Blagis","capacity":27,"coordonnees_geo":{"lon":2.302526,"lat":48.785205},"station_opening_hours":null},{"stationcode":"23303","name":"Gare de Robinson","capacity":30,"coordonnees_geo":{"lon":2.281828634440899,"lat":48.7799259211605},"station_opening_hours":null},{"stationcode":"20142","name":"Mûriers - Père Lachaise","capacity":20,"coordonnees_geo":{"lon":2.39164982067019,"lat":48.864130509668044},"station_opening_hours":null},{"stationcode":"15053","name":"Lecourbe - Convention","capacity":46,"coordonnees_geo":{"lon":2.2915197908878326,"lat":48.83923319241899},"station_opening_hours":null},{"stationcode":"10003","name":"Hauteville - Bonne Nouvelle","capacity":17,"coordonnees_geo":{"lon":2.3496496368327,"lat":48.87077436024},"station_opening_hours":null},{"stationcode":"30003","name":"Moscou - Edouard Vaillant","capacity":30,"coordonnees_geo":{"lon":2.4689837335263,"lat":48.90755810177},"station_opening_hours":null},{"stationcode":"14009","name":"Tombe Issoire - René Coty","capacity":36,"coordonnees_geo":{"lon":2.3343613743782,"lat":48.830512876709},"station_opening_hours":null},{"stationcode":"17117","name":"Pereire - Saussure","capacity":32,"coordonnees_geo":{"lon":2.3101296275854,"lat":48.888229075478},"station_opening_hours":null},{"stationcode":"15045","name":"Porte de la Plaine","capacity":35,"coordonnees_geo":{"lon":2.2924277186393742,"lat":48.82805169605981},"station_opening_hours":null},{"stationcode":"21023","name":"Ancienne Mairie - André Morizet","capacity":25,"coordonnees_geo":{"lon":2.234077,"lat":48.838311},"station_opening_hours":null},{"stationcode":"22701","name":"Général Leclerc - République","capacity":30,"coordonnees_geo":{"lon":2.2682306702811,"lat":48.915885074177},"station_opening_hours":null},{"stationcode":"14005","name":"René Coty - Place Denfert-Rochereau","capacity":36,"coordonnees_geo":{"lon":2.3329411447048,"lat":48.833056477316},"station_opening_hours":null},{"stationcode":"6004","name":"Regard - Rennes","capacity":46,"coordonnees_geo":{"lon":2.3268555477262,"lat":48.847385404956},"station_opening_hours":null},{"stationcode":"12040","name":"Porte de Charenton","capacity":67,"coordonnees_geo":{"lon":2.3989107459784,"lat":48.831240105856},"station_opening_hours":null},{"stationcode":"20106","name":"Mairie du 20ème","capacity":27,"coordonnees_geo":{"lon":2.3990669846535,"lat":48.865302324275},"station_opening_hours":null},{"stationcode":"21007","name":"Rond-Point Rhin et Danube","capacity":53,"coordonnees_geo":{"lon":2.2280225157737736,"lat":48.840452820991764},"station_opening_hours":null},{"stationcode":"21107","name":"Bertrand Sincholle - Henri Barbusse","capacity":23,"coordonnees_geo":{"lon":2.3042294383049016,"lat":48.89925982394349},"station_opening_hours":null},{"stationcode":"22305","name":"Jean Jaurès - Place du Dr Roux","capacity":35,"coordonnees_geo":{"lon":2.2947337017374,"lat":48.927567032796},"station_opening_hours":null},{"stationcode":"26008","name":"Henri Barbusse - Bourguignons","capacity":34,"coordonnees_geo":{"lon":2.2734212270774417,"lat":48.91301722799713},"station_opening_hours":null},{"stationcode":"21514","name":"Place de la Paix - Abbé Saint-Pierre","capacity":24,"coordonnees_geo":{"lon":2.2047570338469806,"lat":48.86462724459225},"station_opening_hours":null},{"stationcode":"18026","name":"Ruisseau - Ordener","capacity":53,"coordonnees_geo":{"lon":2.340144887566567,"lat":48.89299462568024},"station_opening_hours":null},{"stationcode":"13205","name":"Choisy - Pointe d'Ivry","capacity":24,"coordonnees_geo":{"lon":2.3633708034878,"lat":48.822154170359},"station_opening_hours":null},{"stationcode":"20112","name":"Jourdain - Place des Grandes Rigoles","capacity":22,"coordonnees_geo":{"lon":2.3895947635174,"lat":48.874031137272},"station_opening_hours":null},{"stationcode":"18041","name":"Rochechouart - Martyrs","capacity":20,"coordonnees_geo":{"lon":2.3405495658517,"lat":48.882193779572},"station_opening_hours":null},{"stationcode":"8057","name":"Hoche - Tilsitt","capacity":33,"coordonnees_geo":{"lon":2.2971323132515,"lat":48.874836457837},"station_opening_hours":null},{"stationcode":"13010","name":"Place d'Italie - Vincent Auriol","capacity":40,"coordonnees_geo":{"lon":2.3567550292319,"lat":48.831481874467},"station_opening_hours":null},{"stationcode":"32012","name":"Carrefour Pleyel","capacity":68,"coordonnees_geo":{"lon":2.3438543826341625,"lat":48.92034156960326},"station_opening_hours":null},{"stationcode":"8004","name":"Malesherbes - Place de la Madeleine","capacity":67,"coordonnees_geo":{"lon":2.323243509808,"lat":48.870406028483},"station_opening_hours":null},{"stationcode":"12109","name":"Mairie du 12ème","capacity":30,"coordonnees_geo":{"lon":2.3875549435616,"lat":48.840855311763},"station_opening_hours":null},{"stationcode":"31028","name":"Raspail Barbès","capacity":28,"coordonnees_geo":{"lon":2.4247387,"lat":48.8529945},"station_opening_hours":null},{"stationcode":"41303","name":"Gare de Nogent-le-Perreux","capacity":32,"coordonnees_geo":{"lon":2.493693307042122,"lat":48.83842553348809},"station_opening_hours":null},{"stationcode":"8009","name":"Gare Saint-Lazare - Isly","capacity":27,"coordonnees_geo":{"lon":2.326515804784655,"lat":48.874777677621296},"station_opening_hours":null},{"stationcode":"9014","name":"Faubourg Montmartre - La Fayette","capacity":35,"coordonnees_geo":{"lon":2.3408536612988,"lat":48.875254549053},"station_opening_hours":null},{"stationcode":"45003","name":"11 Novembre 1918 - 8 Mai 1945","capacity":36,"coordonnees_geo":{"lon":2.5382421165704727,"lat":48.80889533774377},"station_opening_hours":null},{"stationcode":"11002","name":"Roquette - Thiéré","capacity":23,"coordonnees_geo":{"lon":2.3733686318721463,"lat":48.85507930579506},"station_opening_hours":null},{"stationcode":"16108","name":"Sablons - Georges Mandel","capacity":38,"coordonnees_geo":{"lon":2.28189,"lat":48.863875},"station_opening_hours":null},{"stationcode":"6006","name":"Notre-Dame-des-Champs - Stanislas","capacity":19,"coordonnees_geo":{"lon":2.329337755887181,"lat":48.84479928858768},"station_opening_hours":null},{"stationcode":"11027","name":"Saint-Ambroise - Parmentier","capacity":38,"coordonnees_geo":{"lon":2.3772348091006,"lat":48.862147844548},"station_opening_hours":null},{"stationcode":"8054","name":"Bertie Albrecht - Hoche","capacity":32,"coordonnees_geo":{"lon":2.301303138307601,"lat":48.87614039826388},"station_opening_hours":null},{"stationcode":"21006","name":"Marcelin Berthelot","capacity":27,"coordonnees_geo":{"lon":2.233161628246308,"lat":48.8415473058801},"station_opening_hours":null},{"stationcode":"15034","name":"Lakanal - Commerce","capacity":53,"coordonnees_geo":{"lon":2.294059172272682,"lat":48.84442462786544},"station_opening_hours":null},{"stationcode":"41202","name":"Gare Rer de Fontenay sous Bois","capacity":61,"coordonnees_geo":{"lon":2.4630465,"lat":48.8436279},"station_opening_hours":null},{"stationcode":"23006","name":"Jules Guesde - Alsace","capacity":25,"coordonnees_geo":{"lon":2.2950777411461,"lat":48.890566275506},"station_opening_hours":null},{"stationcode":"22006","name":"Pierret - Madrid","capacity":28,"coordonnees_geo":{"lon":2.260125767248034,"lat":48.882976576876565},"station_opening_hours":null},{"stationcode":"17037","name":"Bayen - Pereire","capacity":22,"coordonnees_geo":{"lon":2.2921088710427284,"lat":48.881804409079656},"station_opening_hours":null},{"stationcode":"14117","name":"Gare Montparnasse - René Mouchotte","capacity":41,"coordonnees_geo":{"lon":2.3208839446306,"lat":48.839203843292},"station_opening_hours":null},{"stationcode":"21502","name":"Verdun - Place Henri IV","capacity":26,"coordonnees_geo":{"lon":2.2277003154158592,"lat":48.870797375639214},"station_opening_hours":null},{"stationcode":"5002","name":"Sommerard - Saint-Jacques","capacity":34,"coordonnees_geo":{"lon":2.3450158352986,"lat":48.850310432924},"station_opening_hours":null},{"stationcode":"10015","name":"Lucien Sampaix - Récollets","capacity":46,"coordonnees_geo":{"lon":2.3621229082345963,"lat":48.874330377560476},"station_opening_hours":null},{"stationcode":"41207","name":"Place du Général de Gaulle","capacity":28,"coordonnees_geo":{"lon":2.4877332,"lat":48.8525288},"station_opening_hours":null},{"stationcode":"6103","name":"Mézières - Rennes","capacity":55,"coordonnees_geo":{"lon":2.3303819820284843,"lat":48.85023459321703},"station_opening_hours":null},{"stationcode":"6018","name":"Michelet - Assas","capacity":18,"coordonnees_geo":{"lon":2.3350211977959,"lat":48.842741502832},"station_opening_hours":null},{"stationcode":"19039","name":"Edouard Pailleron - Simon Bolivar","capacity":24,"coordonnees_geo":{"lon":2.374839261174202,"lat":48.87979886049996},"station_opening_hours":null},{"stationcode":"9031","name":"Provence - Chaussée d'Antin","capacity":25,"coordonnees_geo":{"lon":2.332976511564311,"lat":48.87428447542072},"station_opening_hours":null},{"stationcode":"17046","name":"Mac-Mahon - Brey","capacity":25,"coordonnees_geo":{"lon":2.2945125360529,"lat":48.87753208413},"station_opening_hours":null},{"stationcode":"31703","name":"Sadi Carnot - François Mitterrand","capacity":27,"coordonnees_geo":{"lon":2.4241617321968083,"lat":48.87532687671517},"station_opening_hours":null},{"stationcode":"35003","name":"Gabrielle Josserand - Edouard Vaillant","capacity":25,"coordonnees_geo":{"lon":2.3933270573616032,"lat":48.90271566255436},"station_opening_hours":null},{"stationcode":"11006","name":"Ledru-Rollin - Place du Père Chaillet","capacity":37,"coordonnees_geo":{"lon":2.379020587761426,"lat":48.856433706943704},"station_opening_hours":null},{"stationcode":"9026","name":"Jean-Baptiste Pigalle - La Bruyere","capacity":17,"coordonnees_geo":{"lon":2.333709173337285,"lat":48.87939826447722},"station_opening_hours":null},{"stationcode":"9017","name":"Lallier - Trudaine","capacity":29,"coordonnees_geo":{"lon":2.3408224806189537,"lat":48.88109246617963},"station_opening_hours":null},{"stationcode":"18035","name":"René Binet - Porte de Montmartre","capacity":37,"coordonnees_geo":{"lon":2.3365534096956253,"lat":48.89905109950848},"station_opening_hours":null},{"stationcode":"16014","name":"Eylau - Trocadéro","capacity":24,"coordonnees_geo":{"lon":2.2864209115505,"lat":48.863354122371},"station_opening_hours":null},{"stationcode":"16115","name":"Raffet - Montmorency","capacity":42,"coordonnees_geo":{"lon":2.2629252456151954,"lat":48.85258670812},"station_opening_hours":null},{"stationcode":"11032","name":"Jean-Pierre Timbaud - Vaucouleurs","capacity":47,"coordonnees_geo":{"lon":2.377885,"lat":48.867937},"station_opening_hours":null},{"stationcode":"13048","name":"Wurtz - Tolbiac","capacity":28,"coordonnees_geo":{"lon":2.344585955143,"lat":48.82631195621},"station_opening_hours":null},{"stationcode":"13128","name":"Quai de la Gare - Pont de Bercy","capacity":30,"coordonnees_geo":{"lon":2.3740861260598,"lat":48.83730787972},"station_opening_hours":null}]) AS schema#54409]
(29) Project
Arguments: [from_json(ArrayType(StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,StructType(StructField(lat,DoubleType,true),StructField(lon,DoubleType,true)),true),StructField(name,StringType,true),StructField(station_opening_hours,StringType,true),StructField(stationcode,StringType,true)),true), data#54395, Some(Etc/UTC)) AS root#54426]
(30) Generate
Arguments: explode(root#54426), false, [root#54435]
(31) Project
Arguments: [root#54435]
(32) Project
Arguments: [root#54435.capacity AS capacity#54439L, root#54435.coordonnees_geo AS coordonnees_geo#54440, root#54435.name AS name#54441, root#54435.station_opening_hours AS station_opening_hours#54442, root#54435.stationcode AS stationcode#54443]
(33) Project
Arguments: [capacity#54439L, to_json(coordonnees_geo#54440, Some(Etc/UTC)) AS coordonnees_geo#54463, name#54441, station_opening_hours#54442, stationcode#54443]
(34) Project
Arguments: [capacity#54439L AS capacity#54480L, coordonnees_geo#54463 AS coordonnees_geo#54481, name#54441 AS name#54482, station_opening_hours#54442 AS station_opening_hours#54483, stationcode#54443 AS stationcode#54484]
(35) Project
Arguments: [capacity#54480L, coordonnees_geo#54481, name#54482, station_opening_hours#54483, stationcode#54484]
(36) Project
Arguments: [capacity#54480L AS CAPACITY_119304#54507L, coordonnees_geo#54481 AS COORDONNEES_GEO_119305#54508, name#54482 AS NAME_119306#54509, stationcode#54484 AS STATIONCODE_119307#54510]
(37) Project
Arguments: [CAPACITY_119304#54507L, COORDONNEES_GEO_119305#54508, NAME_119306#54509, STATIONCODE_119307#54510]
(38) View
Arguments: `F00D3ACD_F693_4F8F_B4DA_EAF38B363EE0`, true
(39) SubqueryAlias
Arguments: F00D3ACD_F693_4F8F_B4DA_EAF38B363EE0
(40) Project
Arguments: [CAPACITY_119304#54507L, COORDONNEES_GEO_119305#54508, NAME_119306#54509, STATIONCODE_119307#54510]
(41) Aggregate
Arguments: [CAPACITY_119304#54507L, COORDONNEES_GEO_119305#54508, NAME_119306#54509, STATIONCODE_119307#54510], [CAPACITY_119304#54507L, COORDONNEES_GEO_119305#54508, NAME_119306#54509, STATIONCODE_119307#54510]
(42) View
Arguments: `INFORMATION_STA_119303167`, true
(43) SubqueryAlias
Arguments: INFORMATION_STA_119303167
(44) Project
Arguments: [CAPACITY_119304#54507L AS INFORMATION_STA_119303_CAPACITY_119304#55516L, COORDONNEES_GEO_119305#54508 AS INFORMATION_STA_119303_COORDONNEES_GEO_119305#55517, NAME_119306#54509 AS INFORMATION_STA_119303_NAME_119306#55518, STATIONCODE_119307#54510 AS INFORMATION_STA_119303_STATIONCODE_119307#55519]
(45) Join
Arguments: LeftOuter, (COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55390 = INFORMATION_STA_119303_STATIONCODE_119307#55519)
(46) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55390, COL_8A096969_1374_4168_B930_C219BC1F0591#55391, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55392, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55393, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55394, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55395, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55396, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55397, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55398, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55399, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55400, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55401, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55402, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55420, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55423, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55424, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55425, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55426, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55427, INFORMATION_STA_119303_CAPACITY_119304#55516L AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55717L]
(47) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55390 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55787, COL_8A096969_1374_4168_B930_C219BC1F0591#55391 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55789, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55392 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55791, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55393 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55793, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55394 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55795, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55395 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55797, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55396 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55799, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55397 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55801, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55398 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55803, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55399 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55805, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55400 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55807, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55401 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55808, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55402 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55809, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55420 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55810, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55423 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55811, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55424 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55812, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55425 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55813, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55426 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55814, bigint_to_int(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55717L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55817, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55427 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55818]
(48) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55787 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55919, COL_8A096969_1374_4168_B930_C219BC1F0591#55789 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55920, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55791 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55921, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55793 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55922, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55795 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55923, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55797 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55924, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55799 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55925, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55801 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55926, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55803 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55927, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55805 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55928, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55807 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55929, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55808 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55930, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55809 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55931, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55812 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55813 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55814 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55934, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55810 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55935, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55811 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55936, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55817 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55937, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55818 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55938]
(49) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55919, COL_8A096969_1374_4168_B930_C219BC1F0591#55920, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55921, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55922, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55923, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55924, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55925, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55926, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55927, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55928, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55929, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55930, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55931, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55934, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55935, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55936, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55937, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55938, dec_operator(cast(SOMME as string), array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933)) AS COL_4886635E_35B3_4E90_94E4_401045F89277#56020]
(50) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55919, COL_8A096969_1374_4168_B930_C219BC1F0591#55920, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55921, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55922, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55923, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55924, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55925, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55926, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55927, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55928, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55929, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55930, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55931, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55934, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55935, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55936, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55937, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55938, COL_4886635E_35B3_4E90_94E4_401045F89277#56020, str_if_with_rule((CASE WHEN isnull((COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932 > cast(0 as int))) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932 > cast(0 as int)) END AND CASE WHEN isnull((COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933 > cast(0 as int))) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933 > cast(0 as int)) END), cast(Mécaniques + Electriques as string), str_if_with_rule(CASE WHEN isnull((COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933 > cast(0 as int))) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933 > cast(0 as int)) END, cast(Mécaniques as string), str_if_with_rule(CASE WHEN isnull((COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932 > cast(0 as int))) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932 > cast(0 as int)) END, cast(Electriques as string), cast(Pas de disponibilité as string)))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56086]
(51) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55919, COL_8A096969_1374_4168_B930_C219BC1F0591#55920, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55921, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55922, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55923, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55924, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55925, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55926, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55927, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55928, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55929, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55930, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55931, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55934, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55935, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55936, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55937, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55938, COL_4886635E_35B3_4E90_94E4_401045F89277#56020, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56086, dec_round(dec_operator(cast(PRODUIT as string), array(dec_operator(cast(DIVISION as string), array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#55935, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55937, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55935)))), cast(100 as double))), cast(2 as int)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56155]
(52) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55919, COL_8A096969_1374_4168_B930_C219BC1F0591#55920, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55921, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55922, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55923, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55924, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55925, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55926, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55927, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55928, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55929, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55930, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55931, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55934, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55935, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55936, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55937, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55938, COL_4886635E_35B3_4E90_94E4_401045F89277#56020, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56086, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56155, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55937)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#56228]
(53) Filter
Arguments: CASE WHEN isnull((COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55937 > cast(0 as int))) THEN false ELSE (COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55937 > cast(0 as int)) END
(54) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55919 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56373, COL_8A096969_1374_4168_B930_C219BC1F0591#55920 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56374, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55921 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56375, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55922 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56376, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55923 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56377, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55924 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56378, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55925 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56379, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55926 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56380, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55927 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56381, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55928 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56382, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55929 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56383, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55930 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56384, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55931 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56385, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55932 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56386, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55933 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56387, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55934 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56388, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55935 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56389, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55936 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56390, COL_4886635E_35B3_4E90_94E4_401045F89277#56020 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56391, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56086 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56392, dec_to_int(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56155) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56393, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55937 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56394, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55938 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56395, COL_69842CB9_D407_4477_8F44_680AF6209358#56228 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56396]
(55) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56373 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56470, COL_8A096969_1374_4168_B930_C219BC1F0591#56374 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56471, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56375 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56472, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56376 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56473, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56377 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56474, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56378 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56475, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56379 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56476, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56380 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56477, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56381 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56478, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56382 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56479, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56383 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56480, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56384 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56481, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56385 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56482, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56386 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56483, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56387 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56484, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56388 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56485, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56389 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56486, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56390 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56487, COL_4886635E_35B3_4E90_94E4_401045F89277#56391 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56488, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56392 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56489, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56393 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56395 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56491, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56394 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56492, COL_69842CB9_D407_4477_8F44_680AF6209358#56396 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56493]
(56) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56470, COL_8A096969_1374_4168_B930_C219BC1F0591#56471, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56472, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56473, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56474, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56475, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56476, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56477, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56478, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56479, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56480, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56481, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56482, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56483, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56484, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56485, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56486, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56487, COL_4886635E_35B3_4E90_94E4_401045F89277#56488, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56489, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56491, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56492, COL_69842CB9_D407_4477_8F44_680AF6209358#56493, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, < 10 %, less_or_equal, struct(col1, 10), struct(col1, 0), #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, de 10 à 20 %, between, struct(col1, 10), struct(col1, 20), #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, de 20 à 30 %, between, struct(col1, 20), struct(col1, 30), #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, de 30 à 40 %, between, struct(col1, 30), struct(col1, 40), #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, de 40 à 50 %, between, struct(col1, 40), struct(col1, 50), #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, de 50 à 60 %, between, struct(col1, 50), struct(col1, 60), #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, de 60 à 70 %, between, struct(col1, 60), struct(col1, 70), #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, de 70 à 80 %, between, struct(col1, 70), struct(col1, 80), #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, de 80 à 90, between, struct(col1, 80), struct(col1, 90), #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490, > 90 %, greater_or_equal, struct(col1, 90), struct(col1, 0), #219A48, , null))) AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56566]
(57) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56470 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56667, COL_8A096969_1374_4168_B930_C219BC1F0591#56471 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56668, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56472 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56669, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56473 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56670, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56474 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56671, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56475 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56672, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56476 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56673, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56477 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56674, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56478 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56675, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56479 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56676, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56480 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56677, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56481 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56678, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56482 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56679, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56483 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56680, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56484 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56681, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56485 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56682, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56486 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56683, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56487 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56684, COL_4886635E_35B3_4E90_94E4_401045F89277#56488 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56685, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56489 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56686, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56490 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56687, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56491 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56688, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56566 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56689, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56492 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56690, COL_69842CB9_D407_4477_8F44_680AF6209358#56493 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56691]
(58) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56667 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56867, COL_8A096969_1374_4168_B930_C219BC1F0591#56668 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56868, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56671 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56869, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56672 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56870, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56673 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56871, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56674 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56872, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56675 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56873, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56676 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56874, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56677 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56875, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56678 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56876, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56679 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56877, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56680 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56878, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56681 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56879, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56682 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56880, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56683 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56881, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56684 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56882, COL_4886635E_35B3_4E90_94E4_401045F89277#56685 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56883, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56686 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56884, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56687 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56885, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56688 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56886, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56689 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56887, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56690 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56888, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56669 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56889, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56670 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56890, COL_69842CB9_D407_4477_8F44_680AF6209358#56691 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56891]
(59) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56867 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56992, COL_8A096969_1374_4168_B930_C219BC1F0591#56868 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56993, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56869 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56994, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56870 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56995, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56871 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56996, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56872 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56997, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56873 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56998, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56874 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56999, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56875 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#57000, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56876 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#57001, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56877 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#57002, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56878 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#57003, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56879 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#57004, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56880 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#57005, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56881 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#57006, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56882 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#57007, COL_4886635E_35B3_4E90_94E4_401045F89277#56883 AS COL_4886635E_35B3_4E90_94E4_401045F89277#57008, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56884 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#57009, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56885 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#57010, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56886 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#57011, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56887 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#57012, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56888 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#57013, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56889 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#57014, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56890 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#57015, COL_69842CB9_D407_4477_8F44_680AF6209358#56891 AS COL_69842CB9_D407_4477_8F44_680AF6209358#57016]