PostGIS

ST_WrapX

Prev

8.5. Geometry Editors

Next

Name

ST_WrapX — Wrap a geometry around an X value.

Synopsis

+geometry +ST_WrapX(+`geometry `+geom, float8 wrap, float8 move`)`;

Description

This function splits the input geometries and then moves every resulting component falling on the right (for negative 'move') or on the left (for positive 'move') of given 'wrap' line in the direction specified by the 'move' parameter, finally re-unioning the pieces together.

Note

This is useful to "recenter" long-lat input to have features of interest not spawned from one side to the other.

Availability: 2.3.0 requires GEOS

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

Examples

-- Move all components of the given geometries whose bounding box
-- falls completely on the left of x=0 to +360
select ST_WrapX(geom, 0, 360);

-- Move all components of the given geometries whose bounding box
-- falls completely on the left of x=-30 to +360
select ST_WrapX(geom, -30, 360);

See Also

Prev

Up

Next

ST_ShiftLongitude

Home

ST_SnapToGrid