Share via

st_geogfromwkt function

Applies to: check marked yes Databricks Runtime 17.1 and above

Important

This feature is in Public Preview.

Parses the WKT description of a geography and returns the corresponding GEOGRAPHY value. The SRID value of the returned GEOGRAPHY value is 4326.

Syntax

st_geogfromwkt ( wktExpr )

Arguments

  • wktExpr: A STRING value, representing a geography in WKT format.

Returns

A value of type GEOGRAPHY(4326), corresponding to the input WKT description.

The function returns NULL if the input is NULL.

Error conditions

  • If the value of wktExpr is an invalid WKT description, the function returns WKT_PARSE_ERROR.

Examples

-- Simple example.
> SELECT SELECT st_asgeojson(st_geogfromwkt('POINT Z (1 2 3)'))
  {"type":"Point","coordinates":[1,2,3]}