[STREAMPIPES-131] Increase Accuracy of the Geo Distance Calculation

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.67.0
• Assignee: Florian Micklich
• Reporter: Florian Micklich
• Created: 16/May/20 17:23
• Updated: 26/Nov/22 12:54
• Resolved: 21/May/20 11:00

Description

At the moment the Distance Calculation and Static Distance Calulation are using the using the ‘haversine’ formula [1].

But the result can be improved:

Issue:

Calc distance between Karlsruhe and New York:
StreamPipes: 6230.166 km
reference PostGIS: 6246.970 km
--> Difference of ~17 km or 0,26 % error

Calc distance between Karlsruhe and Rastatt:
StreamPipes: 21.87866 km
reference PostGIS: 21.908 km
--> Difference of ~0,029 km or 0,13 % error

Solution:
Using GeographicLib as Library under MIT Licende [3][4]

Using Geodesy Algorithm resolving different problems mentions in this paper [5]

[1] https://www.movable-type.co.uk/scripts/latlong.html
[3] https://mvnrepository.com/artifact/net.sf.geographiclib/GeographicLib-Java/1.50
[4] https://geographiclib.sourceforge.io/html/java/
[5] https://link.springer.com/article/10.1007/s00190-012-0578-z