GeometryType - Amazon Redshift
SyntaxArgumentsReturn typeExamples

Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025. If you would like to use Python UDFs, create the UDFs prior to that date. Existing Python UDFs will continue to function as normal. For more information, see the blog post .

GeometryType

GeometryType returns the subtype of an input geometry as a string.

Syntax

GeometryType(geom)

Arguments

geom

A value of data type GEOMETRY or an expression that evaluates to a GEOMETRY type.

Return type

VARCHAR representing the subtype of geom.

If geom is null, then null is returned.

The values returned are as follows.

Returned string value for 2D, 3DZ, 4D geometries Returned string value for 3DM geometries Geometry subtype

POINT

POINTM

Returned if geom is a POINT subtype

LINESTRING

LINESTRINGM

Returned if geom is a LINESTRING subtype

POLYGON

POLYGONM

Returned if geom is a POLYGON subtype

MULTIPOINT

MULTIPOINTM

Returned if geom is a MULTIPOINT subtype

MULTILINESTRING

MULTILINESTRINGM

Returned if geom is a MULTILINESTRING subtype

MULTIPOLYGON

MULTIPOLYGONM

Returned if geom is a MULTIPOLYGON subtype

GEOMETRYCOLLECTION

GEOMETRYCOLLECTIONM

Returned if geom is a GEOMETRYCOLLECTION subtype

Examples

The following SQL converts a well-known text (WKT) representation of a polygon and returns the GEOMETRY subtype as a string.

SELECT GeometryType(ST_GeomFromText('POLYGON((0 2,1 1,0 -1,0 2))'));

geometrytype
-------------
 POLYGON