(mysql.info.gz) Polygon property functions

Info Catalog

(mysql.info.gz) Multilinestring property functions

(mysql.info.gz) Geometry property functions

(mysql.info.gz) Multipolygon property functions

 
 18.5.2.5 `Polygon' Functions
 ............................
 
 `Area(POLY)'
      Returns as a double-precision number the area of the `Polygon'
      value POLY, as measured in its spatial reference system.
 
           mysql> SET @poly = 'Polygon((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1 1))';
           mysql> SELECT Area(GeomFromText(@poly));
           +---------------------------+
           | Area(GeomFromText(@poly)) |
           +---------------------------+
           |                         4 |
           +---------------------------+
 
 `ExteriorRing(POLY)'
      Returns the exterior ring of the `Polygon' value POLY as a
      `LineString'.
           mysql> SET @poly =
               -> 'Polygon((0 0,0 3,3 3,3 0,0 0),(1 1,1 2,2 2,2 1,1 1))';
           mysql> SELECT AsText(ExteriorRing(GeomFromText(@poly)));
           +-------------------------------------------+
           | AsText(ExteriorRing(GeomFromText(@poly))) |
           +-------------------------------------------+
           | LINESTRING(0 0,0 3,3 3,3 0,0 0)           |
           +-------------------------------------------+
 
 `InteriorRingN(POLY,N)'
      Returns the N-th interior ring for the `Polygon' value POLY as a
      `LineString'.  Ring numbers begin at 1.
           mysql> SET @poly =
               -> 'Polygon((0 0,0 3,3 3,3 0,0 0),(1 1,1 2,2 2,2 1,1 1))';
           mysql> SELECT AsText(InteriorRingN(GeomFromText(@poly),1));
           +----------------------------------------------+
           | AsText(InteriorRingN(GeomFromText(@poly),1)) |
           +----------------------------------------------+
           | LINESTRING(1 1,1 2,2 2,2 1,1 1)              |
           +----------------------------------------------+
 
 `NumInteriorRings(POLY)'
      Returns the number of interior rings in the `Polygon' value POLY.
           mysql> SET @poly =
               -> 'Polygon((0 0,0 3,3 3,3 0,0 0),(1 1,1 2,2 2,2 1,1 1))';
           mysql> SELECT NumInteriorRings(GeomFromText(@poly));
           +---------------------------------------+
           | NumInteriorRings(GeomFromText(@poly)) |
           +---------------------------------------+
           |                                     1 |
           +---------------------------------------+
 
 

Info Catalog

(mysql.info.gz) Multilinestring property functions

(mysql.info.gz) Geometry property functions

(mysql.info.gz) Multipolygon property functions