ST_Translate

ST_Translate takes a geometry column and two numbers and returns a geometry column. The result is the input geometry translated in the x and y directions by the specified offsets.

Function	Syntax
Python	`translate(geometry, x_offset, y_offset)`
SQL	`ST_Translate(geometry, x_offset, y_offset)`

For more details, go to the GeoAnalytics Engine API reference for translate.

Examples

Python

SQL

Use dark colors for code blocksCopy
from geoanalytics.sql import functions as ST

data = [
    ("POINT (-117.05 34.22)",),
    ("MULTIPOINT (-117.55 34.33, -117.66 34.44, -117.66 34.22)",),
    ("LINESTRING (-116.89 33.96, -116.71 34.01, -116.66 34.08)", ),
    ("POLYGON ((-117.27 34.05, -117.22 33.91, -116.96 33.64, -116.66 33.71, -117.08 33.91, -117.16 34.09, -117.27 34.05))", )
]

df = spark.createDataFrame(data, ["wkt"]) \
          .withColumn("geometry", ST.geom_from_text("wkt", srid=4326))

df_translate = df.withColumn("translate", ST.translate("geometry", x_offset=2, y_offset=-1))

ax = df_translate.st.plot("geometry", facecolor="none", edgecolor="red", figsize=(15, 8))
df_translate.st.plot("translate", ax=ax, facecolor="none", edgecolor="blue")

Plotted example for ST_Translate — Plotted result for ST_Translate.

Version table

Release	Notes
1.2.0	Function introduced

ST_Translate

Examples

Version table

Related topics