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)