ST_Project

Introduction: Calculates a new point location given a starting point, distance, and azimuth. The azimuth indicates the direction, expressed in radians, and is measured in a clockwise manner starting from true north. The system can handle azimuth values that are negative or exceed 2π (360 degrees). The optional lenient parameter prevents an error if the input geometry is not a Point. Its default value is false.

Format:

ST_Project(point: Geometry, distance: Double, azimuth: Double, lenient: Boolean = False)

ST_Project(point: Geometry, distance: Double, Azimuth: Double)

Return type: Geometry

Since: v1.7.0

SQL Example:

SELECT ST_Project(ST_GeomFromText('POINT (10 15)'), 100, radians(90))

Output:

POINT (110 14.999999999999975)

SQL Example:

SELECT ST_Project(
        ST_GeomFromText('POLYGON ((1 5, 1 1, 3 3, 5 3, 1 5))'),
        25, radians(270), true)

Output:

POINT EMPTY