Index: doc/dsoilmodel/queries/All2dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql =================================================================== diff -u -ra483049c20ef6d26addd0718d0f31ae1922e6f49 -r1e2f10592270d6b14fddf6286d10091086d5c6a7 --- doc/dsoilmodel/queries/All2dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql (.../All2dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql) (revision a483049c20ef6d26addd0718d0f31ae1922e6f49) +++ doc/dsoilmodel/queries/All2dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql (.../All2dProfilesAndLayersAndLayerPropertiesAndMaterialProperties.sql) (revision 1e2f10592270d6b14fddf6286d10091086d5c6a7) @@ -6,10 +6,7 @@ mpl.X as IntersectionX, AbovePhreaticLevel, BelowPhreaticLevel, - PermeabKx, - DiameterD70, - WhitesConstant, - BeddingAngle, + DryUnitWeight, IsAquifer FROM Mechanism as m JOIN MechanismPointLocation as mpl ON mpl.ME_ID = m.ME_ID @@ -24,10 +21,7 @@ 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 = 'PermeabKx' then pv.PV_Value end) PermeabKx, - sum(case when pn.PN_Name = 'DiameterD70' then pv.PV_Value end) DiameterD70, - sum(case when pn.PN_Name = 'WhitesConstant' then pv.PV_Value end) WhitesConstant, - sum(case when pn.PN_Name = 'BeddingAngle' then pv.PV_Value end) BeddingAngle + sum(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