Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
GEOGRAPHY_
On this page
The GEOGRAPHY_ 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: