GEOGRAPHY_CONTAINS

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

image

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(...)");
Was this article useful?