Share via

st_isempty function

Applies to: check marked yes Databricks Runtime 17.1 and above

Important

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

-- 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