On Mon, Oct 5, 2020 at 5:27 PM Martin Davis <mtncl...@gmail.com> wrote:
>
> PostGIS WKT output does overly-aggressive rounding, IMO.
Not anymore (changed in 3.1+):
template_postgis=# SELECT
ST_AsText(ST_GeomFromWKB('\x01010000000ad7a3f0735727c13e0ad7a3ae0c30c1'));
st_astext
---------------------------------------
POINT(-764857.97 -1051822.6400000001)
(1 row)
template_postgis=# SELECT
ST_AsText(ST_GeomFromWKB('\x01010000000ad7a3f0735727c13e0ad7a3ae0c30c1'));
st_astext
---------------------------------------
POINT(-764857.97 -1051822.6400000001)
(1 row)
And what's best, it won't ever try to return 150 decimal digits (or
30+ like in Komzpa's message) since they aren't meaningful.
--
Raúl Marín Rodríguez
carto.com
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
