GEOGRAPHY_CONTAINS

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

contains.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(...)");