Name
ST_Area — Returns the area of the geometry if it is a polygon or multi-polygon.
Synopsis
float ST_Area(geometry g1);
Description
Returns the area of the geometry if it is a polygon or multi-polygon. Return the area measurement of an ST_Surface or ST_MultiSurface value. Area is in the units of the spatial reference system.
This method implements the OpenGIS Simple Features
Implementation Specification for SQL.
This method implements the SQL/MM specification:
SQL-MM 3: 8.1.2, 9.5.3
Examples
Return area in square feet for a plot of Massachusetts land. Note this is in square feet because 2249 is Mass State Plane Feet
SELECT ST_Area(ST_GeomFromText('POLYGON((743238 2967416,743238 2967450,
743265 2967450,743265.625 2967416,743238 2967416))',2249));
st_area
---------
928.625
(1 row)
--this returns in square meters
SELECT ST_Area(ST_Transform(ST_GeomFromText('POLYGON((743238 2967416,743238 2967450,
743265 2967450,743265.625 2967416,743238 2967416))',2249), 26986));
st_area
------------------
86.2724306061864