ST_Area method

Calculates the area of a surface in the specified units.

Syntax

surface-expression.ST_Area([ unit-name])

Parameters

Name	Type	Description
unit-name	VARCHAR(128)	The units in which the length 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'.

The ST_Area method computes the area of a surface. The units used to represent the area are based on the specified linear unit of measure. For example, if the specified linear unit of measure is feet, the unit used for area is square feet.

Note

This method can not be used with geometries in round-Earth spatial reference system.

Standards and compatibility

Example

The following example returns the result 12.5.

SELECT TREAT( Shape AS ST_Polygon ).ST_Area() 
FROM SpatialShapes WHERE ShapeID = 22

The following returns the area of the poly_geometry column in square miles from the fictional region table.

SELECT name, poly_geometry.ST_Area( 'Statute Mile' )
FROM region

Discuss this page in DocCommentXchange.

ST_Area method

Syntax

Parameters

Returns

Remarks

Note

See also

Standards and compatibility

Example