(mysql.info) multilinestring-property-functions

Info Catalog

(mysql.info) linestring-property-functions

(mysql.info) geometry-property-functions

(mysql.info) polygon-property-functions

 
 16.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 |
           +-----------------------------+
 
      `GLength()' is a non-standard name. It corresponds to the OpenGIS
      `Length()' function.
 
    * `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) linestring-property-functions

(mysql.info) geometry-property-functions

(mysql.info) polygon-property-functions