[postgis-tickets] [PostGIS] #3510: ST_RemoveColinearPoints

[PostGIS]

#3510: ST_RemoveColinearPoints
--------------------------+---------------------------
  Reporter:  robe         |      Owner:  pramsey
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 2.3.0
 Component:  postgis      |    Version:  trunk
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by robe):

 That's what Leo tried first.  Doesn't work.


 {{{
 WITH z (x,y) AS (
     VALUES
         (ST_GeomFromText('POLYGON((3 0, 5 0, 5 4, 3 4, 3 0))'),'A'),

         (ST_GeomFromText('POLYGON((2 0, 9 0, 9 2, 2 2, 2 0))'),'A')


 )

 SELECT ST_Simplify(ST_Union(x),0) AS u FROM z;

 }}}


 He wanted to get rid of that bottom extra vertex -

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3510#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.