Extract Lat/Lon from Geo Point
Description
This activity extracts latitude and longitude values from a geo point column. The extracted values are stored in separate columns.
Input
Data
Output
Transformed Data
Configuration Fields
GeoPoint column Specifies the column containing geopoints. Latitude column Defines the column to store extracted latitude. Longitude column Defines the column to store extracted longitude.
Sample Input
| ID | Location |
|---|---|
| 1 | (12.9716, 77.5946) |
| 2 | (40.7128, -74.0060) |
| 3 | (34.0522, -118.2437) |
Sample Configuration
Sample Output
| ID | Location | Latitude | Longitude |
|---|---|---|---|
| 1 | (12.9716, 77.5946) | 12.9716 | 77.5946 |
| 2 | (40.7128, -74.0060) | 40.7128 | -74.0060 |
| 3 | (34.0522, -118.2437) | 34.0522 | -118.2437 |