Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Computes the area of the multi-surface in the specified units.
The units in which the area should be computed. Defaults to the unit of the spatial reference system. The unit name must match
the UNIT_NAME column of a row in the ST_UNITS_OF_MEASURE view where UNIT_TYPE is 'LINEAR'.
Returns the area of the multi-surface.
Computes the area of the multi-surface in the specified units. The area of the multi-surface is the sum of the areas of the
This method can not be used with geometries in round-Earth spatial reference system.
SQL/MM (ISO/IEC 13249-3: 2006)
The following example returns the result 8.
SELECT TREAT( Shape AS ST_MultiSurface ).ST_Area()
FROM SpatialShapes WHERE ShapeID = 27
The following returns the area of the multipoly_geometry column in square miles from the fictional region table.
SELECT name, multipoly_geometry.ST_Area( 'Statute Mile' )