ST_NDims

Introduction: Returns the coordinate dimension of the geometry. Empty geometries return 2.

Format: ST_NDims(geom: Geometry)

Return type: Integer

Since: v1.3.1

Spark SQL example with z coordinate:

SELECT ST_NDims(ST_GeomFromEWKT('POINT(1 1 2)'))

Output:

3

Spark SQL example with x,y coordinate:

SELECT ST_NDims(ST_GeomFromText('POINT(1 1)'))

Output:

2

Spark SQL example with an empty geometry:

SELECT ST_NDims(ST_GeomFromText('POINT EMPTY'))

Output:

2