ST_AREA()

All functions > GEOSPATIAL > ST_AREA()

Returns the area of a geometry or geography.

Signatures

Area

Returns: Area of the input

ST_AREA(geo: T) → DOUBLE

With:

• T : Custom types: GEOM_POINT | GEOM_LINESTRING | GEOM_POLYGON | GEOM_MULTIPOINT | GEOM_MULTILINESTRING | GEOM_MULTIPOLYGON | GEOM_MULTIANY | GEOG_POINT | GEOG_LINESTRING | GEOG_POLYGON | GEOG_MULTIPOINT | GEOG_MULTILINESTRING | GEOG_MULTIPOLYGON | GEOG_MULTIANY

Signature notes:

• On GEOMETRY: returns planar area in SRID coordinate units squared
• On GEOGRAPHY: returns area in square meters
• Returns 0.0 for Point, LineString, MultiPoint, and MultiLineString (not NULL)
• On GeometryCollection: returns the sum of areas of areal children
• Returns NULL if the input is NULL

Examples

Geometry (planar area)

SELECT
    f1 := ST_AREA(ST_GEOMFROMTEXT('POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))')), -- Area of a 10x10 square
    f2 := ST_AREA(ST_GEOMPOINT(1.0, 2.0)) -- Area of a point is 0
;

Geography (area in square meters)

SELECT
    f1 := ST_AREA(ST_GEOGFROMTEXT('POLYGON ((2.29 48.85, 2.36 48.85, 2.36 48.87, 2.29 48.87, 2.29 48.85))')) -- Approximate area around central Paris in m²
;