snowflake.snowpark.functions.st_geompointfromgeohash¶

snowflake.snowpark.functions.st_geompointfromgeohash(geohash: Union[snowflake.snowpark.column.Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.44.0/src/snowflake/snowpark/_functions/scalar_functions.py#L3045-L3062)¶

Returns a GEOMETRY object that represents a point constructed from a geohash string.

Parameters:

geohash (ColumnOrName) – A column or string representing the geohash value to convert to a geometry point

Returns:

A GEOMETRY object representing the point decoded from the geohash

Return type:

Column

Examples::

CopyExpand

>>> df = session.create_dataframe([['9q9j8ue2v71y5zzy0s4q'], ['9q9hpyb25d']], schema=["geohash"])
>>> df.select(st_geompointfromgeohash(df["geohash"]).alias("geometry_point")).collect()
[Row(GEOMETRY_POINT='{\n  "coordinates": [\n    -1.223061000000001e+02,\n    3.755416199999996e+01\n  ],\n  "type": "Point"\n}'), Row(GEOMETRY_POINT='{\n  "coordinates": [\n    -1.220026749372482e+02,\n    3.730271726846695e+01\n  ],\n  "type": "Point"\n}')]

Show lessSee more

Scroll to top