Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

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)