GEOGRAPHY_POINT

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)

Related Topics

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