paleolimbot commented on PR #478: URL: https://github.com/apache/sedona-db/pull/478#issuecomment-3708741714
> if the difference of CRSs is actually handled correctly by the underlying libraries. The difference would be the ellipsoid, and the current backing library for our Geography is S2, which ignores the ellipsoid (except for the radius, so we could in theory do things like use Geography and have ST_Distance "do the right thing" on the moon or something). > I'll study more about how other DBs handle GEOGRAPHY. I did a brief survey ~a year ago that has some links ( https://github.com/opengeospatial/geoparquet/pull/248 ). I'll be working on this quite a lot in the next two months (mostly on getting S2 to operate directly on WKB so that the performance is not garbage). My takeaway from the survey I did a year ago is that there's a lot of variability and we may have to make some unilateral decisions about how Geography can/should work. -- 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]
