st_isempty function

Applies to: Databricks SQL Databricks Runtime 17.1 and above

Preview

This feature is in Public Preview.

Returns true if the input GEOGRAPHY or GEOMETRY value does not contain any non-empty points.

Syntax

st_isempty ( geoExpr )

Arguments

• geoExpr: A GEOGRAPHY or GEOMETRY value.

Returns

A value of type BOOLEAN, true if the input GEOGRAPHY or GEOMETRY value does not contain any non-empty points.

The function returns NULL if the input is NULL.

Examples

SQL

-- Returns false for geometry containing non-empty points.
> SELECT st_isempty(st_geomfromtext('MULTIPOINT(10 34,44 57,EMPTY)'));
  false
-- Returns true for geometry containing only empty points.
> SELECT st_isempty(st_geogfromtext('MULTIPOINT(EMPTY,EMPTY)'));
  true

Related functions

• st_isvalid function
• st_geometrytype function