You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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