| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | f1_keywords | helpviewer_keywords | dev_langs | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
STPolyFromText (geography Data Type) |
STPolyFromText (geography Data Type) |
MladjoA |
mlandzic |
07/30/2017 |
sql |
t-sql |
reference |
|
|
|
|
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]
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 )
polygon_tagged_text
Is the WKT representation of the geographyPolygon instance you wish to return. polygon_tagged_text is an nvarchar(max) expression.
SRID
Is an int expression representing the spatial reference ID (SRID) of the geographyPolygon instance you wish to return.
[!INCLUDEssNoVersion] return type: geography
CLR return type: SqlGeography
OGC type: Polygon
This method throws a FormatException if the input is not well-formatted.
Note
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();