Relate Two Geometry Data Types

You can use the function GeometryRelate() to determine whether one shape is related to another shape.

A shape from one geometry column can be inside, outside, adjacent inside, adjacent outside, or touching another shape from a different geometry column. The shapes are categorized as Inside, Outside, or Touch. This function may require a Cartesian join.

Usage: GeometryRelate(geometry_column1,geometry_column2).

This example shows the usage of the GeometryRelate() calculation.

Description of the illustration maps_geodatatype_calc_geometryrelate.png

The sequence in which the geometry columns are selected within the GeometryRelate() calculation has a direct impact on the result in which shapes are identified as relating to each other.

This example shows the visualization on the right relating all the counties that are touching the storm buffer or inside the storm buffer for potential impact.

Description of the illustration maps_geodatatype_calc_geometryrelate_touchingorinside.png

This example shows shapes from US counties that are touching the storm buffer shape, calculated using the GeometryRelate() calculation.

Description of the illustration maps_geodatatype_calc_geometryrelate_touching_stormbuffer.png

This example shows shapes from US counties that are inside the storm buffer shape, calculated using the GeometryRelate() calculation.

Description of the illustration maps_geodatatype_calc_geometryrelate_inside_stormbuffer.png