Geometric Functions for Polygon Objects : polygon « Geometric « SQL / MySQL






  1. SQL / MySQL
  2. Geometric
  3. polygon

Geometric Functions for Polygon Objects

    
Function                 Description
AREA                     Area of the polygon.
EXTERIORRING             Outer ring of the polygon as LINESTRING.
INTERIORRINGN(g, N)      Inner ring of the polygon as LINESTRING.
NUMINTERIORRINGS         Number of inner rings (holes).








Related examples in the same category

1.Determine the length of the outer polygon with EXTERIORRING function:
2.POLYGON type column: A closed LINESTRING; two-dimensional.
3.Using the POLYGON object in the variable