跳到主要内容

POINT_IN_POLYGON

Calculates whether a given point falls within the polygon formed by joining multiple points.

Syntax

POINT_IN_POLYGON((x,y), [(a,b), (c,d), (e,f) ... ])

Arguments

ArgumentTypeDescription
(x,y)(Float64,Float64)Coordinates of the given point.
(a,b), (c,d), (e,f) ...VARIANTAn ordered list of coordinate pairs defining the shape of a polygon.
备注

A polygon is a closed shape connected by coordinate pairs in the order they appear. Changing the order of coordinate pairs can result in a different shape.

Return Type

Returns 1 if the given point falls within the formed polygon; otherwise, returns 0.

Examples

SELECT POINT_IN_POLYGON((3., 3.), [(6, 0), (8, 4), (5, 8), (0, 2)])

----
1