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
| Port | Type | Takes |
|---|---|---|
in | table | one edge |
Parameters
| Parameter | Kind | Default | Choices |
|---|---|---|---|
mode | menu | "inside" | inside, outside, near |
geometry | code | "POLYGON((-74.02 40.70, -73.97 40.71, -73.97 40.76, -74.01 40.76, -74.02 40.70))" | |
metres | float | 500 | |
lng | expr | "lng" | |
lat | expr | "lat" |
Outputs
| Port | Type |
|---|---|
out | table |
Details
- Category: Rows
- Operator:
region