Compute Distance Between Geospatial Points
Description
This activity computes the distance between geospatial points in the dataset based on user-defined comparison types. The user can compare a column of geospatial points against a fixed location, a fixed geospatial object, or another geospatial column. The computed distance is stored in a new column.
Input
Data
Output
Transformed Data
Configuration Fields
- Compare Type Type of comparison (Options include Fixed Geo Point, Fixed Geospatial Object, Another Geospatial Column).
- Fixed Geopoint The fixed geospatial point for distance comparison (Rendered when CompareType is Fixed Geo Point).
- Latitude Column Column containing latitude values in the dataset (Rendered when CompareType is Fixed Geo Point).
- Longitude Column Column containing longitude values in the dataset (Rendered when CompareType is Fixed Geo Point).
- Latitude Value For FixedGeopoint Latitude of the fixed geospatial point.
- LongitudeValue For FixedGeopoint Longitude of the fixed geospatial point.
- GeoColumn Column containing geospatial points (Rendered when CompareType is Fixed Geospatial Object).
- Column For Comparision The column to compare against (Rendered when CompareType is Another Geospatial Column).
- Distance Column Name The name of the column where the computed distances will be stored.
Sample Input
| 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 |
Sample Configuration
Sample Output
| 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 |