[postgis-tickets] [PostGIS] #2987: ERROR: BOOM! Could not generate outside point!

[PostGIS]

#2987: ERROR:  BOOM! Could not generate outside point!
-------------------------+--------------------------------------------------
 Reporter:  jczaplewski  |       Owner:  pramsey      
     Type:  defect       |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.1.5
Component:  postgis      |     Version:  2.1.x        
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by pramsey):

 There's probably one particular row that's causing the error. By "bisect"
 I mean do something like this. If you had a table of, say 100 entries,
 you'd find the offending entry by going
 {{{
     WITH subset AS ( select * from mytable limit 50 offset 0 ) SELECT *
 FROM table WHERE ST_Intersects()
     WITH subset AS ( select * from mytable limit 50 offset 50 ) SELECT *
 FROM table WHERE ST_Intersects()
 }}}
 Then you'd know if the problem was in the first or last half of the data.
 So if the problem was in the last half you could go
 {{{
     WITH subset AS ( select * from mytable limit 25 offset 50 ) SELECT *
 FROM table WHERE ST_Intersects()
     WITH subset AS ( select * from mytable limit 25 offset 75 ) SELECT *
 FROM table WHERE ST_Intersects()
 }}}
 And then you'd know if it was first or last part of *that* half, and so on
 until you're down to only one bad record.

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