Index: doc/dsoilmodel/queries/All1dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql
===================================================================
diff -u -r6692dc3480971fe1c017aef633382c40eb37056f -r2da851fd63f93a1e0684874c0011b69c97506472
--- doc/dsoilmodel/queries/All1dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql	(.../All1dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql)	(revision 6692dc3480971fe1c017aef633382c40eb37056f)
+++ doc/dsoilmodel/queries/All1dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql	(.../All1dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql)	(revision 2da851fd63f93a1e0684874c0011b69c97506472)
@@ -17,17 +17,17 @@
 LEFT JOIN (
 	SELECT 
 		m.MA_ID, 
-		sum(case when pn.PN_Name = 'AbovePhreaticLevel' then pv.PV_Value end) AbovePhreaticLevel,
-		sum(case when pn.PN_Name = 'BelowPhreaticLevel' then pv.PV_Value end) BelowPhreaticLevel,
-		sum(case when pn.PN_Name = 'DryUnitWeight' then pv.PV_Value end) DryUnitWeight
+		max(case when pn.PN_Name = 'AbovePhreaticLevel' then pv.PV_Value end) AbovePhreaticLevel,
+		max(case when pn.PN_Name = 'BelowPhreaticLevel' then pv.PV_Value end) BelowPhreaticLevel,
+		max(case when pn.PN_Name = 'DryUnitWeight' then pv.PV_Value end) DryUnitWeight
 	FROM ParameterNames as pn
 	JOIN ParameterValues as pv ON pn.PN_ID = pv.PN_ID
 	JOIN Materials as m ON m.MA_ID = pv.MA_ID
 	GROUP BY m.MA_ID) as mat ON l.MA_ID = mat.MA_ID
 LEFT JOIN (
 	SELECT 
 		pv.SL1D_ID, 
-		sum(case when pn.PN_Name = 'IsAquifer' then pv.PV_Value end) IsAquifer
+		max(case when pn.PN_Name = 'IsAquifer' then pv.PV_Value end) IsAquifer
 	FROM ParameterNames as pn
 	JOIN LayerParameterValues as pv ON pn.PN_ID = pv.PN_ID
 	GROUP BY pv.SL1D_ID) as lpv ON lpv.SL1D_ID = l.SL1D_ID