Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
GEOGRAPHY_
On this page
This function takes two floats or doubles and returns a GeographyPoint type.
Since all of SingleStore’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.
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)Related Topics
For more information about working with geospatial data, see Working with Geospatial Features.
Last modified: February 24, 2023