Product Solutions Support
Try MemSQL

GEOGRAPHY_POINT

Constructor function. This function takes two floats or doubles and returns a GeographyPoint type. Since all of MemSQL’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

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 geopspatial data.

memsql> create table foo (
    ->    id int unsigned primary key,
    ->    lon float,
    ->    lat float,
    ->    location as geography_point(lon, lat) persisted geographypoint,
    ->    index(location)
    -> );
memsql> insert into foo values (1, 50.01, 40.01);
memsql> select * from foo;
+----+-------+-------+--------------------------------+
| id | lon   | lat   | location                       |
+----+-------+-------+--------------------------------+
|  1 | 50.01 | 40.01 | POINT(50.00999831 40.00999832) |
+----+-------+-------+--------------------------------+
1 row in set (0.00 sec)
Was this article useful?