[postgis-devel] [PostGIS] #834: lw_collection_construct error

PostGIS trac at osgeo.org
Wed Feb 16 06:24:11 PST 2011


#834: lw_collection_construct error
-----------------------+----------------------------------------------------
 Reporter:  aperi2007  |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.0.0
Component:  postgis    |     Version:  1.5.X        
 Keywords:             |  
-----------------------+----------------------------------------------------

Comment(by aperi2007):

 You are reason !
 In effect the polygon are 3D and lines are 2D.


 {{{
  select
   id,
   st_intersection(b.geom,st_exteriorring(st_force_2d(a.geom))),
   b.geom
  from
   table_polygons as a,
   table_linestrings as b
  where
   a.id = b.id
   and
   st_containsproperly(a.geom,b.geom)=false
   and
   st_crosses(b.geom,a.geom)=true
  ;

 }}}

 the error disappeared.

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


More information about the postgis-devel mailing list