Point (geography Data Type)

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

Syntax

Point ( Lat, Long, SRID )

Arguments

  • 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.

Return Types

SQL Server return type: geography

CLR return type: SqlGeography

Examples

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();

See Also

Other Resources