STDistance (geography Data Type)

STDistance (geography Data Type)

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Language Filter

SQL Server 2008 Books Online (June 2009)

STDistance (geography Data Type)

Returns the shortest distance between a point in a geography instance and a point in another geography instance.

Syntax

.STDistance ( other_geography )

Arguments

other_geography: Is another geography instance from which to measure the distance between the instance on which STDistance() is invoked. If other_geography is an empty set, STDistance() returns null.

Return Types

SQL Server return type: float

CLR return type: SqlDouble

Remarks

STDistance() always returns null if the spatial reference IDs (SRIDs) of the geography instances do not match.

If STDistance() is used to determine distance between antipodal points, or consecutive points on opposite sides of the globe, as in the distance between POINT (0 0) and POINT (180 0), this method will return null.

Note:
Methods on the geography data type that produce a metric return value will have different results based on the SRID of the instance used in the method. For more information on SRIDs, see Spatial Reference Identifiers (SRIDs).

Examples

DECLARE @g geography;
DECLARE @h geography;
SET @g = geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656)', 4326);
SET @h = geography::STGeomFromText('POINT(-122.34900 47.65100)', 4326);
SELECT @g.STDistance(@h);

Other Resources

OGC Methods on Geography Instances

Help and Information

Getting SQL Server 2008 Assistance