[postgis-devel] [PostGIS] #1274: ST_CreateTopoGeo failed

[PostGIS]

#1274: ST_CreateTopoGeo failed
-----------------------+----------------------------------------------------
  Reporter:  strk      |       Owner:  strk         
      Type:  defect    |      Status:  closed       
  Priority:  medium    |   Milestone:  PostGIS 2.0.0
 Component:  topology  |     Version:  trunk        
Resolution:  fixed     |    Keywords:               
-----------------------+----------------------------------------------------
Changes (by strk):

  * status:  new => closed
  * resolution:  => fixed


Comment:

 Alright, it looks like there's nothing else. As of r8212 the
 small_sample.sql.gz dataset can be converted to a topology on both 32bit
 and 64bit system.

 Summary:
 {{{
  Topology small_sample_topo (2042), SRID 0, precision 0
  83 nodes, 156 edges, 74 faces, 0 topogeoms in 0 layers
 }}}

 It's interesting to note how once constructed the topology can be more
 easily cleaned by inspecting suspicious areas:

 Edges which partecipate in the boundary of a faces whose bounding box has
 an area < 0.1:
 {{{
 with smallfaces as ( select face_id from small_sample_topo.face where
 st_area(mbr) < 0.1 ) select edge_id from small_sample_topo.edge_data where
 left_face in (select * from smallfaces ) or right_face in (select * from
 smallfaces) order by edge_id;
 }}}

 Automating further cleanup could mean getting the longest edge in each
 "small_face" and removing it, so to assign the small face area to an
 adiacent face.

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