ST_CoordDim

ST_CoordDim takes a geometry column and returns an integer column representing the dimensionality of the coordinates in the input geometry. For example, an input geometry with x,y coordinates only will return 2, while a geometry with x,y,z coordinates will return 3.

For more details, go to the GeoAnalytics for Microsoft Fabric API reference for coord_dim.

This function implements the OpenGIS Simple Features Implementation Specification for SQL 1.2.1.

Examples

1
2
3
4
5
6
7
8
9
10
11
12
13
from geoanalytics_fabric.sql import functions as ST, Point

data = [
    (Point(10, 10),),
    (Point(10, 10, 50),),
    (Point(10, 10, 50, 1000),)
]

df = spark.createDataFrame(data, ["point"])

df.select(ST.coord_dim("point").alias("coord_dim")).show()

1
2
3
4
5
6
7
+---------+
|coord_dim|
+---------+
|        2|
|        3|
|        4|
+---------+

Version table

Related topics

• SQL functions
• ST_Dimension
• Data sources
• Coordinate systems and transformations