ST_OffsetCurve

Returns a line at a given offset distance from a linear geometry. If the distance is positive, the offset is on the left side of the input line; if it is negative, it is on the right side. Returns null for empty geometries. The optional third parameter quadrantSegments controls the number of line segments used to approximate a quarter circle at round joins. The default value is 8.

Signatures

ST_OffsetCurve(geometry: Geometry, distance: Double)

ST_OffsetCurve(geometry: Geometry, distance: Double, quadrantSegments: Integer)

Parameters

Geometry

required

The linear geometry to offset.

Double

required

The offset distance. Positive offsets to the left of the line; negative to the right.

Integer

The number of segments used to approximate a quarter circle at round joins. Defaults to 8.

Return type

The offset line.

Example

SELECT ST_AsText(ST_OffsetCurve(ST_GeomFromWKT('LINESTRING(0 0, 10 0, 10 10)'), 5.0))

LINESTRING (0 5, 5 5, 5 10)

With a negative distance (offset to the right):

SELECT ST_NPoints(ST_OffsetCurve(ST_GeomFromWKT('LINESTRING(0 0, 10 0, 10 10)'), -3.0))

With quadrantSegments set to 16:

SELECT ST_NPoints(ST_OffsetCurve(ST_GeomFromWKT('LINESTRING(0 0, 10 0, 10 10)'), -3.0, 16))

ST_MinimumWidthRectangle

ST_OrientedEnvelope

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Example

​Signatures

​Parameters

​Return type

​Example

Signatures

Parameters

Return type

Example