st_astext function

Applies to: Databricks Runtime 17.1 and above

Returns the input GEOGRAPHY or GEOMETRY value in WKT format.

Syntax

st_astext ( geoExpr )

Arguments

• geoExpr: A GEOGRAPHY or GEOMETRY value.

Returns

A value of type STRING. The returned value is the WKT description of the input GEOGRAPHY or GEOMETRY value.

The function returns NULL if the input is NULL.

Examples

-- Export a 3DZ Cartesian point, given in GeoJSON format, in WKT format.
> SELECT st_text(to_geometry('{"type":"Point","coordinates":[2.718281828,3.141592653,100]}'))
  POINT Z (2.718281828 3.141592653 100)

-- Export a 3DZ geographic point, given in GeoJSON format, in WKT format.
> SELECT st_text(to_geography('{"type":"Point","coordinates":[2.718281828,3.141592653,100]}'))
  POINT Z (2.718281828 3.141592653 100)

Related functions

• st_asbinary function
• st_asewkb function
• st_asewkt function
• st_asgeojson function
• st_aswkb function
• st_aswkt function
• st_geogfromgeojson function
• st_geogfromtext function
• st_geogfromwkb function
• st_geogfromwkt function
• st_geomfromewkb function
• st_geomfromgeojson function
• st_geomfromtext function
• st_geomfromwkb function
• st_geomfromwkt function
• to_geography function
• to_geometry function
• try_to_geography function
• try_to_geometry function