SingleStore DB

GEOGRAPHY_CONTAINS

This function takes in two geospatial objects and determines whether the first one completely covers the area of the second.

16083b5799c274.png
Syntax
GEOGRAPHY_CONTAINS ( geo1, geo2 )
Arguments
  • geo1, geo2: any valid geospatial object or WKT string: path, point or polygon.

Return Type

Boolean

Examples
SELECT id, name FROM neighborhoods
WHERE
  GEOGRAPHY_CONTAINS(shape, "POLYGON(...)");