(mysql.info.gz) Multilinestring property functions

Info Catalog

(mysql.info.gz) Linestring property functions

(mysql.info.gz) Geometry property functions

(mysql.info.gz) Polygon property functions

 
 18.5.2.4 `MultiLineString' Functions
 ....................................
 
 `GLength(MLS)'
      Returns as a double-precision number the length of the
      `MultiLineString' value MLS. The length of MLS is equal to the sum
      of the lengths of its elements.
 
           mysql> SET @mls = 'MultiLineString((1 1,2 2,3 3),(4 4,5 5))';
           mysql> SELECT GLength(GeomFromText(@mls));
           +-----------------------------+
           | GLength(GeomFromText(@mls)) |
           +-----------------------------+
           |             4.2426406871193 |
           +-----------------------------+
 
 `IsClosed(MLS)'
      Returns 1 if the `MultiLineString' value MLS is closed (that is,
      the `StartPoint()' and `EndPoint()' values are the same for each
      `LineString' in MLS).  Returns 0 if MLS is not closed, and -1 if
      it is `NULL'.
 
           mysql> SET @mls = 'MultiLineString((1 1,2 2,3 3),(4 4,5 5))';
           mysql> SELECT IsClosed(GeomFromText(@mls));
           +------------------------------+
           | IsClosed(GeomFromText(@mls)) |
           +------------------------------+
           |                            0 |
           +------------------------------+
 
 

Info Catalog

(mysql.info.gz) Linestring property functions

(mysql.info.gz) Geometry property functions

(mysql.info.gz) Polygon property functions