You are viewing documentation about an older version (1.45.0). View latest version

snowflake.snowpark.functions.st_transform

snowflake.snowpark.functions.st_transform(geometry_expression: Union[snowflake.snowpark.column.Column, str], to_srid: Union[snowflake.snowpark.column.Column, str], from_srid: Union[snowflake.snowpark.column.Column, str] = None)[source]

Transforms a geometry from one spatial reference system (SRS) to another using SRID (Spatial Reference System Identifier) values.

Parameters:

  • geometry_expression (ColumnOrName) – A column containing geometry objects to transform

  • to_srid (ColumnOrName) – The target spatial reference system identifier to transform the geometry to

  • from_srid (ColumnOrName, optional) – The source spatial reference system identifier. If None, uses the geometry’s existing SRID

Returns:

A column containing the transformed geometry objects

Return type:

Column

Examples::
>>> from snowflake.snowpark import Row
>>> from snowflake.snowpark.functions import to_geometry, lit

>>> df = session.create_dataframe([["POINT(389866.35 5819003.03)"]], schema=["geom_wkt"])
>>> result1 = df.select(st_transform(st_setsrid(to_geometry(df["geom_wkt"]), lit(32617)), lit(3857)).alias("transformed")).collect()
>>> assert result1 == [Row(TRANSFORMED='{\n  "coordinates": [\n    -9.197531022388615e+06,\n    6.892872198680114e+06\n  ],\n  "type": "Point"\n}')]

>>> result2 = df.select(st_transform(to_geometry(df["geom_wkt"]), lit(32633), lit(3857)).alias("transformed")).collect()
>>> assert result2 == [Row(TRANSFORMED='{\n  "coordinates": [\n    -3.861449042853381e+05,\n    5.185433920948020e+06\n  ],\n  "type": "Point"\n}')]