ST_POINT

Learn how to use the ST_POINT spatial function in PlaidCloud Lakehouse. Creates a point geometry from longitude and latitude values - with syntax and examples.

Creates a point geometry from longitude and latitude values.

Analyze Syntax

func.st_point(<lng>, <lat>)

Analyze Examples

func.st_point(-73.9857, 40.7484)

┌────────────┐
│ (geometry)  │
└────────────┘

SQL Syntax

ST_POINT(<lng>, <lat>)

SQL Examples

SELECT ST_ASTEXT(ST_POINT(-73.9857, 40.7484));

┌──────────────────────────┐
│ POINT (-73.9857 40.7484)  │
└──────────────────────────┘