ST_IsEmpty

ST_IsEmpty takes a geometry column and returns a boolean column. The output returns True if the geometry is empty; otherwise, it returns False.

Function	Syntax
Python	`is_empty(geometry)`
SQL	`ST_IsEmpty(geometry)`

For more details, go to the GeoAnalytics Engine API reference for is_empty.

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

Examples

Python

SQL

Use dark colors for code blocksCopy
from geoanalytics.sql import functions as ST

data = [
    ("POINT (-2533858.73 8107527.81)",),
    ("POINT EMPTY", )
]

df = spark.createDataFrame(data, ["wkt"])\
          .select(ST.geom_from_text("wkt", srid=54008).alias("geometry"))

df.select(ST.is_empty("geometry").alias("is_empty")).show()

Result
Use dark colors for code blocksCopy
+--------+
|is_empty|
+--------+
|   false|
|    true|
+--------+

Version table

Release	Notes
1.0.0	Function introduced

SQL functions
Data sources
Coordinate systems and transformations

ST_IsEmpty

Examples

Version table

Related topics