[FEATURE]: Add geofencing checks

[tdikland]

Is there an existing issue for this?

• I have searched the existing issues

Problem statement

I want to add more precise geofencing checks to my pipelines. I have the following use cases in mind:

1. Given a reference polygon, check if the geom/geog is contained by the reference polygon
2. Given a reference point, check if the geog/geog is within a specified distance of the reference point

Proposed Solution

Add new checks that cover these use cases

Additional Context

geofence

[ghanse]

It would be great to use pure H3 indices or a hybrid H3/ST functions approach based on an input parameter.

is_in_geofence(column: str | Column, use_st_functions: bool = False)

[tdikland]

@ghanse, I think it would be a better user experience if they could choose between precise (using ST_ functions) or approximate (using e.g., H3 grid with a resolution depending on the size of the polygon or the distance to a reference point). That gives a bit more freedom in the implementation, plus the possibility of adding more modes when needed later.