View a markdown version of this page

Spatial functions - Amazon Redshift

Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

Spatial functions

Relationships between geometry objects are based on the Dimensionally Extended nine-Intersection Model (DE-9IM). This model defines predicates such as equals, contains, and covers. For more information about the definition of spatial relationships, see DE-9IM in Wikipedia.

For more information about how to use spatial data with Amazon Redshift, see Querying spatial data in Amazon Redshift.

Amazon Redshift provides spatial functions that work with GEOMETRY and GEOGRAPHY data types. The following lists the functions that support the GEOGRAPHY data type:

The following lists the full set of spatial functions supported by Amazon Redshift.