3 ms·
Great post. Just to be pedantic for a moment: > it gives you results that are 100% correct, which is pretty important! Not quite 100% correct, as the `ST_Dist
by dandelany 5y ago
Great post. Just to be pedantic for a moment:
> it gives you results that are 100% correct, which is pretty important!
Not quite 100% correct, as the `ST_Distance_Sphere` function uses a spherical earth model, & in fact the earth is an oblate spheroid :) The slower-but-more-accurate `ST_Distance_Spheroid` also exists if you care about such things.
- nixpulvis 5y agoIt's hardly pedantic, the differences can be on the order of kilometers over large distances. The GPS uses WGS 84 as the reference ellipsoid model, for example. (if my memory serves)