ST_Point(DOUBLE, DOUBLE, DOUBLE, DOUBLE[, INT]) constructor

Syntax

NEW ST_Point(DOUBLE x, DOUBLE y, DOUBLE z, DOUBLE m[, INT srid])

Parameters

• x – The X coordinate value.
• y – The Y coordinate value.
• z – The Z coordinate value.
• m – The measure value.
• srid – The SRID of the result. If not specified, the default is 0.

Returns

ST_Point Returns a 3D, measured point with the specified X,Y,Z coordinates and a measure value

Examples

• Example 1 – The following returns Point ZM (10 20 100 1224).

  SELECT NEW ST_Point(10.0,20.0,100.0,1224.0,0)

Standards

SQL/MM (ISO/IEC 13249-3: 2006) 6.1.2