Outdated Version
You are viewing an older version of this section. View current production version.
GEOGRAPHY_LENGTH
This function measures the length of a path or the total perimeter of a polygon, in meters.
Syntax
GEOGRAPHY_LENGTH ( geo )
Arguments
- geo: any valid geospatial object or WKT string: path, point or polygon.
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 |
+-----------+