Index: doc/dsoilmodel/queries/All2dProfilesAndLayersAndMaterialProperties.sql =================================================================== diff -u -rffa19c225b1b809dd81ffce8afb870ae7264e5cf -rcc4d576f4e819e0ace71c57eae13b54cfdafc069 --- doc/dsoilmodel/queries/All2dProfilesAndLayersAndMaterialProperties.sql (.../All2dProfilesAndLayersAndMaterialProperties.sql) (revision ffa19c225b1b809dd81ffce8afb870ae7264e5cf) +++ doc/dsoilmodel/queries/All2dProfilesAndLayersAndMaterialProperties.sql (.../All2dProfilesAndLayersAndMaterialProperties.sql) (revision cc4d576f4e819e0ace71c57eae13b54cfdafc069) @@ -1,8 +1,7 @@ SELECT - p.SP2D_Name, - l.GeometrySurface, - mat.MA_ID, - mpl.X, + p.SP2D_Name as ProfileName, + l.GeometrySurface as LayerGeometry, + mpl.X as IntersectionX, sum(case when mat.PN_Name = "AbovePhreaticLevel" then mat.PV_Value end) AbovePhreaticLevel, sum(case when mat.PN_Name = "BelowPhreaticLevel" then mat.PV_Value end) BelowPhreaticLevel, sum(case when mat.PN_Name = "PermeabKx" then mat.PV_Value end) PermeabKx, @@ -20,4 +19,4 @@ JOIN Materials as m ON m.MA_ID = pv.MA_ID) as mat ON l.MA_ID = mat.MA_ID WHERE m.ME_ID = 4 GROUP BY l.SL2D_ID -ORDER BY p.SP2D_ID, l.SL2D_ID \ No newline at end of file +ORDER BY p.SP2D_ID, l.SL2D_ID