Name

ST_FlipCoordinates — 返回X轴和Y轴翻转的几何体版本。

Synopsis

geometry ST_FlipCoordinates(geometry geom);

描述

返回X轴和Y轴翻转的给定几何图形的版本。用于固定包含以纬度/经度(Y,X)表示的坐标的几何图形。

可用性:2.0.0

This method supports Circular Strings and Curves

This function supports 3d and will not drop the z-index.

This function supports M coordinates.

This function supports Polyhedral surfaces.

This function supports Triangles and Triangulated Irregular Network Surfaces (TIN).

示例

SELECT ST_AsEWKT(ST_FlipCoordinates(GeomFromEWKT('POINT(1 2)')));
 st_asewkt
------------
POINT(2 1)
         

另请参阅

ST_SwapOrdinates