ST_Circle

Description

Syntax:

GEOMETRY ST_Circle(DOUBLE center_lng, DOUBLE center_lat, DOUBLE radius)

This function converts a WKT (Well Known Text) into a circle on the earth's sphere, where center_lng and Center_lat denote the longitude and latitude of the center of the circle, respectively, and radius denotes the radius of the circle (measured in meters and no larger than 9999999).

Example

mysql> SELECT ST_AsText(ST_Circle(111, 64, 10000));
+--------------------------------------------+
| st_astext(st_circle(111.0, 64.0, 10000.0)) |
+--------------------------------------------+
| CIRCLE ((111 64), 10000)                   |
+--------------------------------------------+

Keywords

ST_CIRCLE,ST,CIRCLE