Index: doc/dsoilmodel/queries/All1d2dProfilesAndLayersAndMaterialProperties.sql
===================================================================
diff -u -r30c4782361bd6f897f02df74461a73b60bc4a085 -r92ea66818567a23223b31d658ef8db3349f9e8f0
--- doc/dsoilmodel/queries/All1d2dProfilesAndLayersAndMaterialProperties.sql	(.../All1d2dProfilesAndLayersAndMaterialProperties.sql)	(revision 30c4782361bd6f897f02df74461a73b60bc4a085)
+++ doc/dsoilmodel/queries/All1d2dProfilesAndLayersAndMaterialProperties.sql	(.../All1d2dProfilesAndLayersAndMaterialProperties.sql)	(revision 92ea66818567a23223b31d658ef8db3349f9e8f0)
@@ -4,6 +4,7 @@
   l.GeometrySurface as LayerGeometry, 
   mpl.X as IntersectionX,
   null as Bottom,
+  null as Top,
   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,
@@ -28,6 +29,7 @@
   null as LayerGeometry,
   null as IntersectionX,
   p.BottomLevel as Bottom,
+  l.TopLevel as Top,
   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,