Filter
Point in Polygon
Keeps the rows whose coordinates fall inside an area you paste (GeoJSON, WKT or a list of points) — or outside it, or keeps all rows and marks them.
When to use it
Use it to keep only service-area rows, split customers by region boundary, or check deliveries against a zone.
In a pipeline
File InputPoint in PolygonExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Latitude column | select | Yes | Select column… |
| Longitude column | select | Yes | Select column… |
| Area | textarea | Yes | GeoJSON, WKT POLYGON((lon lat, …)) or [[lon,lat],[lon,lat],…] |
| Rows | select | — | inside |
| New column name | text | — | Default: In Area |
Example
Keep sites inside central London
- Latitude column=Lat
- Longitude column=Lon
- Area=[[-0.25,51.4],[0.05,51.4],[0.05,51.6],[-0.25,51.6]]
| Site | Lat | Lon |
|---|---|---|
| A | 51.51 | -0.12 |
| B | 52.2 | 0.12 |
| C | 51.45 | -0.2 |
| Site | Lat | Lon |
|---|---|---|
| A | 51.51 | -0.12 |
| C | 51.45 | -0.2 |
Worth knowing
- Points are longitude first, as GeoJSON and WKT write them: [[lon, lat], …] or POLYGON((lon lat, …)). GeoJSON Polygon, MultiPolygon, Feature and FeatureCollection all work, holes included.
- Rows without a usable latitude and longitude are dropped (and counted) when keeping inside or outside; with Keep all they get a blank.
- Draw an area on geojson.io and paste the result.