ST_Area

Determine the surface area of a geometry.

This function returns the surface area of a polygon, multipolygon, or geometry collection that is in WKB format.

Syntax

ST_Area(geo[, unit]);

geo

The input geometry.

Type: ST_GEOMETRY(ANY)

unit

The units (squared) of the output area. Possible values include 'meter', 'kilometer', 'foot', 'mile', and 'nautical mile'.

Type: VARCHAR(ANY)

Default: 'meter'

Returns

A value of type DOUBLE that contains the area of the input geometry.

Examples

SELECT inza..ST_Area(inza..ST_WKTToSQL('POLYGON((1 1, 1 2, 2 2, 2 1, 1 1))', 27700));

ST_AREA
---------
1
(1 row)

SELECT inza..ST_Area(inza..ST_WKTToSQL('POLYGON((1 1, 1 2, 2 2, 2 1, 1 1))', 4269));

ST_AREA
-----------------
12304814949.668
(1 row)

SELECT inza..ST_Area(inza..ST_WKTToSQL('POLYGON((1 1, 1 2, 2 2, 2 1, 1 1))', 4326));

ST_AREA
-----------------
12304814950.073
(1 row)

SELECT inza..ST_Area(inza..ST_WKTToSQL('POLYGON((1 1, 1 2, 2 2, 2 1, 1 1))', 27700), 'foot');
ST_AREA
----------------
10.76391041671
(1 row)

SELECT inza..ST_Area(inza..ST_Transform(inza..ST_WKTToSQL('POLYGON((1 1, 1 2, 2 2, 2 1, 1 1))', 27700), 4326), 'meter');
ST_AREA
-----------------
0.9373240361496
(1 row)

SELECT inza..ST_Area(inza..ST_Transform(inza..ST_WKTToSQL('POLYGON((1 1, 1 2, 2 2, 2 1, 1 1))'), 4269), 'meter');
ST_AREA
-----------------
12305124757.028
(1 row)