snowflake.snowpark.functions.st_makepolygon¶

snowflake.snowpark.functions.st_makepolygon(geography_or_geometry_expression: Union[snowflake.snowpark.column.Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.47.0/src/snowflake/snowpark/_functions/scalar_functions.py#L2740-L2760)¶

Creates a polygon from a linestring that represents the exterior ring.

Parameters:: geography_or_geometry_expression (ColumnOrName) – A column or column name containing a GEOGRAPHY or GEOMETRY object representing a linestring that forms the exterior ring of the polygon.
Returns:: A new column containing the polygon created from the input linestring.
Return type:: Column

Examples::

>>> from snowflake.snowpark.functions import to_geometry
>>> df = session.create_dataframe([["LINESTRING(0.0 0.0, 1.0 0.0, 1.0 2.0, 0.0 2.0, 0.0 0.0)"]], schema=["linestring"])
>>> df.select(st_makepolygon(to_geometry(df["linestring"])).alias("polygon")).collect()
[Row(POLYGON='{\n  "coordinates": [\n    [\n      [\n        0.000000000000000e+00,\n        0.000000000000000e+00\n      ],\n      [\n        1.000000000000000e+00,\n        0.000000000000000e+00\n      ],\n      [\n        1.000000000000000e+00,\n        2.000000000000000e+00\n      ],\n      [\n        0.000000000000000e+00,\n        2.000000000000000e+00\n      ],\n      [\n        0.000000000000000e+00,\n        0.000000000000000e+00\n      ]\n    ]\n  ],\n  "type": "Polygon"\n}')]