SqlGeometry.STGeomFromText Method

Returns a SqlGeometry 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.

Namespace:  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

Syntax

'Declaration
<SqlMethodAttribute(IsDeterministic := True, IsPrecise := False)> _
Public Shared Function STGeomFromText ( _
    geometryTaggedText As SqlChars, _
    srid As Integer _
) As SqlGeometry
'Usage
Dim geometryTaggedText As SqlChars
Dim srid As Integer
Dim returnValue As SqlGeometry

returnValue = SqlGeometry.STGeomFromText(geometryTaggedText, _
    srid)
[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public static SqlGeometry STGeomFromText(
    SqlChars geometryTaggedText,
    int srid
)
[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public:
static SqlGeometry^ STGeomFromText(
    SqlChars^ geometryTaggedText, 
    int srid
)
[<SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)>]
static member STGeomFromText : 
        geometryTaggedText:SqlChars * 
        srid:int -> SqlGeometry 
public static function STGeomFromText(
    geometryTaggedText : SqlChars, 
    srid : int
) : SqlGeometry

Parameters

  • srid
    Type: System.Int32
    An int expression that represents the spatial reference ID (SRID) of the SqlGeometry instance you wish to return.

Return Value

Type: Microsoft.SqlServer.Types.SqlGeometry
A SqlGeometry instance constructed from the specified WKT representation.

Remarks

The OGC type of the SqlGeometry instance returned by STGeomFromText is set to the corresponding WKT input.

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

This member is static.