snowflake.snowpark.functions.st_srid¶

snowflake.snowpark.functions.st_srid(geography_or_geometry_expression: Union[snowflake.snowpark.column.Column, str]) → Column[source]¶

Returns the spatial reference system identifier (SRID) for a GEOGRAPHY or GEOMETRY object.

Parameters:

geography_or_geometry_expression (ColumnOrName) – A GEOGRAPHY or GEOMETRY object

Returns:

The SRID of the input GEOGRAPHY or GEOMETRY object

Return type:

Column

Examples::

>>> from snowflake.snowpark.functions import st_makepoint
>>> df = session.create_dataframe([[37.5, 45.5]], schema=["x", "y"])
>>> df.select(st_srid(st_makepoint(df["x"], df["y"])).alias("srid")).collect()
[Row(SRID=4326)]

Copy