ST_INTERSECTS (Azure Stream Analytics)
Returns 1 if a geography intersects with another. If geographies do not intersect it will return 0.
Syntax
ST_INTERSECTS (lineStringA, lineStringB)
Argument
LineStringA
The LineString that could intersect with LineStringB.
LineStringB
The LineString that could intersect with LineStringA.
Return Type
Returns 1 if a LineString intersects with another LineString, if not it will return 0.
Example
SELECT
ST_INTERSECTS(input.pavedRoad, input.dirtRoad)
FROM input
Input Example
datacenterArea | stormArea |
---|---|
{"type":"LineString", "coordinates": [ [-10.0, 0.0], [0.0, 0.0], [10.0, 0.0] ]} | {"type":"LineString", "coordinates": [ [0.0, 10.0], [0.0, 0.0], [0.0, -10.0] ]} |
{"type":"LineString", "coordinates": [ [-10.0, 0.0], [0.0, 0.0], [10.0, 0.0] ]} | {"type":"LineString", "coordinates": [ [-10.0, 10.0], [0.0, 10.0], [10.0, 10.0] ]} |
Output Example
1
0
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for