Available in versions: Dev (3.16)

Spatial predicates

Applies to ❌ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

A few databases have implemented the ISO/IEC 13249-3 SQL standard spatial extensions (or vendor specific adaptations thereof) to calculate geometric or geographic sets.

Most functionality comes in the form of spatial functions, but some useful predicates can also be formed from geometries.

Table of contents

4.9.23.1.
ST_Contains (new)
4.9.23.2.
ST_Crosses (new)
4.9.23.3.
ST_Disjoint (new)
4.9.23.4.
ST_Equals (new)
4.9.23.5.
ST_Intersects (new)
4.9.23.6.
ST_IsClosed (new)
4.9.23.7.
ST_IsEmpty (new)
4.9.23.8.
ST_Overlaps (new)
4.9.23.9.
ST_Touches (new)
4.9.23.10.
ST_Within (new)

The jOOQ User Manual : SQL building : Conditional expressions : Spatial predicatesprevious : next

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo