Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2012
Product Documentation
Developer Reference for SQL Server 2012
Developer Reference
Developer's Guide (Database Engine)
Microsoft.SqlServer.Types
SqlGeography Class
SqlGeography Methods
AsBinaryZM Method
AsGml Method
AsTextZM Method
BufferWithCurves Method
BufferWithTolerance Method
CurveToLineWithTolerance Method
Deserialize Method
EnvelopeAngle Method
EnvelopeCenter Method
Filter Method
GeomFromGml Method
InstanceOf Method
ISqlSpatialGridIndexable.BufferForDistanceQuery Method
ISqlSpatialGridIndexable.GetBoundingBoxCorners Method
ISqlSpatialGridIndexable.GetGridCoverage Method
ISqlSpatialGridIndexable.InteriorBufferForDistanceQuery Method
IsValidDetailed Method
MakeValid Method
MinDbCompatibilityLevel Method
NumRings Method
Parse Method
Point Method
Populate Method
Read Method
Reduce Method
ReorientObject Method
RingN Method
Serialize Method
ShortestLineTo Method
STArea Method
STAsBinary Method
STAsText Method
STBuffer Method
STContains Method
STConvexHull Method
STCurveN Method
STCurveToLine Method
STDifference Method
STDimension Method
STDisjoint Method
STDistance Method
STEndPoint Method
STEquals Method
STGeomCollFromText Method
STGeomCollFromWKB Method
STGeometryN Method
STGeometryType Method
STGeomFromText Method
STGeomFromWKB Method
STIntersection Method
STIntersects Method
STIsClosed Method
STIsEmpty Method
STIsValid Method
STLength Method
STLineFromText Method
STLineFromWKB Method
STMLineFromText Method
STMLineFromWKB Method
STMPointFromText Method
STMPointFromWKB Method
STMPolyFromText Method
STMPolyFromWKB Method
STNumCurves Method
STNumGeometries Method
STNumPoints Method
STOverlaps Method
STPointFromText Method
STPointFromWKB Method
STPointN Method
STPolyFromText Method
STPolyFromWKB Method
STStartPoint Method
STSymDifference Method
STUnion Method
STWithin Method
ToString Method
Write Method
Expand Minimize
This topic has not yet been rated - Rate this topic

SqlGeography.STGeomCollFromText Method

SQL Server 2012

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.

Namespace:  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)
C#
C++
F#
JScript
VB
Copy 
[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public static SqlGeography STGeomCollFromText(
	SqlChars geometryCollectionTaggedText,
	int srid
)

Parameters

geometryCollectionTaggedText
Type: System.Data.SqlTypes.SqlChars
Is the WKT representation of the geography instance you wish to return. geometrycollection_tagged_text is an nvarchar(max) expression.
srid
Type: System.Int32
Is an int expression representing the spatial reference ID (SRID) of the geography instance you wish to return.

Return Value

Type: Microsoft.SqlServer.Types.SqlGeography
A geography instance.

The OGC type of the geography instance returned by STGeomCollFromText is set to the corresponding WKT input.

This method throws an ArgumentException if the input is not valid.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.