Hi,
thanks a lot for pointing me to rounding problem.

Michal

On 10/5/20 5:27 PM, Martin Davis wrote:
PostGIS WKT output does overly-aggressive rounding, IMO.

In JTS you get:

01010000000ad7a3f0735727c13e0ad7a3ae0c30c1 = POINT (-764857.97 -1051822.6400000001)

01010000000ad7a3f0735727c13d0ad7a3ae0c30c1 = POINT (-764857.97 -1051822.64)


On Mon, Oct 5, 2020 at 8:21 AM Michal Seidl <michal.se...@gmail.com <mailto:michal.se...@gmail.com>> wrote:

    Hello I have two points with different HEX representation but the same
    WKT representation? I do not know the binary representation in detail.

    The difference in HEX is somewhere in th middle "d" versus "e" value

    SELECT
    ST_AsEWKT(ST_GeomFromWKB('\x01010000000ad7a3f0735727c13e0ad7a3ae0c30c1'));

    SELECT
    ST_AsEWKT(ST_GeomFromWKB('\x01010000000ad7a3f0735727c13d0ad7a3ae0c30c1'));

    SELECT ST_GeomFromWKB('\x01010000000ad7a3f0735727c13e0ad7a3ae0c30c1') =
    ST_GeomFromWKB('\x01010000000ad7a3f0735727c13d0ad7a3ae0c30c1');

    So what is different?

    Michal
    _______________________________________________
    postgis-users mailing list
    postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
    https://lists.osgeo.org/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

Reply via email to