== 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_119279172`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [DATASETID_119274#54360, FIELDS_119275#54361, GEOMETRY_119276#54362, RECORDID_119278#54363, RECORD_TIMESTAM_119277#54364], false
(4) View
Arguments: `VLIB_JSON_119273172`, true
(5) SubqueryAlias
Arguments: VLIB_JSON_119273172
(6) Project
Arguments: [DATASETID_119274#54360 AS VLIB_JSON_119273_DATASETID_119274#54632, FIELDS_119275#54361 AS VLIB_JSON_119273_FIELDS_119275#54633, GEOMETRY_119276#54362 AS VLIB_JSON_119273_GEOMETRY_119276#54634, RECORDID_119278#54363 AS VLIB_JSON_119273_RECORDID_119278#54635, RECORD_TIMESTAM_119277#54364 AS VLIB_JSON_119273_RECORD_TIMESTAM_119277#54636]
(7) Project
Arguments: [cast(VLIB_JSON_119273_DATASETID_119274#54632 as string) AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54647, cast(VLIB_JSON_119273_FIELDS_119275#54633 as string) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54648, cast(VLIB_JSON_119273_GEOMETRY_119276#54634 as string) AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54649, cast(VLIB_JSON_119273_RECORD_TIMESTAM_119277#54636 as string) AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54650, cast(VLIB_JSON_119273_RECORDID_119278#54635 as string) AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54651]
(8) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54647 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54648 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54649 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54650 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54651 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661]
(9) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.is_installed as string)) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692]
(10) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.is_renting as string)) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709]
(11) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.is_returning as string)) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747]
(12) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.numbikesavailable as string)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782]
(13) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.numdocksavailable as string)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54807]
(14) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54807, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.stationcode as string)) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54842]
(15) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54807, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54842, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.ebike as string)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54885]
(16) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54807, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54842, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54885, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.mechanical as string)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54923]
(17) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54807, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54842, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54885, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54923, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, 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#54962]
(18) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54807, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54842, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54885, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54923, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54962, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.name as string)) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55016]
(19) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54807, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54842, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54885, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54923, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54962, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55016, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.nom_arrondissement_communes as string)) AS COL_8A096969_1374_4168_B930_C219BC1F0591#55049]
(20) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54807, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54842, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54885, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54923, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54962, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55016, COL_8A096969_1374_4168_B930_C219BC1F0591#55049, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.coordonnees_geo[0] as string)) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55111]
(21) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54807, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54842, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54885, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54923, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54962, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55016, COL_8A096969_1374_4168_B930_C219BC1F0591#55049, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55111, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.coordonnees_geo[1] as string)) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55164]
(22) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54807, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54842, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54885, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54923, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54962, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55016, COL_8A096969_1374_4168_B930_C219BC1F0591#55049, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55111, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55164, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658, cast($.stationcode as string)) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55219]
(23) Filter
Arguments: true
(24) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54842 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55286, COL_8A096969_1374_4168_B930_C219BC1F0591#55049 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55288, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55111 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55290, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55164 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55292, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#54962 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55293, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54709 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55294, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54692 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55295, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54747 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55296, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54657 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55297, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54658 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55298, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54659 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55299, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54660 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55300, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54661 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55301, str_to_integer(COL_222816E0_1771_4A96_9C59_DB1900C311FE#54782) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55303, str_to_integer(COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54807) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55305, str_to_integer(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54885) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55306, str_to_integer(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#54923) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55308, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55016 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55309, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55219 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55310]
(25) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55286 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55352, COL_8A096969_1374_4168_B930_C219BC1F0591#55288 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55353, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55290 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55354, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55292 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55355, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55293 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55356, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55294 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55357, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55295 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55358, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55296 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55359, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55297 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55360, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55298 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55361, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55299 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55362, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55300 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55363, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55301 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55364, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55303 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55365, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55305 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55366, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55306 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55367, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55308 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55368, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55309 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55369, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55310 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55370]
(26) LogicalRelation
Arguments: text, [value#54390], false
(27) Project
Arguments: [get_json_object(value#54390, $.results) AS data#54394]
(28) Project
Arguments: [data#54394, 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#54408]
(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#54394, Some(Etc/UTC)) AS root#54427]
(30) Generate
Arguments: explode(root#54427), false, [root#54436]
(31) Project
Arguments: [root#54436]
(32) Project
Arguments: [root#54436.capacity AS capacity#54444L, root#54436.coordonnees_geo AS coordonnees_geo#54445, root#54436.name AS name#54446, root#54436.station_opening_hours AS station_opening_hours#54447, root#54436.stationcode AS stationcode#54448]
(33) Project
Arguments: [capacity#54444L, to_json(coordonnees_geo#54445, Some(Etc/UTC)) AS coordonnees_geo#54464, name#54446, station_opening_hours#54447, stationcode#54448]
(34) Project
Arguments: [capacity#54444L AS capacity#54475L, coordonnees_geo#54464 AS coordonnees_geo#54476, name#54446 AS name#54477, station_opening_hours#54447 AS station_opening_hours#54478, stationcode#54448 AS stationcode#54479]
(35) Project
Arguments: [capacity#54475L, coordonnees_geo#54476, name#54477, station_opening_hours#54478, stationcode#54479]
(36) Project
Arguments: [capacity#54475L AS CAPACITY_119304#54511L, coordonnees_geo#54476 AS COORDONNEES_GEO_119305#54512, name#54477 AS NAME_119306#54513, stationcode#54479 AS STATIONCODE_119307#54514]
(37) Project
Arguments: [CAPACITY_119304#54511L, COORDONNEES_GEO_119305#54512, NAME_119306#54513, STATIONCODE_119307#54514]
(38) View
Arguments: `693182C7_D67C_4DB3_9453_C057EF00F9D9`, true
(39) SubqueryAlias
Arguments: 693182C7_D67C_4DB3_9453_C057EF00F9D9
(40) Project
Arguments: [CAPACITY_119304#54511L, COORDONNEES_GEO_119305#54512, NAME_119306#54513, STATIONCODE_119307#54514]
(41) Aggregate
Arguments: [CAPACITY_119304#54511L, COORDONNEES_GEO_119305#54512, NAME_119306#54513, STATIONCODE_119307#54514], [CAPACITY_119304#54511L, COORDONNEES_GEO_119305#54512, NAME_119306#54513, STATIONCODE_119307#54514]
(42) View
Arguments: `INFORMATION_STA_119303172`, true
(43) SubqueryAlias
Arguments: INFORMATION_STA_119303172
(44) Project
Arguments: [CAPACITY_119304#54511L AS INFORMATION_STA_119303_CAPACITY_119304#55489L, COORDONNEES_GEO_119305#54512 AS INFORMATION_STA_119303_COORDONNEES_GEO_119305#55490, NAME_119306#54513 AS INFORMATION_STA_119303_NAME_119306#55491, STATIONCODE_119307#54514 AS INFORMATION_STA_119303_STATIONCODE_119307#55492]
(45) Join
Arguments: LeftOuter, (COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55352 = INFORMATION_STA_119303_STATIONCODE_119307#55492)
(46) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55352, COL_8A096969_1374_4168_B930_C219BC1F0591#55353, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55354, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55355, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55356, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55357, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55358, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55359, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55360, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55361, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55362, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55363, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55364, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55365, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55366, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55367, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55368, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55369, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55370, INFORMATION_STA_119303_CAPACITY_119304#55489L AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55716L]
(47) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55352 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55779, COL_8A096969_1374_4168_B930_C219BC1F0591#55353 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55780, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55354 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55781, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55355 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55782, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55356 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55783, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55357 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55784, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55358 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55785, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55359 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55786, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55360 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55788, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55361 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55790, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55362 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55792, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55363 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55794, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55364 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55796, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55365 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55798, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55366 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55800, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55367 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55802, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55368 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55804, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55369 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55806, bigint_to_int(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55716L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55815, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55370 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55816]
(48) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55779 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55859, COL_8A096969_1374_4168_B930_C219BC1F0591#55780 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55860, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55781 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55861, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55782 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55862, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55783 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55863, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55784 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55864, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55785 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55865, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55786 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55866, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55788 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55867, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55790 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55868, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55792 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55869, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55794 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55870, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55796 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55871, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55802 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55804 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55806 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55874, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55798 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55875, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55800 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55876, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55815 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55877, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55816 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55878]
(49) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55859, COL_8A096969_1374_4168_B930_C219BC1F0591#55860, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55861, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55862, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55863, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55864, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55865, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55866, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55867, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55868, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55869, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55870, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55871, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55874, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55875, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55876, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55877, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55878, dec_operator(cast(SOMME as string), array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873)) AS COL_4886635E_35B3_4E90_94E4_401045F89277#55979]
(50) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55859, COL_8A096969_1374_4168_B930_C219BC1F0591#55860, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55861, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55862, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55863, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55864, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55865, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55866, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55867, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55868, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55869, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55870, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55871, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55874, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55875, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55876, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55877, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55878, COL_4886635E_35B3_4E90_94E4_401045F89277#55979, str_if_with_rule((CASE WHEN isnull((COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872 > cast(0 as int))) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872 > cast(0 as int)) END AND CASE WHEN isnull((COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873 > cast(0 as int))) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873 > cast(0 as int)) END), cast(Mécaniques + Electriques as string), str_if_with_rule(CASE WHEN isnull((COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873 > cast(0 as int))) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873 > cast(0 as int)) END, cast(Mécaniques as string), str_if_with_rule(CASE WHEN isnull((COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872 > cast(0 as int))) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872 > cast(0 as int)) END, cast(Electriques as string), cast(Pas de disponibilité as string)))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56043]
(51) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55859, COL_8A096969_1374_4168_B930_C219BC1F0591#55860, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55861, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55862, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55863, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55864, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55865, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55866, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55867, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55868, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55869, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55870, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55871, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55874, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55875, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55876, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55877, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55878, COL_4886635E_35B3_4E90_94E4_401045F89277#55979, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56043, dec_round(dec_operator(cast(PRODUIT as string), array(dec_operator(cast(DIVISION as string), array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#55875, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55877, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55875)))), cast(100 as double))), cast(2 as int)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56110]
(52) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55859, COL_8A096969_1374_4168_B930_C219BC1F0591#55860, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55861, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55862, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55863, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55864, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55865, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55866, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55867, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55868, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55869, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55870, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55871, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55874, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55875, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55876, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55877, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55878, COL_4886635E_35B3_4E90_94E4_401045F89277#55979, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56043, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56110, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55877)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#56180]
(53) Filter
Arguments: CASE WHEN isnull((COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55877 > cast(0 as int))) THEN false ELSE (COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55877 > cast(0 as int)) END
(54) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55859 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56252, COL_8A096969_1374_4168_B930_C219BC1F0591#55860 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56253, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55861 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56254, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55862 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56255, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55863 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56256, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55864 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56257, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55865 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56258, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55866 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56259, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55867 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56260, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55868 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56261, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55869 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56262, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55870 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56263, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55871 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56264, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55872 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56265, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55873 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56266, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55874 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56267, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55875 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56268, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55876 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56269, COL_4886635E_35B3_4E90_94E4_401045F89277#55979 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56270, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56043 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56271, dec_to_int(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56110) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56272, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55877 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56273, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55878 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56274, COL_69842CB9_D407_4477_8F44_680AF6209358#56180 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56275]
(55) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56252 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56325, COL_8A096969_1374_4168_B930_C219BC1F0591#56253 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56326, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56254 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56327, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56255 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56328, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56256 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56329, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56257 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56330, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56258 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56331, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56259 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56332, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56260 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56333, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56261 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56334, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56262 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56335, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56263 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56336, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56264 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56337, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56265 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56338, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56266 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56339, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56267 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56340, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56268 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56341, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56269 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56342, COL_4886635E_35B3_4E90_94E4_401045F89277#56270 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56343, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56271 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56344, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56272 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56274 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56346, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56273 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56347, COL_69842CB9_D407_4477_8F44_680AF6209358#56275 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56348]
(56) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56325, COL_8A096969_1374_4168_B930_C219BC1F0591#56326, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56327, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56328, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56329, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56330, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56331, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56332, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56333, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56334, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56335, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56336, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56337, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56338, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56339, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56340, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56341, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56342, COL_4886635E_35B3_4E90_94E4_401045F89277#56343, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56344, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56346, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56347, COL_69842CB9_D407_4477_8F44_680AF6209358#56348, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, < 10 %, less_or_equal, struct(col1, 10), struct(col1, 0), #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, de 10 à 20 %, between, struct(col1, 10), struct(col1, 20), #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, de 20 à 30 %, between, struct(col1, 20), struct(col1, 30), #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, de 30 à 40 %, between, struct(col1, 30), struct(col1, 40), #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, de 40 à 50 %, between, struct(col1, 40), struct(col1, 50), #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, de 50 à 60 %, between, struct(col1, 50), struct(col1, 60), #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, de 60 à 70 %, between, struct(col1, 60), struct(col1, 70), #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, de 70 à 80 %, between, struct(col1, 70), struct(col1, 80), #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, de 80 à 90, between, struct(col1, 80), struct(col1, 90), #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345, > 90 %, greater_or_equal, struct(col1, 90), struct(col1, 0), #219A48, , null))) AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56469]
(57) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56325 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56617, COL_8A096969_1374_4168_B930_C219BC1F0591#56326 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56618, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56327 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56619, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56328 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56620, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56329 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56621, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56330 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56622, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56331 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56623, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56332 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56624, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56333 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56625, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56334 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56626, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56335 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56627, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56336 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56628, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56337 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56629, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56338 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56630, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56339 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56631, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56340 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56632, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56341 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56633, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56342 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56634, COL_4886635E_35B3_4E90_94E4_401045F89277#56343 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56635, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56344 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56636, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56345 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56637, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56346 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56638, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56469 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56639, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56347 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56640, COL_69842CB9_D407_4477_8F44_680AF6209358#56348 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56641]
(58) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56617 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56717, COL_8A096969_1374_4168_B930_C219BC1F0591#56618 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56718, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56621 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56719, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56622 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56720, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56623 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56721, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56624 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56722, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56625 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56723, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56626 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56724, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56627 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56725, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56628 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56726, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56629 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56727, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56630 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56728, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56631 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56729, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56632 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56730, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56633 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56731, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56634 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56732, COL_4886635E_35B3_4E90_94E4_401045F89277#56635 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56733, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56636 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56734, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56637 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56735, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56638 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56736, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56639 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56737, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56640 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56738, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56619 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56739, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56620 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56740, COL_69842CB9_D407_4477_8F44_680AF6209358#56641 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56741]
(59) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56717 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56817, COL_8A096969_1374_4168_B930_C219BC1F0591#56718 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56818, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56719 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56819, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56720 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56820, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56721 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56821, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56722 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56822, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56723 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56823, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56724 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56824, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56725 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56825, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56726 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56826, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56727 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56827, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56728 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56828, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56729 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56829, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56730 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56830, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56731 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56831, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56732 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56832, COL_4886635E_35B3_4E90_94E4_401045F89277#56733 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56833, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56734 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56834, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56735 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56835, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56736 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56836, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56737 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56837, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56738 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56838, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56739 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56839, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56740 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56840, COL_69842CB9_D407_4477_8F44_680AF6209358#56741 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56841]