Distance 6703
-->
Returns the shortest distance between a point in a geography instance and a point in another geography instance.
Note
Mar 08, 2020 6703 Camino Del Prado, Carlsbad, CA 92011 is a 2 bedroom, 2 bathroom, 1,284 sqft single-family home built in 1976. 6703 Camino Del Prado is located in Poinsettia, Carlsbad. This property is not currently available for sale. The current Trulia Estimate for 6703 Camino Del Prado is $646,547. This is a 1656 square foot, 2.0 bathroom, single family home. It is located at 6703 Carpenter Ct Woodridge, Illinois.
STDistance() returns the shortest LineString between two geography types. This is a close approximate to the geodesic distance. The deviation of STDistance() on common earth models from the exact geodesic distance is no more than .25%. This avoids confusion over the subtle differences between length and distance in geodesic types.
Syntax
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.
Distance 6703 North
Return Types
SQL Server return type: float
CLR return type: SqlDouble
Remarks
The result is expressed in the unit of measure defined by the Spatial Reference Identifier (SRID) of spatial data.STDistance() always returns null if the spatial reference IDs (SRIDs) of the geography instances do not match.
Note
Distance 6703 Calculator
Methods on the geography data type that calculate an area or distance will return different results based on the SRID of the instance used in the method. For more information about SRIDs, see Spatial Reference Identifiers (SRIDs).
Examples
The following example finds the distance between two geography instances.