snowflake.snowpark.functions.st_geogpointfromgeohash¶

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

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}')]

Copy