GeometryType - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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