snowflake.snowpark.functions.st_makegeompoint¶

snowflake.snowpark.functions.st_makegeompoint(longitude: Union[snowflake.snowpark.column.Column, str], latitude: Union[snowflake.snowpark.column.Column, str]) → Column[source]¶

Constructs a GEOMETRY object that represents a point with the specified longitude and latitude values.

Parameters:

• longitude (ColumnOrName) – A column or column name containing the longitude values

• latitude (ColumnOrName) – A column or column name containing the latitude values

Returns:

A column containing GEOMETRY objects representing points

Return type:

Column

Examples::

CopyExpand

>>> df = session.create_dataframe([[-122.35, 37.55], [-74.006, 40.7128]], schema=["longitude", "latitude"])
>>> df.select(st_makegeompoint(df["longitude"], df["latitude"]).alias("geom_point")).collect()
[Row(GEOM_POINT='{\n  "coordinates": [\n    -1.223500000000000e+02,\n    3.755000000000000e+01\n  ],\n  "type": "Point"\n}'), Row(GEOM_POINT='{\n  "coordinates": [\n    -7.400600000000000e+01,\n    4.071280000000000e+01\n  ],\n  "type": "Point"\n}')]

Show lessSee more

Scroll to top