(mysql.info) multipolygon-property-functions

Info Catalog

(mysql.info) polygon-property-functions

(mysql.info) geometry-property-functions

(mysql.info) geometrycollection-property-functions

 
 16.5.2.6 `MultiPolygon' Functions
 .................................
 
    * `Area(MPOLY)'
 
      Returns as a double-precision number the area of the
      `MultiPolygon' value MPOLY, as measured in its spatial reference
      system.
 
           mysql> SET @mpoly =
               -> 'MultiPolygon(((0 0,0 3,3 3,3 0,0 0),(1 1,1 2,2 2,2 1,1 1)))';
           mysql> SELECT Area(GeomFromText(@mpoly));
           +----------------------------+
           | Area(GeomFromText(@mpoly)) |
           +----------------------------+
           |                          8 |
           +----------------------------+
 
 The OpenGIS specification also defines the following functions, which
 MySQL does not implement:
 
    * `Centroid(MPOLY)'
 
      Returns the mathematical centroid for the `MultiPolygon' value
      MPOLY as a `Point'. The result is not guaranteed to be on the
      `MultiPolygon'.
 
    * `PointOnSurface(MPOLY)'
 
      Returns a `Point' value that is guaranteed to be on the
      `MultiPolygon' value MPOLY.
 

Info Catalog

(mysql.info) polygon-property-functions

(mysql.info) geometry-property-functions

(mysql.info) geometrycollection-property-functions