Changes between Initial Version and Version 1 of Ticket #4910, comment 4


Ignore:
Timestamp:
07/30/21 10:09:04 (3 years ago)
Author:
pramsey

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #4910, comment 4

    initial v1  
    22{{{
    33WITH g(geom) AS (
    4    SELECT 'POLYGON((-804030.52 -988525.62,-804026.137267668 -988528.6887703099,-804026.14 -988528.6900000001,-804030.52 -988525.62))'::geometry
     4   SELECT 'POLYGON((0 0, 10 0, 10 0.000001, 0 0.000001, 0 0))'::geometry
    55)
    66SELECT
    7   ST_GeomFromGML(
    8     ST_AsGML(3, geom, 2, 0, 'gml', NULL),
    9   5514)
     7ST_GeomFromGML(
     8      ST_AsGML(3, geom, 2, 0, 'gml', NULL)
     9      ,5514)
    1010FROM g;
    1111}}}
     12The ST_AsGML call is rounding off the coordinates and creating an invalid collapsed polygon. The problem can be averted by not rounding coordinates.