Export (0) Print
Expand All

SqlGeography.STArea Method

Returns the total surface area of a SqlGeography instance.

Namespace:  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public SqlDouble STArea()

Return Value

Type: SqlDouble
A SqlDouble value specifying the total surface area. STArea will return 0 if a SqlGeography instance contains only 0- and 1-dimensional figures, or if it is empty.

Results for STArea are returned in the square of the unit of measure used by the spatial reference identifier of the geography instance; for example, if the SRID of the instance is 4326, STArea returns results in square meters.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft