ST_SnapToGrid( ST_Point , DOUBLE, DOUBLE, DOUBLE, DOUBLE) method

Syntax

geometry-expression.ST_SnapToGrid( ST_Point origin, DOUBLE cell_size_x, DOUBLE cell_size_y, DOUBLE cell_size_z, DOUBLE cell_size_m)

Parameters

• origin – The origin of the grid.
• cell_size_x – The cell size for the grid in the X dimension.
• cell_size_y – The cell size for the grid in the Y dimension.
• cell_size_z – The cell size for the grid in the Z dimension.
• cell_size_m – The cell size for the grid in the M dimension.

Returns

ST_Geometry Returns the geometry with all points snapped to the grid.

Examples

• Example 1 – The following example returns the result LineString (1.010101 20.20202, 1.015625 20.203125, 1.01 20.2).

  SELECT NEW ST_LineString(
  NEW ST_Point( 1.010101, 20.202020 ),
  TREAT( NEW ST_Point( 1.010101, 20.202020 ).ST_SnapToGrid( NEW ST_Point( 0.0, 0.0 ), POWER( 2, -6 ), POWER( 2, -7 ), 0.0, 0.0 ) AS ST_Point ),
  TREAT( NEW ST_Point( 1.010101, 20.202020 ).ST_SnapToGrid( NEW ST_Point( 1.01, 20.2 ), POWER( 2, -6 ), POWER( 2, -7 ), 0.0, 0.0 ) AS ST_Point ) )

  The first point of the linestring is the point ST_Point( 1.010101, 20.202020 ), snapped to the grid defined for SRID 0. The second point of the linestring is the same point snapped to a grid defined with its origin at point ( 0.0 0.0 ), where cell size x is POWER( 2, -6 ) and cell size y is POWER( 2, -7 ). The third point of the linestring is the same point snapped to a grid defined with its origin at point ( 1.01, 20.2 ), where cell size x is POWER( 2, -6 ) and cell size y is POWER( 2, -7 ).

Standards

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