Loading...
Returns the area of a Polygon or MultiPolygon. The result is a double-precision number measured in the geometry's spatial reference units.
ST_Area(poly) Area(poly)
Returns as a double-precision number the area of the Polygon value poly, as measured in its spatial reference system.
poly
ST_Area() and Area() are synonyms.
ST_Area()
Area()
This page is licensed: GPLv2, originally from
SET @poly = 'Polygon((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1 1))'; SELECT Area(GeomFromText(@poly)); +---------------------------+ | Area(GeomFromText(@poly)) | +---------------------------+ | 4 | +---------------------------+