Categories:

Geospatial functions

ST_MAKEPOINT , ST_POINT¶

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

See also:

TO_GEOGRAPHY

Syntax¶

ST_MAKEPOINT( <longitude> , <latitude> )
Copy

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)         |
+--------------------------+
Copy