Skip to main content

st_geogfromwkt function

Applies to: check marked yes Databricks Runtime 17.1 and above

Preview

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

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