The following is a list of predicate methods available for use with spatial data. An X in the Round-Earth column indicates that the method is also supported on round-Earth spatial reference systems. The SQL/MM column reflects compliance with the SQL/MM standard (ISO/IEC 13249-3: 2006).
Method | Type | Description | Round-Earth | SQL/MM |
---|---|---|---|---|
ST_Contains method | ST_Geometry type |
Tests if a geometry value spatially contains another geometry value. |
5.1.31 | |
ST_ContainsFilter method | ST_Geometry type |
An inexpensive test if a geometry might contain another. |
Vendor extension | |
ST_CoveredBy method | ST_Geometry type |
Tests if a geometry value is spatially covered by another geometry value. |
X | Vendor extension |
ST_CoveredByFilter method | ST_Geometry type |
An inexpensive test if a geometry might be covered by another. |
X | Vendor extension |
ST_Covers method | ST_Geometry type |
Tests if a geometry value spatially covers another geometry value. |
X | Vendor extension |
ST_CoversFilter method | ST_Geometry type |
An inexpensive test if a geometry might cover another. |
X | Vendor extension |
ST_Crosses method | ST_Geometry type |
Tests if a geometry value crosses another geometry value. |
5.1.29 | |
ST_Disjoint method | ST_Geometry type |
Test if a geometry value is spatially disjoint from another value. |
X | 5.1.26 |
ST_Equals method | ST_Geometry type |
Tests if an ST_Geometry value is spatially equal to another ST_Geometry value. |
X | 5.1.24 |
ST_EqualsFilter method | ST_Geometry type |
An inexpensive test if a geometry is equal to another. |
X | Vendor extension |
ST_Intersects method | ST_Geometry type |
Test if a geometry value spatially intersects another value. |
X | 5.1.27 |
ST_IntersectsFilter method | ST_Geometry type |
An inexpensive test if the two geometries might intersect. |
X | Vendor extension |
ST_IntersectsRect method | ST_Geometry type |
Test if a geometry intersects a rectangle. |
X | Vendor extension |
ST_OrderingEquals method | ST_Geometry type |
Tests if a geometry is identical to another geometry. |
X | 5.1.43 |
ST_Overlaps method | ST_Geometry type |
Tests if a geometry value overlaps another geometry value. |
5.1.32 | |
ST_Relate method | ST_Geometry type |
Tests if a geometry value is spatially related to another geometry value as specified by the intersection matrix. The ST_Relate method uses a 9-character string from the Dimensionally Extended 9 Intersection Model (DE-9IM) to describe the pair-wise relationship between two spatial data items. For example, the ST_Relate method determines if an intersection occurs between the geometries, and the geometry of the resulting intersection, if it exists. See also: How spatial relationships work. |
5.1.25, Vendor extension | |
ST_Touches method | ST_Geometry type |
Tests if a geometry value spatially touches another geometry value. |
5.1.28 | |
ST_Within method | ST_Geometry type |
Tests if a geometry value is spatially contained within another geometry value. |
5.1.30 | |
ST_WithinDistance method | ST_Geometry type |
Test if two geometries are within a specified distance of each other. |
X | Vendor extension |
ST_WithinDistanceFilter method | ST_Geometry type |
An inexpensive of whether two geometries might be within a specified distance of each other. |
X | Vendor extension |
ST_WithinFilter method | ST_Geometry type |
An inexpensive test if a geometry might be within another. |
Vendor extension |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |