Export (0) Print
Expand All
Expand Minimize

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

ADD
Show:
© 2014 Microsoft