Help Center> Data Lake Insight> Developer Guide> Geometry Query> Support of Geometry Query Functions> Geometry Editors
View PDF

Geometry Editors

st_translate

Geometry st_translate(Geometry geom, Double deltaX, Double deltaY)

This function returns the Geometry produced when geom is translated by deltaX and deltaY.

Example:

  • Query command:

    select st_asText(st_translate(st_geomFromWKT(location),1,2)) from geotbl where id='4'

  • The query result is as follows: 
    POLYGON ((36 12, 46 47, 16 42, 11 22, 36 12), (21 32, 36 37, 31 22, 21 32))