(mysql.info.gz) Multipolygon property functions

Info Catalog

(mysql.info.gz) Polygon property functions

(mysql.info.gz) Geometry property functions

(mysql.info.gz) Geometrycollection property functions

 
 18.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.gz) Polygon property functions

(mysql.info.gz) Geometry property functions

(mysql.info.gz) Geometrycollection property functions