Help Center > > Developer Guide> Geometry Query> Support of Geometry Query Functions> Geometry Editors

Geometry Editors

Updated at: Apr 09, 2019 GMT+08:00

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))

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel