Product Solutions Support
Try MemSQL

GEOGRAPHY_LENGTH

This function measures the length of a path or the total perimeter of a polygon, in meters.

image

Syntax

GEOGRAPHY_LENGTH ( geo )

Arguments

Return Type

Double. In the case of a POINT, the length is always 0.

Examples

mysql> select round(geography_length(shape), 0) as perimeter from neighborhoods;
+-----------+
| perimeter |
+-----------+
|      8558 |
|      9188 |
|      4831 |
|     11990 |
|      9455 |
|      7886 |
|      6418 |
|      8580 |
|      7983 |
+-----------+
Was this article useful?