== 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_119279174`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [DATASETID_119274#54380, FIELDS_119275#54381, GEOMETRY_119276#54382, RECORDID_119278#54383, RECORD_TIMESTAM_119277#54384], false
(4) View
Arguments: `VLIB_JSON_119273174`, true
(5) SubqueryAlias
Arguments: VLIB_JSON_119273174
(6) Project
Arguments: [DATASETID_119274#54380 AS VLIB_JSON_119273_DATASETID_119274#54721, FIELDS_119275#54381 AS VLIB_JSON_119273_FIELDS_119275#54722, GEOMETRY_119276#54382 AS VLIB_JSON_119273_GEOMETRY_119276#54723, RECORDID_119278#54383 AS VLIB_JSON_119273_RECORDID_119278#54724, RECORD_TIMESTAM_119277#54384 AS VLIB_JSON_119273_RECORD_TIMESTAM_119277#54725]
(7) Project
Arguments: [cast(VLIB_JSON_119273_DATASETID_119274#54721 as string) AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54751, cast(VLIB_JSON_119273_FIELDS_119275#54722 as string) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54752, cast(VLIB_JSON_119273_GEOMETRY_119276#54723 as string) AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54753, cast(VLIB_JSON_119273_RECORD_TIMESTAM_119277#54725 as string) AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54754, cast(VLIB_JSON_119273_RECORDID_119278#54724 as string) AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54755]
(8) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54751 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54752 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54753 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54754 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54755 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773]
(9) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.is_installed as string)) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796]
(10) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.is_renting as string)) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823]
(11) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.is_returning as string)) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853]
(12) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.numbikesavailable as string)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886]
(13) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.numdocksavailable as string)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54897]
(14) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54897, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.stationcode as string)) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54947]
(15) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54897, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54947, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.ebike as string)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54974]
(16) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54897, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54947, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54974, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.mechanical as string)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55017]
(17) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54897, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54947, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54974, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55017, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, 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#55063]
(18) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54897, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54947, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54974, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55017, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55063, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.name as string)) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55112]
(19) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54897, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54947, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54974, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55017, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55063, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55112, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.nom_arrondissement_communes as string)) AS COL_8A096969_1374_4168_B930_C219BC1F0591#55163]
(20) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54897, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54947, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54974, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55017, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55063, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55112, COL_8A096969_1374_4168_B930_C219BC1F0591#55163, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.coordonnees_geo[0] as string)) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55218]
(21) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54897, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54947, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54974, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55017, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55063, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55112, COL_8A096969_1374_4168_B930_C219BC1F0591#55163, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55218, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.coordonnees_geo[1] as string)) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55256]
(22) Project
Arguments: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853, COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54897, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54947, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54974, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55017, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55063, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55112, COL_8A096969_1374_4168_B930_C219BC1F0591#55163, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55218, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55256, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770, cast($.stationcode as string)) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55332]
(23) Filter
Arguments: true
(24) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#54947 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55428, COL_8A096969_1374_4168_B930_C219BC1F0591#55163 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55429, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55218 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55430, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55256 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55431, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55063 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55432, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#54823 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55433, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#54796 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55434, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#54853 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55435, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#54769 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55436, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#54770 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55437, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#54771 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55438, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#54772 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55439, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#54773 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55440, str_to_integer(COL_222816E0_1771_4A96_9C59_DB1900C311FE#54886) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55441, str_to_integer(COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#54897) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55442, str_to_integer(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#54974) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55443, str_to_integer(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55017) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55444, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55112 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55445, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55332 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55446]
(25) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55428 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55520, COL_8A096969_1374_4168_B930_C219BC1F0591#55429 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55521, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55430 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55522, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55431 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55523, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55432 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55524, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55433 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55525, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55434 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55526, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55435 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55527, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55436 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55528, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55437 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55529, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55438 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55530, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55439 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55531, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55440 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55532, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55441 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55533, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55442 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55534, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55443 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55535, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55444 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55536, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55445 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55537, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55446 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55538]
(26) LogicalRelation
Arguments: text, [value#54420], false
(27) Project
Arguments: [get_json_object(value#54420, $.results) AS data#54422]
(28) Project
Arguments: [data#54422, 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#54449]
(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#54422, Some(Etc/UTC)) AS root#54531]
(30) Generate
Arguments: explode(root#54531), false, [root#54554]
(31) Project
Arguments: [root#54554]
(32) Project
Arguments: [root#54554.capacity AS capacity#54560L, root#54554.coordonnees_geo AS coordonnees_geo#54561, root#54554.name AS name#54562, root#54554.station_opening_hours AS station_opening_hours#54563, root#54554.stationcode AS stationcode#54564]
(33) Project
Arguments: [capacity#54560L, to_json(coordonnees_geo#54561, Some(Etc/UTC)) AS coordonnees_geo#54578, name#54562, station_opening_hours#54563, stationcode#54564]
(34) Project
Arguments: [capacity#54560L AS capacity#54584L, coordonnees_geo#54578 AS coordonnees_geo#54585, name#54562 AS name#54586, station_opening_hours#54563 AS station_opening_hours#54587, stationcode#54564 AS stationcode#54588]
(35) Project
Arguments: [capacity#54584L, coordonnees_geo#54585, name#54586, station_opening_hours#54587, stationcode#54588]
(36) Project
Arguments: [capacity#54584L AS CAPACITY_119304#54599L, coordonnees_geo#54585 AS COORDONNEES_GEO_119305#54600, name#54586 AS NAME_119306#54601, stationcode#54588 AS STATIONCODE_119307#54602]
(37) Project
Arguments: [CAPACITY_119304#54599L, COORDONNEES_GEO_119305#54600, NAME_119306#54601, STATIONCODE_119307#54602]
(38) View
Arguments: `3C6A7703_4AC4_4E5F_972B_A769948D6CBF`, true
(39) SubqueryAlias
Arguments: 3C6A7703_4AC4_4E5F_972B_A769948D6CBF
(40) Project
Arguments: [CAPACITY_119304#54599L, COORDONNEES_GEO_119305#54600, NAME_119306#54601, STATIONCODE_119307#54602]
(41) Aggregate
Arguments: [CAPACITY_119304#54599L, COORDONNEES_GEO_119305#54600, NAME_119306#54601, STATIONCODE_119307#54602], [CAPACITY_119304#54599L, COORDONNEES_GEO_119305#54600, NAME_119306#54601, STATIONCODE_119307#54602]
(42) View
Arguments: `INFORMATION_STA_119303174`, true
(43) SubqueryAlias
Arguments: INFORMATION_STA_119303174
(44) Project
Arguments: [CAPACITY_119304#54599L AS INFORMATION_STA_119303_CAPACITY_119304#55570L, COORDONNEES_GEO_119305#54600 AS INFORMATION_STA_119303_COORDONNEES_GEO_119305#55571, NAME_119306#54601 AS INFORMATION_STA_119303_NAME_119306#55572, STATIONCODE_119307#54602 AS INFORMATION_STA_119303_STATIONCODE_119307#55573]
(45) Join
Arguments: LeftOuter, (COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55520 = INFORMATION_STA_119303_STATIONCODE_119307#55573)
(46) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55520, COL_8A096969_1374_4168_B930_C219BC1F0591#55521, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55522, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55523, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55524, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55525, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55526, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55527, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55528, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55529, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55530, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55531, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55532, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55533, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55534, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55535, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55536, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55537, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55538, INFORMATION_STA_119303_CAPACITY_119304#55570L AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55718L]
(47) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55520 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55819, COL_8A096969_1374_4168_B930_C219BC1F0591#55521 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55820, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55522 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55821, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55523 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55822, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55524 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55823, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55525 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55824, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55526 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55825, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55527 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55826, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55528 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55827, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55529 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55828, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55530 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55829, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55531 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55830, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55532 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55831, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55533 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55832, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55534 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55833, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55535 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55834, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55536 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55835, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55537 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55836, bigint_to_int(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55718L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55837, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55538 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55838]
(48) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55819 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55939, COL_8A096969_1374_4168_B930_C219BC1F0591#55820 AS COL_8A096969_1374_4168_B930_C219BC1F0591#55940, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55821 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55941, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55822 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55942, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55823 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55943, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55824 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55944, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55825 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55945, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55826 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55946, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55827 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55947, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55828 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55948, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55829 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55949, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55830 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55950, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55831 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55951, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55834 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55835 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55836 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#55954, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55832 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#55955, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55833 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55956, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55837 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55957, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55838 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55958]
(49) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55939, COL_8A096969_1374_4168_B930_C219BC1F0591#55940, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55941, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55942, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55943, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55944, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55945, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55946, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55947, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55948, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55949, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55950, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55951, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55954, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55955, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55956, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55957, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55958, dec_operator(cast(SOMME as string), array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953)) AS COL_4886635E_35B3_4E90_94E4_401045F89277#56021]
(50) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55939, COL_8A096969_1374_4168_B930_C219BC1F0591#55940, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55941, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55942, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55943, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55944, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55945, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55946, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55947, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55948, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55949, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55950, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55951, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55954, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55955, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55956, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55957, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55958, COL_4886635E_35B3_4E90_94E4_401045F89277#56021, str_if_with_rule((CASE WHEN isnull((COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952 > cast(0 as int))) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952 > cast(0 as int)) END AND CASE WHEN isnull((COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953 > cast(0 as int))) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953 > cast(0 as int)) END), cast(Mécaniques + Electriques as string), str_if_with_rule(CASE WHEN isnull((COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953 > cast(0 as int))) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953 > cast(0 as int)) END, cast(Mécaniques as string), str_if_with_rule(CASE WHEN isnull((COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952 > cast(0 as int))) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952 > cast(0 as int)) END, cast(Electriques as string), cast(Pas de disponibilité as string)))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56087]
(51) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55939, COL_8A096969_1374_4168_B930_C219BC1F0591#55940, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55941, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55942, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55943, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55944, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55945, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55946, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55947, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55948, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55949, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55950, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55951, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55954, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55955, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55956, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55957, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55958, COL_4886635E_35B3_4E90_94E4_401045F89277#56021, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56087, dec_round(dec_operator(cast(PRODUIT as string), array(dec_operator(cast(DIVISION as string), array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#55955, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55957, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55955)))), cast(100 as double))), cast(2 as int)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56156]
(52) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55939, COL_8A096969_1374_4168_B930_C219BC1F0591#55940, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55941, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55942, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55943, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55944, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55945, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55946, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55947, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55948, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55949, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55950, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55951, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55954, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55955, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55956, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55957, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55958, COL_4886635E_35B3_4E90_94E4_401045F89277#56021, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56087, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56156, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55957)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#56276]
(53) Filter
Arguments: CASE WHEN isnull((COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55957 > cast(0 as int))) THEN false ELSE (COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55957 > cast(0 as int)) END
(54) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#55939 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56421, COL_8A096969_1374_4168_B930_C219BC1F0591#55940 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56422, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#55941 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56423, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#55942 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56424, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#55943 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56425, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#55944 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56426, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#55945 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56427, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#55946 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56428, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#55947 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56429, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#55948 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56430, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#55949 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56431, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#55950 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56432, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#55951 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56433, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#55952 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56434, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#55953 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56435, COL_2F07F797_35B4_491C_8255_10445B86EEB9#55954 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56436, COL_222816E0_1771_4A96_9C59_DB1900C311FE#55955 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56437, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#55956 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56438, COL_4886635E_35B3_4E90_94E4_401045F89277#56021 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56439, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56087 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56440, dec_to_int(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56156) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56441, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#55957 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56442, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#55958 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56443, COL_69842CB9_D407_4477_8F44_680AF6209358#56276 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56444]
(55) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56421 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56518, COL_8A096969_1374_4168_B930_C219BC1F0591#56422 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56519, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56423 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56520, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56424 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56521, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56425 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56522, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56426 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56523, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56427 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56524, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56428 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56525, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56429 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56526, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56430 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56527, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56431 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56528, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56432 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56529, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56433 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56530, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56434 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56531, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56435 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56532, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56436 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56533, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56437 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56534, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56438 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56535, COL_4886635E_35B3_4E90_94E4_401045F89277#56439 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56536, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56440 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56537, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56441 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56443 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56539, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56442 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56540, COL_69842CB9_D407_4477_8F44_680AF6209358#56444 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56541]
(56) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56518, COL_8A096969_1374_4168_B930_C219BC1F0591#56519, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56520, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56521, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56522, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56523, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56524, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56525, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56526, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56527, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56528, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56529, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56530, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56531, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56532, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56533, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56534, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56535, COL_4886635E_35B3_4E90_94E4_401045F89277#56536, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56537, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56539, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56540, COL_69842CB9_D407_4477_8F44_680AF6209358#56541, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, < 10 %, less_or_equal, struct(col1, 10), struct(col1, 0), #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, de 10 à 20 %, between, struct(col1, 10), struct(col1, 20), #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, de 20 à 30 %, between, struct(col1, 20), struct(col1, 30), #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, de 30 à 40 %, between, struct(col1, 30), struct(col1, 40), #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, de 40 à 50 %, between, struct(col1, 40), struct(col1, 50), #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, de 50 à 60 %, between, struct(col1, 50), struct(col1, 60), #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, de 60 à 70 %, between, struct(col1, 60), struct(col1, 70), #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, de 70 à 80 %, between, struct(col1, 70), struct(col1, 80), #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, de 80 à 90, between, struct(col1, 80), struct(col1, 90), #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538, > 90 %, greater_or_equal, struct(col1, 90), struct(col1, 0), #219A48, , null))) AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56591]
(57) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56518 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56767, COL_8A096969_1374_4168_B930_C219BC1F0591#56519 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56768, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56520 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56769, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56521 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56770, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56522 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56771, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56523 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56772, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56524 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56773, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56525 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56774, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56526 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56775, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56527 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56776, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56528 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56777, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56529 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56778, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56530 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56779, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56531 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56780, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56532 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56781, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56533 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56782, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56534 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56783, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56535 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56784, COL_4886635E_35B3_4E90_94E4_401045F89277#56536 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56785, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56537 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56786, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56538 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56787, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56539 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56788, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56591 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56789, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56540 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56790, COL_69842CB9_D407_4477_8F44_680AF6209358#56541 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56791]
(58) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56767 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56917, COL_8A096969_1374_4168_B930_C219BC1F0591#56768 AS COL_8A096969_1374_4168_B930_C219BC1F0591#56918, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56771 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56919, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56772 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56920, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56773 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56921, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56774 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56922, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56775 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56923, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56776 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56924, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56777 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56925, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56778 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56926, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56779 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56927, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56780 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56928, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56781 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56929, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56782 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#56930, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56783 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#56931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56784 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56932, COL_4886635E_35B3_4E90_94E4_401045F89277#56785 AS COL_4886635E_35B3_4E90_94E4_401045F89277#56933, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56786 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56934, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56787 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56935, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56788 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56936, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56789 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56937, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56790 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56938, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56769 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56939, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56770 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56940, COL_69842CB9_D407_4477_8F44_680AF6209358#56791 AS COL_69842CB9_D407_4477_8F44_680AF6209358#56941]
(59) Project
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#56917 AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#57042, COL_8A096969_1374_4168_B930_C219BC1F0591#56918 AS COL_8A096969_1374_4168_B930_C219BC1F0591#57043, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#56919 AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#57044, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#56920 AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#57045, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#56921 AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#57046, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#56922 AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#57047, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#56923 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#57048, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#56924 AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#57049, COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#56925 AS COL_CC9E2BDB_C960_436A_982D_74C88CB1DD07#57050, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#56926 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#57051, COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#56927 AS COL_3A63BBB5_425C_465D_B8B3_D2E0C982E859#57052, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#56928 AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#57053, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#56929 AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#57054, COL_2F07F797_35B4_491C_8255_10445B86EEB9#56930 AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#57055, COL_222816E0_1771_4A96_9C59_DB1900C311FE#56931 AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#57056, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#56932 AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#57057, COL_4886635E_35B3_4E90_94E4_401045F89277#56933 AS COL_4886635E_35B3_4E90_94E4_401045F89277#57058, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#56934 AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#57059, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#56935 AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#57060, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#56936 AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#57061, COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#56937 AS COL_C263C963_DBFC_4CA5_8638_D9F3EF4E4057#57062, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#56938 AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#57063, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#56939 AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#57064, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#56940 AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#57065, COL_69842CB9_D407_4477_8F44_680AF6209358#56941 AS COL_69842CB9_D407_4477_8F44_680AF6209358#57066]