[postgis-devel] [PostGIS] #920: CURVEPOLYGON problem when converting to/from text

PostGIS trac at osgeo.org
Thu Apr 21 18:26:21 PDT 2011

#920: CURVEPOLYGON problem when converting to/from text
 Reporter:  debe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 1.5.3
Component:  postgis  |     Version:  1.5.X        
 Keywords:           |  

Comment(by robe):


 I looked at this and I don't think it's a bug but just an unfortunate
 consequence of converting from geometry to text representation.  The first
 geometry in your compound curve is a linestring with only one point which
 is clearly invalid.  What I suspect happened is that the linestring in
 binary form had 2 points, but when converted to ST_AsText which only keeps
 15 decimal places or so, because the points were so close, it got reduced
 to 1 point and thus became invalid.

 To determine this, can you send us the binary or hex of the geometry

 e.g. do a SELECT geometry  (should output as hex)

 or a SELECT ST_AsBinary(geometry) ...

Ticket URL: <http://trac.osgeo.org/postgis/ticket/920#comment:1>
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.

More information about the postgis-devel mailing list