Skip to main content

ST_GeometryType

Returns the geometry type as a string.

Syntax​

ST_GeometryType(geometry)

Parameters​

ParameterTypeDescription
geometryGeometryInput geometry

Returns​

TypeDescription
Utf8Geometry type name (e.g., "Point", "Polygon")

Examples​

Get Type of Point​

SELECT ST_GeometryType(ST_Point(0, 0));
-- Returns: "Point"

Get Type of Polygon​

SELECT ST_GeometryType(ST_GeomFromText('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'));
-- Returns: "Polygon"

Group by Geometry Type​

SELECT ST_GeometryType(geom) as geom_type, COUNT(*) as count
FROM features
GROUP BY ST_GeometryType(geom);

Filter by Type​

SELECT * FROM mixed_features
WHERE ST_GeometryType(geom) = 'Polygon';

Notes​

  • Returns standard OGC geometry type names
  • Possible values: Point, LineString, Polygon, MultiPoint, MultiLineString, MultiPolygon, GeometryCollection
  • Useful for filtering or routing logic based on geometry type
  • Case-sensitive return value

See Also​