Hi everyone!
I'm excited to announce that a new GEO Extension is now available for OpenRefine! This extension adds geographic coordinate processing functions that many users have been
requesting.
What it provides:
decToGMS() function - Convert decimal degrees to degrees/minutes/seconds format
decToGMS(40.7128, "lat")→"40° 42' 46.08" N"decToGMS(-74.0060, "lng")→"74° 0' 21.60" W"
geoDistance() function - Calculate great circle distance between coordinates
geoDistance(40.7128, -74.0060, 34.0522, -118.2437, "km")→ distance in kilometers- Supports meters, kilometers, and miles
- Uses accurate Haversine formula
Installation:
The extension is now listed on the official extensions page. Compatible with OpenRefine 3.8+.
Background:
This implements the functionality requested in GitHub issue #6570 and should be helpful for anyone working with geographic data
in OpenRefine.
Extension repository: GitHub - OpenRefine/openrefine-geo-extension: Geographic functions extension for OpenRefine: decToGMS() and geoDistance()
Feel free to ask questions or report any issues!