Categories:

Geospatial Functions

ST_MAKEPOINT , ST_POINT

Constructs a GEOGRAPHY value that contains a point with the specified longitude and latitude.

See also:

TO_GEOGRAPHY

Syntax

ST_MAKEPOINT( <longitude> , <latitude> )

Arguments

longitude

A REAL that represents the longitude.

latitude

A REAL that represents the latitude.

Returns

The function returns a value of type GEOGRAPHY.

Usage Notes

  • ST_POINT is an alias for ST_MAKEPOINT.

Examples

This shows a simple use of the ST_MAKEPOINT function:

SELECT ST_MAKEPOINT(37.5, 45.5);
+--------------------------+
| ST_MAKEPOINT(37.5, 45.5) |
|--------------------------|
| POINT(37.5 45.5)         |
+--------------------------+