0 out of 1 rated this helpful - Rate this topic

Parse (geography Data Type)

SQL Server 2012

Returns a geography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation. Parse() is equivalent to STGeomFromText, except that it assumes a spatial reference ID (SRID) of 4326 as a parameter. The input may carry optional Z (elevation) and M (measure) values.

This geography data type method supports FullGlobe instances or spatial instances that are larger than a hemisphere.

Syntax


          

Parse ( 'geography_tagged_text' )

Arguments

geography_tagged_text: Is the WKT representation of the geography instance to return. geography_tagged_text is an nvarchar expression.

Return Types

SQL Server return type: geography

CLR return type: SqlGeography

Remarks

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

The string 'Null' will be interpreted as a null geography instance.

This method will throw ArgumentException if the input contains an antipodal edge.

Examples

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

DECLARE @g geography; 
SET @g = geography::Parse('LINESTRING(-122.360 47.656, -122.343 47.656)');
SELECT @g.ToString();

Reference

STGeomFromText (geography Data Type)

Other Resources

Extended Static Geography Methods

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD