jiayuasu opened a new issue, #3177: URL: https://github.com/apache/sedona/issues/3177
## What's missing `ST_MakeLine` is geometry-only, so a line built from two geography points cannot be measured geodesically. ```sql -- wanted SELECT ST_Length(ST_MakeLine(geogA, geogB)); -- metres ``` ## Why This blocks the geography form of SpatialBench Q7, which compares a trip's reported distance against the straight-line distance between pickup and dropoff. The geometry version has to measure a planar length in degrees and divide by a hard-coded `0.000009` to pretend the result is metres — a factor that is only correct near the equator along longitude. With geography the length comes back in metres directly and the detour ratio is meaningful everywhere. Constructing a two-point line carries no edge semantics of its own, so the natural signature is `ST_MakeLine(geography, geography) -> geography`, with the geodesic interpretation applied when the result is measured. ## Reference SedonaDB accepts geography for `ST_MakeLine` today (undocumented there — apache/sedona-db#1087): `ST_Length(ST_MakeLine(geog, geog))` returns 865 168 (metres) where the geometry overload returns 7.87 (degrees) for the same pair of points. Part of https://github.com/apache/sedona/issues/2830. -- 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]
