STArea (geography Data Type)
Returns the total surface area of a geography instance. 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.
.STArea ( )
SQL Server return type: float
CLR return type: SqlDouble
STArea() returns 0 if a geography instance contains only 0- and 1-dimensional figures, or if it is empty.
The following example uses
STArea() to create a
Polygon``geography instance and computes the area of the polygon.
DECLARE @g geography; SET @g = geography::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326); SELECT @g.STArea();