Yurik created this task. Yurik added a project: Wikidata-Query-Service. Herald added a subscriber: Aklapper. Herald added projects: Wikidata, Discovery. |
TASK DESCRIPTION
Given a set of points, it is frequently needed to calculate their "average" point - a weighted center of sorts. Simply creating a new point with AVG(longitude(point)), AVG(latitude(point)) may work in many places, but it could be grossly incorrect near anti-meridian.
this stackoverflow question provides a more accurate implementation, by transitioning each point's (lon, lat) into cartesian system (x,y,z), averaging on each coordinate, and converting back. If earth is assumed to be a sphere, the calculations are slightly simpler.
TASK DETAIL
EMAIL PREFERENCES
To: Yurik
Cc: Smalyshev, Aklapper, Yurik, GoranSMilovanovic, QZanden, EBjune, merbst, Avner, debt, Gehel, Jonas, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
Cc: Smalyshev, Aklapper, Yurik, GoranSMilovanovic, QZanden, EBjune, merbst, Avner, debt, Gehel, Jonas, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs