2 out of 2 rated this helpful - Rate this topic

Point (geography Data Type)

SQL Server 2008 R2

Constructs a geography instance representing a Point instance from its x and y values and a spatial reference ID (SRID).


Point ( Lat, Long, SRID )

Lat: Is a float expression representing the x-coordinate of the Point being generated.
Long: Is a float expression representing the y-coordinate of the Point being generated. For more information on valid latitude and longitude values, see Point.
SRID: Is an int expression representing the SRID of the geography instance you wish to return.

SQL Server return type: geography

CLR return type: SqlGeography

The following example uses Point() to create a geography instance.

DECLARE @g geography; 
SET @g = geography::Point(47.65100, -122.34900, 4326)
SELECT @g.ToString();

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions