Skip to content

Extract lat/lon from GeoPoint

Description

The Extract Lat/Lon from Geo Point activity parses geographic coordinate values from a column containing geo point strings — typically in the format (latitude, longitude) — and separates them into two new columns: one for latitude and another for longitude.

Use case:
Useful when working with address datasets, location-tracked records, or mapping systems that store coordinates in a single field. This activity allows for easier geospatial filtering, distance calculations, or visualization on maps.


Input

TypeDescription
DataA dataset containing a GeoPoint column in the format (lat, lon)

Output

TypeDescription
Transformed DataSame dataset with additional Latitude and Longitude columns

Configuration Fields

Field NameRequiredDescription
GeoPoint columnYesThe name of the column containing the (latitude, longitude) string
Latitude columnYesThe name of the column where latitude values will be stored
Longitude columnYesThe name of the column where longitude values will be stored

Sample Input

IDLocation
1(12.9716, 77.5946)
2(40.7128, -74.0060)
3(34.0522, -118.2437)

Sample Configuration

FieldValue
GeoPoint columnLocation
Latitude columnLatitude
Longitude columnLongitude

Sample Output

IDLocationLatitudeLongitude
1(12.9716, 77.5946)12.971677.5946
2(40.7128, -74.0060)40.7128-74.0060
3(34.0522, -118.2437)34.0522-118.2437