3 ms·
> If using built-in Points, note that the order of ll_to_earth’s coordinates is reversed: points are (x, y) which corresponds to (lng, lat). But the function ta
by mleonhard 7y ago
> If using built-in Points, note that the order of ll_to_earth’s coordinates is reversed: points are (x, y) which corresponds to (lng, lat). But the function takes lat, lng.
This is a strong reason to use PostGIS.
- anamexis 7y agoIt’s a contentious point, but plenty of formats and standards use lng, lat ordering. https://macwright.org/lonlat/ https://macwright.org/lonlat/ https://macwright.org/2016/07/15/longitude-latitude-is-the-right-way.html https://macwright.org/2016/07/15/longitude-latitude-is-the-r...