volker1,086 post(s) |
out of my archive somewhere here in the forum (i dont't who the author was): code sql SELECT [ID], ( Avg( 1 / ( cos( Deg2Rad( SlopeHeight([Dgm],[Dgm].[X (I)],[Dgm].[Y (I)], 1 ) ) ) ) ) * First([Area (I)]) ) As [SURFACE_AREA] INTO [TRUE_AREA_M2] FROM [POLYGON], [Dgm] WHERE Contains( [POLYGON].[ID], AssignCoordSys( Geom( NewPoint( [Dgm].[Center X (I)], [Dgm].[Center Y (I)] ) ), CoordSys("Dgm" AS COMPONENT) ) ) GROUP BY [POLYGON].[ID];
http://www.thegisservicesector.de |