Skip to main content

SingleStoreDB v8.1

GEOGRAPHY_POINT

This function takes two floats or doubles and returns a GeographyPoint type.

Since all of SingleStoreDB’s topological and measurement functions can equally understand WKT strings and geospatial objects, this constructor is mainly for convenience. Note that the ordering in the input pair is significant, the first value is the longitude and the second value is the latitude.

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 ROWSTORE TABLE geopoint (
  id INT UNSIGNED PRIMARY KEY,
  lon FLOAT,
  lat FLOAT,
  location AS GEOGRAPHY_POINT(lon, lat) PERSISTED GEOGRAPHYPOINT,
  INDEX(location)
  );
INSERT INTO geopoint VALUES(1, 50.01, 40.01);

SELECT * FROM geopoint;
****
+----+-------+-------+--------------------------------+
| id | lon   | lat   | location                       |
+----+-------+-------+--------------------------------+
|  1 | 50.01 | 40.01 | POINT(50.00999831 40.00999832) |
+----+-------+-------+--------------------------------+
1 row in set (0.00 sec)
In this section: