5. Geospatial Functions : Area
 
Share this page                  
Area
AREA(g Geometry)
Alias: ST_AREA
Returns the area of g.
Result type: float
Example: Query the area of a polygon:
SELECT AREA(POLYFROMTEXT('POLYGON((0 0,0 10,5 5,10 10, 8 6,10 0,3 3,0 0))'));
------------
col1
------------
50.000
------------