You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by "hevansDev (via GitHub)" <gi...@apache.org> on 2024/08/12 17:03:39 UTC

Re: [I] Better geo handling in Druid (druid)

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: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org