Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

GEOGRAPHY_POINT

The GEOGRAPHY_POINT() function takes two floats or doubles and returns a GeographyPoint type.

Since all of SingleStore Helios’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)

For more information about working with geospatial data, see Working with Geospatial Features.

Last modified:

Was this article helpful?