Skip to main content
Modifies longitude coordinates in geometries, shifting values between -180..0 degrees to 180..360 degrees and vice versa. This is useful for normalizing data across the International Date Line and standardizing coordinate ranges for visualization and spheroidal calculations.
This function is only applicable to geometries that use lon/lat coordinate systems.
ST_ShiftLongitude

​
Signatures

ST_ShiftLongitude (geom: geometry)

​
Parameters

​
geom
Geometry
required
The input geometry.

​
Return type

The resulting geometry.

​
Examples

SELECT ST_ShiftLongitude(ST_GeomFromText('LINESTRING(177 10, 179 10, -179 10, -177 10)'))

LINESTRING(177 10, 179 10, 181 10, 183 10)