Compute Distance Between Geospatial Points
Infoveave Data Automation — Geospatial
Every customer address row gets a distance-from-warehouse column in one step — no PostGIS, no Haversine formula in a query, just configure the reference point and run.
Proximity is one of the most common filtering, ranking, and routing criteria in logistics, retail, and field operations analytics. Knowing how far each customer, asset, or event is from a reference location — a warehouse, a service center, a store — lets teams segment customers by delivery zone, route service visits efficiently, build catchment analysis, and trigger proximity-based alerts. Computing that distance column typically requires either GIS software, a PostGIS query with Haversine or ST_Distance functions, or a Python script with the geopy or shapely library. Compute Distance Between Geospatial Points adds the distance column directly in the data workflow, reading each row's coordinates and computing distance from the configured reference so the result is immediately available for filtering, ranking, and reporting.
What Compute Distance Between Geospatial Points does
Calculate the distance between geospatial locations in a dataset against a fixed reference point, a static geospatial object, or another geopoint column in Infoveave. Measure customer proximity, delivery distances, and logistics coverage without GIS software or PostGIS queries.
When to use Compute Distance Between Geospatial Points
- You are building a logistics or delivery optimization pipeline where each order or customer record needs a distance-from-hub column to assign delivery zones, estimate delivery costs, or filter orders within a service radius
- You are performing retail catchment analysis where each customer transaction record needs a distance from the nearest store calculated and stored as a column for segmenting loyal vs passing customers
- You are analyzing field service or maintenance records where each asset or service event needs to be tagged with its distance from the regional service center to support routing, escalation, and coverage reporting
- You need to compute the distance between two geopoint columns in the same row — such as pickup location and drop-off location for ride-share or delivery records — to add a trip distance column to the dataset
When to avoid it
- You need to create a GeoPoint column from raw latitude and longitude values before computing distance — use Create GeoPoint from Latitude/Longitude first
- You need to draw a buffer or coverage area around a point rather than compute a scalar distance — use Create Area Around Geopoint for area-based geofencing
- You already have distance values and need to filter rows based on a distance threshold — use Filter on Numerical Range on the distance column after computing it
Where it fits in your Infoveave automation
Compute Distance Between Geospatial Points is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Compute Distance Between Geospatial Points
Real scenarios where this transformation saves hours of manual work.
Tag Each Customer Transaction with Distance from Nearest Store
A retail analytics team processes customer transaction records where each record includes the customer's home address as a latitude/longitude pair. The team needs to know how far each customer traveled to visit a store for catchment area mapping and loyalty segmentation. Compute Distance Between Geospatial Points is configured with the customer's lat/lon columns and a fixed reference geopoint for each store. The distance column labels customers as local (under 5 km), regional (5-20 km), or distant (over 20 km) in a subsequent classification step.
Calculate Distance Between Manufacturing Plants and Distribution Centers
A supply chain team maintains a dataset of production lots where each lot includes the originating plant geopoint and the assigned distribution center geopoint in separate columns. Compute Distance Between Geospatial Points is configured with the Another Geospatial Column comparison type, computing the distance between the two geopoint columns for each row. The resulting distance column is used to compute freight cost estimates and evaluate plant-to-center routing efficiency.
Measure ATM Distance from Branch to Optimize Coverage Planning
A bank's network planning team maintains an ATM dataset where each ATM record includes its GPS coordinates. The team needs to compute each ATM's distance from its nearest branch to identify coverage gaps and redundant ATM placements. Compute Distance Between Geospatial Points uses the ATM lat/lon columns and a fixed reference point for each branch (run in a loop per branch) to add a distance column that feeds the coverage optimization model.
See Compute Distance Between Geospatial Points in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
Fixed Geo PointLatitudeLongitude12.9716 (Bangalore)77.5946 (Bangalore)DistanceFromBangaloreInput Data
| ID | Latitude | Longitude |
|---|---|---|
| 1 | 28.7041 | 77.1025 |
| 2 | 34.0522 | -118.2437 |
| 3 | 48.8566 | 2.3522 |
| 4 | 51.5074 | -0.1278 |
| 5 | 40.7128 | -74.0060 |
Output Data
| ID | Latitude | Longitude | DistanceFromBangalore |
|---|---|---|---|
| 1 | 28.7041 | 77.1025 | 1756.4 |
| 2 | 34.0522 | -118.2437 | 14572.1 |
| 3 | 48.8566 | 2.3522 | 8023.5 |
| 4 | 51.5074 | -0.1278 | 8276.3 |
| 5 | 40.7128 | -74.0060 | 13386.7 |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Compare Type
Choose how the distance reference is defined. Fixed Geo Point computes distance between each row and a fixed latitude/longitude you specify — use this for distance from a single known location like a warehouse or store. Fixed Geospatial Object computes distance between each row and a stored geospatial shape. Another Geospatial Column computes distance between two geopoint columns in the same row — use this for trip distance between a pickup and a drop-off point.
Distance Column Name
Name the output column that will store the computed distance values. Distance is returned in kilometers by default. The column can be used immediately for filtering, ranking, and zone assignment in downstream steps.
Frequently asked questions
Everything you need to know about Compute Distance Between Geospatial Points in Infoveave.
Also in Geospatial — and what runs before & after
Transformations in the same family as Compute Distance Between Geospatial Points, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Compute Distance Between Geospatial Points is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
