snowflake.snowpark.functions.st_geometryfromwkt¶

snowflake.snowpark.functions.st_geometryfromwkt(varchar_expression: Union[snowflake.snowpark.column.Column, str], srid: Union[snowflake.snowpark.column.Column, str] = None, allow_invalid: Union[snowflake.snowpark.column.Column, str] = None) → Column[source]¶

Parses a WKT (well-known text) input and returns a GEOMETRY object.

Parameters:

  • varchar_expression (ColumnOrName) – A string expression containing the WKT representation of a geometry.

  • srid (ColumnOrName, optional) – The spatial reference system identifier (SRID) for the geometry.

  • allow_invalid (ColumnOrName, optional) – Whether to allow invalid geometries.

Returns:

A GEOMETRY object parsed from the WKT input

Return type:

Column

Examples::
>>> from snowflake.snowpark.functions import col, lit
>>> df = session.create_dataframe([["POINT(389866.35 5819003.03)"]], schema=["wkt"])
>>> df.select(st_geometryfromwkt(col("wkt")).alias("geometry")).collect()
[Row(GEOMETRY='{\n  "coordinates": [\n    3.898663500000000e+05,\n    5.819003030000000e+06\n  ],\n  "type": "Point"\n}')]
Copy
>>> df.select(st_geometryfromwkt(col("wkt"), lit(4326)).alias("geometry")).collect()
[Row(GEOMETRY='{\n  "coordinates": [\n    3.898663500000000e+05,\n    5.819003030000000e+06\n  ],\n  "type": "Point"\n}')]
Copy
>>> df.select(st_geometryfromwkt(col("wkt"), lit(4326), lit(True)).alias("geometry")).collect()
[Row(GEOMETRY='{\n  "coordinates": [\n    3.898663500000000e+05,\n    5.819003030000000e+06\n  ],\n  "type": "Point"\n}')]
Copy
>>> df.select(st_geometryfromwkt(col("wkt"), allow_invalid=lit(True)).alias("geometry")).collect()
[Row(GEOMETRY='{\n  "coordinates": [\n    3.898663500000000e+05,\n    5.819003030000000e+06\n  ],\n  "type": "Point"\n}')]
Copy
Language: English