ST_MakePoint

Creates a 2D, 3D Z or 4D ZM Point geometry. Use ST_MakePointM to make points with XYM coordinates. Z and M values are optional.

Signatures

ST_MakePoint (X: Double, Y: Double, Z: Double, M: Double)

Double

required

The X coordinate (longitude).

Double

required

The Y coordinate (latitude).

Double

required

The Z coordinate (elevation).

Double

required

The M coordinate (measure).

The resulting geometry.

SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456));

POINT (1.2345 2.3456)

SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567));

POINT Z (1.2345 2.3456 3.4567)

SELECT ST_AsText(ST_MakePoint(1.2345, 2.3456, 3.4567, 4));

POINT ZM (1.2345 2.3456 3.4567 4)

⌘I