st_flipcoordinates function

Applies to: Databricks SQL Databricks Runtime 17.1 and above

Important

This feature is in Public Preview.

Note

This feature is not available on Databricks SQL Classic warehouses. To learn more about Databricks SQL warehouses, see SQL warehouse types.

Swaps X and Y coordinates of the input GEOMETRY value.

Syntax

st_flipcoordinates ( geoExpr )

Arguments

• geoExpr: A GEOMETRY value.

Returns

A value of type GEOMETRY with X and Y coordinates swapped.

The SRID value of the output GEOMETRY value is equal to that of the input value.

The function returns NULL if the input is NULL.

Examples

-- Swaps X and Y coordinates of a linestring.
> SELECT st_astext(st_flipcoordinates(st_geomfromtext('LINESTRING(1 2,3 4,5 6,7 8)')));
  LINESTRING(2 1,4 3,6 5,8 7)
-- Swaps X and Y coordinates of a point.
> SELECT st_astext(st_flipcoordinates(st_geomfromtext('POINT(10 20)')));
  POINT(20 10)

Related functions

• st_x function
• st_y function