Is there a way of doing ST_SnapToGrid in MySql?

Question

Given that MySQL 5.7 has spatial data types Is there an equivalent to PostGIS's ST_SnapToGrid in MySQL?

Looking at the reference:

http://dev.mysql.com/doc/refman/5.7/en/spatial-function-reference.html

I can't find one. Is there something else I could use that would do the same thing?

Answer 1

I wrote this function which does the same thing in MySQL.

DROP FUNCTION IF EXISTS ST_SnapToGrid;
DELIMITER $$
CREATE FUNCTION ST_SnapToGrid(geom POINT, sizeX FLOAT, sizeY FLOAT)
RETURNS POINT
BEGIN

    DECLARE x, y FLOAT;

    SET x = FLOOR(ST_X(geom) / sizeX) * sizeX;
    SET y = FLOOR(ST_Y(geom) / sizeY) * sizeY;

    SET geom = POINT(x, y);

    RETURN geom;

END$$
DELIMITER ;