hevansDev commented on issue #1055: URL: https://github.com/apache/druid/issues/1055#issuecomment-2284514679
I've recently been working with measuring the distances between simple lat, lon, and alt coordinates rather than wgs84 but am interested in working on contributing some functions for doing these calculations, potentially something like [ST_Distance_Sphere](https://tighten.com/insights/a-mysql-distance-function-you-should-know-about/)? I've been using variations on the formula ```ACOS((SIN(RADIANS(Lat1)) * SIN(RADIANS(Lat2))) + (COS(RADIANS(Lat1)) * COS(RADIANS(Lat2))) * (COS(RADIANS(Lon2) - RADIANS(Lon1)))) * 6371``` which could potentially be an improvement on Euclidean distance? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
