Skip to main content

Region Filter

Keep rows inside, outside or near a polygon. Runs in SQL, on the GPU or the CPU, wherever the planner puts it.

Syntax​

{ "id": "n1", "op": "region", "name": "region", "x": 0, "y": 0, "params": {} }

An edge into it ends at "targetPort": "in"; one out of it starts at "sourcePort": "out"; a parameter is set in params (leave out the ones at their default), driven by an edge to par:metres, or read elsewhere as ch('region/metres').

Inputs​

PortTypeTakes
intableone edge

Parameters​

ParameterKindDefaultChoices
modemenu"inside"inside, outside, near
geometrycode"POLYGON((-74.02 40.70, -73.97 40.71, -73.97 40.76, -74.01 40.76, -74.02 40.70))"
metresfloat500
lngexpr"lng"
latexpr"lat"

Outputs​

PortType
outtable

Details​

  • Category: Rows
  • Operator: region