ST_Centroid(mpoly) Centroid(mpoly)
Returns a point reflecting the mathematical centroid (geometric center) for the MultiPolygon mpoly. The resulting point will not necessarily be on the MultiPolygon.
ST_Centroid()
and Centroid()
are synonyms.
SET @poly = ST_GeomFromText('POLYGON((0 0,20 0,20 20,0 20,0 0))'); SELECT ST_AsText(ST_Centroid(@poly)) AS center; +--------------+ | center | +--------------+ | POINT(10 10) | +--------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/st_centroid/