== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Aggregate (18)
+- Project (17)
+- SubqueryAlias (16)
+- View (15)
+- Project (14)
+- Project (13)
+- Project (12)
+- Project (11)
+- Project (10)
+- Project (9)
+- Project (8)
+- Generate (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `INFORMATION_STA_119303167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: text, [value#54392], false
(4) Project
Arguments: [get_json_object(value#54392, $.results) AS data#54395]
(5) Project
Arguments: [data#54395, schema_of_json([{"stationcode":"10206","name":"René Boulanger - Lancry","capacity":33,"coordonnees_geo":{"lon":2.3598745346052,"lat":48.868769331741},"station_opening_hours":null},{"stationcode":"23802","name":"Raymond Poincaré - Allée de la Marche","capacity":23,"coordonnees_geo":{"lon":2.1724102640451,"lat":48.838634069623},"station_opening_hours":null},{"stationcode":"12032","name":"Porte Dorée","capacity":36,"coordonnees_geo":{"lon":2.4077132,"lat":48.8354337},"station_opening_hours":null},{"stationcode":"19040","name":"Belleville - Télégraphe","capacity":41,"coordonnees_geo":{"lon":2.3995549,"lat":48.8756045},"station_opening_hours":null},{"stationcode":"11041","name":"Square Saint-Ambroise","capacity":43,"coordonnees_geo":{"lon":2.375841,"lat":48.860934},"station_opening_hours":null},{"stationcode":"20016","name":"Pyrénées - Maraîchers","capacity":33,"coordonnees_geo":{"lon":2.4043509364128113,"lat":48.85714001395299},"station_opening_hours":null},{"stationcode":"14006","name":"Saint-Jacques - Tombe Issoire","capacity":23,"coordonnees_geo":{"lon":2.3369108140468597,"lat":48.833206330538864},"station_opening_hours":null},{"stationcode":"21114","name":"Gustave Eiffel - Parc des Impressionnistes","capacity":30,"coordonnees_geo":{"lon":2.2946908324956894,"lat":48.90390619651018},"station_opening_hours":null},{"stationcode":"10164","name":"Claude Vellefaux - Sambre et Meuse","capacity":34,"coordonnees_geo":{"lon":2.370478,"lat":48.875022},"station_opening_hours":null},{"stationcode":"20103","name":"Le Vau - Maurice Bertaux","capacity":25,"coordonnees_geo":{"lon":2.411030612453627,"lat":48.86803439043193},"station_opening_hours":null},{"stationcode":"16031","name":"Vignes - Boulainvilliers","capacity":21,"coordonnees_geo":{"lon":2.275240458548069,"lat":48.856399483950504},"station_opening_hours":null},{"stationcode":"48009","name":"République - Auguste Perret","capacity":30,"coordonnees_geo":{"lon":2.3518594354391094,"lat":48.78695280952244},"station_opening_hours":null},{"stationcode":"14127","name":"Odessa - Départ","capacity":39,"coordonnees_geo":{"lon":2.3244281485677,"lat":48.842885590081},"station_opening_hours":null},{"stationcode":"31026","name":"Demi-Lune - Aristide Briand","capacity":20,"coordonnees_geo":{"lon":2.4562818557024,"lat":48.8762638192},"station_opening_hours":null},{"stationcode":"20039","name":"Belleville - Couronnes","capacity":50,"coordonnees_geo":{"lon":2.3809862136841,"lat":48.868831082877},"station_opening_hours":null},{"stationcode":"5034","name":"Censier - Santeuil","capacity":69,"coordonnees_geo":{"lon":2.3537524044513702,"lat":48.840658921385234},"station_opening_hours":null},{"stationcode":"21708","name":"Marcel Yol - Jullien","capacity":30,"coordonnees_geo":{"lon":2.287235018058929,"lat":48.82537611802588},"station_opening_hours":null},{"stationcode":"20108","name":"Jardin de l'Hospice Debrousse","capacity":23,"coordonnees_geo":{"lon":2.40568600595,"lat":48.861451061938},"station_opening_hours":null},{"stationcode":"21219","name":"Amaury Duval - Gabriel Péri","capacity":36,"coordonnees_geo":{"lon":2.323841750621796,"lat":48.81718759671675},"station_opening_hours":null},{"stationcode":"42209","name":"Place de l'Europe - Quai de Bercy","capacity":17,"coordonnees_geo":{"lon":2.3945679143071175,"lat":48.82529858840266},"station_opening_hours":null},{"stationcode":"13044","name":"Place Jeanne d'Arc","capacity":36,"coordonnees_geo":{"lon":2.369126,"lat":48.829575},"station_opening_hours":null},{"stationcode":"22015","name":"Île de la Jatte","capacity":23,"coordonnees_geo":{"lon":2.2666339203715324,"lat":48.894036161302104},"station_opening_hours":null},{"stationcode":"47009","name":"Charentonneau - Maison Alfort","capacity":28,"coordonnees_geo":{"lon":2.443241664773,"lat":48.809972406542},"station_opening_hours":null},{"stationcode":"10033","name":"Gare du Nord - Saint-Vincent de Paul","capacity":24,"coordonnees_geo":{"lon":2.3524305148385,"lat":48.880955741648},"station_opening_hours":null},{"stationcode":"16012","name":"Flandrin - Longchamp","capacity":42,"coordonnees_geo":{"lon":2.274354539176829,"lat":48.86877849178477},"station_opening_hours":null},{"stationcode":"45002","name":"Roger Salengro - Général de Gaulle","capacity":27,"coordonnees_geo":{"lon":2.4846760556101803,"lat":48.820029010376956},"station_opening_hours":null},{"stationcode":"14135","name":"Jourdan - Cité Universitaire","capacity":39,"coordonnees_geo":{"lon":2.3397007964124366,"lat":48.819897343156676},"station_opening_hours":null},{"stationcode":"14132","name":"Bézout - Général Leclerc","capacity":30,"coordonnees_geo":{"lon":2.3285973072052,"lat":48.82884804502439},"station_opening_hours":null},{"stationcode":"6031","name":"Pierre Sarrazin - Saint-Michel","capacity":33,"coordonnees_geo":{"lon":2.342130728066,"lat":48.850908146398},"station_opening_hours":null},{"stationcode":"19130","name":"Place Paul Delouvrier","capacity":42,"coordonnees_geo":{"lon":2.3851288855075836,"lat":48.89197621431365},"station_opening_hours":null},{"stationcode":"6026","name":"Saint-Placide - Cherche Midi","capacity":66,"coordonnees_geo":{"lon":2.325317971408367,"lat":48.8490535919234},"station_opening_hours":null},{"stationcode":"28005","name":"Jean Jaurès - Paul Lafargue","capacity":28,"coordonnees_geo":{"lon":2.2484488785267,"lat":48.884933177666},"station_opening_hours":null},{"stationcode":"23042","name":"André Theuriet - Blagis","capacity":30,"coordonnees_geo":{"lon":2.3130525648593903,"lat":48.77977325745441},"station_opening_hours":null},{"stationcode":"1008","name":"Les Halles - Saint-Eustache","capacity":32,"coordonnees_geo":{"lon":2.342623919248581,"lat":48.86362695901683},"station_opening_hours":null},{"stationcode":"23301","name":"Les Blagis","capacity":27,"coordonnees_geo":{"lon":2.302526,"lat":48.785205},"station_opening_hours":null},{"stationcode":"23303","name":"Gare de Robinson","capacity":30,"coordonnees_geo":{"lon":2.281828634440899,"lat":48.7799259211605},"station_opening_hours":null},{"stationcode":"20142","name":"Mûriers - Père Lachaise","capacity":20,"coordonnees_geo":{"lon":2.39164982067019,"lat":48.864130509668044},"station_opening_hours":null},{"stationcode":"15053","name":"Lecourbe - Convention","capacity":46,"coordonnees_geo":{"lon":2.2915197908878326,"lat":48.83923319241899},"station_opening_hours":null},{"stationcode":"10003","name":"Hauteville - Bonne Nouvelle","capacity":17,"coordonnees_geo":{"lon":2.3496496368327,"lat":48.87077436024},"station_opening_hours":null},{"stationcode":"30003","name":"Moscou - Edouard Vaillant","capacity":30,"coordonnees_geo":{"lon":2.4689837335263,"lat":48.90755810177},"station_opening_hours":null},{"stationcode":"14009","name":"Tombe Issoire - René Coty","capacity":36,"coordonnees_geo":{"lon":2.3343613743782,"lat":48.830512876709},"station_opening_hours":null},{"stationcode":"17117","name":"Pereire - Saussure","capacity":32,"coordonnees_geo":{"lon":2.3101296275854,"lat":48.888229075478},"station_opening_hours":null},{"stationcode":"15045","name":"Porte de la Plaine","capacity":35,"coordonnees_geo":{"lon":2.2924277186393742,"lat":48.82805169605981},"station_opening_hours":null},{"stationcode":"21023","name":"Ancienne Mairie - André Morizet","capacity":25,"coordonnees_geo":{"lon":2.234077,"lat":48.838311},"station_opening_hours":null},{"stationcode":"22701","name":"Général Leclerc - République","capacity":30,"coordonnees_geo":{"lon":2.2682306702811,"lat":48.915885074177},"station_opening_hours":null},{"stationcode":"14005","name":"René Coty - Place Denfert-Rochereau","capacity":36,"coordonnees_geo":{"lon":2.3329411447048,"lat":48.833056477316},"station_opening_hours":null},{"stationcode":"6004","name":"Regard - Rennes","capacity":46,"coordonnees_geo":{"lon":2.3268555477262,"lat":48.847385404956},"station_opening_hours":null},{"stationcode":"12040","name":"Porte de Charenton","capacity":67,"coordonnees_geo":{"lon":2.3989107459784,"lat":48.831240105856},"station_opening_hours":null},{"stationcode":"20106","name":"Mairie du 20ème","capacity":27,"coordonnees_geo":{"lon":2.3990669846535,"lat":48.865302324275},"station_opening_hours":null},{"stationcode":"21007","name":"Rond-Point Rhin et Danube","capacity":53,"coordonnees_geo":{"lon":2.2280225157737736,"lat":48.840452820991764},"station_opening_hours":null},{"stationcode":"21107","name":"Bertrand Sincholle - Henri Barbusse","capacity":23,"coordonnees_geo":{"lon":2.3042294383049016,"lat":48.89925982394349},"station_opening_hours":null},{"stationcode":"22305","name":"Jean Jaurès - Place du Dr Roux","capacity":35,"coordonnees_geo":{"lon":2.2947337017374,"lat":48.927567032796},"station_opening_hours":null},{"stationcode":"26008","name":"Henri Barbusse - Bourguignons","capacity":34,"coordonnees_geo":{"lon":2.2734212270774417,"lat":48.91301722799713},"station_opening_hours":null},{"stationcode":"21514","name":"Place de la Paix - Abbé Saint-Pierre","capacity":24,"coordonnees_geo":{"lon":2.2047570338469806,"lat":48.86462724459225},"station_opening_hours":null},{"stationcode":"18026","name":"Ruisseau - Ordener","capacity":53,"coordonnees_geo":{"lon":2.340144887566567,"lat":48.89299462568024},"station_opening_hours":null},{"stationcode":"13205","name":"Choisy - Pointe d'Ivry","capacity":24,"coordonnees_geo":{"lon":2.3633708034878,"lat":48.822154170359},"station_opening_hours":null},{"stationcode":"20112","name":"Jourdain - Place des Grandes Rigoles","capacity":22,"coordonnees_geo":{"lon":2.3895947635174,"lat":48.874031137272},"station_opening_hours":null},{"stationcode":"18041","name":"Rochechouart - Martyrs","capacity":20,"coordonnees_geo":{"lon":2.3405495658517,"lat":48.882193779572},"station_opening_hours":null},{"stationcode":"8057","name":"Hoche - Tilsitt","capacity":33,"coordonnees_geo":{"lon":2.2971323132515,"lat":48.874836457837},"station_opening_hours":null},{"stationcode":"13010","name":"Place d'Italie - Vincent Auriol","capacity":40,"coordonnees_geo":{"lon":2.3567550292319,"lat":48.831481874467},"station_opening_hours":null},{"stationcode":"32012","name":"Carrefour Pleyel","capacity":68,"coordonnees_geo":{"lon":2.3438543826341625,"lat":48.92034156960326},"station_opening_hours":null},{"stationcode":"8004","name":"Malesherbes - Place de la Madeleine","capacity":67,"coordonnees_geo":{"lon":2.323243509808,"lat":48.870406028483},"station_opening_hours":null},{"stationcode":"12109","name":"Mairie du 12ème","capacity":30,"coordonnees_geo":{"lon":2.3875549435616,"lat":48.840855311763},"station_opening_hours":null},{"stationcode":"31028","name":"Raspail Barbès","capacity":28,"coordonnees_geo":{"lon":2.4247387,"lat":48.8529945},"station_opening_hours":null},{"stationcode":"41303","name":"Gare de Nogent-le-Perreux","capacity":32,"coordonnees_geo":{"lon":2.493693307042122,"lat":48.83842553348809},"station_opening_hours":null},{"stationcode":"8009","name":"Gare Saint-Lazare - Isly","capacity":27,"coordonnees_geo":{"lon":2.326515804784655,"lat":48.874777677621296},"station_opening_hours":null},{"stationcode":"9014","name":"Faubourg Montmartre - La Fayette","capacity":35,"coordonnees_geo":{"lon":2.3408536612988,"lat":48.875254549053},"station_opening_hours":null},{"stationcode":"45003","name":"11 Novembre 1918 - 8 Mai 1945","capacity":36,"coordonnees_geo":{"lon":2.5382421165704727,"lat":48.80889533774377},"station_opening_hours":null},{"stationcode":"11002","name":"Roquette - Thiéré","capacity":23,"coordonnees_geo":{"lon":2.3733686318721463,"lat":48.85507930579506},"station_opening_hours":null},{"stationcode":"16108","name":"Sablons - Georges Mandel","capacity":38,"coordonnees_geo":{"lon":2.28189,"lat":48.863875},"station_opening_hours":null},{"stationcode":"6006","name":"Notre-Dame-des-Champs - Stanislas","capacity":19,"coordonnees_geo":{"lon":2.329337755887181,"lat":48.84479928858768},"station_opening_hours":null},{"stationcode":"11027","name":"Saint-Ambroise - Parmentier","capacity":38,"coordonnees_geo":{"lon":2.3772348091006,"lat":48.862147844548},"station_opening_hours":null},{"stationcode":"8054","name":"Bertie Albrecht - Hoche","capacity":32,"coordonnees_geo":{"lon":2.301303138307601,"lat":48.87614039826388},"station_opening_hours":null},{"stationcode":"21006","name":"Marcelin Berthelot","capacity":27,"coordonnees_geo":{"lon":2.233161628246308,"lat":48.8415473058801},"station_opening_hours":null},{"stationcode":"15034","name":"Lakanal - Commerce","capacity":53,"coordonnees_geo":{"lon":2.294059172272682,"lat":48.84442462786544},"station_opening_hours":null},{"stationcode":"41202","name":"Gare Rer de Fontenay sous Bois","capacity":61,"coordonnees_geo":{"lon":2.4630465,"lat":48.8436279},"station_opening_hours":null},{"stationcode":"23006","name":"Jules Guesde - Alsace","capacity":25,"coordonnees_geo":{"lon":2.2950777411461,"lat":48.890566275506},"station_opening_hours":null},{"stationcode":"22006","name":"Pierret - Madrid","capacity":28,"coordonnees_geo":{"lon":2.260125767248034,"lat":48.882976576876565},"station_opening_hours":null},{"stationcode":"17037","name":"Bayen - Pereire","capacity":22,"coordonnees_geo":{"lon":2.2921088710427284,"lat":48.881804409079656},"station_opening_hours":null},{"stationcode":"14117","name":"Gare Montparnasse - René Mouchotte","capacity":41,"coordonnees_geo":{"lon":2.3208839446306,"lat":48.839203843292},"station_opening_hours":null},{"stationcode":"21502","name":"Verdun - Place Henri IV","capacity":26,"coordonnees_geo":{"lon":2.2277003154158592,"lat":48.870797375639214},"station_opening_hours":null},{"stationcode":"5002","name":"Sommerard - Saint-Jacques","capacity":34,"coordonnees_geo":{"lon":2.3450158352986,"lat":48.850310432924},"station_opening_hours":null},{"stationcode":"10015","name":"Lucien Sampaix - Récollets","capacity":46,"coordonnees_geo":{"lon":2.3621229082345963,"lat":48.874330377560476},"station_opening_hours":null},{"stationcode":"41207","name":"Place du Général de Gaulle","capacity":28,"coordonnees_geo":{"lon":2.4877332,"lat":48.8525288},"station_opening_hours":null},{"stationcode":"6103","name":"Mézières - Rennes","capacity":55,"coordonnees_geo":{"lon":2.3303819820284843,"lat":48.85023459321703},"station_opening_hours":null},{"stationcode":"6018","name":"Michelet - Assas","capacity":18,"coordonnees_geo":{"lon":2.3350211977959,"lat":48.842741502832},"station_opening_hours":null},{"stationcode":"19039","name":"Edouard Pailleron - Simon Bolivar","capacity":24,"coordonnees_geo":{"lon":2.374839261174202,"lat":48.87979886049996},"station_opening_hours":null},{"stationcode":"9031","name":"Provence - Chaussée d'Antin","capacity":25,"coordonnees_geo":{"lon":2.332976511564311,"lat":48.87428447542072},"station_opening_hours":null},{"stationcode":"17046","name":"Mac-Mahon - Brey","capacity":25,"coordonnees_geo":{"lon":2.2945125360529,"lat":48.87753208413},"station_opening_hours":null},{"stationcode":"31703","name":"Sadi Carnot - François Mitterrand","capacity":27,"coordonnees_geo":{"lon":2.4241617321968083,"lat":48.87532687671517},"station_opening_hours":null},{"stationcode":"35003","name":"Gabrielle Josserand - Edouard Vaillant","capacity":25,"coordonnees_geo":{"lon":2.3933270573616032,"lat":48.90271566255436},"station_opening_hours":null},{"stationcode":"11006","name":"Ledru-Rollin - Place du Père Chaillet","capacity":37,"coordonnees_geo":{"lon":2.379020587761426,"lat":48.856433706943704},"station_opening_hours":null},{"stationcode":"9026","name":"Jean-Baptiste Pigalle - La Bruyere","capacity":17,"coordonnees_geo":{"lon":2.333709173337285,"lat":48.87939826447722},"station_opening_hours":null},{"stationcode":"9017","name":"Lallier - Trudaine","capacity":29,"coordonnees_geo":{"lon":2.3408224806189537,"lat":48.88109246617963},"station_opening_hours":null},{"stationcode":"18035","name":"René Binet - Porte de Montmartre","capacity":37,"coordonnees_geo":{"lon":2.3365534096956253,"lat":48.89905109950848},"station_opening_hours":null},{"stationcode":"16014","name":"Eylau - Trocadéro","capacity":24,"coordonnees_geo":{"lon":2.2864209115505,"lat":48.863354122371},"station_opening_hours":null},{"stationcode":"16115","name":"Raffet - Montmorency","capacity":42,"coordonnees_geo":{"lon":2.2629252456151954,"lat":48.85258670812},"station_opening_hours":null},{"stationcode":"11032","name":"Jean-Pierre Timbaud - Vaucouleurs","capacity":47,"coordonnees_geo":{"lon":2.377885,"lat":48.867937},"station_opening_hours":null},{"stationcode":"13048","name":"Wurtz - Tolbiac","capacity":28,"coordonnees_geo":{"lon":2.344585955143,"lat":48.82631195621},"station_opening_hours":null},{"stationcode":"13128","name":"Quai de la Gare - Pont de Bercy","capacity":30,"coordonnees_geo":{"lon":2.3740861260598,"lat":48.83730787972},"station_opening_hours":null}]) AS schema#54409]
(6) Project
Arguments: [from_json(ArrayType(StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,StructType(StructField(lat,DoubleType,true),StructField(lon,DoubleType,true)),true),StructField(name,StringType,true),StructField(station_opening_hours,StringType,true),StructField(stationcode,StringType,true)),true), data#54395, Some(Etc/UTC)) AS root#54426]
(7) Generate
Arguments: explode(root#54426), false, [root#54435]
(8) Project
Arguments: [root#54435]
(9) Project
Arguments: [root#54435.capacity AS capacity#54439L, root#54435.coordonnees_geo AS coordonnees_geo#54440, root#54435.name AS name#54441, root#54435.station_opening_hours AS station_opening_hours#54442, root#54435.stationcode AS stationcode#54443]
(10) Project
Arguments: [capacity#54439L, to_json(coordonnees_geo#54440, Some(Etc/UTC)) AS coordonnees_geo#54463, name#54441, station_opening_hours#54442, stationcode#54443]
(11) Project
Arguments: [capacity#54439L AS capacity#54480L, coordonnees_geo#54463 AS coordonnees_geo#54481, name#54441 AS name#54482, station_opening_hours#54442 AS station_opening_hours#54483, stationcode#54443 AS stationcode#54484]
(12) Project
Arguments: [capacity#54480L, coordonnees_geo#54481, name#54482, station_opening_hours#54483, stationcode#54484]
(13) Project
Arguments: [capacity#54480L AS CAPACITY_119304#54507L, coordonnees_geo#54481 AS COORDONNEES_GEO_119305#54508, name#54482 AS NAME_119306#54509, stationcode#54484 AS STATIONCODE_119307#54510]
(14) Project
Arguments: [CAPACITY_119304#54507L, COORDONNEES_GEO_119305#54508, NAME_119306#54509, STATIONCODE_119307#54510]
(15) View
Arguments: `F00D3ACD_F693_4F8F_B4DA_EAF38B363EE0`, true
(16) SubqueryAlias
Arguments: F00D3ACD_F693_4F8F_B4DA_EAF38B363EE0
(17) Project
Arguments: [CAPACITY_119304#54507L, COORDONNEES_GEO_119305#54508, NAME_119306#54509, STATIONCODE_119307#54510]
(18) Aggregate
Arguments: [CAPACITY_119304#54507L, COORDONNEES_GEO_119305#54508, NAME_119306#54509, STATIONCODE_119307#54510], [CAPACITY_119304#54507L, COORDONNEES_GEO_119305#54508, NAME_119306#54509, STATIONCODE_119307#54510]