MakePoint

View as Markdown

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:

Example of the MakePoint function shown over three columns. Latitude and Longitude are combined to make a column of point values.