MakePoint

The MakePoint function constructs a point from latitude and longitude data that describe a location within the Geographic Coordinate System.

📘
This function isn't compatible with all data platform connections. To check if your connection supports it, see Supported data platforms and feature compatibility.

Syntax

MakePoint(longitude, latitude)

The function arguments are:

longitude: Required; A valid longitude value. Must be within the range of -180 to 180.
latitude: Required; A valid latitude value. Must be within the range of -90 to 90.

🚩
On Databricks connections, the longitude value 180 is not valid. It is equivalent to the longitude value -180.

Example

MakePoint([Longitude],[Latitude])

The MakePoint function constructs the following points from the Longitude and Latitude columns: