ES|QL ST_INTERSECTS function
geomA- Expression that is either a geometry (
geo_point,cartesian_point,geo_shapeorcartesian_shape) or a geo-grid value (geohash,geotile,geohex). Ifnull, the function returnsnull. geomB-
Expression that is either a geometry (
geo_point,cartesian_point,geo_shapeorcartesian_shape) or a geo-grid value (geohash,geotile,geohex). Ifnull, the function returnsnull. The second parameter must also have the same coordinate system as the first. This means it is not possible to combinegeo_*andcartesian_*parameters.
Returns true if two geometries intersect. They intersect if they have any point in common, including their interior points (points along lines or within polygons). This is the inverse of the ST_DISJOINT function. In mathematical terms: ST_Intersects(A, B) ⇔ A ⋂ B ≠ ∅
| geomA | geomB | result |
|---|---|---|
| cartesian_point | cartesian_point | boolean |
| cartesian_point | cartesian_shape | boolean |
| cartesian_shape | cartesian_point | boolean |
| cartesian_shape | cartesian_shape | boolean |
| geo_point | geo_point | boolean |
| geo_point | geo_shape | boolean |
| geo_point | geohash | boolean |
| geo_point | geohex | boolean |
| geo_point | geotile | boolean |
| geo_shape | geo_point | boolean |
| geo_shape | geo_shape | boolean |
| geohash | geo_point | boolean |
| geohex | geo_point | boolean |
| geotile | geo_point | boolean |
FROM airports
| WHERE ST_INTERSECTS(location, TO_GEOSHAPE("POLYGON((42 14, 43 14, 43 15, 42 15, 42 14))"))
| abbrev:keyword | city:keyword | city_location:geo_point | country:keyword | location:geo_point | name:text | scalerank:i | type:k |
|---|---|---|---|---|---|---|---|
| HOD | Al Ḩudaydah | POINT(42.9511 14.8022) | Yemen | POINT(42.97109630194 14.7552534413725) | Hodeidah Int'l | 9 | mid |