snowflake.snowpark.functions.st_geogpointfromgeohash¶

snowflake.snowpark.functions.st_geogpointfromgeohash(geohash: 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#L3658-L3675)¶

Constructs a GEOGRAPHY object that represents a point from a geohash string.

Parameters:: geohash (ColumnOrName) – The geohash value to convert to a geography point.
Returns:: A GEOGRAPHY object representing a point decoded from the geohash.
Return type:: Column

Examples::

>>> df = session.create_dataframe([["9q9j8ue2v71y5zzy0s4q"], ["9q9hpb8"]], schema=["geohash"])
>>> df.select(st_geogpointfromgeohash(df["geohash"]).alias("geography_point")).collect()
[Row(GEOGRAPHY_POINT='{\n  "coordinates": [\n    -1.223060999999999e+02,\n    3.755416200000003e+01\n  ],\n  "type": "Point"\n}'), Row(GEOGRAPHY_POINT='{\n  "coordinates": [\n    -1.220024871826172e+02,\n    3.726905822743459e+01\n  ],\n  "type": "Point"\n}')]