ST_Dimension()¶

TL;DR¶

Use ST_Dimension() to return a geometry’s inherent dimension.

Returns a geometry’s inherent dimension: 0 for points, 1 for lines, and 2 for surfaces.

Syntax¶

ST_Dimension(geom)

Arguments¶

Argument	Description
`geom`	A `GEOMETRY` or `GEOMETRY32` value.

Return Value¶

Returns INT64.

Usage Notes¶

GEOMETRY32 is supported, as covered by geo_review_fixes.sql.

Examples¶

DROP DATABASE IF EXISTS geo_dimension_demo;
CREATE DATABASE geo_dimension_demo;
USE geo_dimension_demo;

SELECT ST_Dimension(ST_GeomFromText('POLYGON((0 0,1 0,1 1,0 0))')) AS dimension;

DROP DATABASE geo_dimension_demo;

See Also¶