STPolyFromText (geography Data Type)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

Returns a geography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation augmented with any Z (elevation) and M (measure) values carried by the instance.


STPolyFromText ( 'polygon_tagged_text' , SRID )  


To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.


Is the WKT representation of the geographyPolygon instance you wish to return. polygon_tagged_text is an nvarchar(max) expression.

Is an int expression representing the spatial reference ID (SRID) of the geographyPolygon instance you wish to return.

Return Types

SQL Server return type: geography

CLR return type: SqlGeography

OGC type: Polygon


This method throws a FormatException if the input is not well-formatted.


The order in which the points are listed matters for geography polygons. It determines if the polygon area is to the inside or outside of the given ring. See Polygon for more information.


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

DECLARE @g geography;  
SET @g = geography::STPolyFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326);  
SELECT @g.ToString();  

See Also

OGC Static Geography Methods