point-geography-data-type.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
Point (geography Data Type)	Point (geography Data Type)	MladjoA	mlandzic	10/10/2019	sql	t-sql	reference	ignite-2024	Point Point_TSQL	Point method Point (geography Data Type)	TSQL	=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

Point (geography Data Type)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]

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

Syntax

  
Point ( Lat, Long, SRID )  

Arguments

Lat
Is a float expression representing the y-coordinate of the Point being generated.

Long
Is a float expression representing the x-coordinate of the Point being generated. For more information on valid latitude and longitude values, see Point.

SRID
Is an int expression representing the Spatial Reference Identifier of the geography instance you wish to return.

Note

Arguments for the Point (geography Data Type) method have coordinates reversed compared to WKT.

Return Types

[!INCLUDEssNoVersion] 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

Extended Static Geography Methods