Top 5 Recent Articles

ARTICLES CATEGORIES

ST_Move for MySQL Spatial

A version of my Move functions for SQL Server Spatial and Oracle Spatial is available.

Function Declaration

 DELIMITER $$
 CREATE FUNCTION `ST_Move`
 (
   p_geometry geometry,
   p_dX       DOUBLE,
   p_dY       DOUBLE,
   p_round    INT
 )
 RETURNS geometry
 BEGIN
   -- Processing
   RETURN geometry;
 END; 
 DELIMITER ;

Function Testing

 SELECT ST_AsText(ST_Move(ST_PointFromText('POINT(0 0)',0), -5.0, 30.1, 1)) AS movedGeom;
 # movedGeom
 'POINT(-5 -5)'
 --
 SELECT ST_AsText(ST_Move(ST_GeomFromText('LINESTRING(0.1 0.2,1.4 45.2)',0),-5.0,30.1, 1)) AS movedGeom;
 # movedGeom
 'LINESTRING(-4.9 30.2,-3.6 31.5)'
 --
 SELECT ST_AsText(ST_Move(ST_GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0))',0),-5.0,30.1, 2)) AS movedGeom;
 # movedGeom
 'POLYGON((-5 30.1,5 40.1,5 40.1,-5 30.1,-5 30.1))'

If you think this is of use to you, make a donation and I will release the code to you along with any other MySQL functions I have created.