Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
✅ Azure Stream Analytics ✅ Fabric Eventstream
Returns 1 if a geography is within another, if not it will return 0.
Syntax
ST_WITHIN (geography, polygon)
Argument
Geography
The geography that could be inside the polygon. Can be either a point or a polygon.
Polygon
The polygon that could contain the geography.
Return Type
Returns 1 if either a point or polygon is within another polygon, if not it will return 0.
Example
SELECT
ST_WITHIN(input.deliveryDestination, input.warehouse)
FROM input
Input Example
| deliveryDestination | warehouse |
|---|---|
| {"type":"Point", "coordinates": [76.6, 10.1]} | {"type":"Polygon", "coordinates": [[ [0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0] ]]} |
| {"type":"Point", "coordinates": [15.0, 15.0]} | {"type":"Polygon", "coordinates": [[ [10.0, 10.0], [20.0, 10.0], [20.0, 20.0], [10.0, 20.0], [10.0, 10.0] ]]} |
Output Example
0
1