SingleStore DB

GEOGRAPHY_POINT

Constructor function. This function takes two floats or doubles and returns a GeographyPoint type. Since all of SingleStore DB’s topological and measurement functions can equally understand WKT strings and geospatial objects, this constructor is mainly for convenience.

Syntax
GEOGRAPHY_POINT ( longitude, latitude )
Arguments
  • longitude: float or double describing the longitude in degrees. Values outside of the range [-180, 180] will be wrapped around.

  • latitude: float or double describing the latitude in degrees. Values outside of the range [-90, 90] will trigger an error.

Return Type

A GeographyPoint object.

Examples

In this example, we use a persisted computed column to create an indexed GeographyPoint from a pair of floats. This technique is useful for bulk-loading geospatial data.

CREATE TABLE foo (
    ->    id INT UNSIGNED PRIMARY KEY,
    ->    lon FLOAT,
    ->    lat FLOAT,
    ->    location AS GEOGRAPHY_POINT(lon, lat) PERSISTED GEOGRAPHYPOINT,
    ->    INDEX(location)
    -> );
INSERT INTO foo VALUES(1, 50.01, 40.01);
SELECT * FROM foo;
+----+-------+-------+--------------------------------+
| id | lon   | lat   | location                       |
+----+-------+-------+--------------------------------+
|  1 | 50.01 | 40.01 | POINT(50.00999831 40.00999832) |
+----+-------+-------+--------------------------------+
1 row in set (0.00 sec)