[postgis-users] Getting data from table with interval

Luca Bertoncello lucabert at lucabert.de
Fri Jan 7 12:31:25 PST 2022


Am 07.01.2022 um 21:28 schrieb Paul Ramsey:
> Yes, the "distances" you got when you ran the calculation in geometry space were wrong. They were both wrong in unit terms (meaningless units vs meters) and also in picking the right elevation point (since there's a N/S compression effect in raw lon/lat coordinates working in cartesian space). 
> 
> Trust the geography result.

OK, then I'll make a query to get the points from the other query I
already got...

Thanks a lot!
Luca Bertoncello
(lucabert at lucabert.de)


More information about the postgis-users mailing list