Index: doc/dsoilmodel/queries/All1d2dProfilesAndLayersAndMaterialProperties.sql
===================================================================
diff -u -rcc4d576f4e819e0ace71c57eae13b54cfdafc069 -r30c4782361bd6f897f02df74461a73b60bc4a085
--- doc/dsoilmodel/queries/All1d2dProfilesAndLayersAndMaterialProperties.sql	(.../All1d2dProfilesAndLayersAndMaterialProperties.sql)	(revision cc4d576f4e819e0ace71c57eae13b54cfdafc069)
+++ doc/dsoilmodel/queries/All1d2dProfilesAndLayersAndMaterialProperties.sql	(.../All1d2dProfilesAndLayersAndMaterialProperties.sql)	(revision 30c4782361bd6f897f02df74461a73b60bc4a085)
@@ -1,7 +1,9 @@
 SELECT 
+  2 as Dimensions,
   p.SP2D_Name as ProfileName,
   l.GeometrySurface as LayerGeometry, 
   mpl.X as IntersectionX,
+  null as Bottom,
   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,
@@ -21,9 +23,11 @@
 GROUP BY l.SL2D_ID
 UNION
 SELECT 
+  1 as Dimensions,
   p.SP1D_Name as ProfileName,
   null as LayerGeometry,
   null as IntersectionX,
+  p.BottomLevel as Bottom,
   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,