== 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_119279169`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [DATASETID_119274#122650, FIELDS_119275#122651, GEOMETRY_119276#122652, RECORDID_119278#122653, RECORD_TIMESTAM_119277#122654], false
(4) View
Arguments: `VLIB_JSON_119273169`, true
(5) SubqueryAlias
Arguments: VLIB_JSON_119273169
(6) Project
Arguments: [DATASETID_119274#122650 AS VLIB_JSON_119273_DATASETID_119274#122744, FIELDS_119275#122651 AS VLIB_JSON_119273_FIELDS_119275#122745, GEOMETRY_119276#122652 AS VLIB_JSON_119273_GEOMETRY_119276#122746, RECORDID_119278#122653 AS VLIB_JSON_119273_RECORDID_119278#122747, RECORD_TIMESTAM_119277#122654 AS VLIB_JSON_119273_RECORD_TIMESTAM_119277#122748]
(7) Project
Arguments: [cast(VLIB_JSON_119273_DATASETID_119274#122744 as string) AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122759, cast(VLIB_JSON_119273_FIELDS_119275#122745 as string) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122760, cast(VLIB_JSON_119273_GEOMETRY_119276#122746 as string) AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122761, cast(VLIB_JSON_119273_RECORD_TIMESTAM_119277#122748 as string) AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122762, cast(VLIB_JSON_119273_RECORDID_119278#122747 as string) AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122763]
(8) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122759 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122760 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122761 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122762 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122763 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773]
(9) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.is_installed as string)) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779]
(10) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.is_renting as string)) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786]
(11) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.is_returning as string)) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794]
(12) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.numbikesavailable as string)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803]
(13) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794, COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.numdocksavailable as string)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122813]
(14) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794, COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122813, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.stationcode as string)) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122824]
(15) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794, COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122813, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122824, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.ebike as string)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#122836]
(16) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794, COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122813, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122824, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#122836, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.mechanical as string)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#122849]
(17) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794, COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122813, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122824, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#122836, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#122849, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, 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#122863]
(18) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794, COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122813, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122824, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#122836, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#122849, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#122863, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.name as string)) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#122878]
(19) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794, COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122813, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122824, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#122836, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#122849, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#122863, COL_2F07F797_35B4_491C_8255_10445B86EEB9#122878, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.nom_arrondissement_communes as string)) AS COL_8A096969_1374_4168_B930_C219BC1F0591#122894]
(20) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794, COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122813, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122824, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#122836, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#122849, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#122863, COL_2F07F797_35B4_491C_8255_10445B86EEB9#122878, COL_8A096969_1374_4168_B930_C219BC1F0591#122894, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.coordonnees_geo[0] as string)) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#122911]
(21) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794, COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122813, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122824, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#122836, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#122849, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#122863, COL_2F07F797_35B4_491C_8255_10445B86EEB9#122878, COL_8A096969_1374_4168_B930_C219BC1F0591#122894, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#122911, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.coordonnees_geo[1] as string)) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#122929]
(22) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794, COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122813, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122824, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#122836, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#122849, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#122863, COL_2F07F797_35B4_491C_8255_10445B86EEB9#122878, COL_8A096969_1374_4168_B930_C219BC1F0591#122894, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#122911, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#122929, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770, cast($.stationcode as string)) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#122948]
(23) Filter
Arguments: true
(24) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122824 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122968, COL_8A096969_1374_4168_B930_C219BC1F0591#122894 AS COL_8A096969_1374_4168_B930_C219BC1F0591#122969, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#122911 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#122970, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#122929 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#122971, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#122863 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#122972, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122786 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122973, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122779 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122974, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122794 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122975, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122769 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122976, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122770 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122977, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122771 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122978, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122772 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122979, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122773 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122980, str_to_integer(COL_222816E0_1771_4A96_9C59_DB1900C311FE#122803) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#122981, str_to_integer(COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122813) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122982, str_to_integer(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#122836) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#122983, str_to_integer(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#122849) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#122984, COL_2F07F797_35B4_491C_8255_10445B86EEB9#122878 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#122985, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#122948 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#122986]
(25) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#122968 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123006, COL_8A096969_1374_4168_B930_C219BC1F0591#122969 AS COL_8A096969_1374_4168_B930_C219BC1F0591#123007, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#122970 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123008, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#122971 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123009, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#122972 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123010, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#122973 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123011, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#122974 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123012, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#122975 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123013, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#122976 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123014, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#122977 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123015, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#122978 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123016, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#122979 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123017, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#122980 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123018, COL_222816E0_1771_4A96_9C59_DB1900C311FE#122981 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#123019, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#122982 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123020, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#122983 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123021, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#122984 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123022, COL_2F07F797_35B4_491C_8255_10445B86EEB9#122985 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#123023, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#122986 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123024]
(26) LogicalRelation
Arguments: text, [value#122660], false
(27) Project
Arguments: [get_json_object(value#122660, $.results) AS data#122662]
(28) Project
Arguments: [data#122662, schema_of_json([{"stationcode":"18033","name":"Belliard - Damrémont","capacity":34,"coordonnees_geo":{"lon":2.338023450388167,"lat":48.89669238777841},"station_opening_hours":null},{"stationcode":"7008","name":"Villersexel - Saint-Germain","capacity":16,"coordonnees_geo":{"lon":2.3237934708595,"lat":48.858297001218},"station_opening_hours":null},{"stationcode":"3101","name":"Porte Saint-Martin","capacity":34,"coordonnees_geo":{"lon":2.35570102930069,"lat":48.86860172112996},"station_opening_hours":null},{"stationcode":"19021","name":"Mairie du 19ème","capacity":27,"coordonnees_geo":{"lon":2.3812624812126164,"lat":48.88256264247959},"station_opening_hours":null},{"stationcode":"17023","name":"Porte d'Asnières","capacity":36,"coordonnees_geo":{"lon":2.3036286234855656,"lat":48.89035817610495},"station_opening_hours":null},{"stationcode":"19108","name":"Gaston Tessier - Rosa Parks RER","capacity":37,"coordonnees_geo":{"lon":2.3743692,"lat":48.8963765},"station_opening_hours":null},{"stationcode":"9114","name":"Faubourg Poissonnière - Dunkerque","capacity":30,"coordonnees_geo":{"lon":2.349934279918671,"lat":48.880883445404436},"station_opening_hours":null},{"stationcode":"47001","name":"Place de la Gare","capacity":46,"coordonnees_geo":{"lon":2.4275037646293645,"lat":48.80253358011283},"station_opening_hours":null},{"stationcode":"43001","name":"Paris - Laitières","capacity":22,"coordonnees_geo":{"lon":2.4207553267479,"lat":48.846302741513},"station_opening_hours":null},{"stationcode":"92006","name":"Place Nelson Mandela","capacity":30,"coordonnees_geo":{"lon":2.2182820737361912,"lat":48.897874318180556},"station_opening_hours":null},{"stationcode":"6002","name":"Saint-Benoît - Jacob","capacity":23,"coordonnees_geo":{"lon":2.3334722220897675,"lat":48.85545136013941},"station_opening_hours":null},{"stationcode":"12015","name":"Place de la Nation - Picpus","capacity":36,"coordonnees_geo":{"lon":2.4001130461693,"lat":48.846821681548},"station_opening_hours":null},{"stationcode":"11112","name":"Jules Vallès - Charonne","capacity":23,"coordonnees_geo":{"lon":2.3847674578428,"lat":48.854284379935},"station_opening_hours":null},{"stationcode":"18034","name":"Leibniz - Jean Dollfus","capacity":32,"coordonnees_geo":{"lon":2.333390423834684,"lat":48.896328348515986},"station_opening_hours":null},{"stationcode":"16102","name":"Pergolèse - Marbeau","capacity":27,"coordonnees_geo":{"lon":2.2815125225299,"lat":48.873568706869},"station_opening_hours":null},{"stationcode":"19010","name":"Emile Reynaud - Porte de la Villette","capacity":22,"coordonnees_geo":{"lon":2.3887022584676743,"lat":48.90098953630053},"station_opening_hours":null},{"stationcode":"15132","name":"Bargue - Dutot","capacity":21,"coordonnees_geo":{"lon":2.308876,"lat":48.837884},"station_opening_hours":null},{"stationcode":"4017","name":"Place de l'Hôtel de Ville","capacity":14,"coordonnees_geo":{"lon":2.351458,"lat":48.8573314},"station_opening_hours":null},{"stationcode":"4009","name":"Village Saint-Paul","capacity":28,"coordonnees_geo":{"lon":2.3607301712036,"lat":48.852639866625},"station_opening_hours":null},{"stationcode":"42018","name":"Amédée Huon - Fort d'Ivry","capacity":31,"coordonnees_geo":{"lon":2.388489693403244,"lat":48.805131376899986},"station_opening_hours":null},{"stationcode":"48008","name":"Guy Môquet - Parvis Georges Marchais","capacity":30,"coordonnees_geo":{"lon":2.35943466424942,"lat":48.79518840095975},"station_opening_hours":null},{"stationcode":"2020","name":"Danielle Casanova - Opéra","capacity":20,"coordonnees_geo":{"lon":2.3333894088864,"lat":48.867643242297},"station_opening_hours":null},{"stationcode":"23104","name":"Quai de Sèvres - Manufacture Nationale","capacity":28,"coordonnees_geo":{"lon":2.22499,"lat":48.828688},"station_opening_hours":null},{"stationcode":"15018","name":"Dutot - Place Alleray","capacity":56,"coordonnees_geo":{"lon":2.3071701095578,"lat":48.836826091766},"station_opening_hours":null},{"stationcode":"32605","name":"Mairie","capacity":20,"coordonnees_geo":{"lon":2.4163350908311,"lat":48.87914304162},"station_opening_hours":null},{"stationcode":"15041","name":"Franquet - Labrouste","capacity":37,"coordonnees_geo":{"lon":2.306762784719467,"lat":48.83287705011431},"station_opening_hours":null},{"stationcode":"10009","name":"Mairie du 10ème","capacity":19,"coordonnees_geo":{"lon":2.3575825989246,"lat":48.872089449907},"station_opening_hours":null},{"stationcode":"20110","name":"Gambetta - Tourelles","capacity":20,"coordonnees_geo":{"lon":2.4059921130538,"lat":48.875337902264},"station_opening_hours":null},{"stationcode":"20005","name":"Reynaldo Hahn - Lagny","capacity":19,"coordonnees_geo":{"lon":2.412330328844772,"lat":48.849266043601794},"station_opening_hours":null},{"stationcode":"11016","name":"Philippe-Auguste","capacity":48,"coordonnees_geo":{"lon":2.3932945355773,"lat":48.851853488265},"station_opening_hours":null},{"stationcode":"15032","name":"Félix Faure - Lourmel","capacity":58,"coordonnees_geo":{"lon":2.2818081825971603,"lat":48.83868901709515},"station_opening_hours":null},{"stationcode":"11201","name":"Faubourg St-Antoine - Place de la Nation","capacity":16,"coordonnees_geo":{"lon":2.393606,"lat":48.8487726},"station_opening_hours":null},{"stationcode":"12106","name":"Gare de Lyon - Roland Barthes","capacity":68,"coordonnees_geo":{"lon":2.3790882155299187,"lat":48.84395729494058},"station_opening_hours":null},{"stationcode":"23205","name":"Parc des Pierrettes","capacity":23,"coordonnees_geo":{"lon":2.2909969,"lat":48.7973062},"station_opening_hours":null},{"stationcode":"31301","name":"Gare RER","capacity":30,"coordonnees_geo":{"lon":2.4581568985227,"lat":48.896280181078},"station_opening_hours":null},{"stationcode":"13203","name":"Square de Choisy - Eastman","capacity":24,"coordonnees_geo":{"lon":2.3583075090494,"lat":48.828543456283},"station_opening_hours":null},{"stationcode":"40003","name":"Centre Hospitalier Intercommunal de Créteil","capacity":17,"coordonnees_geo":{"lon":2.463801423807,"lat":48.797078298909},"station_opening_hours":null},{"stationcode":"5020","name":"Institut du Monde Arabe - Saint-Germain","capacity":40,"coordonnees_geo":{"lon":2.3558086529374,"lat":48.849063299501},"station_opening_hours":null},{"stationcode":"35022","name":"Grilles - Honoré d'Estienne d'Orves","capacity":23,"coordonnees_geo":{"lon":2.4066777712134,"lat":48.890439299703},"station_opening_hours":null},{"stationcode":"5202","name":"Arbalète - Claude Bernard","capacity":34,"coordonnees_geo":{"lon":2.347522975107,"lat":48.840008992},"station_opening_hours":null},{"stationcode":"9104","name":"Caumartin - Provence","capacity":22,"coordonnees_geo":{"lon":2.3284685611724854,"lat":48.874422773426545},"station_opening_hours":null},{"stationcode":"32304","name":"Charcot - Benfleet","capacity":28,"coordonnees_geo":{"lon":2.440523876268,"lat":48.878370277021},"station_opening_hours":null},{"stationcode":"14014","name":"Jourdan - Stade Charléty","capacity":60,"coordonnees_geo":{"lon":2.3433353751898,"lat":48.819428333369},"station_opening_hours":null},{"stationcode":"5110","name":"Lacépède - Monge","capacity":23,"coordonnees_geo":{"lon":2.3519663885235786,"lat":48.84389286531899},"station_opening_hours":null},{"stationcode":"13101","name":"Croulebarde - Corvisart","capacity":34,"coordonnees_geo":{"lon":2.3481646925210953,"lat":48.830981659316855},"station_opening_hours":null},{"stationcode":"16138","name":"Saint-Cloud - Hippodrome","capacity":30,"coordonnees_geo":{"lon":2.2549109905958176,"lat":48.85772148887421},"station_opening_hours":null},{"stationcode":"13104","name":"Gare d'Austerlitz - Quai Saint-Bernard","capacity":27,"coordonnees_geo":{"lon":2.3657163977623,"lat":48.84369030864},"station_opening_hours":null},{"stationcode":"26002","name":"Redoute - Les Courtilles","capacity":40,"coordonnees_geo":{"lon":2.2836696356535,"lat":48.929867194519},"station_opening_hours":null},{"stationcode":"15067","name":"Desaix - Edgar Faure","capacity":12,"coordonnees_geo":{"lon":2.293077029857222,"lat":48.852804604940296},"station_opening_hours":null},{"stationcode":"10016","name":"Récollets - Square Villemin","capacity":17,"coordonnees_geo":{"lon":2.359801238597928,"lat":48.875034655883944},"station_opening_hours":null},{"stationcode":"11030","name":"Oberkampf - République","capacity":24,"coordonnees_geo":{"lon":2.37611478491,"lat":48.86531608707},"station_opening_hours":null},{"stationcode":"18201","name":"Tristan Tzara - Tchaïkovski","capacity":33,"coordonnees_geo":{"lon":2.3648490384221077,"lat":48.89490221746837},"station_opening_hours":null},{"stationcode":"20132","name":"Réunion - Avron","capacity":26,"coordonnees_geo":{"lon":2.403928068708116,"lat":48.852566752033766},"station_opening_hours":null},{"stationcode":"31705","name":"Champeaux - Gallieni","capacity":50,"coordonnees_geo":{"lon":2.4161778017878532,"lat":48.864459134684644},"station_opening_hours":null},{"stationcode":"12126","name":"Gravelle - Route du Bac","capacity":51,"coordonnees_geo":{"lon":2.418455,"lat":48.824407},"station_opening_hours":null},{"stationcode":"5026","name":"Pascal - Claude Bernard","capacity":49,"coordonnees_geo":{"lon":2.3499782010912895,"lat":48.839061952159746},"station_opening_hours":null},{"stationcode":"14139","name":"Pierre Larousse - Raymond Losserand","capacity":30,"coordonnees_geo":{"lon":2.3119183257222176,"lat":48.83059564231877},"station_opening_hours":null},{"stationcode":"21308","name":"Bara - Henri Farman","capacity":58,"coordonnees_geo":{"lon":2.2677567601203923,"lat":48.833218027457846},"station_opening_hours":null},{"stationcode":"31019","name":"Vincennes - Douy-Delcupe","capacity":38,"coordonnees_geo":{"lon":2.436049282550812,"lat":48.85493692155721},"station_opening_hours":null},{"stationcode":"9117","name":"Bellefond - Maubeuge","capacity":31,"coordonnees_geo":{"lon":2.3452642187476,"lat":48.878255397645},"station_opening_hours":null},{"stationcode":"11010","name":"Boulets - Faubourg Saint-Antoine","capacity":43,"coordonnees_geo":{"lon":2.3917546141943,"lat":48.849259262115},"station_opening_hours":null},{"stationcode":"32015","name":"Gare RER de Saint-Denis","capacity":40,"coordonnees_geo":{"lon":2.3471488058567047,"lat":48.93554324248177},"station_opening_hours":null},{"stationcode":"10207","name":"Charles Robin - Grange aux Belles","capacity":23,"coordonnees_geo":{"lon":2.3698456519833,"lat":48.877376705016},"station_opening_hours":null},{"stationcode":"11034","name":"Parmentier - Fontaine au Roi","capacity":48,"coordonnees_geo":{"lon":2.372705978671471,"lat":48.86787670551736},"station_opening_hours":null},{"stationcode":"23008","name":"Hôtel de Ville de Levallois Perret","capacity":26,"coordonnees_geo":{"lon":2.2888818383216862,"lat":48.89314451997415},"station_opening_hours":null},{"stationcode":"9113","name":"Bleue - Trévise","capacity":30,"coordonnees_geo":{"lon":2.347289621829987,"lat":48.87578906564573},"station_opening_hours":null},{"stationcode":"21951","name":"Place Centrale","capacity":22,"coordonnees_geo":{"lon":2.2278830409049992,"lat":48.78740167690531},"station_opening_hours":null},{"stationcode":"92005","name":"Gare de Nanterre Ville","capacity":43,"coordonnees_geo":{"lon":2.1957932,"lat":48.8950295},"station_opening_hours":null},{"stationcode":"35015","name":"Averroès - Aimé Césaire","capacity":19,"coordonnees_geo":{"lon":2.412636950612068,"lat":48.91405323432864},"station_opening_hours":null},{"stationcode":"9016","name":"Choron - Martyrs","capacity":29,"coordonnees_geo":{"lon":2.3396701365709,"lat":48.877851443503},"station_opening_hours":null},{"stationcode":"21029","name":"Cours de l'Ile Seguin - Parc Billancourt","capacity":29,"coordonnees_geo":{"lon":2.234234511852265,"lat":48.82714055843935},"station_opening_hours":null},{"stationcode":"19208","name":"Sérurier - Alphonse Aulard","capacity":16,"coordonnees_geo":{"lon":2.398028970957,"lat":48.880528901839},"station_opening_hours":null},{"stationcode":"41210","name":"Hôtel de ville de Fontenay-sous-Bois","capacity":20,"coordonnees_geo":{"lon":2.4750164151191716,"lat":48.84949749106274},"station_opening_hours":null},{"stationcode":"44101","name":"Place Mongolfier","capacity":39,"coordonnees_geo":{"lon":2.4592879414558415,"lat":48.815160030060376},"station_opening_hours":null},{"stationcode":"15005","name":"Place Jacques et Thérèse Tréfouël","capacity":43,"coordonnees_geo":{"lon":2.3125657439232,"lat":48.842726498317},"station_opening_hours":null},{"stationcode":"7017","name":"La Motte-Picquet - La Tour Maubourg","capacity":40,"coordonnees_geo":{"lon":2.3096215831203,"lat":48.856926701847},"station_opening_hours":null},{"stationcode":"35006","name":"Delizy - Louis Nadot","capacity":22,"coordonnees_geo":{"lon":2.4094578623771667,"lat":48.896212845581346},"station_opening_hours":null},{"stationcode":"32601","name":"Porte des Lilas - Faidherbe","capacity":39,"coordonnees_geo":{"lon":2.4120327830314636,"lat":48.87861855668978},"station_opening_hours":null},{"stationcode":"13516","name":"Glacière - Soeur Catherine Marie","capacity":40,"coordonnees_geo":{"lon":2.343570403754711,"lat":48.829522989420596},"station_opening_hours":null},{"stationcode":"7202","name":"Constant Coquelin - Invalides","capacity":31,"coordonnees_geo":{"lon":2.315749520203,"lat":48.848283157236},"station_opening_hours":null},{"stationcode":"5115","name":"Buffon - Jardin des Plantes","capacity":30,"coordonnees_geo":{"lon":2.3618587106466293,"lat":48.842668466104875},"station_opening_hours":null},{"stationcode":"21319","name":"Esplanade du Foncet - Camille Desmoulins","capacity":28,"coordonnees_geo":{"lon":2.2606857866049,"lat":48.827090233495},"station_opening_hours":null},{"stationcode":"15129","name":"Hôpital Necker","capacity":40,"coordonnees_geo":{"lon":2.313245013356209,"lat":48.846043490118454},"station_opening_hours":null},{"stationcode":"33014","name":"Parc Eli Lotar","capacity":20,"coordonnees_geo":{"lon":2.3727085813879967,"lat":48.91844993053703},"station_opening_hours":null},{"stationcode":"48004","name":"Maxime Gorki - Louis Aragon","capacity":20,"coordonnees_geo":{"lon":2.368387877941132,"lat":48.78909814728443},"station_opening_hours":null},{"stationcode":"14001","name":"Edgar Quinet - Gaité","capacity":27,"coordonnees_geo":{"lon":2.324595451355,"lat":48.841160928966},"station_opening_hours":null},{"stationcode":"44014","name":"Camille Risch - Paul Armangot","capacity":25,"coordonnees_geo":{"lon":2.373685,"lat":48.774703},"station_opening_hours":null},{"stationcode":"21309","name":"Mairie d'Issy","capacity":41,"coordonnees_geo":{"lon":2.2723111510277,"lat":48.823767792468},"station_opening_hours":null},{"stationcode":"7012","name":"Cité Vaneau","capacity":26,"coordonnees_geo":{"lon":2.319614924490452,"lat":48.8542210666207},"station_opening_hours":null},{"stationcode":"8110","name":"Gare Saint-Lazare - Stockholm","capacity":32,"coordonnees_geo":{"lon":2.322417162358761,"lat":48.877127316667654},"station_opening_hours":null},{"stationcode":"20029","name":"Frères Flavien - Porte des Lilas","capacity":23,"coordonnees_geo":{"lon":2.41104629853209,"lat":48.8780992764359},"station_opening_hours":null},{"stationcode":"9111","name":"Victoire - Laffitte","capacity":20,"coordonnees_geo":{"lon":2.338118505144376,"lat":48.87514373494672},"station_opening_hours":null},{"stationcode":"44001","name":"Quai Jules Guesde - Saint-Simon","capacity":30,"coordonnees_geo":{"lon":2.4089661620274,"lat":48.80391487219},"station_opening_hours":null},{"stationcode":"22603","name":"Place de la Division Leclerc","capacity":34,"coordonnees_geo":{"lon":2.2731140430551027,"lat":48.793824988636516},"station_opening_hours":null},{"stationcode":"6029","name":"Vaugirard - Monsieur le Prince","capacity":26,"coordonnees_geo":{"lon":2.3411329463124,"lat":48.848951441614},"station_opening_hours":null},{"stationcode":"26012","name":"Jardin Modèle - Pierre Boudou","capacity":18,"coordonnees_geo":{"lon":2.3057010525935,"lat":48.914866710946},"station_opening_hours":null},{"stationcode":"24101","name":"Place Charles de Gaulle","capacity":24,"coordonnees_geo":{"lon":2.1894485725692,"lat":48.826073335699},"station_opening_hours":null},{"stationcode":"31104","name":"Mairie de Rosny-sous-Bois","capacity":30,"coordonnees_geo":{"lon":2.4865807592869,"lat":48.871256519012},"station_opening_hours":null},{"stationcode":"5033","name":"Saint-Séverin - Saint-Michel","capacity":30,"coordonnees_geo":{"lon":2.3440927639604,"lat":48.852731305488},"station_opening_hours":null},{"stationcode":"6028","name":"Quatre Vents - Carrefour de l'Odéon","capacity":37,"coordonnees_geo":{"lon":2.338161695134053,"lat":48.851751374458864},"station_opening_hours":null}]) AS schema#122669]
(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#122662, Some(Etc/UTC)) AS root#122675]
(30) Generate
Arguments: explode(root#122675), false, [root#122678]
(31) Project
Arguments: [root#122678]
(32) Project
Arguments: [root#122678.capacity AS capacity#122680L, root#122678.coordonnees_geo AS coordonnees_geo#122681, root#122678.name AS name#122682, root#122678.station_opening_hours AS station_opening_hours#122683, root#122678.stationcode AS stationcode#122684]
(33) Project
Arguments: [capacity#122680L, to_json(coordonnees_geo#122681, Some(Etc/UTC)) AS coordonnees_geo#122690, name#122682, station_opening_hours#122683, stationcode#122684]
(34) Project
Arguments: [capacity#122680L AS capacity#122696L, coordonnees_geo#122690 AS coordonnees_geo#122697, name#122682 AS name#122698, station_opening_hours#122683 AS station_opening_hours#122699, stationcode#122684 AS stationcode#122700]
(35) Project
Arguments: [capacity#122696L, coordonnees_geo#122697, name#122698, station_opening_hours#122699, stationcode#122700]
(36) Project
Arguments: [capacity#122696L AS CAPACITY_119304#122711L, coordonnees_geo#122697 AS COORDONNEES_GEO_119305#122712, name#122698 AS NAME_119306#122713, stationcode#122700 AS STATIONCODE_119307#122714]
(37) Project
Arguments: [CAPACITY_119304#122711L, COORDONNEES_GEO_119305#122712, NAME_119306#122713, STATIONCODE_119307#122714]
(38) View
Arguments: `72D94506_05A1_4CB0_9A48_B952DD1F6F98`, true
(39) SubqueryAlias
Arguments: 72D94506_05A1_4CB0_9A48_B952DD1F6F98
(40) Project
Arguments: [CAPACITY_119304#122711L, COORDONNEES_GEO_119305#122712, NAME_119306#122713, STATIONCODE_119307#122714]
(41) Aggregate
Arguments: [CAPACITY_119304#122711L, COORDONNEES_GEO_119305#122712, NAME_119306#122713, STATIONCODE_119307#122714], [CAPACITY_119304#122711L, COORDONNEES_GEO_119305#122712, NAME_119306#122713, STATIONCODE_119307#122714]
(42) View
Arguments: `INFORMATION_STA_119303169`, true
(43) SubqueryAlias
Arguments: INFORMATION_STA_119303169
(44) Project
Arguments: [CAPACITY_119304#122711L AS INFORMATION_STA_119303_CAPACITY_119304#123048L, COORDONNEES_GEO_119305#122712 AS INFORMATION_STA_119303_COORDONNEES_GEO_119305#123049, NAME_119306#122713 AS INFORMATION_STA_119303_NAME_119306#123050, STATIONCODE_119307#122714 AS INFORMATION_STA_119303_STATIONCODE_119307#123051]
(45) Join
Arguments: LeftOuter, (COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123006 = INFORMATION_STA_119303_STATIONCODE_119307#123051)
(46) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123006, COL_8A096969_1374_4168_B930_C219BC1F0591#123007, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123008, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123009, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123010, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123011, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123012, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123013, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123014, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123015, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123016, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123017, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123018, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123019, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123020, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123021, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123022, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123023, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123024, INFORMATION_STA_119303_CAPACITY_119304#123048L AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123102L]
(47) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123006 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123123, COL_8A096969_1374_4168_B930_C219BC1F0591#123007 AS COL_8A096969_1374_4168_B930_C219BC1F0591#123124, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123008 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123125, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123009 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123126, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123010 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123127, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123011 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123128, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123012 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123129, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123013 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123130, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123014 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123131, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123015 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123132, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123016 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123133, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123017 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123134, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123018 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123135, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123019 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#123136, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123020 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123137, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123021 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123138, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123022 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123139, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123023 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#123140, bigint_to_int(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123102L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123141, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123024 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123142]
(48) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123123 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123163, COL_8A096969_1374_4168_B930_C219BC1F0591#123124 AS COL_8A096969_1374_4168_B930_C219BC1F0591#123164, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123125 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123165, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123126 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123166, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123127 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123167, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123128 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123168, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123129 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123169, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123130 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123170, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123131 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123171, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123132 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123172, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123133 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123173, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123134 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123174, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123135 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123175, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123138 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123139 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123140 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#123178, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123136 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#123179, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123137 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123180, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123141 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123181, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123142 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123182]
(49) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123163, COL_8A096969_1374_4168_B930_C219BC1F0591#123164, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123165, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123166, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123167, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123168, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123169, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123170, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123171, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123172, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123173, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123174, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123175, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123178, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123179, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123180, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123181, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123182, dec_operator(cast(SOMME as string), array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177)) AS COL_4886635E_35B3_4E90_94E4_401045F89277#123203]
(50) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123163, COL_8A096969_1374_4168_B930_C219BC1F0591#123164, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123165, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123166, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123167, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123168, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123169, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123170, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123171, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123172, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123173, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123174, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123175, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123178, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123179, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123180, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123181, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123182, COL_4886635E_35B3_4E90_94E4_401045F89277#123203, str_if_with_rule((CASE WHEN isnull((COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176 > cast(0 as int))) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176 > cast(0 as int)) END AND CASE WHEN isnull((COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177 > cast(0 as int))) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177 > cast(0 as int)) END), cast(Mécaniques + Electriques as string), str_if_with_rule(CASE WHEN isnull((COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177 > cast(0 as int))) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177 > cast(0 as int)) END, cast(Mécaniques as string), str_if_with_rule(CASE WHEN isnull((COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176 > cast(0 as int))) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176 > cast(0 as int)) END, cast(Electriques as string), cast(Pas de disponibilité as string)))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123225]
(51) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123163, COL_8A096969_1374_4168_B930_C219BC1F0591#123164, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123165, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123166, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123167, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123168, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123169, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123170, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123171, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123172, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123173, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123174, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123175, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123178, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123179, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123180, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123181, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123182, COL_4886635E_35B3_4E90_94E4_401045F89277#123203, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123225, dec_round(dec_operator(cast(PRODUIT as string), array(dec_operator(cast(DIVISION as string), array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#123179, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123181, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123179)))), cast(100 as double))), cast(2 as int)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123248]
(52) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123163, COL_8A096969_1374_4168_B930_C219BC1F0591#123164, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123165, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123166, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123167, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123168, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123169, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123170, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123171, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123172, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123173, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123174, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123175, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123178, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123179, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123180, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123181, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123182, COL_4886635E_35B3_4E90_94E4_401045F89277#123203, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123225, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123248, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123181)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#123272]
(53) Filter
Arguments: CASE WHEN isnull((COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123181 > cast(0 as int))) THEN false ELSE (COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123181 > cast(0 as int)) END
(54) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123163 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123297, COL_8A096969_1374_4168_B930_C219BC1F0591#123164 AS COL_8A096969_1374_4168_B930_C219BC1F0591#123298, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123165 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123299, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123166 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123300, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123167 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123301, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123168 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123302, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123169 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123303, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123170 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123304, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123171 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123305, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123172 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123306, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123173 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123307, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123174 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123308, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123175 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123309, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123176 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123310, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123177 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123311, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123178 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#123312, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123179 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#123313, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123180 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123314, COL_4886635E_35B3_4E90_94E4_401045F89277#123203 AS COL_4886635E_35B3_4E90_94E4_401045F89277#123315, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123225 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123316, dec_to_int(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123248) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123317, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123181 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123318, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123182 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123319, COL_69842CB9_D407_4477_8F44_680AF6209358#123272 AS COL_69842CB9_D407_4477_8F44_680AF6209358#123320]
(55) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123297 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123345, COL_8A096969_1374_4168_B930_C219BC1F0591#123298 AS COL_8A096969_1374_4168_B930_C219BC1F0591#123346, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123299 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123347, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123300 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123348, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123301 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123349, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123302 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123350, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123303 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123351, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123304 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123352, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123305 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123353, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123306 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123354, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123307 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123355, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123308 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123356, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123309 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123357, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123310 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123358, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123311 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123359, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123312 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#123360, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123313 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#123361, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123314 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123362, COL_4886635E_35B3_4E90_94E4_401045F89277#123315 AS COL_4886635E_35B3_4E90_94E4_401045F89277#123363, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123316 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123364, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123317 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123319 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123366, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123318 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123367, COL_69842CB9_D407_4477_8F44_680AF6209358#123320 AS COL_69842CB9_D407_4477_8F44_680AF6209358#123368]
(56) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123345, COL_8A096969_1374_4168_B930_C219BC1F0591#123346, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123347, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123348, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123349, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123350, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123351, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123352, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123353, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123354, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123355, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123356, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123357, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123358, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123359, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123360, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123361, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123362, COL_4886635E_35B3_4E90_94E4_401045F89277#123363, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123364, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123366, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123367, COL_69842CB9_D407_4477_8F44_680AF6209358#123368, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, < 10 %, less_or_equal, struct(col1, 10), struct(col1, 0), #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, de 10 à 20 %, between, struct(col1, 10), struct(col1, 20), #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, de 20 à 30 %, between, struct(col1, 20), struct(col1, 30), #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, de 30 à 40 %, between, struct(col1, 30), struct(col1, 40), #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, de 40 à 50 %, between, struct(col1, 40), struct(col1, 50), #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, de 50 à 60 %, between, struct(col1, 50), struct(col1, 60), #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, de 60 à 70 %, between, struct(col1, 60), struct(col1, 70), #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, de 70 à 80 %, between, struct(col1, 70), struct(col1, 80), #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, de 80 à 90, between, struct(col1, 80), struct(col1, 90), #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365, > 90 %, greater_or_equal, struct(col1, 90), struct(col1, 0), #219A48, , null))) AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#123393]
(57) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123345 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123419, COL_8A096969_1374_4168_B930_C219BC1F0591#123346 AS COL_8A096969_1374_4168_B930_C219BC1F0591#123420, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123347 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123421, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123348 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123422, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123349 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123423, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123350 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123424, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123351 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123425, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123352 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123426, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123353 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123427, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123354 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123428, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123355 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123429, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123356 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123430, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123357 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123431, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123358 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123432, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123359 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123433, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123360 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#123434, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123361 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#123435, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123362 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123436, COL_4886635E_35B3_4E90_94E4_401045F89277#123363 AS COL_4886635E_35B3_4E90_94E4_401045F89277#123437, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123364 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123438, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123365 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123439, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123366 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123440, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#123393 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#123441, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123367 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123442, COL_69842CB9_D407_4477_8F44_680AF6209358#123368 AS COL_69842CB9_D407_4477_8F44_680AF6209358#123443]
(58) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123419 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123469, COL_8A096969_1374_4168_B930_C219BC1F0591#123420 AS COL_8A096969_1374_4168_B930_C219BC1F0591#123470, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123423 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123471, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123424 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123472, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123425 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123473, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123426 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123474, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123427 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123475, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123428 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123476, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123429 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123477, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123430 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123478, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123431 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123479, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123432 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123480, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123433 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123481, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123434 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#123482, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123435 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#123483, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123436 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123484, COL_4886635E_35B3_4E90_94E4_401045F89277#123437 AS COL_4886635E_35B3_4E90_94E4_401045F89277#123485, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123438 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123486, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123439 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123487, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123440 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123488, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#123441 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#123489, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123442 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123490, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123421 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123491, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123422 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123492, COL_69842CB9_D407_4477_8F44_680AF6209358#123443 AS COL_69842CB9_D407_4477_8F44_680AF6209358#123493]
(59) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123469 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#123519, COL_8A096969_1374_4168_B930_C219BC1F0591#123470 AS COL_8A096969_1374_4168_B930_C219BC1F0591#123520, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123471 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#123521, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123472 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#123522, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123473 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#123523, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123474 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#123524, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123475 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#123525, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123476 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#123526, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123477 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#123527, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123478 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#123528, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123479 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#123529, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123480 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#123530, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123481 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#123531, COL_2F07F797_35B4_491C_8255_10445B86EEB9#123482 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#123532, COL_222816E0_1771_4A96_9C59_DB1900C311FE#123483 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#123533, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123484 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#123534, COL_4886635E_35B3_4E90_94E4_401045F89277#123485 AS COL_4886635E_35B3_4E90_94E4_401045F89277#123535, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123486 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#123536, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123487 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#123537, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123488 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#123538, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#123489 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#123539, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123490 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#123540, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123491 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#123541, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123492 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#123542, COL_69842CB9_D407_4477_8F44_680AF6209358#123493 AS COL_69842CB9_D407_4477_8F44_680AF6209358#123543]