Analytics
Geo Distance
Adds the great-circle (haversine) distance between each row's coordinates and a fixed point, or a second pair of coordinate columns, in km, miles, metres or nautical miles.
When to use it
Use it for warehouse-to-customer distances, nearest-store checks or delivery radius rules.
In a pipeline
File InputGeo DistanceFilter Rows
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Measure to | select | — | point |
| Latitude column | select | Yes | Select column… |
| Longitude column | select | Yes | Select column… |
| Point latitude | number | — | 51.5072 |
| Point longitude | number | — | -0.1276 |
| Second latitude column | select | — | Select column… |
| Second longitude column | select | — | Select column… |
| Unit | select | — | km |
| Decimals | number | — | 2 |
| Distance column name | text | — | Default: Distance |
Example
Distance from London
- Latitude column=Lat
- Longitude column=Lon
- Point latitude=51.5072
- Point longitude=-0.1276
| Store | Lat | Lon |
|---|---|---|
| Paris | 48.8566 | 2.3522 |
| Manchester | 53.4808 | -2.2426 |
| Store | Lat | Lon | Distance |
|---|---|---|---|
| Paris | 48.8566 | 2.3522 | 343.53 |
| Manchester | 53.4808 | -2.2426 | 262.01 |
Worth knowing
- Coordinates are decimal degrees (WGS 84). Rows with a blank or out-of-range latitude or longitude get a blank distance and are counted.
- Distances are as the crow flies over a spherical Earth (within about 0.5%), not road distances.
- Have postcodes, not coordinates? Join a postcode table first; geocoding is waiting on Address Verify / Geocode.