Tests if an ST_Geometry value spatially crosses another ST_Geometry value.
|
Argument … |
Specifies … |
|
ageometry |
the other ST_Geometry value. |
Returns an INTEGER value:
All ST_Geometry types except geometry collections.
Note: This method can be called on 3D geometries (those that include z coordinates). However, the z coordinate is ignored in method calculations.
Use of a geospatial index can greatly improve the performance of queries that use this method.
SELECT streetName
FROM sample_streets
WHERE streetShape.ST_Crosses(
NEW ST_Geometry('LINESTRING(2 2, 3 2, 4 1)')) = 1
ORDER BY streetName;