ST_OVERLAPS (Azure Stream Analytics)

  • Article

Returns 1 if a geography overlaps with another. If geographies do not overlap or one is within another, it will return 0.

Syntax

ST_OVERLAPS (polygonA, polygonB)

Argument

PolygonA

The polygon that could overlap with polygonB.

PolygonB

The polygon that could overlap with polygonA.

Return Type

Returns 1 if a polygon overlaps with another polygon, if not it will return 0.

Example

SELECT  
     ST_OVERLAPS(input.datacenterArea, input.stormArea)  
FROM input

Input Example

datacenterArea stormArea
{"type":"Polygon", "coordinates": [ [0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0] ]} {"type":"Polygon", "coordinates": [ [30.0, 30.0], [40.0, 30.0], [40.0, 40.0], [30.0, 40.0], [30.0, 30.0] ]}
{"type":"Polygon", "coordinates": [ [0.0, 0.0], [20.0, 0.0], [20.0, 20.0], [0.0, 20.0], [0.0, 0.0] ]} {"type":"Polygon", "coordinates": [ [10.0, 10.0], [40.0, 10.0], [40.0, 40.0], [40.0, 20.0], [40.0, 40.0] ]}

Output Example

0

1

See Also