The Within function determines if one geography is fully within another geography.
Within is one of Sigma's Geography functions.
The function has these arguments:
- The Geography value which is potentially within (inside) the other Geography value
- Can be a Point, a Line Segment, or Polygon
- The Geography value that is potentially within (inside) the other Geography value
Geography("POLYGON((1 1, 2 1, 2 2, 1 2, 1 1))"),
Geography("POLYGON((0 0, 3 0, 3 3, 0 3, 0 0))"))
The function returns
Within(MakePoint(-73.985428, 40.748817), [Coordinates])
The first Within function determines if the Centroid of the polygon is within the polygon, while the second function determines if the Empire State Building ( -73.985428, 40.748817) is within the polygon.
The Within function determines if the values in the Coordinates column are within the boundaries of Brooklyn.