(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
automatically generated byinfo2html