SqlGeography.STGeomFromText Method (SqlChars, Int32)

  • Article

 

Applies To: SQL Server 2016 Preview

Returns a SqlGeography 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

[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public static SqlGeography STGeomFromText(
    SqlChars geometryTaggedText,
    int srid
)

public:
[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
static SqlGeography^ STGeomFromText(
    SqlChars^ geometryTaggedText,
    int srid
)

[<SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)>]
static member STGeomFromText : 
        geometryTaggedText:SqlChars *
        srid:int -> SqlGeography

<SqlMethodAttribute(IsDeterministic := True, IsPrecise := False)>
Public Shared Function STGeomFromText (
    geometryTaggedText As SqlChars,
    srid As Integer
) As SqlGeography

Parameters

  • srid
    Type: System.Int32

    An int expression that represents the spatial reference ID (SRID) of the SqlGeography instance you wish to return.

Return Value

Type: Microsoft.SqlServer.Types.SqlGeography

A SqlGeography instance constructed from the WKY representation.

Remarks

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

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

See Also

SqlGeography Class
Microsoft.SqlServer.Types Namespace

Return to top