Description
The ST_Intersects function determines whether or not one geometry object
intersects another geometry object.
Syntax
ST_Intersects(WritableGeometry geometry1, WritableGeometry geometry2)Parameters
| Parameter | Type | Description |
|---|---|---|
| geometry1 | WritableGeometry | The first instance of a WritableGeometry. |
| geometry2 | WritableGeometry | The second instance of a WritableGeometry. |
Return Values
| Return Type | Description |
|---|---|
| Boolean |
True, if there is any direct position in common between the two
geometries; otherwise, False.If either
|
Examples
SELECT ST_Intersects(ST_GeomFromWKT(t1.geometry, 'epsg:4326'), ST_GeomFromWKT(t2.geometry, 'epsg:4326'))
FROM table1 t1, table2 t2;SELECT R.highway FROM USA_RIVERS L, usa_highways R WHERE L.name='Hudson River' AND
ST_Intersects(st_GeomFromWKT(L.geom), ST_GeomFromWKT(R.geom));