Geography.FromWellKnownText

Syntax

Geography.FromWellKnownText(input as nullable text) as nullable record

About

Translates text representing a geographic value in Well-Known Text (WKT) format into a structured record. WKT is a standard format defined by the Open Geospatial Consortium (OGC) and is the typical serialization format used by databases including SQL Server.

Example

Convert a Well-Known Text (WKT) representation of a geographic point into a structured record.

Usage

Geography.FromWellKnownText("POINT(-122.127222 47.641944)")

Output

[Kind = "POINT", Longitude = -122.127222, Latitude = 47.641944]