ST_GEOGFROMTEXT
Constructs a GEOGRAPHY
object from a Well-Known Text (WKT) string. The extended WKT format is supported only for Spatial Reference Identifier (SRID) 4326, which corresponds to the WGS84 coordinate system.
Normalization and invalid input handling are applied as descibed in the GEOGRAPHY type documentation.
Syntax
ST_GEOGFROMTEXT(<WKT>)
Parameters
Parameter | Description | Supported input types |
---|---|---|
<WKT> | A WKT string to convert to a GEOGRAPHY object. | TEXT |
Return Type
ST_GEOGFROMTEXT
returns a value of type GEOGRAPHY
.
Example
The following code example constructs a Point from a WKT string describing a Point at specified longitude and latitude coordinates and converts it to WKT format:
SELECT ST_ASTEXT(ST_GEOGFROMTEXT('POINT(-73.98551041593687 40.75793403395676)')) AS result
Returns
result (TEXT) |
---|
‘POINT(-73.98551041593687 40.75793403395676)’ |